File to JDBC Scenario through BPM

[Former Member]

Hello All,

Kindly help me to create a below XI scenario using BPM.

Scenario:

I want to take the file data and update the details in JDBC and if the records gets updated, i mean update count > 0 then only i want to archive file otherwise i dnt want to move the file from source folder.

Thanks & regards,

Vanita

[Former Member]

Hi,

Plz Help

Regards,

Vanita

[Former Member]

Hi Vanita,

Check below link for File to JDBC scenario configuraiton.

http://www.sap-xi.com/sap-xi-scenarios-file-jdbc.html

http://www.riyaz.net/sap/jdbc-adapter-configuration/1200/

http://wiki.sdn.sap.com/wiki/display/XI/FiletoJDBCStepby+Step

You can also create Z program to check the count of messages and run archive job.

Thanks,

Sravanthi

[Former Member]

Hello All,

As I am new so can i get the step by step example of such scenario.

Thank you in advanse.

Regards,

Vanita

[Former Member]

Hello Vanita Jain,

Please follow these documents which is mentioned in thread mentioned by Shiva.

Check out the weblog and help for writing stored procedure:

http://www.ics.com/support/docs/dx/1.5/tut6.html

http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

http://www.sqlteam.com/article/stored-procedures-an-overview

Read the documents and try to configure it.

Regards,

Amit Barnawal

[Former Member]

Dear All,

I have created a Scenario as follows:

Data Type & Message Type:

File_Sender_DT,File_Response_DT,JDBC_REQ_DT,JDBC_RES_DT

Message Interface:

FIle_REQ_MI,File_REQ_AB_MI,File_RES_MI,File_RES_AB_MI,FIle_SYNC_MI,JDBC_SYNC_MI

Message Mapping:

FiletoJDBC_MM,JDBCTOFILE_MM

Interface Mapping:

FiletoJDBC_IM

and created Required Configuration object.

But getting the below error in RWB:

Unable to execute statement for table or stored procedure. 'null' (Structure 'FILENAME') due to java.lang.IndexOutOfBoundsException: Index: 1, Size: 1

Kindly help... awaiting for Reply

Thanks & Regards,

Vanita

[Former Member]

Hello Vanita,

Please refer to this thread :

Regards,

Amit Barnawal