Re: Can someone tell me what's wrong with my sql statement ?

[Karen Goh]

Filipe Silva Wrote:
-------------------------------------------------------
> Hi Karen,
>
> Your query should be: "INSERT INTO
> project.tutor_subject (tutor_id) VALUES (" +
> generatedId + ")";
>
> Mind the spaces around "VALUES" and the missing
> parenthesis around the values section.
>
> IHTH

Hi Filipe,

There is no error now but I am not able to get the insertion to go into my database :(

stmt2 = (Statement) connection.createStatement();
ResultSet rs = stmt2.executeQuery("SELECT max(tutor_id) as tutor_id from project.tutor");
int tutor_id = 0;
while (rs.next()){
tutor_id = rs.getInt(1);
}
int generatedId = 0;
ResultSet tableKeys = ps.getGeneratedKeys();

while(tableKeys.next())
stmt3 = (Statement) connection.createStatement();
String sql3 = "INSERT INTO project.tutor_subject (tutor_id) VALUES (" + generatedId + ")";
// String sql3 = "INSERT INTO project.tutor_subject (tutor_id) values (LAST_INSERT_ID() from project.tutor)";
if (tableKeys != null)
stmt3.executeUpdate(sql3); // wrong
tableKeys.close();