Обсуждение: 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
>
>
>

On Wednesday 29 June 2005 14:19, Baki, Geetha D. wrote:
> > 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)

You got the wrong list. This is for postgresql specific JDBC issues. You have
a Sybase issue.

JdV!!

--
--------------------------------------------------------------
Jan de Visser                     jdevisser@digitalfairway.com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------