Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Tomcat and the fly likes Statement parameter 1 is not set Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Products » Tomcat
Reply Bookmark "Statement parameter 1 is not set" Watch "Statement parameter 1 is not set" New topic
Author

Statement parameter 1 is not set

Gayani Kanchana
Greenhorn

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.
thanks
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 56197
    
  13

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.


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Statement parameter 1 is not set
 
Similar Threads
Session Timeout problem
FarmWarDeployer: Clusterwide hot deployment
Tomcat 5 on hosting service
[solved]bean mySearchBean not found within scope
JSTL Problem deploying on different computer