File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Updates

 
Tapan Parikh
Greenhorn
Posts: 26
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 358
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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);
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic