This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes java.sql.SQLExceptiion: Column Index out of range (0>1) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.SQLExceptiion: Column Index out of range (0>1)" Watch "java.sql.SQLExceptiion: Column Index out of range (0>1)" New topic
Author

java.sql.SQLExceptiion: Column Index out of range (0>1)

nitinmittal mittal
Greenhorn

Joined: Sep 23, 2003
Posts: 1
java.sql.SQLExceptiion: Column Index out of range (0>1),
I am trying to insert some data into mysql table and then this exception was printed on the Tomcat, even the data was inserted into the table, after that when I updated the data it wasn't updated, and the same error was there, I have checked all the values, they are compatible to the table. So anybody plz help me in solving this problem.
Nagendra Prasad
Ranch Hand

Joined: Jul 11, 2002
Posts: 219
its one of ur get() or set() methods which is using an invalid index.
For instance it u are doing something like
resultSet.getString(10); and there is no 10th column, you would get this error.


Best Regards,<br />Nagendra Prasad.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLExceptiion: Column Index out of range (0>1)
 
It's not a secret anymore!