This page last changed on Nov 15, 2006 by michelle@atlassian.com.

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

Document generated by Confluence on Mar 27, 2011 18:52