Skip to Content
avatar image
Former Member

JDBC Receiver Adapter Communication channel

HI,

I have a scenarion where JDBC is receiver. i would appreciate if someone can provide me required information.

Connection?

Driver?

where do we mentoin database name.

and table name.

how to we avoid duplicate entries.

Jeff

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 17, 2007 at 02:59 AM

    Hi Jeff,

    The connection and driver settings

    http://help.sap.com/saphelp_nw04s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

    Database name is part of the connection string and driver detail

    e.g. for SQL server,u have to deploy the drivers (msbase.jar, mssqlserver.jar, msutil.jar).

    U have to specify the table name in the message structure defined in the following manner

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

    Have a look at this also

    /people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

    Regards,

    Prateek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 17, 2007 at 09:46 AM

    Hi Jeff,

    The parameters that you mention in your JDBC adapter depends on which Database you are trying to connect to and also you have to install the appropriate driver on your XI server for that database. Are you done with this step??

    This PDF can help you on the steps involved to install the JDBC driver.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f1a10

    Regards,

    Abhy Thomas

    Add comment
    10|10000 characters needed characters exceeded