Re: JDBC and Oracle

Instead of using JDBC, I would suggest that you write stored procedures in the database, and call these procedures from your program.

That way you can alleviate traffic and only receive the results needed instead of calling the database hundreds of times. (Are you sure you mean what you say? Hundreds of queries per second or do you mean hundreds of rows per second? If you mean what you say, you'ld better look into other performance enhancing techniques on the database administration side like caching, precompiling, clustering, load balancing, etc. Tune your queries as well.)

You can write your stored procedures in PL/SQL or Java. These are then cached in the database.

You might also look into using the OCI drivers instead of the thin drivers.

Nicodemus Chan.
(nicodemus_at_NOSPAMOKAYdavidaslan.com)

"Matthias Kampmann" <matthias.kampmann_at_uni-bielefeld.de> wrote in message news:3D91BA82.831E1E27_at_uni-bielefeld.de...
> Hello,
>
> I am on a project with Oracle and JDBC. A Servlet should process about
> serveral hundret SQL-Queries per sec with Oracle DB, with small data
> sets as return. Therefore the servlet should be very fast and stable.
> SQLJ is quite elegant, but I think its to lame for that cause it uses
> JDBC. Or is that bad rumour?
> By now I am planning to use JDBC type 1 or 4 and do Connecting Polling.
> At the moment I am getting the JDeveloper from Oracle. I know there are
> plenty of JDBC drivers.
>
> Is there anything faster than JDBC? (Only hoping)
> Has someone experiences with Oracle and Java-sql queries?
>
> Any suggestions?
>
> Thx in advance, Matthias
>
>
Received on Thu Sep 26 2002 - 23:29:36 CEST