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

Skip to end of metadata
Go to start of metadata

When restoring data into an Oracle 9 database using the I-Net Oranxo Driver a user was seeing this error message in their logs:

org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ([OraDriver] #7 Unexpected end of inputstream in header.)
	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:375)
	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115)
	at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
	at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450)
	at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
	at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191)
	at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751)
	at java.lang.Thread.run(Thread.java:595)
com.inet.ora.Ora3SQLException: [OraDriver] #7 Unexpected end of inputstream in header.
	at com.inet.ora.Ora3Factory.createSQLException(Unknown Source)
	at com.inet.ora.Ora3Factory.createSQLException(Unknown Source)
	at com.inet.ora.OraConnection.c(Unknown Source)
	at com.inet.ora.OraConnection.a(Unknown Source)
	at com.inet.ora.OraPreparedStatement.a(Unknown Source)
	at com.inet.ora.OraPreparedStatement.a(Unknown Source)
	at com.inet.ora.OraPreparedStatement.executeUpdate(Unknown Source)

Fix

This error was fixed by changing the Set Clob entry in the server.xml if using Standalone or the jira.xml file if using the WebApp edition of JIRA.

So instead of using:

connectionProperties="SetBigStringTryClob=true"

for this driver it needs to be replaced with:

connectionProperties="streamstolob=true" 

As per this document on Oracle JDBC Manual