Problems with reverse engineering in Sybase ASE 12.5

dcastro · **Joined:** Mon Feb 13, 2006 10:26 am **Posts:** 6

I'm using Hibernate 3.1.2 and Hibernate Tools 3.1.0 Beta 4 in Eclipse 3.1.1 with a Sybase ASE 12.5.3 and I when I try to generate the code automatically I get the following error:

Code:

Exception while generating code
Reason:
org.hibernate.exception.GenericJDBCException: Error while reading primary key meta data for myDB.myTable

Details:

Code:

org.hibernate.exception.GenericJDBCException: Error while reading primary key meta data for myDB.myTable
  com.sybase.jdbc3.jdbc.SybSQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

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

The settings that I'm using in the hibernate.cfg.xml are correct because I was using Hibernate with this file and everything worked well.

Thank you very much,
Diego

max · **Posted:** Mon Feb 13, 2006 10:53 am

sybase has issues with reading jdbcmetadata in a tx.

search the forum for solutions - been reported previously.

dcastro · **Joined:** Mon Feb 13, 2006 10:26 am **Posts:** 6

I read what you answered in the other topic, but didn't find the solution of that problem... Do you have any idea of what can I do to solve that problem?

Thank you very much... Diego

romatenen · **Joined:** Tue Nov 15, 2005 12:25 pm **Posts:** 15

Diego.

Make sure that Option : ddl in tran checked for your database

dcastro wrote:

I read what you answered in the other topic, but didn't find the solution of that problem... Do you have any idea of what can I do to solve that problem?

Thank you very much... Diego

dcastro · **Joined:** Mon Feb 13, 2006 10:26 am **Posts:** 6

Thank you for the answer!

Can you specify where do I find that option ("ddl in tran") in order to check it?

Thanks, Diego

romatenen · **Joined:** Tue Nov 15, 2005 12:25 pm **Posts:** 15

Diego.

In Sybase Central , Database - Properties - Options tab.

dcastro · **Joined:** Mon Feb 13, 2006 10:26 am **Posts:** 6

I did what you said, but I'm still getting the same error... Any other idea to solve that issue??

Thanks, Diego

romatenen · **Joined:** Tue Nov 15, 2005 12:25 pm **Posts:** 15

Check if you have rights to create tables.

Otherwise it should help.

I remember having the same problem, but changing option ddl in tran and access rights did helped.

dcastro · **Joined:** Mon Feb 13, 2006 10:26 am **Posts:** 6

Thanks for your help romatenen.

I've created tables manually (with Sybase Central and SQL Advantage), so I think I have rights to do so... But how can I check if I have rights to create tables in the Sybase Central?

Thanks,
Diego