This week's book / license giveaways are in the JDBC and Relational Databases and Java in General forums.
We're giving away four copies each of PostGIS in Action and Java Advanced Topics Training and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and Relational Databases and the fly likes Invalid Transaction State Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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>
I agree. Here's the link:
subject: Invalid Transaction State