Re: should I program Oracle in Java or pl/sql

I'd say use Java as much as possible for your application logic, with a bit of PL/SQL only for complex data retrieval. Keeping most of the application in Java will make it simpler to move the code off to an application server in the future if necessary, in addition to being able to use the object-oriented capabilities of Java right now. Altough PL/SQL now has objects, it still lacks object-oriented fundamentals such as inheritance and polymorphism.

And when writing Java in the database, try to steer clear of Oracle-specific extensions, if you want to avoid being locked into Oracle for the next 10 years, and if you want to keep open the possibility of moving the code to an external application server. For example, avoid using Oracle's DATE and NUMBER Java classes, or at least create your own wrapper classes for the Oracle classes so they can be replaced easily if moving the code out of the Oracle server.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 10 2000 - 10:06:36 CST