aspose file tools
The moose likes Websphere and the fly likes Connection is closed - error in web service calling DB2 stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Products » Websphere
Reply Bookmark "Connection is closed - error in web service calling DB2 stored procedure" Watch "Connection is closed - error in web service calling DB2 stored procedure" New topic
Author

Connection is closed - error in web service calling DB2 stored procedure

Thys Geldenhuys
Greenhorn

Joined: Sep 19, 2006
Posts: 1
I am trying to create a web service in WebSphere 5.0.2 using a DADX file.

When the operation is a simple SQL select then the service works correctly. When, however, the operation is a call to a stored procedure I get the following error if I use a simple JDBC connection:

[SOAPException: faultCode=SOAP-ENV:Server; msg=COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003]

I have also tried using a connection pool. In that case I get a StaleConnectionException.

(I have tried to find other posts on this topic and I have found two but both were closed for administrative reasons.)

Any help would be appreciated.
Thys

The DADX file for my service is:

<?xml version="1.0"?>
<DADX xmlns="http://schemas.ibm.com/db2/dxx/dadx"<br /> xmlns:xsd="http://www.w3.org/2001/XMLSchema"<br /> xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
<wsdl ocumentation>

This service invokes a DB2 Stored Procedure
@DB2 is the corresponding DB2 subsystem.

1 Result set is returned by this Stored Procedure.
</wsdl ocumentation>
<result_set_metadata name="cursorInfo1" rowName="row1">
<column name="REPORT_NUMBER" type="INTEGER" nullable="true"/>
<column name="REPORT_CATEGORY" type="CHAR" nullable="true"/>
<column name="REPORT_TITLE" type="CHAR" nullable="true"/>
<column name="SHORT_DESCRIPTION" type="CHAR" nullable="true"/>
<column name="LONG_DESCRIPTION" type="CHAR" nullable="true"/>
<column name="REQ_FILTER_COLS" type="VARCHAR" nullable="true"/>
</result_set_metadata>
<operation name="getReportList">
<wsdl ocumentation>
Returns
1 Result set
Output Parameters :
RETURN_CODE
REASON_CODE
ERROR_TEXT
SP_SQLCODE
SP_SQLTOKENS
SP_SQLSTATE
REPORT_ID_TS
ROW_COUNT
</wsdl ocumentation>
<call>
<SQL_call>CALL (
:appUserId
, ebugLevel
,:returnCode
,:reasonCode
,:errorText
,:spSqlcode
,:spSqltokens
,:spSqlstate
,:reportCategory
,:sortOrder
,:reorderFlag
,:reportIdTs
,:lineOffset
, ageSize
,:rowCount
)</SQL_call>
<parameter name="appUserId" type="xsd:string" kind="in"/>
<parameter name="debugLevel" type="xsd:string" kind="in"/>
<parameter name="returnCode" type="xsd:int" kind="out"/>
<parameter name="reasonCode" type="xsd:string" kind="out"/>
<parameter name="errorText" type="xsd:string" kind="out"/>
<parameter name="spSqlcode" type="xsd:int" kind="out"/>
<parameter name="spSqltokens" type="xsd:string" kind="out"/>
<parameter name="spSqlstate" type="xsd:string" kind="out"/>
<parameter name="reportCategory" type="xsd:string" kind="in"/>
<parameter name="sortOrder" type="xsd:string" kind="in"/>
<parameter name="reorderFlag" type="xsd:string" kind="in"/>
<parameter name="reportIdTs" type="xsd:string" kind="in/out"/>
<parameter name="lineOffset" type="xsd:int" kind="in"/>
<parameter name="pageSize" type="xsd:short" kind="in"/>
<parameter name="rowCount" type="xsd:int" kind="out"/>
<result_set name="cursor1" metadata="cursorInfo1"/>
</call>
</operation>
</DADX>
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Connection is closed - error in web service calling DB2 stored procedure
 
Similar Threads
error when generating WS Client code using wsdl
How to change WSDL schema definition to suit incoming requests?
missling wsdl namespace for wsdl:type element when using Caucho Resin 3.0
jax-ws clients and jboss
How to retrieve data form webservices