Unknown channel type: JDBC

[Former Member]

dear everyone:

my Scenario is HTTP-XI-JDBC synchronous select

Database: oracle Version: 10.2.0.2.0

JDBC Adapter communication channel configuration as follow list:

jdbc driver: oracle.jdbc.driver.OracleDriver

connection: jdbc:oracle:thin:@192.168.0.180:1521:dstest

we have configure jdbc driver and test by notes 1085539, the test result is ok.

when we implement this scenario, i meet some error information as

follow list:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Call Adapter

-->

- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30"

xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/"

SOAP:mustUnderstand="1">

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code area="MESSAGE">GENERAL</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

when i change trace_level to 3, i get detail error information:

Unknown channel type: JDBC

please give me some advise

[Former Member]

i have solve this problem, my configuration is right, but in my scenario, i user lowercase field name in data type, so oracle don't accept it, field name letter must to be setting uppercase.

[Former Member]

hi Swarup,

thanks very much your reply.

my xi verson is pi7.0 patch level is 13; at my scenario, i don't use query string, i use action = select to select data from db, my jdbc receiver connection configeruation as follow list:

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@192.168.0.180:1521:dstest

[Former Member]

Hi,

If This is errored out along with below message also,

"'Transport protocol not supported in adapter XI' " then there is problem as the 'Transport protocol' in Adapter is usually 'JDBC 2.0' and not just 'JDBC'. Which SP are you on? Also, please check the JDBC Query string.

Thanks

Swarup