This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes proble with preparedStatement 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 "proble with preparedStatement" Watch "proble with preparedStatement" New topic
Author

proble with preparedStatement

Kishore Vallabhajosyula
Greenhorn

Joined: Mar 07, 2007
Posts: 2
Hi All,

I am facing a problem with preparedStatement.executeUpdate(). My requirement is that I will execute an update query first and I need to log the result of executing query. My expectation is that, when no records are updated zero will be returned. But all the times it returns the number of rows matched. I tried even getUpdateCount(). Solution should work with both mysql and oracle.

Please advice.

Thanks,
Kishore.
Aditya Kumar
Ranch Hand

Joined: Oct 31, 2006
Posts: 56
Can you please show us the code? It helps.
 
wood burning stoves
 
subject: proble with preparedStatement
 
Similar Threads
Data Type Conversion(urgent)
Career selection J2ee vs. Net
How to close all child windows from parent window
Batch processing
adding a section and subsection dynamically