• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

PreparedStatement error shown

 
Tanima Gupta
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 618
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic