How to insert Multiple Rows in sql database by JDBC adpter

[Former Member]

Hello experts,

My Scenario is a File to JDBC adapter.

Created scenario and all but I'm not able to insert data in the database. In mapping level, it was successful multiple data is coming. While I am passing data in the database all fields coming null value only one row is inserted that row is also null values coming. I want to create a multiple rows.

Please find receiver structure and database null values.

Please do needful.

Thanks&Regards,

Ashok

I am new to JDBC adapter please help me receiver-structure.pngmapping.pngmapping-out.pngcapture.png.

[pankaj_yadav3 · Accepted solution]

Hi Ashok

I have seen your receiver str . It is not correct format str. So frist you can change your str . For your reference i am attaching the str .

As per this str i am inserting the multiple rows in database .

Regards

Pankaj Singh

[Former Member]

Hi Nabendu pankaj yadav,

Thanks for your reply now its working fine, I changed receiver structure thanks a lot.

Regards,

Ashok

[nabendu_sen]

Hi Ashok,

I don't see any real time execution of the JDBC Channel, the screenshot you provided only showing Ping status. Run a transaction "End to End" and then check. I think 'NULL' values were already present and PI never made any real JDBC call to the table.

Please share the screenshot with 'Audit Log' like below:

P.S. Testing a message from Message Mapping 'Test Tab' does not call the receiver Adapter or run the interface end to end.

Regards,

Nabendu.

[Former Member]

Hi Nabendu sen,

Thanks for your reply .

The JDBC channel is working fine.While ping the channel the database connectivity is successful. and also while sending test message it is also successfully delivered. Please find screenshots of Access and channel capture3.pngcapture4.png.

Please help me.

Regards,

Ashok

[nabendu_sen]

Please expand "access" node and share the screenshot. Just wanted to ensure which value is sent to JDBC adapter.

Also check the JDBC Channel in Monitoring.

Regards,

Nabendu.