CODEWITHSUNDEEP
javasql
Reeza Muaz
Reeza Muaz

Reputation: 23

cannot insert java.sql.Date to the "Date" field in the database

I am getting a string value such as "2012-01-20" and converting it to sql.Date to insert it in the database.

code

java.util.Date DOB = new java.util.Date();
String datetext = txtDate.getText();

SimpleDateFormat sd = new SimpleDateFormat("yyyy-mm-dd");
DOB = sd.parse(datetext);
java.sql.Date sqlDate = new java.sql.Date(DOB.getTime());

String query = "ISERT INTO EMPLOYEE ('DOB')"
                   + " VALUES ( ? ) ";

con = db.createConnection();
 try{
     ps = con.prepareStatement(query);
     ps.setDate(1, sqlDate);
     ps.executeQuery();
    }catch(Exception ex){
       System.err.print(ex);
  }

When i run this code I am getting an exception ""[Microsoft][ODBC SQL Server Driver]Optional feature not implemented"

what am i doing wrong here ? pls help !

Upvotes: 2

Views: 2957

Answers (1)

KV Prajapati
KV Prajapati

Reputation: 94625

Remove single quote - ('DOB') and INSERT (misspell)

String query = "INSERT INTO EMPLOYEE (DOB) VALUES (?)";

You may use java.sql.Date.valueOf("2012-01-20") method to convert string to sql date.

Use executeUpdate() method instead of executeQuery().

String query = "INSERT INTO EMPLOYEE (DOB) VALUES (?)";

con = db.createConnection();
 try{
     ps = con.prepareStatement(query);
     ps.setDate(1, java.sql.Date.valueOf("2012-01-20"));
     //Or use
     //  ps.setTimestamp(1, new Timestamp(DOB.getTime())); 
     ps.executeUpdate();
    }catch(Exception ex){
       System.err.print(ex);
  }

Upvotes: 5

Related Questions