Embedded EJB3 doesn't work when Transaction Isolation is set

[dangelo1]

If you add the following in the datasource configuration of the Embeddable EJB3

TRANSACTION_REPEATABLE_READ

of any other transaction isolation level


It doesn't work!

i.e. in SQL server my database inserts just hangs and doesn't seem to get committed.

[bill.burke]

Sounds like a problem with your application and database.

[dangelo1]

We have discovered the cause.... In our unit test we use hibernate and it has a create setting on the ddl creation...

However the SchemaExport tool that hibernate uses calls setAutoCommit(true) which fails....

because of this the database is put into some wiered behaviour that everytime hibernate tries to generate an id using th hilo generator... it blocks because it could not for some reason get a excusive lock on the row...


our solution is to just not use the create setting for ddl generation