| Author |
Problem passing PreparedStatement
|
Mike London
Ranch Hand
Joined: Jul 12, 2002
Posts: 948
|
|
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: 948
|
|
Please disregard this message thread. I was using the incorrect PreparedStatement. The problem is now resloved. -- Mike
|
 |
 |
|
|
subject: Problem passing PreparedStatement
|
|
|