error while using sql update statement

[jttslg]

while running the following program i got a runtime error:

exception [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.




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

public class database
{
public static void main(String args[])throws IOException
{
Connection con=null;
Statement stmt=null;
// ResultSet rs=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Access" );
//String s="SELECT * FROM CUSTOMER";
stmt=con.createStatement();
String s1 = "insert into CUSTOMER values('adf','dsf')";
if (stmt.executeUpdate(s1)>0)
System.out.println("record inserted");
else
System.out.println("record insertion failed");
// rs=stmt.executeQuery(s);
// while (rs.next())
// {
// System.out.println(" " + rs.getString("name"));
// }
}
catch(Exception e)
{
System.out.println("exception "+e.getMessage());
}
}
}


plz help me solve the problem

[d3n1s]

try stmt.executeQuery() instead

[DarrylBurke]

I don't do JDBC, but I don't see anywhere in that code where you tell Access which database (.mdb) to use.

@d3n1s: the question is about inserting a record, not about querying a table.

db

[JosAH]

I don't do JDBC, but I don't see anywhere in that code where you tell Access which database (.mdb) to use.

@d3n1s: the question is about inserting a record, not about querying a table.

The OP edited his/her post; the orignal one had a ddl statement where a table was supposed to be created. The error message was different too (something about a read-only database)

kind regards,

Jos

[d3n1s]

I don't do JDBC, but I don't see anywhere in that code where you tell Access which database (.mdb) to use.

@d3n1s: the question is about inserting a record, not about querying a table.

db

You're right db i guess i misread. Before i began using hibernate i had the same approach to inserting a record into mysql and the method he uses work fine. Are you able to run a simple select query to return a rowset using this connection object? As in :

stmt = con.createStatement();
String sql = "SELECT max(id) as id FROM tblPerson";
ResultSet rs = stmt.executeQuery(sql);
rs.first();
Id = rs.getInt("id") + 1;
rs.close();

[mine0926]

con=DriverManager.getConnection("jdbc:odbc:Access" );

I am not sure with this line.

In your stmt = con.createStatement() you have to put the value for parameters such as resultSetType and resultSetConcurrency.
Syntax for this is:

createStatement(int resultSetType, int resultSetConcurremcy)

[Tolls]

I am not sure with this line.

That's fine. It's the syntax for the jdbc-odbc bridge. So long as the OP has an ODBC source defined as Access then that'll work.

In your stmt = con.createStatement() you have to put the value for parameters such as resultSetType and resultSetConcurrency.
Syntax for this is:

createStatement(int resultSetType, int resultSetConcurremcy)

Nope. You don't have to have any parameters on a createStatement() command. I rarely bother, as the default result set is usually OK.

[jttslg]

I don't do JDBC, but I don't see anywhere in that code where you tell Access which database (.mdb) to use.

@d3n1s: the question is about inserting a record, not about querying a table.

db

how do i tell Access which database (.mdb) to use.
plz help

[Tolls]

Have you declared an odbc data source called Access?
If not then you need to do that.
I'm sure there'll be some Microsoft documentation on how to do that.

[jttslg]

Have you declared an odbc data source called Access?
If not then you need to do that.
I'm sure there'll be some Microsoft documentation on how to do that.

that i had already done .... in fact when i use executeQuery method it works fine it is only when i try to update the table this error comes.... plz help

[jttslg]

Have you declared an odbc data source called Access?
If not then you need to do that.
I'm sure there'll be some Microsoft documentation on how to do that.

that i have already done in fact when i use executeQuery method it works fine ... it is only when i try to update the table this error comes.... plz help

[Tolls]

OK, then give us the full error message with stack trace.
You'll have to change your catch block to use printStackTrace().

[jttslg]

OK, then give us the full error message with stack trace.
You'll have to change your catch block to use printStackTrace().

init:
deps-module-jar:
deps-ear-jar:
deps-jar:
compile-single:
run-main:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java :3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcSt atement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Jdbc OdbcStatement.java:288)
at database.main(database.java:18)
BUILD SUCCESSFUL (total time: 1 second)

[Tolls]

Looks like your Access db might be already open?
Something somewhere is marked as read only.

[andrewmonkhouse]

This topic was cross posted to CodeRanch. The OP has not posted anything new in either topic, however it is probably worth looking in the other topic to see if there is anything new.