wood burning stoves 2.0*
The moose likes JDBC and the fly likes PreparedStatement error shown Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PreparedStatement error shown" Watch "PreparedStatement error shown" New topic
Author

PreparedStatement error shown

Tanima Gupta
Greenhorn

Joined: Mar 18, 2011
Posts: 12
Hello,
Kindly help me. I created a Servlet wherein i have created a jdbc database connection with DB2 server. I have used PreparedStatement to precompile and access the values with SELECT statement. But it shows the following exception :
DB2 SQL error : SQLCODE=-206 SQLSTATE=42703 SQLERRMC : USERID DRIVER:4.9.78
it means it does not identify USERID column name...please help me with the syntax


Tom Reilly
Rancher

Joined: Jun 01, 2010
Posts: 618
I don't know if this is the problem about which you are asking but don't you need a space between your single quote and "and"? That is,
 
 
subject: PreparedStatement error shown
 
Similar Threads
unable to forward using jsp:forward
Not able to navigate the user to another jsp in servlets using RequestDispatcher
prepareStatement problem with the driver classes12.zip
Prepared Statement problem in my servlet's data manager
Validation/DB query question