problem with inserting new record

Hi All,

I have this following code:

Statement stmtInsert = connection.createStatement();
String test = "insert into calltract (transaction_id,location_code) values (1,\"01\")";
stmtInsert.executeUpdate(test);


and the result is:
No data - zero rows fetched, selected, or processed

The purpose of this code is to insert data into table "calltract"

Any Idea what wrong with this code?

Lets see some more of the code around this. Namely the try/catch/finally block in which it occurs.

One thing though, that "\"01\" should probably be '01'