JDBC receiver Database connection

[former_member329292]

Hello experts,

How can we create JDBC database connection details.

Can you please help on this..

[former_member190293]

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.

[former_member329292]

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

Cheers.

[manoj_khavatkopp]

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

[former_member308026]

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.