SYBASE ERROR JZ0R0: ResultSet has already been closed

joseantonio.aparicio.securitasdirect.es's picture
Hi We're testig your tolls with Sybase using JCOnnect 6.0 version. All integrations process work fine but I'm not able to get a recordset provided by a store procedure,   when I execute the WS we always have this error:  JZ0R0: ResultSet has already been closed and it doesn't  show any information.   We've activated audit trail in our server but I don't see any regsitry about procedure excution. It seems like the stored procedure haven't never been excuted This is the definition procedure that we're using in that DataService.   <query id="inetcodewordget" useConfig="testconnect">       <sql>{? = call  sbnpro.dbo.inet_codeword_get ?,?,?,?}</sql>       <properties>          <property name="org.wso2.ws.dataservice.query_timeout"></property>          <property name="org.wso2.ws.dataservice.fetch_direction"></property>          <property name="org.wso2.ws.dataservice.fetch_size"></property>          <property name="org.wso2.ws.dataservice.max_field_size"></property>          <property name="org.wso2.ws.dataservice.max_rows"></property>       </properties>       <result element="rows" rowName="row">          <element name="ix" column="ix" xsdType="xs:integer" />          <element name="code" column="code" xsdType="xs:string" />          <element name="tp" column="tp" xsdType="xs:string" />          <element name="tp_desc" column="tp_desc" xsdType="xs:string" />          <element name="exp_date" column="exp_date" xsdType="xs:string" />       </result>       <param name="return_value" paramType="SCALAR" sqlType="INTEGER" type="OUT" ordinal="1" />       <param name="s_ins" paramType="SCALAR" sqlType="INTEGER" type="IN" ordinal="2" />       <param name="lang" paramType="SCALAR" sqlType="SMALLINT" type="IN" ordinal="4" defaultValue="-1" />       <param name="ix" paramType="SCALAR" sqlType="SMALLINT" type="IN" ordinal="3" defaultValue="-1" />       <param name="timezone" paramType="SCALAR" sqlType="STRING" type="IN" ordinal="5" defaultValue="''" />    </query> Could you help us to solve this issue? BR Jose A. Aparicio
joseantonio.aparicio.securitasdirect.es's picture

Solved !!

Hi We solved that problem using jTDS instead of JConnect driver. We're doing test with several answers but the feel is good. More information here -> http://sourceforge.net/projects/jtds/ BR
kalpanie's picture

Hi

Hi, Sorry for not response your query. Glad to hear, that you have solved your issue. Anyways we will check the issue with the JConnect driver. Thanks for pointing us the issue. Don't be hesitate to write us if you have more queries in future. Thanks. Kalpanie.