Hibernate Reverse Engineering Editor - no tables are shown

[va]

Hi, for some reason tables are not shown when i click refresh button. I know the configuration is right, because if i change the conig file i get exceptions (in log).
Can anyone explain the problem?
Thanks

[maxandersen]

is your default schema/catalog set to something non existint ?

[va]

Max,
i upgraded to tools3.1.0.beta4
and
i changed the URL to oldURL/dbName and removed property default schema, where i used to specify dbName. Now, my URL looks like this:
jdbc:sybase:Tds:esmdevdb:5000/access
Now i get a list of tables, and a poblem during code generation:

org.hibernate.exception.GenericJDBCException: Error while reading column meta data for access.dbo.bb_ext_interest_list
com.sybase.jdbc2.jdbc.SybSQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

com.sybase.jdbc2.jdbc.SybSQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

Do i have to have create table rights for this?

[va]

Also,
just read something on this page:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/34899
Apparently using DDL in tempdb is no a good idea...

[va]

"va" wrote:
Also,
just read something on this page:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/34899
Apparently using DDL in tempdb is no a good idea...

..within transactions

[maxandersen]

yes, sybase has this weird error message about "CREATE TABLE" not being allowed even though we don't create any tables - we just ask for metadata.

there is a workaround, just cant remember which one but take a look in the hibernate tools forum.

[va]

I found it on myeclipse site. or at least it looks the same. The workaround discussed there is enabling "Allow DDL in tran" for tempdb - is not really a workaround, since 1. I don't have the rights, 2. This is not good to do even if i could.
http://www.myeclipseide.com/PNphpBB2+file-viewtopic-t-11159.html

[stevel56]

Has anyone sorted this out?

I have the same ptoblem:

Sybase server, able to see the tables in the Hibernate console view, but when I try to reverse engineer it, I get the exception about CREATE TABLE not allowed within a transaction in the tempdb database.

[maxandersen]

and the allow ddl in tran is not usable for you ?

you can also enable autocommit in your hibernate.properties (but only do this for the hibernate.properties you use with the tools)

[va]

In the end i did set that option on tempdb, after all it's just a development db, and it worked. Enabling autocommit sounds like a better idea though.