-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 9 posts ] 
Author Message
 Post subject: Problems with reverse engineering in Sybase ASE 12.5
PostPosted: Mon Feb 13, 2006 10:40 am 
Newbie

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


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 13, 2006 10:53 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
sybase has issues with reading jdbcmetadata in a tx.

search the forum for solutions - been reported previously.

_________________
Max
Don't forget to rate


Top
 Profile  
 
 Post subject:
PostPosted: Wed Feb 15, 2006 9:01 am 
Newbie

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


Top
 Profile  
 
 Post subject: Problems with Sybase
PostPosted: Wed Feb 15, 2006 1:27 pm 
Newbie

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


Top
 Profile  
 
 Post subject:
PostPosted: Thu Feb 16, 2006 9:27 am 
Newbie

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


Top
 Profile  
 
 Post subject: ddl in tran
PostPosted: Thu Feb 16, 2006 11:11 am 
Newbie

Joined: Tue Nov 15, 2005 12:25 pm
Posts: 15
Diego.

In Sybase Central , Database - Properties - Options tab.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Feb 16, 2006 11:32 am 
Newbie

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


Top
 Profile  
 
 Post subject: Sybase problem
PostPosted: Thu Feb 16, 2006 3:21 pm 
Newbie

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.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Feb 17, 2006 8:26 am 
Newbie

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


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 9 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.