• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Sherif Shehab
Ranch Hand
Posts: 485
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
Campbell Ritchie
Sheriff
Pie
Posts: 49817
69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 485
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 49817
69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You're welcome
 
Sherif Shehab
Ranch Hand
Posts: 485
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
did you notice anything in my code may cause this exception ?
 
Campbell Ritchie
Sheriff
Pie
Posts: 49817
69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 338
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic