How to config JDBC adapter for internal database

[Former Member]

Hi all,

I have configured a scenario that sends data from PROXY to JDBC adapter, JDBC adapter connects to the internal database. The Proxy adapter is OK, but the Receiver JDBC adapter I really don't have any idea about it. Please let me know.

The version, I am doing on it, is 7.1

Thanks in advice.

Ken.

[prateek · Accepted solution]

What do you mean by internal database? Which database is it, e.g. Oracle x.x, SQL Server etc. Your JDBC receiver details would depend upon the type of database involved.

Regards,

Prateek

[Former Member]

The same error is existing. Here is the payload of it that I get from PI:

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

- <ns0:mt_jdbc_receiver xmlns:ns0="http://advantco.com/proxy">

- <STATEMENT>

- <ZADV_TEST_JDBC action="INSERT">

<TABLE>ZADV_TEST_JDBC</TABLE>

- <access>

<col>Ken</col>

</access>

</ZADV_TEST_JDBC>

</STATEMENT>

</ns0:mt_jdbc_receiver>

[Former Member]

Hi ,

Check in your message mapping after execution( Target Side) -> Test Tab -> XML structure,

it Should be like this/ in this format

here action/ table/access : these tagname should not be changed.

Enter the new column values in the <access> element.

Enter exactly one <access>element.

<StatementName>

<dbTableName action=u201DINSERTu201D>

<table>TableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName>

Statement would be like this :

INSERT INTO TableName (col1, col2) VALUES(u2018val1u2019, u2018val2u2019)

Regards

Prabhat Sharma.

[Former Member]

Thank you for your reply. The internal database is MAX DB. I have made some config, but It still does work. Here is my config:

Message protocol: XML SQL Format

jdbbc driver: com.sap.dbtech.jdbc.DriverSapDB

connection: jdbc:sapdb://xxxxx:7210/M71

username: SAPM71DB

xxxxx is my system.

The error after execute this scenario:

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'ZADV_TEST_JDBC' (structure 'STATEMENT'): com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 15): Unknown table name:ZADV_TEST_JDBC

I also created 'ZADV_TEST_JDBC' table on the database.

Please tell me where I am incorrect.

Ken.

[Former Member]

Hi,

For Receiver JDBC , There is a specified XML Structure for each Database,

On the basis of this specified XML struture and your database, JDBC Adapter convert it into database Understandable Form i.e SQL Queries.

For Receiver JDBC Structure ( Better to Go help.sap.com and first Search for article

1. XML format for receiver JDBC Adapter)

Hope this help .

Regards

Prabhat Sharma.