cancel
Showing results for 
Search instead for 
Did you mean: 

Creating an Oracle Database Connection In NW EE5 Using Database Explorer

Former Member
0 Kudos

Help,

I’m unable to create an Oracle connection from within NetWeaver Developer Studio, EE 5 Edition. I’m following this procedure:

1. Open database explorer view

2. Select “New Connection” on the “Connections” node

3. Enter the following into the New Connection dialog:

Database: cpad

JDBC Driver Class: oracle.jdbc.pool.OracleConnectionPoolDataSource

Class Location: C:\ORACLE\ora92\jdbc\lib\ojdbc14.jar

Connection URL: jdbc:oracle:thin:@us6tpa01:1521:cpad

Username/Password: The user name and password

When I test the connection, I get this error:

“Connection to Oracle failed. oracle.jdbc.pool.OracleConnectionPoolDataSource”

I’ve also tried “jdbc:oracle:thin://us6tpa01:1521/cpad” for the URL with no success.

Accepted Solutions (1)

Accepted Solutions (1)

Vlado
Advisor
Advisor
0 Kudos

Hi John,

The connection URL is fine, the JDBC driver class is wrong. Try with <b>oracle.jdbc.driver.OracleDriver</b>.

HTH!

-Vladimir

Answers (0)