Hibernate Tools with DB2 on mainframe

rachelkinder · **Joined:** Mon May 29, 2006 9:38 pm **Posts:** 6

I do not see DB2 listed as a supported database in the list for the Hibernate Tools, but yet is is supported with Hibernate. Has anyone tried the Tools with DB2? If so was it not successfuly and that is why it is not listed as a supported db?
thanks,

max · **Posted:** Tue May 30, 2006 5:10 am

what list are you looking at ? The wiki page ?

It is a wiki, so if you can verify it just works then please update the wiki page.

(but if db2's driver works per spec it will work for the reverese engineering ...the querying will of course just work)

rachelkinder · **Joined:** Mon May 29, 2006 9:38 pm **Posts:** 6

The list that I'm referring to is the list of 'decent databases and drivers' at http://www.hibernate.org/383.html.

I see other posts with reference to DB2 and other issues, so it must be supported, my issue must be something else.

Thanks

rachelkinder · **Joined:** Mon May 29, 2006 9:38 pm **Posts:** 6

2006-05-30 14:20:16,687 3971109 [ Worker-9] WARN ng.dialect.JDBCMetaDataDialect - Could not get schemas
com.ibm.db2.jcc.a.SqlException: unsupported encoding Cp500 for result set column
at com.ibm.db2.jcc.a.f.a(f.java:377)
at com.ibm.db2.jcc.c.br.a(br.java:2011)
at com.ibm.db2.jcc.c.bc.a(bc.java:3108)
at com.ibm.db2.jcc.c.bc.a(bc.java:1713)
at com.ibm.db2.jcc.c.bc.b(bc.java:1653)
at com.ibm.db2.jcc.c.bc.a(bc.java:1622)
at com.ibm.db2.jcc.c.bc.l(bc.java:417)
at com.ibm.db2.jcc.c.bc.k(bc.java:327)
at com.ibm.db2.jcc.c.bc.e(bc.java:91)
at com.ibm.db2.jcc.c.q.e(q.java:108)
at com.ibm.db2.jcc.c.bo.i(bo.java:187)
at com.ibm.db2.jcc.a.cq.n(cq.java:1205)
at com.ibm.db2.jcc.a.cr.d(cr.java:1996)
at com.ibm.db2.jcc.a.cs.Q(cs.java:174)
at com.ibm.db2.jcc.a.p.a(p.java:7751)
at com.ibm.db2.jcc.a.p.a(p.java:6301)
at com.ibm.db2.jcc.a.p.getTables(p.java:6215)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:70)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:404)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:68)
at

Any ideas?

max · **Posted:** Wed May 31, 2006 4:15 am

db2 has weird resctrictions - why can't it return the table list because of some encoding ?

What is CP500 encoding ? some non-western character set ? We just run with the default encoding the vm runs with....

rachelkinder · **Joined:** Mon May 29, 2006 9:38 pm **Posts:** 6

In looking it up, cp500 = EBCDIC 500 V1, but I'm not sure what that means to be honest.
The error that follows the Could not get schemas is DatabaseMetaData method called after connection was closed.

I do have the showsql turned on, but with the 'Tools' as opposed to using HIbernate within our project, I'm not sure how to get at the hSQL being sent.

Is it possible that I have something wrong in my config? Am able to hit SQL Sever with JTDS no problem with my current setup.

max · **Posted:** Wed May 31, 2006 8:49 am

we don't send SQL we just call jdbc API.

rachelkinder · **Joined:** Mon May 29, 2006 9:38 pm **Posts:** 6

How can I find out then what JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:70) translates to in SQL?

max · **Posted:** Wed May 31, 2006 10:14 am

look into their driver ;)

..maybe you can list the client's sql on the DB2 side somehow ?