Im having some problems using the JDBCODBC Bridge to connect to Access 97 on Win 98. The problem is that some Updates dont seem to commit to the DB. The statement executes fine, no exceptions or anything, it even produces and exception when the statement is invalid (like when it violates a prim key or foreign key constraint). But the result never shows up in the DB. Any ideas? conn.commit() doesnt work... Also JDBCODBC seems to fire a native error on conn.close()...
posted 14 years ago
When a connection is created, it is in auto-commit mode. This means that each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed. The last thing you can try is disable auto-commit mode and then commit the transaction. Later you can enable the auto commit mode. con.setAutoCommit(false); // your // SQL statements // will go here con.commit(); con.setAutoCommit(true);