Insert Java.sql.Date into Derby Database

Question

I am trying to insert a date object into the database but it says im trying to insert an Integer. Here is my code:

public void insertAssignment(long studentId, String newAssignment, int ptsTotal, int ptsRecieved, String category, Date dueDate, String term, int yr) {
    java.sql.Date temp = new java.sql.Date(dueDate.getTime());
    try{
        s.execute("INSERT INTO Assignments " +
                  "VALUES (" + studentId + ",'" + newAssignment + "'," + ptsTotal +
                  "," + ptsRecieved + ",'" + category + "'," + temp
                  + ",'" + term + "'," + yr + ")");
        System.out.println("Assignment inserted.");
    }
    catch(SQLException error){
        System.err.println("Unable to insertAssignment.");
        error.printStackTrace(System.err);
        System.exit(0);
    }
}

My error: java.sql.SQLSyntaxErrorException: Columns of type 'DATE' cannot hold values of type 'INTEGER'.

It is because the column matching your date column is actually an int value. Also use PreparedStatement. In your sql add the column names. — CoolBeans
– CoolBeans, Commented Jul 20, 2011 at 23:17

Thorbjørn Ravn Andersen · Accepted Answer · 2011-07-21 08:09:52Z

4

To do this, use a prepared statement instead and use a setter.

Currently you flatten your date to a string value (which needs to be in the right format for the database for this to work) and lose that it is a date so the database needs to parse it. You avoid this using the prepared statement.

edited Jul 21, 2011 at 8:09

answered Jul 20, 2011 at 23:29

Thorbjørn Ravn Andersen

75.4k35 gold badges203 silver badges359 bronze badges

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

Collectives™ on Stack Overflow

Insert Java.sql.Date into Derby Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related