It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Invalid Descriptor Index Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Invalid Descriptor Index" Watch "Invalid Descriptor Index" New topic

Invalid Descriptor Index

David Cavanagh

Joined: May 01, 2006
Posts: 1
Hi i keep on getting this error:
Problem: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
Its really wrecking my head and ive tried everything.Below is a copy of my code.Any suggestions?

import java.sql.*;
//import oracle.jdbc.*;

public class dbTest
static Connection conn;
static String username, password;
static Statement stmt= null;

public static void main(String [] args)
conn = null;

//Load the jdbc-odbc bridge driver

username = "ca4photo";
password = "Tmppwd4db";
conn = DriverManager.getConnection("jdbc dbc:images",username,password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, //Create a statement object so that we can submit
ResultSet.CONCUR_UPDATABLE); //SQL statements to the driver
//ResultSet rs = null;
String query = "SELECT idx FROM images where idx = 48046"; //SQL statement
ResultSet rs = stmt.executeQuery(query); //Execute SQL statement

String photo = rs.getString(1);
int ccount = rs.getMetaData().getColumnCount();
for( int i = 1; i <= ccount; i++ )

if(conn != null)
catch(Exception e)
System.out.println("Could'nt close connection \n"+e);
catch(Exception e)
System.out.println("Problem: "+e);

public Connection getConnection()
return conn;

Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
You are trying to access columns of your result set that don't exist. That's what that error actually means.

I am not sure about your looping through the metadata part but this

Is certainly wrong. You only have one column in your result set.
I agree. Here's the link:
subject: Invalid Descriptor Index
It's not a secret anymore!