Re: Why use Java Stored Procedures....

On Thu, 02 Mar 2006 00:13:49 +0000, Bob Jones wrote:

> Would you rather have a Java programmer migrating Java stored procedures to
> a different database or have a PL/SQL programmer migrating PL/SQL stored
> procedures to a foreign language for a different database?

What database, except Oracle, comes with Java as a native language? Personally, for migrating SQL between databases, I'd use ADOdb or DBI. DBD::Oracle is a piece of crap because DBD::Oracle doesn't support Oracle array interface. DBD::Oracle was taken over by Pythian group and they might write something decent by the year 2525. Portability, though, is not a problem. As for the differences, PL/SQL still hasn't some internal optimizations that Java doesn't have and will, therefore, be faster. Poorly written program in Java will be much slower then the same program poorly written in PL/SQL. You have to compare poorly written programs as they make vast majority of all programs.

-- 
http://www.mgogala.com