File - XI - JDBC Scenario

[Former Member]

I am using File-XI-JDBC Scenario. We are using File adapter in Outbound interfac and JDBC adapter to push data into oracle. Here my problem is my table name in database starts with $. So it is not being picked up by XI because it doesnot accept $. Can anybody tell me the method how to send my data into this table. I am in a situation that I cannot rename the tablename.

[Former Member]

Hi Satish,

You can use the structure given in previous post by kalyan. since <table> element is string it will accept, $.

you may also go thro this thread:

Hope this helps.

regards,

P.Venkat

[Former Member]

Hi Satish,

All that i could get from the SAP Help regarding JDBC Adapters once when i searched for the same were these links where i never found anything much regarding the table name.anyways just go through these links and see if you find anything useful.

http://help.sap.com/bp_bpmv130/Documentation/Planning/XIUnicodeGuide030411.pdf

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm">Configuring the Receiver JDBC Adapter</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm">Mapping Lookups</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm">JDBC Adapter</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm">Configuring the Receiver JDBC Adapter - part 2</a>

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

This is all i got from the help files, anyways you can also go through those links and see if you find anything else useful.

- Escape Symbol for Apostrophe

The apostrophe character (‘) is a reserved character in SQL syntax and is therefore replaced by an escape character if it occurs within value strings. This replacement character can be database-specific. Typical replacement characters are \’ or ’’(default value). If a character occurs that is invalid for the database being used, the adapter triggers an error message (an SQL exception) concerning the SQL syntax that is generated by the database.

- Column Name Delimiter

Depending on the database being used, column names can be enclosed by a special delimiter character, for example, if the names can contain special characters (such as ”). This character can be specified at this point. The default setting is no delimiter character. If a character occurs that i

Also check if there are notes in the service market place related to the same.

Regards,

abhy

[Former Member]

Try using this format for your message on the receiver side.

<root>

  <StatementName1>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>  


  </StatementName1>
</root>

I have not tried using the $ but give it a try.

If putting the table name in the

element doesnot work try using table name between "`" e.g. `$dept`

[former_member187339]

Hi,

When you specify the receiver Data type for DB, give it as mentioned by Kalyan. So when you doing so you are not directly mentioning the table name in the DT. The real table name will be given as a value for the node <table>.

So <b>$tablename</b> can be hardcoded as <b>realDbtableName</b>.

Regards

Suraj