I use JDBC, and I like it a lot. There is an OCI driver, which uses JNI to map the JDBC API to OCI. The bottleneck is how fast Oracle can commit transactions, not how fast JDBC can send them (YMMV). It is much either to work with than either OCI or ODBC. The API includes prepared statements, which is like using bind variables, it has a streams interface to CLOBs, which makes them as easy to manipulate as files. There's a "thin" driver also, which ships the JDBC drivers over the network as you need them, if they aren't installed on the client. About the only thing I don't like about JDBC is the way it handles dates and times.
HTH, g -----Original Message----- Sent: Thursday, October 04, 2001 11:50 AM To: Multiple recipients of list ORACLE-L We're thinking of moving our Java application away from proprietary connectivity to Oracle to using JDBC. The application will eventually be deployed to hundreds of client workstations. Anyone using JDBC care to comment on their experiences or what we need to know at the planning stage? We're interested (of course!) in stability, reliability and performance. Many thanks for any insights! Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
