JIRA 4.0 : Restoring data using I-Net (Oranxo) Driver for Oracle
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) FixThis 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 Oct 06, 2009 00:26 |