Skip to Content
0
Mar 14, 2006 at 11:05 AM

Connecting to JDBC system (Oracle)

17 Views

Hi guys,

I have a problem with connecting to my Ora DB from the Portal.

What did I do:

I created the JDBC system in my landscape, gave it an alias and in the system properties I also have: URL connection jdbc:oracle:thin:@<host_ip>:<port>:<SID>

and as a driver class I have oracle.jdbc.driver.OracleDriver .

I have created also user mapping for this system. But I still have a problem in testing my connection.

When I test the connection I get result:

Results

Retrieval of default alias successful

Connection failed. Make sure user mapping is set correctly and all connection properties are correct.

What could be wrong?

Maybe, my JDBC driver is not installed properly. How is it possible to test it? Or, can someone send me a link to a HOW-TO guide for ora jdbc driver installation?

Thanx a lot, Peter