Hello,
I'm using the Hibernate tools within Eclipse 3.2.0 in order to reverse engineer an existing database. When I try to run the tool, I get the exception noted below:

Hibernate version: 3.1

Full stack trace of any exception that occurs:org.hibernate.exception.GenericJDBCException: Error while reading column meta data for GMI.dbo.DOC_MGMT
com.sybase.jdbc2.jdbc.SybSQLException: The 'CREATE TABLE' command is not allowed within a muli-statement transaction in the 'tempdb'

Name and version of the database you are using: Sybase 12.5

Any ideas would be greatly appreciated.

Thanks,
Warren

answered too many times to count on the forum - use the search ;)

(hint: sybase for some reason report CREATE TABLE is used, but that is not something the tool does but the jdbc driver (apparently) when asking for metadata - enable autocommit when using the tools with sybase and you should be fine)

Max,
Sorry, I thought I'd done a better job of checking before asking :-(
Anyway, your suggestion worked great!

Thanks :-)

-Warren-