I've got an application that builds custom web reports from an Advantage database. For testing purposes, I have the option of printing the report to a file or to a Servlet. Both options call the same method to get the rows from the database. This method contains the PreparedStatement in question.
When I run the app and print the report to a file, the PreparedStatement returns x number of rows. However, when I run it through the servlet, the PreparedStatement returns 0 rows.
if you can prove, that both commands use the same prepared statement, and the parameters are the same, (and you don't just know it, and prove it, but have proved it), then you probably react in a different way:
or something like that.
Did you use the technique of printing to servlet/ to file sucessfully before?