JIRA is now available as three separate applications, JIRA Software, JIRA Service Desk, and JIRA Core. For more information on administering these applications, refer to the Administering JIRA Applications documentation.

Using Oracle 10g drivers to solve the 4000 character limitation

As you might be aware Oracle has a 4000 character limitation on VARCHAR2 fields. Which causes quite a few headaches when dealing with custom workflows or working with issues that have long descriptions, comments or custom field values.

Fortunately Oracle have worked around the VARCHAR2 limitation in their latest Oracle 10g JDBC driver. This fix (described online here) works with Oracle 9 and 10. We strongly recommend using Oracle 10g drivers and the setup described below if you are using Oracle 9i or 10g.

Even though Oracle suggests that Oracle 10g drivers work with Oracle 8i, users have reported problems with this configuration.

Please follow the Upgrading JIRA Safely instructions, keeping the following in mind:

Use Oracle 10g driver

This configuration will work only with Oracle 10g drivers. Therefore, from Oracle's site download the ojdbc14.jar (or applicable) JDBC driver, and copy it to your app server's lib/ directory (eg. common/lib/ for Tomcat). Remove the old JDBC jar used previously.

Create a new database for JIRA 3.2

Please create a new database for JIRA 3.2 and configure JIRA's data source to use it. Please do not point JIRA 3.2 at your old database.

Set the SetBigStringTryClob flag

When configuring the data source for the new database set the SetBigStringTryClob flag to true. The way this must be done depends on your application server

JIRA Standalone, Tomcat 4 and 5.0:

Edit conf/server.xml (Tomcat 4) or conf/Catalina/localhost/jira.xml (Tomcat 5.0), locate the section where the 'jdbc/JiraDS' DataSource is set up, and add:

For instance, in JIRA Standalone one would then have:

Tomcat 5.5

In Tomcat 5.5, the format for the added section would be:

Orion / OC4J

For Orion/OC4J, edit config/data-sources.xml, and add the property as a nested tag:

Other app servers

Consult the relevant JIRA app server guide and the app server documentation to find how to add the property.

Use oracle10g field-type-name

Please specify oracle10g (not oracle) as the field-type-name when editing WEB-INF/classes/entityengine.xml

After the data is re-imported and JIRA upgrades the data the 4000 character limitation should disappear.

Was this helpful?

Thanks for your feedback!

Why was this unhelpful?

2 Archived comments

  1. User avatar

    German DZ

    We are using Oracle 9i Rel.2, but JIRA only works using the JDBC Driver 9 provided by Oracle (it have the limit size trouble).

    BUT the only driver of 10g that works is Oracle 10g Driver.

    15 Sep 2005
  2. User avatar

    Jozsef Kozell

    Fortunately, Oracle fixed that in 10.1:

    http://docs.oracle.com/cd/E11882_01/java.112/e16548/oralob.htm#JJDBC28537 and look for "Forcing conversion to LOB".

    27 Feb 2014
Powered by Confluence and Scroll Viewport