Reg: HTTP to JDBC scenario

[Former Member]

hi,

i am doing HTTP to JDBC scenario, in that i am trying to insert a record in table, i am taking MS- Access as a backend, i am able to see the request in sxmb_moni XI picks the file and i am excuting the scenarion in XIWS_httpClient also there also i am able to genereate result.

i am not able to get the updation in corresponding table in Ms Access.

Can anyone help me out.

Thanks

Ajay

[Former Member]

Hi Ajay,

I have never tried with Ms-Access but with SQL server we used to do some configuration in Db i.e it should know which table to write into while receiving data from XI.

It is a common problem which you are facing.

One possibility could be that you are using the right format for insert command data type in XI.

Here is the format for insert data type XML:

<StatementName2>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName2>

Hope this helps.

Sumit

[justin_santhanam]

Ajay,

one more thing, are u writing Asynchronously to JDBC. If yes to know wht exactly happening, Please use note 953120. It will generate trace files. Add the parameter as specified in the note and remove after scenario runs successfully.

Note: The option is available frm SP17 /SPS8

Best regards,

raj.

[justin_santhanam]

Ajay,

Is the scenario fails or its showing success status.?

Best regards,

raj.