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

Question

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 !

KV Prajapati · Accepted Answer · 2012-01-20 05:19:11Z

5

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);
  }

edited Jan 20, 2012 at 5:19

answered Jan 20, 2012 at 4:28

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Reeza Muaz Over a year ago

the "valueof" method is not found ? why is that

KV Prajapati Over a year ago

Date.valueOf() - More info - docs.oracle.com/javase/1.5.0/docs/api/java/sql/Date.html

Reeza Muaz Over a year ago

Thanks , I corrected that. But making all the modifications as You suggested , still does not solve the problem. It gives the same exception.

KV Prajapati Over a year ago

@ReezaMuaz - May be you missed something to set ODBC DSN. See I've edited post.

Reeza Muaz Over a year ago

the DSN is already set and connection is made successfully. When I am debugging the executeUpdate() line is not even reached, after the ps.setDate() it throws the exception. :/

|

Collectives™ on Stack Overflow

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

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related