invalid descriptor index error
hai...
i am having this error..
java.sql.SQLException:[Microsoft][ODBC Microsoft Access Driver]invalid descriptor index.
I am doing RMI application..while i am trying to insert i got this error...
here i paste my code....can anyone help me in finding out error.please...
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:bnk11","","");
Statement max = conn.createStatement();
rs1 = max.executeQuery("Select max(AccountNo) from Customer");
rs1.next();
String maxValue = rs1.getString(1);
int maxx = Integer.parseInt(maxValue);
int max1 = maxx+2;
max2 = Integer.toString(max1);
Statement pin = conn.createStatement();
rs2 = max.executeQuery("Select max(PinNo) from Customer");
rs2.next();
String maxValue1 = rs2.getString(2);
int pinmaxx = Integer.parseInt(maxValue1);
int pinmax1 = pinmaxx+3;
String pinmax2 = Integer.toString(pinmax1);
Statement sm=conn.createStatement();
rs=sm.executeQuery("Select * from Customer");
sm.executeUpdate("insert into Customer values('"+max2+"','"+pinmax2+"','"+c+"','"+d+"','"+e+"','"+f+"','"+g+"','"+h+"','"+i+"')");
conn.close();
Thanks in advance...
