-
1. Re: Hibernate Reverse Engineering Editor - no tables are sho
maxandersen Mar 3, 2006 2:15 AM (in response to va)is your default schema/catalog set to something non existint ?
-
2. Re: Hibernate Reverse Engineering Editor - no tables are sho
va Mar 3, 2006 11:55 AM (in response to 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? -
3. Re: Hibernate Reverse Engineering Editor - no tables are sho
va Mar 3, 2006 12:13 PM (in response to 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... -
4. Re: Hibernate Reverse Engineering Editor - no tables are sho
va Mar 3, 2006 12:14 PM (in response to 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 -
5. Re: Hibernate Reverse Engineering Editor - no tables are sho
maxandersen Mar 3, 2006 2:54 PM (in response to va)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. -
6. Re: Hibernate Reverse Engineering Editor - no tables are sho
va Mar 3, 2006 4:34 PM (in response to 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 -
7. Re: Hibernate Reverse Engineering Editor - no tables are sho
stevel56 Mar 28, 2006 10:57 AM (in response to va)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. -
8. Re: Hibernate Reverse Engineering Editor - no tables are sho
maxandersen Mar 28, 2006 11:04 AM (in response to va)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) -
9. Re: Hibernate Reverse Engineering Editor - no tables are sho
va Mar 28, 2006 4:41 PM (in response to 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.