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 Soft Skills this week in the Jobs Discussion 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