Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc error: Invalid Descriptor Index

 
Rathi Sethuraman
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 572
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving this to the more appropriate JDBC forum. This forum is for Servlets questions.

Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic