Skip to Content

JDBC receiver Database connection

Hello experts,

How can we create JDBC database connection details.

Can you please help on this..

capture.jpg (57.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Dec 21, 2016 at 04:22 AM

    Hello Charan,

    A typical Database connection details are as follows.

    1. Database Type

    2. Database Name

    3. Database Server Port

    Generally Database team provides you these details so that you can configure the same in Communication Channel using the syntax shown in your screen shot.

    If you create a Database on your own then you would know the server details.

    Thanks

    Venkat B.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 21, 2016 at 05:09 AM

    Charan,

    If you have the EAR file deployed as per the note :1085539

    Then navigate to URL http://host:port/ftpjdbc add the required details and do the connection test.

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 21, 2016 at 10:21 AM

    As they are using stored procedure .. For this also can I use same like I mentioned in my query?

    Cheers.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 22, 2016 at 02:21 AM

    Hi Charan!

    In your JDBC adapter settings you set driver class used to establish connection with target DB system, connection string to access particular server/database and user credentials.

    It doesn't matter what type of query you're going to use further as it will be described in your JDBC request message structure.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded