Re: JDBC or ODBC?



PJ wrote:
I am in the interesting position of having to choose between using an ODBC or JDBC connection for a high traffic site. We can develop on either environment though I prefer the Java based one. Database connectivity to our SQL 2000 server is our number one priority. Does anybody know which offers the greatest performance and stability or at the very least point me in the right direction? 

For stability and support, you want JDBC. Performance should be a wash at least,
and unless you have reliability, you usually don't have anything. The JDBC-ODBC
bridge is notably buggy and unsupported. JDBC performance will come from pooling
and re-using open connections and similarly caching Prepared statements, and
managing any transactional work to single user-invokes (Ie: not holding locks
until a user application sends a second message). Primarily, performance will
come by doing as much of the DBMS-related work in the DBMS where the data is.
Write and use big fancy stored procedures. Always do all you can to avoid
shipping huge wads of raw data out of the DBMS to be processed.
Good luck,
Joe Weinstein at BEA Systems

.

Relevant Pages

  • Re: Abnormally dropped sessions & running programs
    ... by clicking on the close window button or killing it through Task ... TCP/IP connection to the server via a virtual workstation ... terminate the interactive process is via SIGNOFF or ENDJOB at the ... created under a default system user, etc, if a JDBC connection is ...
    (comp.sys.ibm.as400.misc)
  • JDBC Connection Help
    ... I need assistance with establishing a JDBC connection to an oracle ... database in VBS. ... I have the correct driver 0jdbc.jar which from what I can tell contains ...
    (microsoft.public.scripting.vbscript)
  • Re: connection timeouts
    ... Experiencing a problem whereby a jdbc connection seems to become stuck while ... It might be that your statement's SQL is blocked by locks in the ... DBMS that are being held by another process. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Using an existing JDBC Connection
    ... connection retrieved from DBI for the Perl script. ... Using an existing JDBC Connection ... information from a database, and am interested in using DBI for the ... the Java class calling into the perl script will ...
    (perl.dbi.users)
  • Re: bluetooth monitor / tx rx test app ?
    ... Depends what you mean by raw data, the simplest method of connecting two ... devices is over an RFComm layer socket which gives you a simple serial port ... style connection, however under the hood the raw data will be somewhat ... You can also map a COM port to a bluetooth connection, ...
    (microsoft.public.pocketpc.developer)