[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6637) LOB test case failures with Teradata against Hibernate 3.6.

[David Repshas (JIRA)]

LOB test case failures with Teradata against Hibernate 3.6.
-----------------------------------------------------------

                 Key: HHH-6637
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6637
             Project: Hibernate Core
          Issue Type: Bug
          Components: testsuite
    Affects Versions: 3.6.6
         Environment: Hibernate 3.6.6 testsuite running against Teradata 13.10 DBS.
            Reporter: David Repshas


The following two test cases fail when run against Teradata:
org.hibernate.test.lob.BlobLocatorTest.java
org.hibernate.test.lob.ClobLocatorTest.java

 
The error returned is:

Testcase: testBoundedBlobLocatorAccess(org.hibernate.test.lob.BlobLocatorTest):        Caused an ERROR
[Teradata Database] [TeraJDBC 13.10.00.20] [Error 5766] [SQLState HY000] The Locator is invalid because the response spool has been 
dropped.
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.10.00.20] [Error 5766] [SQLState HY000] The Locator is 
invalid because the response spool has been dropped.



The reason for the failure is that the Teradata Response Spool that returned the Locator must remain open while retrieving the data associated with the lob locator. From a JDBC perspective, this requires the Connection, Statement and ResultSet used to obtain the locator reamin open until the LOB data is extracted. 





--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira