db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "V.Narayanan (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2770) testBlobAfterCommit(....jdbcapi.BlobClob4BlobTest) fails with 'Unexpected SQL state. expected:<XJ[073]> but was:<XJ[215]>'
Date Thu, 07 Jun 2007 06:33:26 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12502234

V.Narayanan commented on DERBY-2770:

Thank you for looking into this and fixing the tests

I am a little worried about this, more so probably because I get
contrasting results with a small test program I wrote

Should'nt the following series of tests produce the same result of this test?

1) Get a connection to the network server (con)
2) Get a empty Clob or Blob (con.createClob() or con.createBlob())
3) do a con.commit()
4) call length on the Clob or Blob(clob.length() or blob.length())

I get the same SQLState for the exception in both
the cases  with an SQLState of XJ073. Maybe I missed something
while writing the program because I wrote the program in a hurry.

Why is testClobAfterCommit() not failing? Locators have been enabled
for Clob too why hasn't it failed.

I am surely missing something really simple I think.

I will attach the test program also, so that in case I have made some
mistake there you can point it out.

> testBlobAfterCommit(....jdbcapi.BlobClob4BlobTest) fails with 'Unexpected SQL state.
expected:<XJ[073]> but was:<XJ[215]>'
> --------------------------------------------------------------------------------------------------------------------------
>                 Key: DERBY-2770
>                 URL: https://issues.apache.org/jira/browse/DERBY-2770
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions:
>         Environment: OS: Solaris 10 6/06 s10x_u2wos_09a X86 64bits - SunOS 5.10 Generic_118855-14
> JVM: Sun Microsystems Inc. 1.6.0_01-b06
>            Reporter: Ole Solberg
>            Assignee: Kristian Waagan
>            Priority: Minor
>             Fix For:
>         Attachments: derby-2770-1a.diff
> testBlobAfterCommit(org.apache.derbyTesting.functionTests.tests.jdbcapi.BlobClob4BlobTest)junit.framework.ComparisonFailure:
Unexpected SQL state. expected:<XJ[073]> but was:<XJ[215]>
> after 
> r544777 / DERBY-2729
> See http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/544778-org.apache.derbyTesting.functionTests.suites.All_diff.txt

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

View raw message