Re: Customizations in Java

GK Subramanian wrote:
>
> Hi,
>
> One of our clients wants to know if we can do the ORACLE customizations
> in Java instead of using PL/SQL. Has anyone done this and what are the
> advantages of doing this. The client feels that PL/SQL is very
> proprietary. Please let me know your thoughts.
>
> Thanks in advance.
>
> -Krishna.
I'm not quite sure what you mean by customizations so if I am going off on the wrong track please forgive me

Accessing and Oracle Database via Java can only be done in one of two ways.

Firstly using the JDBC/ODBC route. This suffers all the problems/benefits that any ODBC approach suffers but with the bonus of the client independance that JAVA provides. The level of independance of the server database really depends on what facilities you call via JDBC.

The second approach is the additional classes that are provided for database access from server side Java as provided with Oracle Web Server. This is essentially an interface to some PL/SQL procedures so you haven't really got away from PL/SQL.

I would suggest that the question that you need to ask (and you customer needs to answer) is how likely is it that we he/she will want to drop Oracle and use something else. If the answer is that it is unlikely then PL/SQL represents a good option as it is common to all Oracle Databases (so far as I know) and IMHO more portable, if it encompasses the whole of a system, than Java. (I speak as someone who regularly develops under NT and then justs ftps into the unix envirnoment).

I hope this helps

        Steve Received on Wed Dec 10 1997 - 00:00:00 CET