wood burning stoves 2.0*
The moose likes JDBC and the fly likes jdbc error: Invalid Descriptor Index Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc error: Invalid Descriptor Index" Watch "jdbc error: Invalid Descriptor Index" New topic
Author

jdbc error: Invalid Descriptor Index

Rathi Sethuraman
Greenhorn

Joined: May 14, 2004
Posts: 3
Hi,
Is there any odbc expert out there? I have a java class thru which i access the backend and retrieve a set of records. The table has a column by the name "vol_no" and is of char type. But whenever i access it through

rs.getString("vol_no")

It gives the following error...

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5702)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:356)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:413)

what is wrong???
Ali Gohar
Ranch Hand

Joined: Mar 18, 2004
Posts: 572
This type of error mostly occur when you try to get the value of a column of Database twice using JDBC ODBC.

This is error is occuring because you are calling rs.getString("vol_no") twice in your code.

You can store the value of this column in some variable and then use it like

String val = rs.getString("vol_no");
//use val any where instead of using rs.getString("vol_no") repeatedly.

If this is not the problem then post your code.
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17258
    
    6

Moving this to the more appropriate JDBC forum. This forum is for Servlets questions.

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
Don't get me started about those stupid light bulbs.
 
subject: jdbc error: Invalid Descriptor Index