Invalid Transaction State

[Timothy Sam]

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.*;

public class FAnglesDBTest
{
 
    public static void main(String args[])
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String dsn = "FAnglesDB";
            String url = "jdbc :-o	 dbc:" + dsn;
            Connection con = DriverManager.getConnection(url, "", "");
            con.setAutoCommit(false);
 
            System.out.println("Database connection succeeded");
 
            Statement statement;
            String query;
            ResultSet rs;
 
            statement = con.createStatement();
            
            statement.execute("CREATE TABLE employee_tbl(emp_num integer)");
            statement.execute("INSERT INTO employee_tbl values(4)");
            statement.execute("SELECT emp_num FROM employee_tbl");
 

            rs = statement.getResultSet();            
 

            System.out.println("Execute query succeeded");
 
            statement.close();
            rs.close();
            con.close();
 
        }
        catch(Exception err)
        {
            System.out.println("Error: " + err);
        }
    }
 
}

Thanks guys...

[Annie Smith]

Try closing the statement after executing the insert. That should release the locks IIRC.