Re: java.sql.SQLException: JZ0R1: Result set is IDLE as you are not currently access

> Hi All,
>
> When one of our Users tried to save a trade using one of our Java(with Weblogic as the application server) built
application,this is the error she got. 
>
> java.sql.SQLException: JZ0R1: Result set is IDLE as you are not currently access
> ing a row.
>         at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:506)
>         at com.sybase.jdbc2.tds.TdsResultSet.getColumn(TdsResultSet.java:412)
>         at com.sybase.jdbc2.jdbc.SybResultSet.getColumn(SybResultSet.java:1574)
>         at com.sybase.jdbc2.jdbc.SybResultSet.getString(SybResultSet.java:202)
>         at weblogic.jdbc.pool.ResultSet.getString(ResultSet.java:78)
>         at com.aegm.co.cot.general.cot_SuperDealMemberToAllegroPM.removeFromAlle
> gro(cot_SuperDealMemberToAllegroPM.java:87)
>         at com.aegm.co.cot.general.cot_SuperDealMemberPM.remove(cot_SuperDealMem
> berPM.java:182)
>         at com.aegm.ee.eep.value.eep_ValueSaveSessionBean.remove(eep_ValueSaveSe
> ssionBean.java:291)
>         at com.aegm.ee.eep.value.eep_ValueSaveSessionBean_ofc54r_EOImpl.remove(e
> ep_ValueSaveSessionBean_ofc54r_EOImpl.java:308)
>         at com.aegm.ee.eep.value.eep_ValueSaveSessionBean_ofc54r_EOImpl_WLSkel.i
> nvoke(Unknown Source)
>         at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:441)
>         at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerR
> ef.java:114)
>
> This is the line in
com.aegm.co.cot.general.cot_SuperDealMemberToAllegroPM.removeFromAllegro(cot_SuperDealMemberToAllegroPM.java:87)class
thatthis is failing at. 
>
> String vl = rs.getString( 1 );
>
> Did anyone come across this problem before?
>
> Thanks,
> Geetha
>
>
>