Can Hibernate be used with SQLJ ?

Muthukkumari · **Posted:** Thu Jun 15, 2006 4:52 am

I am new to Hibernate.
We are using SQLJ to access data from a DB2 database in our project.

Can we use Hibernate to get the data using the #sql context object (SQLJ) ?

max · **Posted:** Thu Jun 15, 2006 11:28 am

No I don't think so (not easily at least) - SQLJ is a technology that normally *hard* couples (even though it promises otherwise) your code to the underlying database, mainly because it is a very intrusive tech.

Anyway, if you "just" want Hibernate to execute queries through you a sql context and that sql context can provide a connection then write a ConnectionProvider that returns that to it.

Muthukkumari · **Posted:** Fri Jun 16, 2006 12:01 am

Dear max,
Thanks for your reply.

you said..

'Anyway, if you "just" want Hibernate to execute queries through you a sql context and that sql context can provide a connection then write a ConnectionProvider that returns that to it.'

Can you please explain this " write a ConnectionProvider that returns that to it" ?