Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic