java.sql.SQLException: [Microsoft][SQLServer 2000

[aarohan]

Hello Everybody!!!!!!

 

i am facing the following problem when i execute my jsp file. Plz help.

 

Exception is:

java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Invalid operation for the current cursor position.

 

my code runs upto "connection established" but after that it gives error as mentoned above.

 

<%

cedisha = MyConnection.getConnection( "edisha" );

System.out.println("Connection Established");

df1 = new SimpleDateFormat( "dd/MM/yyyy hh:mm:ss" );

todaydate = df1.format( new java.util.Date() );

db_f = new SimpleDateFormat("MM/dd/yyyy hh:mm:ss");

ps_bank = cedisha.prepareStatement( "select BankId , BankName from tblbankmaster" ,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );

rs_bank = ps_bank.executeQuery();

System.out.println("Query Executed");

Collection bankid=new Vector();

Collection bname=new Vector();

while(rs_bank.next())

{

bankid.add(rs_bank.getString(1));

bname.add(rs_bank.getString(2));

}

rs_bank.close();

 

PreparedStatement psApp = cedisha.prepareStatement("SELECT tblappln.SNo, tblappln.FileID, tblappln.Name, tblappln.FatherName, tblappln.GFatherName, tblappln.PermanentAddress, tblappln.CorresAddress, tblappln.dcode, tblappln.tcode, tblappln.WardNo, tblappln.Age, tblappln.ApplicantName, tblappln.ApplicantAddress, tblappln.ReportingDate, tblappln.Remarks, tblappln.BankID, tblappln.ChDDDate, tblappln.ChDDNo, tblappln.Sex, tblappln.RuralUrban, tblappln.ModeOfPayment, tblappln.vtcode FROM tblApplication tblappln INNER JOIN tblTransaction tbltrans ON tblappln.CertCode = tbltrans.ServiceCode AND tblappln.SNo = tbltrans.DReceiptNo WHERE cast(tbltrans.ReceiptNo as bigint) = '"+ receipt_no +"' AND tbltrans.ApplicationCode = '"+ app_code +"'", ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

rs_App = psApp.executeQuery(); /*if(rs_App != null && rs_App.next())

{

System.out.println("Hello");

}*/

//rs_App.first();

rs_App.next();

String Serial=rs_App.getString("SNo");

String FID=rs_App.getString("FileID");

String sname=rs_App.getString("Name");

String sfname=rs_App.getString("FatherName");

String sgfname=rs_App.getString("GFatherName");

String spAdd=rs_App.getString("PermanentAddress");

String scAdd=rs_App.getString("CorresAddress");

String sdcode=rs_App.getString("dcode");

String stcode=rs_App.getString("tcode");

String swardno=rs_App.getString("WardNo");

String sAge=rs_App.getString("Age");

String sAppName=rs_App.getString("ApplicantName");

String sAppAdd=rs_App.getString("ApplicantAddress");

String srDate=rs_App.getString("ReportingDate");

String sremarks=rs_App.getString("Remarks");

String sbankid=rs_App.getString("BankID");

String schDate=rs_App.getString("ChDDDate");

String schNo=rs_App.getString("ChDDNo");

String sex = rs_App.getString( "Sex" );

String ur = rs_App.getString( "RuralUrban" );

String mop = rs_App.getString( "ModeOfPayment" );

String svtcode=rs_App.getString("vtcode");

 

%>

Post edited by: aarohan, at: 2006/10/18 11:55