aspose file tools
The moose likes JDBC and the fly likes How to check query within PreparedStatement object Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "How to check query within PreparedStatement object" Watch "How to check query within PreparedStatement object" New topic
Author

How to check query within PreparedStatement object

Vijay Arora
Greenhorn

Joined: Jun 25, 2007
Posts: 19
PreparedStatement pst=connection.prepareStatement("Select * from table where name=? and age=?");
pst.setString(1,"VIJAY");
pst.setInt(2,20);
ResultSet rs=pst.executeQuery();

Is there any method to print the query string replaced by name and age values.


vijay arora
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 32599
    
    4
Please check your displayed name against the JavaRanch naming policy and amend it accordingly. It requires first name-space-last name.
suresh charan
Greenhorn

Joined: Jun 15, 2006
Posts: 8
Have a look at the following article

http://www.javaworld.com/javaworld/jw-01-2002/jw-0125-overpower.html?page=1
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: How to check query within PreparedStatement object
 
Similar Threads
Exception executing servlet with database connectivity
PreparedStatement and 'null' value in WHERE clause
Regarding time taken by query
Too few paramters
inserting a sequence value to the table