On 16 Dec 2004 05:09, jdk31 wrote:

>Has anyone tried Hibernate with Cloudscape?
>Cloudscape is very similar to DB2, so it should work.....

I have used Hibernate in the context of JBoss (v4.0.1RC2) and this 
reply is largely in that context.

Cloudscape 5.1.20 does not seem to work with JBoss because for some 
reason the metadata lookup fails.

However, Derby 10.0.2.1 (http://incubator.apache.org/derby/) does work 
with JBoss and Hibernate without any errors. Since this the latest 
open source cut of the Cloudscape version, I guess it would work with 
the latest version of Cloudscape too.

However there are one or two things to watch out. There is no 
DerbyDialiect support in Hibernate at the moment. This can however be 
downloaded from:

http://opensource.atlassian.com/projects/hibernate/browse/HB-1224

compiled and inserted into hibernate's jar.

Hope this helps.

Cheers
-raj