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.
library project main code
Learn Cloud
Learn
Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar
Different groups within an organization need to monitor different Key Performance Indicators (KPIs) - An operations team will be interested in the response times of business services and loads of each service,..
Thursday, February 9th 2012, 09.00 AM (PST)

Thursday, February 9th 2012, 10.00 AM (GMT)