Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Unable to set AutoCommit to false in MS Access  RSS feed

 
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
Boost this thread!