• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:

Statement parameter 1 is not set

 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i am working on a web application which is developed using netbeans 5.5(using jdk 1.6).Currently the same application runs on Sun application server without errors. When i tried to run using apache tomcat server(Tomcat 5.5) I get errors.

There is a drop down list in my program
When I run the project, I get the following error.

Exception Details: java.sql.SQLException
Statement parameter 1 not set.

I have used Prepared Statements in my program.
Database is MySQL 4.1. i have used mysql-conncetor-java-3.1 Does this cause a problem?Please help me.
thanks
 
Sheriff
Posts: 67753
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Employ basic debugging techniques to try and find out why the JDBC statement is failing. Obviously, one of the parameters to the statement is not being set.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic