Newbie: Advice on strategy.

Thread view:

abu - 17 Dec 2003 01:51 GMT

Hi all,

I am going to be developing a little app which works with an Oracle 8i db
and will be java desktop application running on Windows 2000. Previously I
had been developing using Oracle 9i and .NET (ODP.NET). So I would like your
advice on how to get started. I would appreciate your assistance with the
following questions:

1) I guess I need to download the Oracle 8i JDBC drivers from Oracle.com and
this will then allow me to use the java.sql API. Is this correct ?

2) If I wanted to deploy the application what whould the host environment
require ? Is it a case of JRE/the application/ JDBC driver. Can anyone
recommend a way of neatly packaging this up?

3) If most of my work will require the generation of exception reports (most
of the data for this will be on the DB) should I use pl/sql procedures or
Java Stored procedures. Actually, I would like to clarify my understanding
of these. Are you effectively creating compiled java code and loading it
into the DB for later use?

Many Thanks,

-A

Reply to this Message

Silvio Bierman - 18 Dec 2003 16:34 GMT

Inline...

> Hi all,
>
[quoted text clipped - 6 lines]
> 1) I guess I need to download the Oracle 8i JDBC drivers from Oracle.com and
> this will then allow me to use the java.sql API. Is this correct ?

That is correct. You should use the thin driver since the other driver uses
native code to access OCI libraries which means you need an Oracle client
installation.

> 2) If I wanted to deploy the application what whould the host environment
> require ? Is it a case of JRE/the application/ JDBC driver. Can anyone
> recommend a way of neatly packaging this up?

Package the app (preferably compiled into a JAR) and the additional JARs and
resources (images, property files, etc.) in a ZIP/TAR.GZ file. If required
distribute a JRE along with the archive (I prefer not to).

> 3) If most of my work will require the generation of exception reports (most
> of the data for this will be on the DB) should I use pl/sql procedures or
> Java Stored procedures. Actually, I would like to clarify my understanding
> of these. Are you effectively creating compiled java code and loading it
> into the DB for later use?

Have not used Java Stored Procs on Oracle8. I thought they where kind-of
beta in 8? I would go for a pl/sql solution for now. You can always rewrite
the pl/sql to Java and leave the app unchanged. I really don't see the
advantage of either solution, unless you know Java/JDBC and not pl/sql (or
the other way around).

> Many Thanks,
>
> -A

Regards,

Silvio Bierman

Reply to this Message

Newbie: Advice on strategy.

Free Magazines