Documentation for JIRA 4.4. Documentation for other versions of JIRA is available too.

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

When using JIRA with Oracle, the Oracle 10g JDBC driver needs to have the SetBigStringTryClob property set to true to store text of unlimited size in the database. If this property is not set, you will have problems modifying JIRA workflows and storing large (over 32k) text strings.

The SetBigStringTryClob property needs to be set in the application server, where the database connection is defined (the 'datasource' definition). The definition depends on the application server that you are using. Please refer to one of the sections below that is applicable to your application server to determine what to add to the datasource definition.

The same thing applies to I-Net's JDBC driver, except the property is called streamstolob.

Tomcat 5.5 and 6.0 (JIRA Standalone)

Resolving Connection Closure Issues

If you experiencing problems with connections closing, you may be able to resolve them by configuring the Commons DBCP (Database Connection Pool) to detect broken connections and create replacement connections. Please read Surviving Connection Closures for instructions on how to do this.

Modify the section where JIRA is configured, usually conf/Catalina/localhost/jira.xml or conf/server.xml (in JIRA Standalone):

<Context path="/jira" docBase="path/to/atlassian-jira-3.11.war">
  <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
    username="...."
    password="...."
    driverClassName="oracle.jdbc.driver.OracleDriver"
    url="jdbc:oracle:thin:@<database host machine>:<port>:<SID>"
    connectionProperties="SetBigStringTryClob=true" />
  <Resource name="UserTransaction" auth="Container" type="javax.transaction.UserTransaction"
    factory="org.objectweb.jotm.UserTransactionFactory"
    jotm.timeout="60"/>
  <Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="false"/>
</Context>
  • No labels



See our Getting Help page for details.



Raise an issue for our developers.



See answers from the community.



Tweet, blog and update our documentation.

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.