Agile Database - Java JDBC concerns

[Joseph Yin]

When using Java to access database tables, one of the biggest concern is the transaction control (commit or rollback). Does anyone have any guideline or solution to address my concern.
Thanks, Joseph Yin
[e-mail]

[Lasse Koskela]

Interesting. Do you have any specific concerns regarding how an agile database design would affect your transaction management?

[Ilja Preuss]

Commit if you want the changes to be persistent, rollback otherwise, so it seems to me. But I guess I don't understand the question...?

[Surasak Leenapongpanit]

By default in JDBC transaction starts and commits after each statement's execution on a connection. But it gives poor performance when multiple statements on a connection are to be executed.

[Lasse Koskela]

Originally posted by surasak lee:
By default in JDBC transaction starts and commits after each statement's execution on a connection. But it gives poor performance when multiple statements on a connection are to be executed.

But this still doesn't have anything to do with agile database design...

[Serge Adzinets]

This topic seems appropriate for JDBC forum.

[Craig Demyanovich]

Given a java.sql.Connection instance conn, use

 conn.setAutoCommit(false); 

Now you can commit only when you want to.
Craig
[ January 14, 2004: Message edited by: Craig Demyanovich ]
[ January 14, 2004: Message edited by: Craig Demyanovich ]

[Pradeep bhatt]

What is agile database? This is a new term .

[Jim Yingst]

I'm moving this to the JDBC forum.

[Lasse Koskela]

What is agile database? This is a new term .

There is no such a thing. There's agile database design or development, however.
[ January 14, 2004: Message edited by: Lasse Koskela ]

[Scott Ambler]

For Agile Database material, check out www.agiledata.org.
When it comes to transaction control and agile databases, my only advice is to understand transaction control, concurrency control, recognize you have options, and the pick the right approaches. http://www.agiledata.org/essays/concurrencyControl.html might help a bit.
- Scott