Re: does java replace pl/sql?

In case you would like the choice, SQL-Programmer will offer Oracle Java integrated with its current PL/SQL for server side coding development environment, all with a Java debugger, same functionnality as SQL-Programmer current PL/SQL Debugger, and more.

In case this might help you.

For the latest review on SQL-Programmer: http://www.oracle-home.com/cgi-bin/reviews/jump.cgi?ID=5

For SQL-Programmer details:
http://www.sfi-software.com

Thanks.

> -----Original Message-----
> From: Michael Moore [SMTP:hicamel_at_home.com]
> Posted At: Monday, May 15, 2000 12:56 AM
> Posted To: tools
> Conversation: does java replace pl/sql?
> Subject: Re: does java replace pl/sql?
>
> There is something to be said for "keep is simple". I've use both Java
> and PL/SQL. I like Java because it looks good on my resume, but PL/SQL
> is a real work horse and better integrated with SQL than JDBC. Also,
> PL/SQL is highly optimized and according to an EX Oracle employee who
> was now starting in and IPO and deciding Java or PL/SQL, said that
> PL/SQL cannot be beat for performance. I am about to embark on a new
> project for the company I work for and I think that I will go with
> PL/SQL unless there is some specific Java functionality that I need.
>
> Mike
>
>
> buckwheat wrote:
> >
> > I'm not that handy with pl/sql. for that matter, i havn't spent
 that
> > much time with java either. so, apologies in advance if this sounds
> > like REAL stupid.
> >
> > I decided to give my 8i a little server-side task to do. Make a
 table,
> > and populate it with about 10k dummy records, all fields filled with
> > randomly generated and distinct data.
> >
> > With VB/ADO it was actually pretty easy. But that was on the client
[Quoted] > > side. With PL/SQL, I used "TOAD", and managed to code it, compile
 it
> > and install it. But with Ora's JDeveloper, I've been working on it
 for
> > 2 days with no luck to make the code "pure java", just on the
 server.
> >
> > So I got out the docs, and see I could make this a CORBA ojbect with
> > Enterprise Beans using either JDBC or SQLJ or Ent Business Objects
 with
> > self-compiled JAR's with autoinstalls with certain versions of JDK
 1.2,
> > but I may have 1.3 then again I've got JD 2000 just upgraded to
> > JavaDevel 3.0 and 3.1 is the newest but i'll have to download the
 whole
> > thing to update it then I could eventually wrap the PL/SQL with SQLJ
 but
> > that sort of defeats the whole purpose I guess then again I see it
 could
> > make an entire web application with Swing and everything but it's
> > awfully slow and there's not a whole lot of talk about AWT but then
> > again JDevel could make me some real nifty XML code but then my web
> > servers gotta be upgraded and the on-line docs tell you how to build
 a
> > client/server app and even some web code but my customer doesn't
 want
> > web code (yet) but now I notice all of a sudden there's NOTHING
 about
> > just laying down a simple Java SPROC then again the JIT compiler may
 or
> > may not be installed on the server itself and besides the J
 extensions
> > need their parents only if the JNI (native interface) into the JVM
 is
> > version-aligned to just make it work but wait - how bout just a
 server
> > side HTTP servlet using just INFOBUS and that's with certain Beans
> > already in place for your run of the mill Applet.....
> >
> > Aw hell. Should I just stick to PL/SQL?
Received on Fri May 19 2000 - 00:00:00 CEST