• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLException: Invalid column index

 
Ripal Naik
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can anyone help me to solve this error: I tried different way to solve this error but could not get success.

Here is my procedure.


 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65335
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's a really bad idea to catch the exception and not print out the stack trace. You have lost valuable information; especially the line number in which the exception occurred.

Rather than System.out, use a real logging package such as java.util.logging, or Log4J. They make it easy to create logging that's much better than simply spitting out output.

 
Dave Tolls
Ranch Hand
Posts: 2091
15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a duplicate of this thread:
http://www.coderanch.com/t/642846/JDBC/databases/CallableStatement-Stored-Procedure-Parameters-Error
in which I point out why you are getting this error.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic