This has nothing to do with servlets, but...
an Oracle JSP (Java Stored Procedure), not to be confused with the common
JSP (Java Server Pages).
Currently the proc/con is not weighted in any one direction too heavily, and
speed is not really in the equation as both teams tend to share information
back and forth quite a bit.
JSP:
Pro: It's just JAVA for your programmers, so lots of resources
JAVA is open, PL/SQL is Oracle's ADA variant, and is proprietary
JAVA (all the rest of it, certification, etc)
Con: To use it in SQL you have to wrap it in PL/SQL anyways.
No access to JNI
Code can be extracted and reverse engineered fairly easily
PL/SQL
Pro: If you're an Oracle shop, you already have PL/SQL programmers
Better cursor management (IMHO)
Access to external C or other Libraries that can be wrapped in C
PL/SQL Wrap utility, makes reverse engineering of code very, very
difficult
Con: Proprietary, and less skilled folks being churned out of schools than
for JAVA
Now, from a physical multi-tier approach, PL/SQL isn't in that ballgame at
all.
Thor HW
----- Original Message -----
From: venu <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 28, 2000 12:44 AM
Subject: Java Stored Procedures
> Hi,
>
> Can anybody please point out the advantages and also disadvantages of
using
> Java Stored Procedurers compared with PL/SQL stored procedure.
>
> Thanks in Advance
> venu
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
