JDBC insert record

[Minh Phan]

After connecting the Access database, try to insert a record and an error message is displayed: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Invalid attribute/option identifier. Why use the commented out lines it is OK? Please help. Here is the code:

import java.io.*;
import java.sql.*;
 
class MyInsert {
static private Statement st;
static private Connection con;
static private ResultSet rs;

public static void main(String[] args) {   
try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con=DriverManager.getConnection(
            "jdbc :o dbc:library","","");
            
st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                     ResultSet.CONCUR_READ_ONLY);
                                
rs = st.executeQuery("select bkCode,bkName,bkAuthor,bkAvailableQty from book");                                
}
catch(Exception e){
      System.out.println("Error opening connection: " + e);   
   }
   
   try {
   String bc = "AAA";
   String bn = "BBB";
   String ba = "CCC";
   int baq = 1;
   
   //String query = "Insert into book Values('" + bc + "', '" + bn + "', '" + ba + "', " + baq + ")";
//System.out.println(query); // this should looks like your commented line below
  
//int result = st.executeUpdate(query);   

//if(result==1)
   //System.out.println("1 record inserted");
//else
//System.out.println("Sorry...Unkown error");

 
        rs.moveToInsertRow();
        rs.updateString("bkCode", "AAA");
        rs.updateString("bkName", "AAA");
        rs.updateString("bkAuthor", "AAA");
        rs.updateInt("bkAvailableQty", 150);
        rs.insertRow();
   }
catch(SQLException e){
      System.out.println("Error inserting record: " + e);   
   }  
}

}

[edited to disable smilies and add code tags]
[ October 05, 2004: Message edited by: Jeanne Boyarsky ]

[Jeanne Boyarsky]

Minh,
Welcome to JavaRanch!

I suggest using a prepared statement instead of a statement. That takes care of the formatting for you.

Check whether the table is defined using the columns in the same order as are in your SQL insert. Or better yet, add the column names explicitly to the SQL.

[Ramaswamy Srinivasan]

Hi Minh

Welcome to Javaranch. Sure you will have a great time Ranching here

I suggest using a prepared statement instead of a statement

I too second the strong recommendation of prepared statement.

It is compiled once and then can be reused. When u want to add some performance measures to your code, you go for the PreparedStatement. You have quite a good time...using that.

Simple and effecient enough.

And did u try the query at the DB console? Did it work properly?Try this out and if trouble still persists, you know where to get back.

Cheers,
Swamy