aspose file tools*
The moose likes Websphere and the fly likes Question about PreparedStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Question about PreparedStatement" Watch "Question about PreparedStatement" New topic
Author

Question about PreparedStatement

jeff mutonho
Ranch Hand

Joined: Apr 30, 2003
Posts: 271
In a generated persister class(eg in my case EJSJDBCPersisterCMPSystemSettingsEjbBean_3bae2ca5.java) ,if I'm degubbing , how do I get to see the values inserted into a query for a finder method such as the one shown below

public EJSFinder findByName(java.lang.String name) throws javax.ejb.FinderException, java.rmi.RemoteException {
ResultSet resultSet = null;
PreparedStatement pstmt = null;
try {
preFind();
pstmt = getPreparedStatement("SELECT T1.SYSTEM_SETTINGS_ID, T1.VALUE, T1.NAME FROM CBPTR1.CBPT_SYSTEM_SETTINGS T1 WHERE T1.NAME = ? ORDER BY T1.VALUE");
if (name == null) {
pstmt.setNull(1, java.sql.Types.VARCHAR);
} else {
pstmt.setString(1, name);
}
resultSet = pstmt.executeQuery();
return new EJSJDBCFinder(resultSet, this, pstmt);
}
catch (Exception ex) {
throw new EJSPersistenceException("find failed:", ex);
}
}

In other words , how do I view the finally generated select statement, the actual query being executed against my datastore?

jeff mutonho
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Question about PreparedStatement
 
Similar Threads
problem in returning data using resultset
preparedStatement with like where clause
How to display data from database to JSP Page in Struts2
Exception
reasons for error: SQLException: No operations allowed after connection closed?