Java Database Connectivity (JDBC)

We are having a specific problem and we are trying to find a suitable workaround.

We have a PL/SQL procedure in a package that is run periodically as a cron job to extract data from a remote 7.3.4 database and insert into a table in our Oracle database. We have a Oracle 8.1.7 production database which is to be updated shortly to Oracle 9.2. The procedure works fine when executed from the Oracle 8.1.7 database.

We have a Oracle 9.2 test database and when we run the procedure from the Oracle 9.2 database we get several errors (ORA-01002 and ORA-02063). We understand that it would not be possible to run the PL/SQL procedure from the Oracle 9.2 database to access data in the Oracle 7.3.4 database as the latter is desupported by Oracle.

We are therefore trying to find a workaround as we do not have any control over the remote Oracle 7.3.4 database. We are trying to see if it would be possible to access the data in the Oracle 7.3.4 database from the 9.2 database. I created a JSP using JDeveloper 9i and tried to call the procedure to extract data from the remote Oracle 7.3.4 database. However, this did not work. I wonder if calling the procedure would work if a Oracle 8.1.7 Oracle Driver was used.

For this purpose I copied and renamed the class12 files (which contains the relevant jar files with the OracleDriver code) from a previous version of JDeveloper and put it into an appropriate folder. I used the following code to get the connection:

JarFile jf= new JarFile("O:/JLibraries/classes12_817.zip");
ZipEntry ze = jf.getEntry("oracle/jdbc/driver/OracleDriver.class");
ObjectInputStream m_Stream = new ObjectInputStream(jf.getInputStream(ze));

OracleDriver m_Driver = (OracleDriver) m_Stream.readObject();
java.util.Properties m_Info = new java.util.Properties();
m_Info.put("user", "user");
m_Info.put("password", "password");
m_Conn = m_Driver.connect("jdbc:oracle:thin:@our_database", m_Info);

However, I get the following error message:
QUOTE
java.io.StreamCorruptedException: InputStream does not contain a serialized object
UNQUOTE

Could you please let me know where I am going wrong?

Thanks.