File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes java.sql.SQLException: Parameter missing IN or OUT index: 2 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 » Databases » JDBC
Reply Bookmark "java.sql.SQLException: Parameter missing IN or OUT index: 2" Watch "java.sql.SQLException: Parameter missing IN or OUT index: 2" New topic
Author

java.sql.SQLException: Parameter missing IN or OUT index: 2

everson santos
Ranch Hand

Joined: Jul 11, 2009
Posts: 50

i got an error: java.sql.SQLException: Parameter missing IN or OUT index::2 in this bellow code

But when I put the value in code I get the error java.sql.SQLException: Parameter missing IN or OUT index:: 1

The Query class is from a framework, but the error happens when execute rs = stmt.executeQuery(); inside Query class as normally Statement...

The database is oracle9i, but I'm using oracle client 10. I don't know if it can cause issues....

Someone have an indea what can be happening ?










everson santos
Ranch Hand

Joined: Jul 11, 2009
Posts: 50

I solved



to



 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: Parameter missing IN or OUT index: 2
 
Similar Threads
To Get the Number of Matches Found in the Database
Datasource Connection
cannot find symbol
List not found error
SQL query not giving any result