This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes Invalid Transaction State Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Invalid Transaction State " Watch "Invalid Transaction State " New topic

Invalid Transaction State

Timothy Sam
Ranch Hand

Joined: Sep 18, 2005
Posts: 746
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.sql.*;

Thanks guys...

SCJP 1.5 -
Annie Smith
Ranch Hand

Joined: Mar 05, 2005
Posts: 172
Try closing the statement after executing the insert. That should release the locks IIRC.

Cheers!<br /><b>Annie</b>
subject: Invalid Transaction State