JDBC vs ODBC Performance

["Richard Dean" <rddean@xxxxxxx>]

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
+---