I would like information on begintrans,is it the same as autocommit.
posted 13 years ago
A bartender should probably move this to the JDBC forum. But to answer your question, yes, you should use the setAutoCommit(true) method of your java.sql.Connection object if you want to explicitly use transactions. When you set auto commit to true, then the JDBC driver is responsible for autmatically starting a transaction the next time you execute a statement. Then each time you do a commit() on the Connection object, the changes will be committed. Then the next statement you execute will start another transaction automatically and the cycle starts over again.
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"