• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transaction blues

 
vikhyath kodipelli
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using jsp with access.Whenever i use the code con.setAutoCommit(false) i get a runtime exception saying invalid transaction state. without it everything works fine except ofcourse there is no transaction support.what could be the possible reasons.Please help.Thanks in advance.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by vikhyath kodipelli:
I am using jsp with access.Whenever i use the code con.setAutoCommit(false) i get a runtime exception saying invalid transaction state. without it everything works fine except ofcourse there is no transaction support.what could be the possible reasons.Please help.Thanks in advance.

does access support transactions?? I didn't think so. I posted a link in a similar discussion here that seems to say that MSAccess does not support transactions. It may also be limited to the ODBC drivers used to access the database. If anyone else finds some better links with regards to MSAccess and transaction support, please post it.
Jamie
 
vikhyath kodipelli
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks jamie. I guess i will have to port it to Oracle.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic