Unable to Connect to Oracle from Admin Console

[mohanchowdary]

Hi
I a, trying to connect to ORacle database from the Admin Console. I did the following setup

Database ID : My Oracle
Database Type : Oracle
Obtain Connections Using : DriverManager
Driver Implementer : oracle.jdbc.driver.OracleDriver
Server Name : 127.0.0.1
Port Number : 1551
Database Name/SID : MYSID
User : uid
Password : pwd
Driver Name : thin

but i get the following error :
[sor2] INFO AdminConsole - [adminConsole.testDB] testDB (My Oracle) error: java.sql.SQLException: invalid arguments in call


Can u pls help in identifying the issue.

Thanks

[Isomorphic]

Hi -

For the Database, using the DriverManager approach, we recommend using an explicit JDBC URL. Just check the "Specify explicit JDBC URL" and type it in. E.g:

jdbc:oracle:thin:scott/tiger@//myhost:1521/orcl

Does this solve your problem?

[mohanchowdary]

Thanks a lot -- It is working
But need to format of the JDBC URL is

URL Format ------ jdbc:oracle:thin:[uid]/[pwd]@[host]:[port]:[database]

URL ------------- jdbc:oracle:thin:scott/tiger@myhost:1521:orcl