• Post Reply Bookmark Topic Watch Topic
  • New Topic

Unable to set AutoCommit to false in MS Access

 
Abhinav Anand
Ranch Hand
Posts: 113
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys,
I use MS Access as the backend database and JdbcOdbcDriver driver as the jdbc driver. I want to support concurrent connections so to disable concurrent updates to my tables I try to set the connection's auto commit mode to false. But when I try to execute this code:
con.setAutoCommit(false);
It does not works. The message i get states that the auto commit mode cannot be set at this paticular position.
Any suggetions ??
Thanks
 
Asanka Nanayakkara
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi.
I assume that you are using JDBC DBC Bridge to connect to Access database. You can’t do transaction handling using Access; Access a database doesn’t have built in transaction log or it doesn’t support transaction handling as his big brother SQL Server. (Remember they are completely different type of databases).
Regards
Asanka
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!