executeUpdate ODBC Too few parameters

[Brett Swift]

 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

java.sql.Connection con = null;
java.sql.Statement stmt = null;
java.sql.ResultSet rs = null;
con = java.sql.DriverManager.getConnection("jdbc :-o	 dbc:Car","","");
stmt = con.createStatement();
//   \" will put the quote into the string.

String str = "INSERT INTO tblCars (Make,Name,Color,Price)";
str += " VALUES  (\"" + carX.getMake() +" \",\" "+ carX.getName();
str +=  " \",\" "+ carX.getColor() +" \", "+carX.getPrice()+ ")";
int result = stmt.executeUpdate(str);
 

I have checked the SQL string, and it is valid, so its got to be part of the Java code.
I am using an Access2000 Database. And popped up a JOptionPane that gave the message:
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
sometimes says Expected 2.
I am confused as to what the problem is here? I have done some searches and I have found that it is usually a mis-spelled column name (ie Make would not be in the DB). however I have used the same SQL statement and put it right into Access and it worked fine!
I am using VisualAge 2.0, so i stepped through and took the exact sql from the debugger... I know the SQL is fine!

[Dan Cranmer]

You might want to check the parameters you pass to the getConnection method. The following is what we use for Oracle.

  
      Connection connection;
      Class.forName("oracle.jdbc.driver.OracleDriver");
      connection = DriverManager.getConnection("jdbc:oracle:thin:@", "username",
 "password");

There should be some examples of how to use the MS database and jdbc.
[ August 02, 2002: Message edited by: Dan Cranmer ]

[Brett Swift]

I have searched and my code seems to be fine, so it must be either a driver error, or something else.... I have tried PreparedStatements too, and that just gives other errors... check my other post

[Cindy Glass]

Moving this to the JDBC forum.