Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

can't connect to external Oracle DB with JDBC connector

Hello guys,

I had failed to connect to connect external Oracle via JDBC connector .

Could you please help me to resolve the problem ?

Backgroud:

We need to connect the external Oracle DB with JDBC connector, because BI need to connect to the target Oracle. If the JDBC connector suceed, BI will create a UD which use the datasource

we create in Visual admin to connect to the external Oracle DB.

Environment:

Our EP version is NW04S SP17 , OS is AIX .

The target Oracle DB version is 10g(10.1.0.2.0, 64bi).

Configuration procedure :

1. Import Oracle driver "ojdbc14.jar" and create new driver which named "Oracle " under

JDBC Connector ->Run time ->Driver in Visual Admin.

2. Create datasource "Mydatasource" under JDBC Connector ->Run time ->Data Source,

Name : Mydatasource

Driver Name : Oracle

JDBC version: 2.0(with XA support)

JDBC compliant:

Object Factory :oracle.jdbc.pool.OracleDataSourceFactory

DataSource Type: ConnectionPoolDataSource

*CPDS class name :oracle.jdbc.pool.OracleConnectionPoolDataSource

Additional:

Additional Properties:

DatabaseName:LPAR8TEST

DriverName:oracle.jdbc.OracleDriver

Password: *****

PortNumber:1521

ServerName: 10.1.16.208

URL :jdbc:oracel:thin@10.1.16.208:1521:LPAR8TEST

User:IMPL

Connectoin Pool:

Initial Connectons: 1 Expiration: (check)

Maximum Connections: 25 Connection Lifetime :600

Maximum time wait of connection : 60 Cleanup Thread : 200

Default Connectoin Isolaton :Default

SQL Engine:

Open SQL

3.Create Connector :

Copy the standard connector :SDK_JDBC to SDK_JDBC_Oracle,

Resource Adopter:

Loader References:

Add "libray:Oracle" .

Managed Connection Factory:

Configuration Property:

DriverName:oracle.jdbc.OracleDriver

Password: ****

User:IMPL

URL: jdbc:oracle:thin@10.1.16.208:1521:LPAR8TEST

All fo my configuration had been listed.

And I had created JCO RFC : JT-BIDEV_PORTAL_BD1 , and created RFC connection with SM59 in BI.

Please give me some suggesiton.

Thanks.

Louis

Former Member
Not what you were looking for? View more on this topic or Ask a question