Wrong error message was returned from JDBC DriverManager.

[JohnPark]

Hi all.

I deployed 3 jdbc drivers(oracle, mssql, tibero which is korean dbms) into SAP PI.

when I try to connect to oracle by jdbc, I got the error message about tibero failure from JDBC Adapter.

I read some article about this issue.

They said that JDBC DriverManager will try to connect other jdbc after failure connection of one jdbc driver.

for example,

1. DriverManager try to connect to oracle.

2. password error.

3. return "password error" message from oracle.

4. DriverManager try to connect to MSSQL.

5. wrong connect url and driver name.

6. return "wrong url" message from MSSQL.

7. DriverManager try to connect to TIBERO.

8. wrong connect url and driver name.

9. return "wrong url" message from TIBERO.

10. save the log latest error message into PI

how can I solve this issue?

[rajasekhar_reddy14 · Accepted solution]

Hi,

When ever you tring to connect ORACLE data base ,the password you have provide seems to be not correct.

The URLs what you are using for SQL Server,Korean DM seems to not correct.

use correct details

Regards,

Raj

[JohnPark · Accepted solution]

Hi Raj.

I used oracle driver as "oracle.jdbc.driver.OracleDriver" and url as "jdbc:oracle:thin:@MyOracleHost:1521:MyDB"

1. DriverManager try to connect to oracle.

2. password error. ___________________________________________________ <-- real error

3. return "password error" message from oracle.

4. DriverManager try to connect to MSSQL.

5. wrong connect url and driver name. ___________________________________ <- try to connect MSSQL using oracle url

6. return "wrong url" message from MSSQL.

7. DriverManager try to connect to TIBERO.

8. wrong connect url and driver name.___________________________________ <- try to connect TIBERO using oracle url

9. return "wrong url" message from TIBERO.

10. save the log latest error message into PI. _____________________________ <- save "wrong url" message

Regards, John.

[Former Member · Accepted solution]

Hi,

Actually according to the JDBC API the driver, which does not recognize the URL should return null and not throw an exception.

The driver should return "null" if it realizes it is the wrong kind of driver to connect to the given URL. This will be common, as when the JDBC driver manager is asked to connect to a given URL it passes the URL to each loaded driver in turn.

The driver should throw an SQLException if it is the right driver to connect to the given URL but has trouble connecting to the database.

If the tibero driver was compliant with the API the real exception would be visible to the end user.

Best Regards

Vyara