Re: JDBC vs ODBC Performance

[Graeme English <graeme.english@xxxxxxxxx>]

Richard,

It is possible that the battle between Native and Toolbox JDBC drivers has
changed since Alex's note.  But as I understand it, the Native JDBC driver
has faster performance and also is the one that is being further improved in
the newer releases.  The format is just a swap with as400 and db2 eg. in
your case use:
>connection = DriverManager.getConnection ("jdbc:db2://my400",
the DDM and Toolbox both use TCP/IP sockets so if you use Alex's QTMHHTTP
trick it should work (although I don't know this one).  However if you start
using the native driver the trick should be irrelevant.  I'm not sure of
this so hopefully someone can add to this.

Good luck,
Graeme.



-----Original Message-----
From: Richard Dean <rddean@gdi.net>
To: JAVA400-L@midrange.com <JAVA400-L@midrange.com>
Date: Friday, January 21, 2000 2:51 PM
Subject: JDBC vs ODBC Performance


>Back in early November of last year Alex Garrison brought up the issue of
>"forcing native access with websphere and toolbox".  And there were a bunch
>of responses about getting the most optimized connection through JDBC vs
>ODBC.  Two things came up.
>
>1. One message said that you can configure your servlet to use the native
>DB2 JDBC drivers instead of the toolbox drivers for faster access.  So how
>do you do this?  I will show how I am doing it below.
>2. The other thing is Alex mentioned something about connecting with user
id
>QTMHHTTP to insure the bypass of TCP/IP on the 400.  Does this only apply
to
>record level access?  Or can I do this with JDBC/ODBC to get the same
>improvements?
>
>Here is how I am doing it:
>
>// Load the AS/400 Toolbox for Java JDBC driver.
>DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver());
>
>// Get a connection to the database.
>connection = DriverManager.getConnection ("jdbc:as400://my400",
>"MY_USER_ID", "MY_PASSWORD");
>DatabaseMetaData dmd = connection.getMetaData ();
>
>Is there a better way?
>
>
>
>Thanks in advance.
>
>Richard Dean
>
>
>+---
>| This is the JAVA/400 Mailing List!
>| To submit a new message, send your mail to JAVA400-L@midrange.com.
>| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: joe@zappie.net
>+---

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---