Restoring data using I-Net (Oranxo) Driver for Oracle

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 JIRA's dbconfig.xml in the JIRA Home Directory.

So instead of using:

<connection-properties>SetBigStringTryClob=true</connection-properties>

for this driver it needs to be replaced with:

<connection-properties>streamstolob=true</connection-properties>

See the appropriate section in the Oracle JDBC Manual for details on these connection properties and the Connecting JIRA to Oracle for more information about configuring your dbconfig.xml file.

Was this helpful?

Thanks for your feedback!

Why was this unhelpful?

Have a question about this article?

See questions about this article

Powered by Confluence and Scroll Viewport