SEO

#1 (**permalink**) 04-15-2008, 11:22 PM

> 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(Erro rMessage.java:506)
> at com.sybase.jdbc2.tds.TdsResultSet.getColumn(TdsRes ultSet.java:412)
> at com.sybase.jdbc2.jdbc.SybResultSet.getColumn(SybRe sultSet.java:1574)
> at com.sybase.jdbc2.jdbc.SybResultSet.getString(SybRe sultSet.java:202)
> at weblogic.jdbc.pool.ResultSet.getString(ResultSet.j ava:78)
> at com.aegm.co.cot.general.cot_SuperDealMemberToAlleg roPM.removeFromAlle
> gro(cot_SuperDealMemberToAllegroPM.java:87)
> at com.aegm.co.cot.general.cot_SuperDealMemberPM.remo ve(cot_SuperDealMem
> berPM.java:182)
> at com.aegm.ee.eep.value.eep_ValueSaveSessionBean.rem ove(eep_ValueSaveSe
> ssionBean.java:291)
> at com.aegm.ee.eep.value.eep_ValueSaveSessionBean_ofc 54r_EOImpl.remove(e
> ep_ValueSaveSessionBean_ofc54r_EOImpl.java:308)
> at com.aegm.ee.eep.value.eep_ValueSaveSessionBean_ofc 54r_EOImpl_WLSkel.i
> nvoke(Unknown Source)
> at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:441)
> at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke( ReplicaAwareServerR
> ef.java:114)
>
> This is the line in com.aegm.co.cot.general.cot_SuperDealMemberToAlleg roPM.removeFromAllegro(cot_SuperDealMemberToAllegr oPM.java:87) class that this is failing at.
>
> String vl = rs.getString( 1 );
>
> Did anyone come across this problem before?
>
> Thanks,
> Geetha
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#2 (**permalink**) 04-15-2008, 11:22 PM

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(Erro rMessage.java:506) at
> > com.sybase.jdbc2.tds.TdsResultSet.getColumn(TdsRes ultSet.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!
--------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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