PreparedStatement executeUpdate()

[vivek ja]

I am trying to insert data into a table using executeUpdate()
The insert is not happening at all, I am not getting any error also.
How can i find out what the problem is?

[Paul Sturrock]

Can you post your code? Otherwise all we can do is guess...

[Wei Dai]

Try Connection.commit();

[vivek ja]

Here is the code, I am doing a commit after executeUpdate.

SQL_CREATE_AGES = "insert into TABLE1 (COL1, COL2, COL3, COL4) VALUES (?,?,?,?);
stmt = argCon.prepareStatement(SQL_CREATE_AGES);
stmt.setInt(++ndx, nextId);
stmt.setString(++ndx, "AAA");
stmt.setString(++ndx, "BBB");
stmt.setString(++ndx, "CCC");
numRows = stmt.executeUpdate();
argCon.commit()

[Shailesh Chandra]

are you sure if there is no exception !! might be there is some exception you are catching but not handling with.

Shailesh