JDBC Connect Test To DB

[Former Member]

I all,

I want to test the JDBC driver, did a deploy the attachment to the note 1085539, to prove need to enter the URL (http://<host>:<port>/ftpjdbc) mentioned right there but I do not know how to fill the fields correctly, someone can help me or guidance with this?.

Please suggest.

kind regards

[Former Member · Accepted solution]

Hi all,

Thanks for all , his comments were of great help. I had success in doing the test to JDBC driver, I did as follows:

Driver Class (fully qualified)     oracle.jdbc.driver.OracleDriver

JDBC URL                               jdbc:oracle:thin:@<serveraddress>:<port>/<db_name>

User Name                               /as sysdba

Password

....

...

...

Sucessfully obtained connection object = oracle.jdbc.driver.T4CConnection@3f543b20

...

...

...

Thanks for all

Regards,

Carlos.

[marksmyth]

Hi Carlos,

It depends on which driver you are using, which DB vendor/release you are connecting to. Each driver has its own specific connection parameters.

Best way to verify is to check with the driver vendor. See note 831162.

Regards
Mark

[former_member182412]

Hi Carlos,

You need to give same like when you configure your communication channel in PI.

Regards,

Praveen.

[neilpadilla]

Hi Carlos,

If you are connecting to Oracle database, you can fill the JDBC URL as follows:

jdbc:oracle:thin:@<serveraddress>:<port>:<databasename>

For MySQL database, I'm not sure if the following format works:

jdbc:mysql://localhost:3306/dbname

Hope this helps.

Regards,

Neil