Java 1.5 and Oracle 8 database

[Makesh Kumar Ramakrishnan]

Currently we have an application in java 1.5 running in one plant. The database used in that plant is Oracle10i.
Now we want to use the application in another plant which has Oracle8i as a database.
The problem here is i couldn't find a jdbc jar file for Oracle8i compatible with Java 1.5.
Is there any hope I can run the application in Java 1.5 against Oracle 8i database? Please let me know if you have any solution.

Thanks,

[Jeanne Boyarsky]

Makesh,
Java 5 can run code from any earlier version of Java. You could use the Java 1.3/1.4 driver that came with Oracle 8.

[Makesh Kumar Ramakrishnan]

Thanks for your reply. Yes, I could use the earlier version jar file like classes12.jar with java 1.5. The problem I have is when I use those jar files, I might lose the some of the functionality provided by the latest JDBC jar file like connection caching. Is there anyway I can use the latest JDBC driver functions compatible with Oracle 8?

Otherwise I need to implement the functions.

Thanks,

[Jeanne Boyarsky]

Originally posted by Makesh Kumar Ramakrishnan:
Is there anyway I can use the latest JDBC driver functions compatible with Oracle 8?

Drivers distributed with a later version of the database are unlikely to work with an earlier version. You could try it, but I think that is asking for trouble down the road.

Otherwise I need to implement the functions.

Or write your application so it uses basic JDBC functionality that has always been there.