Skip to Content
avatar image
Former Member

Problems connecting to Oracle 8.0.6 DB using ojdbc14.jar

Hi all,

I would like to pick up a problem that has started in the threat [Problems with Oracle JDBC|Problems with Oracle JDBC;.

I am trying to connect to a Oracle 8.0.6.2 DB using MII 12.0.2 with ojdbc14.jar. We use the settings:

- JDBCDriver: "oracle.jdbc.driver.OracleDriver"

- ServerURL: "jdbc:oracle:thin:@servername:port:sid"

When activating the data server in MII, the following errors occur in the Last 24 Hours Log:

Unable to fill connection pool for jdbc:oracle:thin:@servername:port:sid
[EXCEPTION]
 java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-02248: invalid option for ALTER SESSION

After doing some internet search it seems that the driver does not support the database version. The current driver only seems to support the Oracle down to version 8.1.7:

[http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq_0.htm#02_02]

I hoped to use the classes12.jar to connect to the Oracle 8.0.6., but what settings do I have to put in the data server to call the classes12.jar? Does anyone has ever used two different jdbc drivers in one MII instance?

Are there any other ideas?

We do not have any problems in connecting to Oracle 10g DBs.

Michael

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 09, 2008 at 02:08 PM

    Hi,

    with the help on SAP we managed to get the connection to the Oracle 8.0.6.2 DB using the classes12.jar driver parallel to the newer ojdbc14.jar driver which runs for our other DBs.

    1. Download the classes12.jar driver

    [http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc901.html]

    Hint: You can download the classes12.zip file which contains the oracle-classes. Unzip the file and convert the all classes in the oracle folder to a jar file using the command "jar cf classes12.jar oracle".

    2. Deploy the classes12.jar JDBC Driver to NetWeaver

    By "deploying", the driver file is copied to NetWeaver and liked to a name that later will be used in the new Data Source. For more details see

    [https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/8675] [original link is broken] [original link is broken] [original link is broken];

    3. Create new Data Source in NetWeaver

    Follow the description from the above mentioned document to create a new data source. To avoid the ORA-02248 error, "SQL Engine" should be set to "Vendor SQL".

    4. Create new Data Server in MII

    Create a new data server in the Data Servers part of MII, using the following parameters:

    - Connector: "DataSource"

    - Datasource: "jdbc/<Resource name of the data source in NetWeaver>"

    On our side, it worked. Two things seemed to be important: SQL Engine "Vendor SQL" prevented the ORA-02248 error, and the link to the NetWeaver Data Source only worked with the Data Source name, prefixed by "jdbc/".

    Michael

    Add comment
    10|10000 characters needed characters exceeded