 |
AppletTalk.com
Java discussions newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
abu
Guest
|
 Posted: Wed Dec 17, 2003 1:51 am Post subject: Newbie: Advice on strategy. |
 |
|
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
|
|
| Back to top |
|
 |
Silvio Bierman
Guest
|
| Posted: Thu Dec 18, 2003 4:34 pm Post subject: Re: Newbie: Advice on strategy. |
|
|
Inline...
"abu" <noway (AT) hotmail (DOT) com> wrote
| Quote: | 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 ?
|
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.
| Quote: |
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).
| Quote: |
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).
Regards,
Silvio Bierman
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
