This discussion is archived
1 Reply Latest reply: Oct 28, 2012 3:39 PM by vladodias RSS

Using DB Adapter for MS SQL Server 2005  SP in OSB 11g.

958368 Newbie
Currently Being Moderated
Hi All,

I have a requirement to create a DB Adapter for MS SQL Server Stored Procedure in JDeveloper and export the Adapter file to OSB 11g. I have Created the Adapter and imported it into OSB 11g successfully. Created the Datasource and Connection pool also in console.

The problem is while trying to execute the created business Service, I am getting the error as below,

<Oct 26, 2012 12:20:25 PM IST> <Error> <JCATransport> <BEA-381967> <Invoke JCA outbound service failed with application error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/Test/CheckAppID/WL_Driver/CheckAppId_WL_Driver [ CheckAppId_WL_Driver_ptt::CheckAppId_WL_Driver(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'CheckAppId_WL_Driver' failed due to: Unimplemented string conversion.
Conversion of JDBC type to String is not supported.
An attempt was made to convert a Java object to String using an unsupported JDBC type: .
; nested exception is:
     BINDING.JCA-11804
Unimplemented string conversion.



My XSD is ,



<element name="InputParameters">
<complexType>
<sequence>
<element name="application_id" type="int" db:index="1" db:type="INT" minOccurs="0" nillable="true"/>
</sequence>
</complexType>
</element>
<element name="OutputParameters">
<complexType>
<sequence>
<element name="RowSet0" type="db:RowSet0_RowSet" db:type="RowSet0" minOccurs="0" maxOccurs="unbounded" nillable="true"/>
<element name="RowSet1" type="db:RowSet1_RowSet" db:type="RowSet1" minOccurs="0" maxOccurs="unbounded" nillable="true"/>
</sequence>
</complexType>
</element>
<complexType name="RowSet1_RowSet">
<sequence>
<element name="RowSet1_Row" minOccurs="0" maxOccurs="unbounded">
<complexType>
<sequence>
<element name="cde" type="int" db:type="INT" minOccurs="0" nillable="true"/>
<element name="msg" db:type="NVARCHAR" minOccurs="0" nillable="true">
<simpleType>
<restriction base="string">
<maxLength value="255"/>
</restriction>
</simpleType>
</element>
</sequence>
</complexType>
</element>
</sequence>
</complexType>
<complexType name="RowSet0_RowSet">
<sequence>
<element name="RowSet0_Row" minOccurs="0" maxOccurs="unbounded">
<complexType>
<sequence>
<element name="aaa" type="boolean" db:type="BIT" minOccurs="0" nillable="true"/>
<element name="bbb" db:type="NVARCHAR" minOccurs="0" nillable="true">
<simpleType>
<restriction base="string">
<maxLength value="10"/>
</restriction>
</simpleType>
</element>
</sequence>
</complexType>
</element>
</sequence>
</complexType>


I don't know why there is a datatype conversion error.

Help me in resolving this.

Regards,
Nataraj R.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points