db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brett Wooldridge (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
Date Wed, 05 Aug 2009 01:28:14 GMT
DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
--------------------------------------------------------------------------

                 Key: DERBY-4337
                 URL: https://issues.apache.org/jira/browse/DERBY-4337
             Project: Derby
          Issue Type: Bug
          Components: Network Client
    Affects Versions: 10.5.1.1, 10.4.2.0, 10.4.1.3
         Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3

            Reporter: Brett Wooldridge


This bug was created after discussions on the developer mailing list, which can be found here:

http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315

In short summary, in an environment involving JTA, Derby, and connection pooling we are experiencing
a failure retrieving a CLOB.

To answer some of the questions and suggestions raised:

1. After switching to the EmbeddedXADataSource, the problem goes away.  This is not a "workaround"
for me, but is diagnostic of the issue.
2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs.  So the "regression"
is between 10.3.2.1 and 10.4.2.0.
3. I have built 10.5.2.0, the problem still occurs.


Execution failed because of a Distributed Protocol Error:  DRDA_Proto_CMDNSPRM; CODPNT arg
 = 2414; Error Code Value = 0
org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of a Distributed
Protocol Error:  DRDA_Proto_CMDNSPRM; CODPNT arg  = 2414; Error Code Value = 0
	at org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Execution failed because of a Distributed Protocol Error:  DRDA_Proto_CMDNSPRM; CODPNT arg
 = 2414; Error Code Value = 0
org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of a Distributed
Protocol Error:  DRDA_Proto_CMDNSPRM; CODPNT arg  = 2414; Error Code Value = 0
	at org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
An IOException was thrown when reading a 'java.sql.String' from an InputStream.
java.sql.SQLException: An IOException was thrown when reading a 'java.sql.String' from an
InputStream.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown Source)
	at org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown Source)
	at org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown Source)
	at org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown Source)
	at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source)
	at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source)
	at org.apache.derby.impl.drda.Database.close(Unknown Source)
	at org.apache.derby.impl.drda.Session.close(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Caused by: java.sql.SQLException: Java exception: 'Stream has already been read and end-of-file
reached and cannot be re-used.: java.io.EOFException'.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
	... 13 more
Caused by: java.io.EOFException: Stream has already been read and end-of-file reached and
cannot be re-used.
	at org.apache.derby.iapi.types.ReaderToUTF8Stream.read(Unknown Source)
	at java.io.DataInputStream.read(DataInputStream.java:80)
	at org.apache.derby.iapi.types.SQLClob.readExternal(Unknown Source)
	at org.apache.derby.iapi.types.SQLChar.getString(Unknown Source)
	at org.apache.derby.iapi.types.SQLChar.setFrom(Unknown Source)
	at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
	at org.apache.derby.impl.sql.GenericParameterValueSet.transferDataValues(Unknown Source)
	at org.apache.derby.impl.sql.execute.BaseActivation.setParameters(Unknown Source)
	at org.apache.derby.impl.sql.GenericActivationHolder.setParameters(Unknown Source)
	... 11 more
Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM = ziptie; diagnostic
msg = An IOException was thrown when reading a 'java.sql.String' from an InputStream.
org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of Permanent Agent
Error: SVRCOD = 40; RDBNAM = ziptie; diagnostic msg = An IOException was thrown when reading
a 'java.sql.String' from an InputStream.
	at org.apache.derby.impl.drda.DRDAProtocolException.newAgentError(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.sendUnexpectedException(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message