I was wondering what is the best strategy, if available, to put couple of database updates into one transaction. These update sqls involve several databases, so usual connection.setAutoCommit(false) does not work here. One basic and maybe stupid way is to establish all connections first, and setAutoCommit(false) to all these connections, and after everything is done and successful, setAutoCommit(true)to all these connections. This approach does not apply to my situation, since I need to use some existing
java classes, which establish connect5ion and do insertion themself. thanks
[ April 04, 2002: Message edited by: bill williams ]
[ April 04, 2002: Message edited by: bill williams ]