jdbc4/ClobTest fails on Zos with AssertionFailedError: Streams differ at index 0 expected:<200> but was:<72>

• Key: DERBY-3774
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Major
• Assignee: Kathey Marsden
• Reporter: Kathey Marsden
• Component/s: JDBC
• Affects Version/s: 10.5.1.1
• Fix Version/s: 10.4.2.0, 10.5.1.1

Description

testGetAsciiStreamCreateClob(org.apache.derbyTesting.functionTes
ts.tests.jdbc4.ClobTest)junit.framework.AssertionFailedError:
Streams differ at index 0 expected:<200> but was:<72>
at
org.apache.derbyTesting.junit.BaseTestCase.assertEquals(BaseTest
Case.java:341)
at
org.apache.derbyTesting.functionTests.tests.jdbc4.ClobTest.testG
etAsciiStreamCreateClob(ClobTest.java:575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
Impl.java:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
AccessorImpl.java:39)
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.
java:101)
at
junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.ja
va:57)
at
junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at
junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.ja
va:57)
at
junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.ja
va:57)

I was able to reproduce this on Windows with slightly different errors running with -Dfile.encoding="UTF-16"

There were 2 errors:
) testGetCharacterStreamClobUpdates(org.apache.derbyTesting.functionTests.tests.jdbc4.ClobTest)java.sql.SQLException: T
e position argument '53' exceeds the size of the BLOB/CLOB.
       at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
       at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
       at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:93)
       at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:172)
       at org.apache.derby.impl.jdbc.EmbedClob.setString(EmbedClob.java:559)
       at org.apache.derby.impl.jdbc.EmbedClob.setString(EmbedClob.java:525)
       at org.apache.derbyTesting.functionTests.tests.jdbc4.ClobTest.testGetCharacterStreamClobUpdates(ClobTest.java:69
)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:104)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
aused by: java.sql.SQLException: The position argument '53' exceeds the size of the BLOB/CLOB.
       at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
       at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
)
       at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
       ... 34 more
) testGetCharacterStreamClobUpdates(org.apache.derbyTesting.functionTests.tests.jdbc4.ClobTest)java.sql.SQLException: T
e position argument '53' exceeds the size of the BLOB/CLOB.
       at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:96)
       at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:362)
       at org.apache.derby.client.am.Clob.setString(Clob.java:588)
       at org.apache.derbyTesting.functionTests.tests.jdbc4.ClobTest.testGetCharacterStreamClobUpdates(ClobTest.java:69
)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:104)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
aused by: org.apache.derby.client.am.SqlException: The position argument '53' exceeds the size of the BLOB/CLOB.
       at org.apache.derby.client.am.Clob.setStringX(Clob.java:624)
       at org.apache.derby.client.am.Clob.setString(Clob.java:579)
       ... 38 more
here were 2 failures:
) testGetAsciiStreamCreateClob(org.apache.derbyTesting.functionTests.tests.jdbc4.ClobTest)junit.framework.AssertionFail
dError: Streams differ at index 0 expected:<254> but was:<72>
       at org.apache.derbyTesting.junit.BaseTestCase.assertEquals(BaseTestCase.java:343)
       at org.apache.derbyTesting.functionTests.tests.jdbc4.ClobTest.testGetAsciiStreamCreateClob(ClobTest.java:575)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:104)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
) testGetAsciiStreamCreateClob(org.apache.derbyTesting.functionTests.tests.jdbc4.ClobTest)junit.framework.AssertionFail
dError: Streams differ at index 0 expected:<254> but was:<72>
       at org.apache.derbyTesting.junit.BaseTestCase.assertEquals(BaseTestCase.java:343)
       at org.apache.derbyTesting.functionTests.tests.jdbc4.ClobTest.testGetAsciiStreamCreateClob(ClobTest.java:575)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:104)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
       at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
       at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
       at junit.extensions.TestSetup.run(TestSetup.java:23)
       at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)

FAILURES!!!
Tests run: 22, Failures: 2, Errors: 2