This week's book giveaway is in the JDBC forum.
We're giving away four copies of Make it so: Java DB Connections & Transactions and have Marcho Behler on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Updates Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Updates" Watch "Updates" New topic


Tapan Parikh

Joined: Jun 28, 2001
Posts: 26
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()...
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
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.
// your
// SQL statements
// will go here

Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
I agree. Here's the link:
subject: Updates
It's not a secret anymore!