Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes executing an update sql takes too long , what is problem ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "executing an update sql takes too long , what is problem ?" Watch "executing an update sql takes too long , what is problem ?" New topic
Author

executing an update sql takes too long , what is problem ?

raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
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.

I used Datasource , and PreparedStatement for updating , am i correct ?

and other parameter are set as the above.

when i execute the statement with executeUpdate() it dies

is there any method that i can see what is the sql string that the prepared statement is executing ?

thank you
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30068
    
149

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.
Yilmaz Mete
Greenhorn

Joined: Dec 23, 2003
Posts: 28
My experience:

i)



ii) Are there any
Indexes or such constraints on the table to be updated?

bye.
Yilmaz
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: executing an update sql takes too long , what is problem ?
 
Similar Threads
Is it possible to get a string representation of a PreparedStatement?
Statement, Prepared Statement, and CallableStatement
Enhanced PreparedStatement
Update problem
IBM 484 : Stmt.execute(Str) - multiple result sets?