How can I connect with Oracle 7.3.4 using JDBC adapter?

[Former Member]

Hi all,

I need to connect from PI 7.0 to an Oracle 7.3.4.

I have triedd with ojdb14 and classes12 jdbc drivers but I have an error.

Has anyone connected to this DB via JDBC?

Thanks

[Former Member]

Hi,

This is the error that I am having.

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@XXX:XXXX:XXXX': SQLException: Io exception: The Network Adapter could not establish the connection

Thanks

[prateek]

It may be due to the following reasons

1. The database is not running.

2. The database connection listener is not running.

3. You have supplied the wrong database connection URL.

Regards,

Prateek

[Former Member]

Hi,

I have chacked and the DB is now working but I am having this error now:

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@XXX:XXX:XXX: SQLException: ORA-01010: invalid OCI operation

Thanks

[nisarkhan_n]

firstly

check this is proper.

Driver:oracle.jdbc.driver.OracleDriver

Connection:jdbc:oracle:thin:@<HOSTNAME>:<DBHOSTNAME>

Check this link for the mentieond error you have.

http://ora-01010.ora-code.com/

[Former Member]

Hi,

I have cheked and it seems to be ok.

In addition, we have deployed the classes111.jar driver for JDBC and it is still not working.

Any idea?

Thanks

[Former Member]

Hi!

Yes, it was working. We first installed the JDBC driver for oracle and then configures the CC.

What error r u getting?

Peter

[prateek]

Wht is the exact error u r getting?

The problem could be with some driver for Oracle 7 and jdk 1.4 version

Regards,

Prateek