File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Problem passing PreparedStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem passing PreparedStatement" Watch "Problem passing PreparedStatement" New topic

Problem passing PreparedStatement

Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1043
In the ServletContext of a Servlet I am creating and storing a PreparedStatement "object".
Then, in a JSP page, I'm trying to get the PreparedStaement object back into a local variable with code like this:
java.sql.PreparedStatement ps = (PreparedStatement) application.getAttribute("psGetMessages");
The problem is that when I pass the "ps" variable to a method that's expecting a PreparedStatement, I get an exception. What seems to be being passed is a ***String*** of the SQL Statement not a pure PreparedStatement object reference.
When I did a System.out.println("Prepared Statement = " + ps), I see that Java reports it's a PreparedStatement AND it includes the SQL!
The Servlet-JSP method above works fine for a regular Statement object stored in the ServletContext and retrieved later in a JSP.
So, my question is how do I store a proper reference for a PreparedStatement that I can later retrieve in a JSP page and then pass ot a method, or whatever, to store something in the database?
Thanks much in advance for any help or ideas!
-- Mike
Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1043
Please disregard this message thread.
I was using the incorrect PreparedStatement.
The problem is now resloved.
-- Mike
wood burning stoves
subject: Problem passing PreparedStatement
Similar Threads
help! perhaps the problems of configuration of JDBC on Weblogic
Plain Java Class needs access to ServletContext
How to store an image from a jsp page to Database
ServletContext problem
PreparedStatement's - how do you use them CORRECTLY?