Look at the javadoc for javax.sql.Connection
If I understand what you are doing,
you want TRANSACTION_SERIALIZABLE
to stop another transaction inserting a record
after your select statement that would have been
All you are doing, is not seeing uncommitted records.
Thanks for that....erm...
Could you tell me where I set it?
I have set it in jboss.jcml in XADataSourceLoader>>TransactionIsolation, but I a still experiencing the same problem.
In Weblogic, this is set in weblogic-ejb-jar.xml on a per bean basis, but there does not seem to be an equivalent setting available in jboss.xml.
Does your database support that isolation level?
Try using getTransactionIsolation() to see what
level of isolation you get.