Skip to Content
0
Former Member
Feb 09, 2007 at 05:27 PM

Creating an Oracle Database Connection In NW EE5 Using Database Explorer

23 Views

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.