Hibernate version: 2.1.6

I use MSSQL

I use JBoss 3.2.5

Hi.
I loaded Hibernate as a JMX inside JBoss, works great.
The Hibernate JMX uses a Datasource and JTA.

I want to call Hibernate from within my own JMX (another JMX which uses the SessionFactory the Hibernate JMX binds).

The problem is that i can't use ANY id generation strategy!

sequence - isn't supported by sql-server
regular HiLo - doesn't work with JTA.
Session Bean - isn't loaded before the JMX (couldn't find how to make my JMX depend on that EJB, or any EJB for that matter).

My only solution this far is not to use Datasource at all (the fact that I use datasource makes it already use container managed transactions).

can someone help me please?
Issahar.

Whats wrong with Identity?

First, I am amazed by the very quick reply - you guys are great!




I am programming for several databases, and Oracle doesn't support Identity (as far as I know).

Also, should i defind the table to use and Identity column, or the Hibernate does it by itself?

thanx again,
Issahar.

You want "native", see the documentation.

Hi.
Thank you very much for your replies.

I knew the "native", and even the "identity", and read the manual very carefuly before posting. Those options were my last.

Sorry for bothering again, but...
To avoide the mismatch between the different databases, we designed here an IDGenerator that uses a table (it is also a Session Bean, and a JMX). The JMX is bundled in the same transaction, thus it fails, and the EJB is not loaded before the JMX.

Is there any other way, or am I at a dead-end?

Thanx again for the help,
Issahar.

After lots of debugging, I think we have a solution:

We created a JDBCHiLoGenerator - it works exactly as the TableHiLoGenerator (I copy/pasted the code from there), but I open a JDBC connection, instead of getting it from the DataSource.

It works, so I am happy :)

Issahar.