JDBC connection transactions

I need to accomplish a number of related select/insert statements(about 10 or 12 distinct queries most on seperate tables) these are all related and if one fails I need to roll all the others back.

This is a servlet environment written in java. It seems to me that I could implament one of a number of standards. I could get a nonautocommitting  connection and pass it from transaction to transaction, rolling back or commiting as needed. I could also create the entire set of queries as one stored procedure. or I could do a combination of the two(this is what I am doing now but it seems problematic because the stored procedures that do part of the work will commit on finishing, thus making any rollback back in the java layer useless)

the problem with going to the database 10 or 12 times per each one of these transactions is just that going to the database 10 or 12 times per each one of these transactions.

I wondered if there is a standard way that people handle this. Or if anyone has any tricks/places to look for reading, etc.

Thanks in advance

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 08 2000 - 10:41:28 CST