File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Tomcat and the fly likes Statement parameter 1 is not set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Statement parameter 1 is not set" Watch "Statement parameter 1 is not set" New topic

Statement parameter 1 is not set

Gayani Kanchana

Joined: Mar 27, 2007
Posts: 19
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.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63866

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.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: Statement parameter 1 is not set
jQuery in Action, 3rd edition