DOs and DONTS for Oracle/JDBC

Hi:

I will be developing a web application using Java Servlets,
JSP (perhaps)
Oracle 8i
and JDBC.

We dont need to support multiple database. So I'd like to use maximum native Oracle.

My question is
1) Which JDBC driver should I use (Oracle's vs. Weblogic or any other) 2) Any other gotchas that I should be aware of? I will need to fetch  multiple row set.
3) At the present I do not have any BFILE. I may have files outside Oracle, and I may store them as BFILE. I may also have some BLOBS in the future. Any gotchas while handling these will be appreciated. 4) Any problems using Oracle Stored procedures or PL/SQL ?

Please forward your responses to umak_at_rocketmail.com

Thanks in advance

Uma Krishnan

In article <7j46b0$tgf$1_at_nnrp1.deja.com>,   Alan Lee <alanlee88_at_my-deja.com> wrote:
> I believe you have to register the driver via driverManager
> and create a connection object with username, password,
> hostname and sid. Don't have the syntax with me but generally
> that's the way to go.
>
> Alternatively, you can create datasource object instead of
> connection.
>
> Hope this helps.
>
> Alan Lee
>
> In article <7j3o2l$n88$1_at_birch.prod.itd.earthlink.net>,
> "Marshall Greer" <marshall_at_galef.org> wrote:
> > I just installed an Oracle 8i Server on NT and am trying to modify a
> java
> > app to access a database instance i created via JDBC w/ the driver
> provided
> > by Oracle (oracle.jdbc.driver.OracleDriver). I'm unclear from the
> class
> > description for the driver of the exact syntax I should be using for
> the url
> > and properties I need to supply the driver with in order for it to
> connect.
> >
> > Suppose the following were true:
> >
> > IP address of NT Server running the Database: 209.62.171.5
> > Port Address for Net8 Listener for IIOP Clients via TCP/IP: 2481
> > SID for Database: db
> > username: jjohnson
> > password: superfly
> >
> > Is this the correct syntax?
> >
> OracleDriver.connect

("jdbc:oci:jjohnson/superfly_at_209.62.171.5:2481/db");
> >
> > Any help would be greatly appreciated.
> >
> > Thanks,
> >
> > M
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 08 1999 - 13:25:37 CDT