SQL Exception While Import ingXML Backup Using an Oracle Database
Symptoms
Import from XML stops with:
Error importing data: org.apache.commons.lang.exception.NestableException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue]
...
(SQL Exception while setting value: (setString can only process strings of less than 32766 chararacters)
Cause
A JIRA field value is too large to accommodate Oracle's String datatype.
Resolution
Set the SetBigStringTryClob property in the datasource definition. An example for the standalone distribution would be to edit $JIRA_APPLICATION_DIRECTORY$/conf/server.xml to include the following, as described in Configuring Datasource for Oracle 10G:
<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" />
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.