Skip to Content
avatar image
Former Member

File - XI - JDBC Scenario

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 21, 2006 at 02:48 AM

    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`

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Mar 21, 2006 at 04:23 AM

    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

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

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

    JDBC" target="_blank">http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm">JDBC Adapter

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 21, 2006 at 04:33 AM

    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:

    table-name-in-receiver-jdbc-adapter

    Hope this helps.

    regards,

    P.Venkat

    Add comment
    10|10000 characters needed characters exceeded