File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Tomcat
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: 60049
    
  65

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