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: Missing IN or OUT parameter at index:: 14 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: Missing IN or OUT parameter at index:: 14" Watch "java.sql.SQLException: Missing IN or OUT parameter at index:: 14" New topic
Author

java.sql.SQLException: Missing IN or OUT parameter at index:: 14

Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 477

Hi all,

i'm getting data from Vector of vectors to insert it in the DB , the problem that i'm facing is this exception : "java.sql.SQLException: Missing IN or OUT parameter at index:: 14 " i checked all the colums that i'm filling all ok .

here is my code



any thing i missed ?


Thanks,
Sherif
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36508
    
  16
What does the ><= operator do?

How many columns does your table require? You are writing 14 at the beginning and only setting 13. Do you really have a table with 14 columns?
Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 477

Campbell Ritchie wrote:What does the ><= operator do?

How many columns does your table require? You are writing 14 at the beginning and only setting 13. Do you really have a table with 14 columns?


no the operator is errata it is <= , ya you are right they are 13 columns only , the 14 is the number of the ? in the query to be set here
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36508
    
  16
You're welcome
Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 477

did you notice anything in my code may cause this exception ?
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36508
    
  16
No, sorry. Are you sure you are getting the correct values in dd? The ++ operator will increment dd 1 too few every time.
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
This may help.

http://publib.boulder.ibm.com/infocenter/wasinfo/v4r0/index.jsp?topic=/com.ibm.support.was.doc/html/Java_2_Connectivity_(J2C)/1163246.html

[edit]Add "URL" tags. CR[/edit]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: Missing IN or OUT parameter at index:: 14
 
Similar Threads
JDBC VRE 2.0 BatchUpdate
getting batchupdate exception while inserting recored for second time...
Inserting and retrieving Blob data from SQL2000 using JDBC
how to call a javabean method from jsp using setproperty
java.sql.SQLException: Invalid column index