Hi everyone,
This simplified version of my code compiles but I get "SQLException: Invalid Descriptor Index" in setData() at runtime. I still get the same problem when I put ClassA and ClassB in the same package.
rsResult has valid data in ClassA but rsResult in setData() seems to have no data at all. Any help on this would be greatly appreciated. - Howard
package com.PK;
public class ClassA
{
...
funtion MyFunc()
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
err = err + " Loaded sun.jdbc.odbc.JdbcOdbcDriver ";
//verify driver is valid
if (DriverManager.getDriver("jdbc:odbc:History").jdbcCompliant())
{
con = DriverManager.getConnection("jdbc:odbc:History");
String strSql = "{call sproc_getData()}";
cs = con.prepareCall(strSql);
.prepareCall(strSql);
cs.execute();
rsResult= cs.getResultSet();
ClassB cB = new ClassB();
while(rsResult.next())
{
System.out.println("before send" + rsResult.getString("Symbol")); // good data
cB.setData(rsResult);
}
}
}
}
package com.PK.History; //error
//package com.PK; //also error
ClassB
{
...
public void setData(ResultSet rsResult)
{
System.out.println("setData:in" + rsResult.getString(1)); // error
//System.out.println("setData:in" + rsResult.getString("Symbol")); //also error.
}
}