RE: odbc/jdbc question

John

   You've lost me on the relevancy. PL/SQL executes within the database so in theory should run magnitudes of time faster than ODBC/JDBC. C is a programming language, so presumably you are using Pro*C or OCI to interact with the database. Again, your C program can execute on the server, thereby avoiding network delay, and again, running magnitudes faster than ODBC/JDBC. The point is that you need to use whatever tool is appropriate to your situation. If the goal is to allow a Java program to interact with Oracle, then that limits your options. Let me know if I've misunderstood your comment.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, August 22, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L

I've tested JDBC scenarios which run 100 times slower than equivalent operations in PL/SQL or C.

Cheers,

John Thomas

In message <F001.004B2243.20020812120824_at_fatcity.com>, Joe Armstrong-Champ <Joseph.Armstrong-Champ_at_tufts.edu> writes
>We are running Oracle 8.1.7 on AIX. Our users want to use ODBC & JDBC
>products to connect to the database. Are there any security issues we
>should know about? Any other issues?
>
>Thanks.
>Joe
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
John Thomas                                     Tel:    01506 881 037
Oracle Contract DBA                             Mobile: 07986 182 368
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Thomas
  INET: oracle_at_toronto.demon.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).