Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Hibernate3 rc1

Mapping documents:




Code between sessionFactory.openSession() and session.close():

using jbpm product! but i need some sample to use hibernate with CMTTransaction or JTATransaction and want to know the exact difference betwen both

Full stack trace of any exception that occurs:


Name and version of the database you are using:
MSSqlServer 7 with an extended class that removes 'scope_identity" from sql command

The generated SQL (show_sql=true):



Debug level Hibernate log excerpt:

I'm using log4j in my application but the log of hibernate does not appear!

Only a minor hint, to help us help you:

is wrong. it should be:
log4j.logger.org.hibernate=DEBUG

This way you'll be able to get Hibernate's debug information.

Erik

All right, like i've suspected! Dont work!

Let me explain my entire context:

I'm using EJB2.0 Stateless SessionBean and i'm using de jbpm product of jboss.org that uses hibernate to make persistence on database, and i've readed the jbpm and hibernate documentation, and the jbpm documentatio said that i have to use hibernate3rc1, but i'm having troubles with transaction in hibernate.

My session bean uses a class named MainWorkFlow that is a singleton class that uses jbpm classes. and all (jbpm & hibernate) jar's are in the lib directory of container and i can't make hibernate to use CMT transactions, some times its hangs, some times it trows a null pointer exception and some times it do not found a connection to work with!

I've tried hibernate3, 3rc1 (this), and 3.1, but with no success!

I need the hibernate to work with CMT transaction, couse i need to make some persistences in my own tables at same process, with the same transaction for business data integrity.

My test environment is:
WebSphere 5.1
MSSqlServer 7.0
Hibernate 3*
Jbpm 3*



this dont work

Please, i need a solution to this, couse i have to implement this feature in our product urgently.

Thanks for your replie

If you have identity columns, this might be your problem. Hibernate uses scope_identity() on insert statements if you have identity columns.

All right, and so ? what i've got to do to work with MSSQL7 ?

Umm... don't remove scope_identity. :)

If you have to remove scope_identity for some reason, but you can change your database, don't use identity columns and set your id generator to hilo, or something else.

I've removed it couse the MSSQLServer7 does not recogonize this function! and i've readed in somewhere (that i dont remember now) that it could be removed from the sql command, but i dont think that its my problem, couse the table has a column identity, and mssql7 just autoincrement it at each insert!

Another suggestion ?

thanks for replie

I'm not familiar with SQL Server 7. I use 2000, and Hibernate uses scope_identity() on inserts with that version. Maybe Hibernate doesn't use scope_identity on 7, then. It was just a suggestion. Good luck.

Thanks for suggestions! but MSSQL7 does not have scope_identity() function, its a feature of MSSQL2000.

I dont know what makes system held, but i made a lot of changes including changing the hibernate version, and i found a work around. Look at this topic http://forum.hibernate.org/viewtopic.php?t=947958

Thanks for replies