aspose 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 Spring in Action this week in the Spring 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: 61432
    
  67

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