executing an update sql takes too long , what is problem ?
Joined: Jul 14, 2005
Hi Thank you for reading my post My problem is : Im trying to execute an update statement over a table in Derby database. when i call executeUpdate() it goes away and die (no exception , no data update happens) I tried and used same query string (changed to fit the insert operation) to insert data into database and it inserted successfylly.
Raminaa, It is possible that some other process has a lock on the row you are trying to update. You are correct in using DataSource and PreparedStatement.
In your example, you only show the setting of one parmeter. In you real code, I assume you set all 4. Otherwise, the code would throw an exception. Also note that it is unnecessary to set EMPNO in the update query since that is what you are searching on and it isn't changing.
For testing, you could just write the query without any "?" so you know what is being executed. Or you could use a DebuggableStatement (search this forum for details.) I think that may be overkill here though.
Joined: Dec 23, 2003
ii) Are there any Indexes or such constraints on the table to be updated?