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

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 Assignee: Strong Liu Labels: Teradata 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.