I got a problem reverse engineering domain code from a db2 database which is on a Linux server, Has anyone of you ever succeeded with db2 database? Any help would be highly appreciated.


configuration:
Hibernate Tools version: HibernateTools-3.2.3
Database: DB2 9.5
JDBC-Driver: I copied db2jcc.jar Iand db2jcc_license_cu.jar from server to my lib.
Eclipse Version: 3.3.2
Build id: M20080221-1800

The exception is as following:


Error
Thu Mar 12 15:10:47 CST 2009
com.ibm.db2.jcc.b.SqlException: DatabaseMetaData information is not known for server DB2/LINUXSQL09052 by this version of JDBC driver

com.ibm.db2.jcc.b.SqlException: DatabaseMetaData information is not known for server DB2/LINUXSQL09052 by this version of JDBC driver
at com.ibm.db2.jcc.b.s.storesMixedCaseQuotedIdentifiers(s.java:873)
at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.caseForSearch(AbstractMetaDataDialect.java:163)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:22)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$2.execute(LazyDatabaseSchemaWorkbenchAdapter.java:111)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:65)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:102)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:59)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:103)
at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:196)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

I tested with db2 and did not bump into issues.

Seems like you got some combination of drivers and db2 server that result in an exception being thrown when we ask what casing to use for the database identifiers.

Please report in jira with what drivers/database/os version you are using (prefereably with links to get the drivers and database for testing)

As a workaround you can look into implementing a subclass of JBDCMetaDataDialect that does call the storesMixedCaseQuotedIdentifiers method and just return a fixed true or false.

Then look in docs for the property to set to use your JBDCMetaDataDialect sub class.

Hi Max, Thanks for your help. I have solved this problem. We can now generate the java files through db2 database now. But I still don't figure out why, I tried again the next day(without changing anything), it just succeeded. It's the same case with one of my colleagues. He met the same exception as I did, but it somehow works the next day. and we connect to different db2 server.

I've never bumped into this exception afterwards, But he did, and after he restarted the server, the exception just disapeared.

The only info I can find about the error is http://www-01.ibm.com/support/docview.w ... wg21259874

But Db2 can be funny at times with respect to jdbc drivers :)