Skip to Content
0

JDBC receiver Database connection

Dec 21, 2016 at 03:37 AM

45

avatar image

Hello experts,

How can we create JDBC database connection details.

Can you please help on this..

capture.jpg (57.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

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

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.

Share
10 |10000 characters needed characters left characters exceeded
Manoj K Dec 21, 2016 at 05:09 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
charan reddy Dec 21, 2016 at 10:21 AM
0

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

Cheers.

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Dec 22, 2016 at 02:21 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded