10.2 client blobclob4blob test run against 10.3 server fails for many tests
with SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.
--------------------------------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-2781
URL: https://issues.apache.org/jira/browse/DERBY-2781
Project: Derby
Issue Type: Bug
Affects Versions: 10.3.0.0
Reporter: Kathey Marsden
Many tests in blobclob4blob.java fail with: SQLSTATE(XJ073): The data in this
BLOB or CLOB is no longer available. The BLOB/CLOB's transaction may be
committed,
Need to determine cause and if this is a bug and evaluate how it will impact
existing applications.
Found I-am-hiding-here-at-position-5910 in row 1 starting from position 1 at
position NOTFOUND
FAIL -- unexpected exception ****************
SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available. The
BLOB/CLOB's transaction may be committed, or its connection is closed.
SQLSTATE(38000): The exception 'java.sql.SQLException: Unable to set stream:
'Reached end-of-stream prematurely'.' was thrown while evaluating an expression.
SQLSTATE(XJ022): Unable to set stream: 'Reached end-of-stream prematurely'.
java.sql.SQLException: The data in this BLOB or CLOB is no longer available.
The BLOB/CLOB's transaction may be committed, or its connection is closed.
at
org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:46)
at
org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:362)
at org.apache.derby.client.am.Clob.position(Clob.java:463)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.blobclob4BLOB.printPosition(Unknown
Source)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.blobclob4BLOB.clobTest3(Unknown
Source)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.blobclob4BLOB.main(Unknown
Source)
Caused by: org.apache.derby.client.am.SqlException: The data in this BLOB or
CLOB is no longer available. The BLOB/CLOB's transaction may be committed, or
its connection is closed.
at
org.apache.derby.client.am.CallableLocatorProcedures.handleInvalidLocator(CallableLocatorProcedures.java:1068)
at
org.apache.derby.client.am.CallableLocatorProcedures.clobGetPositionFromString(CallableLocatorProcedures.java:791)
at
org.apache.derby.client.am.CallableLocatorProcedures.clobGetPositionFromString(CallableLocatorProcedures.java:690)
at org.apache.derby.client.am.Clob.positionX(Clob.java:482)
at org.apache.derby.client.am.Clob.position(Clob.java:454)
... 3 more
Caused by: org.apache.derby.client.am.SqlException: The exception
'java.sql.SQLException: Unable to set stream: 'Reached end-of-stream
prematurely'.' was thrown while evaluating an expression.
at
org.apache.derby.client.am.Statement.completeExecute(Statement.java:1498)
at
org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(NetStatementReply.java:304)
at
org.apache.derby.client.net.NetStatementReply.readExecuteCall(NetStatementReply.java:105)
at
org.apache.derby.client.net.StatementReply.readExecuteCall(StatementReply.java:75)
at
org.apache.derby.client.net.NetStatement.readExecuteCall_(NetStatement.java:176)
at
org.apache.derby.client.am.Statement.readExecuteCall(Statement.java:1464)
at
org.apache.derby.client.am.PreparedStatement.flowExecute(PreparedStatement.java:2158)
at
org.apache.derby.client.am.PreparedStatement.executeX(PreparedStatement.java:1578)
at
org.apache.derby.client.am.CallableLocatorProcedures.clobGetPositionFromString(CallableLocatorProcedures.java:789)
... 6 more
Caused by: org.apache.derby.client.am.SqlException: Unable to set stream:
'Reached end-of-stream prematurely'.
at org.apache.derby.client.am.SqlException.<init>(SqlException.java:290)
at org.apache.derby.client.am.SqlException.<init>(SqlException.java:264)
... 15 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
