Member Menu
 
 Monthly JBoss newsletter:
 
Hibernate Books
CaveatEmptor

Reverse Engineering support in database and drivers

The following page describes how the various combinations of databases and drivers works ( or does not work ) - feel free to add/update to the list.

Database Driver Status Description
Oracle 8-10 Latest Oracle or DataDirect Works To get comments/remark a property needs to be set in jdbc url. Note, when comments is enabled it gets slow
HSQLDB 1.8 HSQLDB 1.8 Works
MySQL ? Works depending on config Older drivers does not report foreign keys even if they are in the database. On older Mysql's you have to explicitly enable InnoDb to get foreign keys even though you have defined them.
Sybase ? Works depending on config If you get an excpetion about "create table" is not allowed (even though the reveng tools does not do that) you need to enable "ddl in trans" for it to run within transactions. Alternative work around set: hibernate.connection.autocommit=true, but only when using the tools - not when using hibernate core.
PostgresSQL ? Works depending on driver Older drivers were not jdbc compliant with respect to column names and/or report autocommit is not supported. Use a more uptodate driver.
SQL Server 2000 jTDS 1.1 Works
© Copyright 2006, Red Hat Middleware, LLC. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc. [Privacy Policy]