Versions Compared

Old Version 1

changes.mady.by.user Michelle de Guzman

Saved on

compared with

New Version Current

changes.mady.by.user Michelle de Guzman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

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

No Format
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:

No Format
connectionProperties="SetBigStringTryClob=true"

for this driver it needs to be replaced with:

No Format
connectionProperties="streamstolob=true"

As per this document on Oracle JDBC Manual