Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

jdbc error: Invalid Descriptor Index  RSS feed

 
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: 17309
11
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
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!