It's not a secret anymore!*
The moose likes JDBC 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
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)
 
Similar Threads
JTable - Table Model vs Display View Columns
Getting Error :HTTP Status 405 - HTTP method GET is not supported by this URL
query is not getting executed
String index out of bound exception in JTable
update query