Home » Developer & Programmer » JDeveloper, Java & XML » Java calling Oracle Update statement
Java calling Oracle Update statement [message #203768] Thu, 16 November 2006 04:37 Go to next message
Messages: 81
Registered: August 2005
I need to update a column in my database via the Java code.

I am using this code

connection = getConnection();
stmt = connection.createStatement();
stmt.execute("UPDATE ORG_CFG " + "SET subset_id = '624001000027134' " + "WHERE ORGANISATION_id = '5082'");

However, the database is not updated and a later select returns null because the value is not updated.
I have tried to use a SELECT statement and a value is returned so its not the connection - it seems something is wrong with the UPDATE.
Can anyone help?


I removed the autocommit and it worked but wouldnt rollback the transaction like I wanted since it was auto committed. With autocommit false it didnt seem to set the value before the rollback. With autocommit true it didnt rollback. So Ive removed autocommit updated the value the updated again to reset to null. Solved.


[Updated on: Thu, 16 November 2006 05:03]

Report message to a moderator

Re: Java calling Oracle Update statement [message #204375 is a reply to message #203768] Mon, 20 November 2006 06:59 Go to previous messageGo to next message
Messages: 61
Registered: November 2006
Location: india
stmt.execute("UPDATE ORG_CFG " + "SET subset_id = '624001000027134' " + "WHERE ORGANISATION_id = '5082'");


int i = stmt.executeUpdate(query);

hope it helps
Re: Java calling Oracle Update statement [message #204528 is a reply to message #203768] Tue, 21 November 2006 03:08 Go to previous message
Messages: 81
Registered: August 2005
Thanks for that - I found out what the problem was.

The auto commit false didnt seem to set it at all - if I put autocommit true it committed it and didnt rollback like I needed. So I set auto commit to true - updated to hold the value, did what I need to then did another update to remove the value. It seemed to work that way.

Thanks for your suggestion though.
Previous Topic: Temporary Tablespace
Next Topic: Oracle 10g support in oXygen XML Editor
Goto Forum:

Current Time: Wed Jul 26 04:19:52 CDT 2017

Total time taken to generate the page: 0.15837 seconds