> 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 that this is failing at.
>
> String vl = rs.getString( 1 );
>
> Did anyone come across this problem before?
>
> Thanks,
> Geetha
>
>
>