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.
Last modified on Nov 10, 2011
Powered by Confluence and Scroll Viewport.