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
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,
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: PreparedStatement error shown
 
Similar Threads
prepareStatement problem with the driver classes12.zip
Not able to navigate the user to another jsp in servlets using RequestDispatcher
Prepared Statement problem in my servlet's data manager
Validation/DB query question
unable to forward using jsp:forward