Receiver JDBC adpater

[Former Member]

Hi friends,

I am working on scenario like file sender & JDBC receiver.

my target structure looks like below.

<mt_jbdc_receiver>

<statement>

<action> </action>

<table> </table>

<access>

<field1> </field1>

<feild2> </field2>

</access>

<statement>

Also in the receiver adapter i specified all the database connection parameters.

In the MONI is it showing processed successfully.But the record was not creating in the database.Please help on this.

[former_member187339]

Hi,

Target structure should be like this

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Suraj

[Former Member]

Suraj/Udo,

This is how my target structure looks now..

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

- <ns0:MT_JDBC_RECEIVER xmlns:ns0="ravipaladugu:file:jdbc">

- <STATEMENTNAME>

- <DB_TABLE_NAME action="INSERT">

<table>ZTEST_JBDC</table>

- <access>

<NAME>RAVI</NAME>

<ID>E100</ID>

</access>

</DB_TABLE_NAME>

</STATEMENTNAME>

</ns0:MT_JDBC_RECEIVER>

In the MONI the status was processed successfully.But in RWB adapter monitoring, it raise an error " Network Adapter could not establish the connection(SQL Exception)".So please help, is there any specific format for 'connection' parameter in the receiver JDBC adapter.At present i was suppling only databse HOST name.

Thanks

Ravi Pal

[former_member187339]

Hi,

Which is the Database you are using?

Check jdbc receiver adapter parameters... Can you specify it here.

Regards

Suraj

[bhavesh_kantilal]

Hi,

The paramters that you mention in your JDBC adapter depends on which Datbase you are trying to connect to and also, you have to install the appropriate driver on your XI server for that database.

Have you done this??

Regards,

Bhavesh

[Former Member]

hi,

I am using ORACLE database.

This how i specify the parameters

JDBC driver : oracle.jdbc.driver.OracleDriver

Connection : jdbc:oracle:thin:@socw3s1er05:1521:XI3

I did't install any appropriate driver on my XI server.Can i download the drivers from the internet.If so please help in providing the url.

Thanks,

Ravi Pal

[Former Member]

Hi Ravi,

To connect to an Oracle DB, the Oracle Driver needs to be installed. The driver to be used depends on the JAVA version that you are using to access the XI server.

classes12.zip / classes12.jar driver is compatible with Java 1.2 and Java 1.3 only, but not with Java 1.4. To get

this support upgrade current driver to latest oracle drivers (ojdbc14.jar)

Please download oracle jdbc driver (ojdbc14.jar ) and install in J2EE engine from this link-

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

This PDF can help you on the steps involved to install the JDBC driver.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

and if you want to use jdbc adapter you have to deploy jdbc driver for the oracle, to know more about it go thru this link:

https://websmp202.sap-ag.de/~sapdownload/011000358700003994312004E/HowTo_ConfigExtAdapters.pdf

I hope it helps you solve your problem.

Regards,

Abhy

Note: reward points for helpful answers.

Message was edited by: Abhy Thomas

[former_member187339]

Hi,

Read thru this document first:

https://websmp101.sap-ag.de/~sapdownload/011000358700003994312004E/HowTo_ConfigExtAdapters.pdf

Regards

Suraj

[bhavesh_kantilal]

hi,

Just to add to what Abhy has told, I would suggest that you use ojdbc14.jar, to connect to the Oracle Database, as it is compatible with Oracle 9i also.

And for the parameters, to connect to an Oracle DB,

Driver Path -- <b>oracle.jdbc.driver.OracleDriver</b>

Coonection String -- <b>jdbc:oracle:thin:@hostip:port:globaldatabasename</b>

Hope this info helps,

Regards,

Bhavesh

[udo_martens]

Hi Ravi,

plz have a look to Runtime Workbench / Adapter Monitoring to find out the reason of your error.

There is a missing element in your request schema. Instead of "action" there should be element around "access" and "table". That element should have a ATTRIBUTE "action". "statement" and the root tag are not closed.

Regards,

Udo