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

Dear Alexander Merz, Thanks, i got the solution and my report is now working. Thank you very much sir. Manjeet.

Dear Alexander Merz, i could not get what u have written, plz explain in detail. "I hope the java code is only a demo/reduced and will not run under a public avaible service..." parameters.put("condition",condition); <parameter name="cond" class="java.lang.String"> <queryString> ... $P!{cond} order by Issuedate;]]> </queryString> i think i have already used the code above u have send to me. i could not get please help Thanks.