Submitted by joseantonio.apa... on June 22, 2010 - 09:07
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
Solved !!
Hi