JDBC Sender Adapter Message format

[former_member1258098]

I am somenone who is new to SAP PI so please help me out in the format of datatype for JDBC SENDER Adapter ?

[former_member184720 · Accepted solution]

Have a look at the below blog -

Adapter help documentation has an example too

https://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

[former_member1258098 · Accepted solution]

Hi Haressh

Thanks for your reply.

But I am looking for format of datatype structure which i can used to fire select query using JDBC sender adapter . Kindly provide me screenshot of datatype which has been used for JDBC sender Adapter.

[Former Member · Accepted solution]

Hi ,

Go through below link for your ref .

SAP PI Adapter Series: JDBC Adapter Configuration

<MessageType>
       <row>
             ...
             ...
       </row>
       <row>
             ...
             ...
       </row>
            ...
            ...
</MessageType>

[former_member184720 · Accepted solution]

It has got a sample structure in it and the blog shows an alternative way to import the structure instead of manual creation.

modified : same blog shared by venkat

Message was edited by: Hareesh Gampa

[Former Member]

Hi Rajesh,

I am facing JDBC adapter problem from last one week and still in problem. I have deployed JDBC driver (sqljdbc4.jar) according to http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4... .

Driver deployed successfully and I have checked it in folder \usr\sap\xxx\DVEBMGS30\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib and it's found ok. But this adapter type  not showing in Communication Channel only RFC and SOAP are showing there. I have restarted the server also. Can you help me to find out where the problem is?

[former_member1258098]

I have import table structure from the database but still facing this error

"Interfacedetermination did not yield any actual interface" .

Please help me out.

[former_member184720]

It's a different question. Please create a separate thread with more information such as the xml you received and screenshot of your interface determination object configuration.

[former_member1258098]

But do i need to import database table while working for JDBC to File Scenario...??

In case u have any example please share it with me ?    

[Former Member]

Hi,

Cross check the sender channel configs thoroughly (message type name,name spae...).

Regards

Venkat

[Former Member]

please suggest me for my discussion "Get Error to start adapter engine after installing "

it's urgent please.

i am getting to much problems please solve.thanks in advance.

[Former Member]

Hi Rajesh

The source xml structure for JDBC adapter is like below

<resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

</resultset>

Then in the sender JDBC adapter, write the select and update query

SQL statement for query: SELECT * FROM table WHERE processed = 0;

SQL statement for update: UPDATE table SET processed = 1 WHERE processed = 0;

processed is the indicator in the database.

Check this link for details

https://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

[former_member1258098]

is that a right structure for JDBC sender type ?

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

<ns0:resultset xmlns:ns0="http://www.company.com//MATDETAIL_JDBC">

   <row>

      <MaterialNumber>1</MaterialNumber>

      <MaterialText>Galaxy Mobile</MaterialText>

      <UnitPrice>10000</UnitPrice>

      <LastUpdated>04-03-2012</LastUpdated>

      <PackingUnit>Box</PackingUnit>

      <Processed>0</Processed>

   </row>

</ns0:resultset>

[Former Member]

Hi Rajesh

Yes the xml structure is correct.