This week's giveaway is in the Spring forum.
We're giving away four copies of Learn Spring Security (video course) and have Eugen Paraschiv on-line!
See this thread for details.
Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem passing PreparedStatement

 
Mike London
Ranch Hand
Posts: 1185
4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1185
4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please disregard this message thread.
I was using the incorrect PreparedStatement.
The problem is now resloved.
-- Mike
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic