I am a developer on the jTDS project and am interested in ensuring the jTDS JDBC driver (http://jtds.sourceforge.net) is compatible with Hibernate. While I do not use Hibernate myself, I believe it is important to make sure the driver is 100% compatible so that it may be used/supported by the hibernate project. Our current development code is showing only a handful of failures with the Hibernate 2.1.2 tests now (the last release of the driver had 60+ failures). However, one of the failures I do not understand is in SQLFunctionsTest.testBlobClob. What is the contract expected to be between Hibernate and a JDBC driver for Blob's? As far as I can tell, the driver is now compliant with the JDBC specification (in terms of Blob support). Does anybody have an idea on why this failure may be occurring?

SQLFunctionsTest.testBlobClob

Error Blobs are not cacheable

java.lang.UnsupportedOperationException: Blobs are not cacheable
at net.sf.hibernate.type.BlobType.disassemble(BlobType.java:60)
at net.sf.hibernate.impl.CacheEntry.disassemble(CacheEntry.java:36)
at net.sf.hibernate.impl.CacheEntry.<init>(CacheEntry.java:27)
at net.sf.hibernate.impl.SessionImpl.initializeEntity(SessionImpl.java:2178)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:240)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:831)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:851)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:57)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:49)
at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
at net.sf.hibernate.impl.SessionImpl.refresh(SessionImpl.java:2147)
at net.sf.hibernate.impl.SessionImpl.refresh(SessionImpl.java:2110)
at org.hibernate.test.SQLFunctionsTest.testBlobClob(SQLFunctionsTest.java:480)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at org.hibernate.test.TestCase.runTest(TestCase.java:82)
0.515


Any insight would be appreciated,
-Brian

Ack! Its not you its me :(

The test suite enables second-level cache for all classes and requires a code edit to turn this off. Since Blobs cannot be cached, this failure occurs unless you disable caching. I intend to make this a property setting for the test suite!

Sorry I wasted your time on this.

Let us know when the rest of the test suite runs and we will announce this, it will be great to have a free, working alternative!

Thanks gavin, I will ignore this failure for the time being then. As soon the tests run clean on a relelased driver, I will post in this forum to let everyone know.

-Brian