Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid Transaction State

 
Timothy Sam
Ranch Hand
Posts: 751
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I get the following error when connecting to Microsoft Access Database(ODBC)


Error: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Invalid transaction state


It seems like my database is locked? I dunno... There is a file described as Microsoft Access Recod-Locking information next to my database file. Here's my code...


import java.io.*;
import java.sql.*;



Thanks guys...
 
Annie Smith
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try closing the statement after executing the insert. That should release the locks IIRC.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic