Lists: | pgsql-jdbc |
---|
From: | "Baki, Geetha D(dot)" <gbaki(at)alleghenyenergy(dot)com> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: java.sql.SQLException: JZ0R1: Result set is IDLE as you are not currently access |
Date: | 2005-06-29 18:19:46 |
Message-ID: | 5D37C5C1690BDF45A65BEBB1940B4CBC05A1CC39@sapxch10.corp.commenergy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
> 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
>
>
>
From: | Jan de Visser <jdevisser(at)digitalfairway(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: java.sql.SQLException: JZ0R1: Result set is IDLE as you are not currently access |
Date: | 2005-06-29 18:51:23 |
Message-ID: | 200506291451.23538.jdevisser@digitalfairway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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(at)digitalfairway(dot)com
Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------