This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin 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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!