Re: JDBC vs ODBC Performance

["Alex Garrison" <agarrison@xxxxxxxxxxx>]

Richard,

1. From code you sent, you are using the toolbox jdbc driver.  If you want
to use the native db2 jdbc driver try:
      DriverManager.registerDriver(new com.ibm.db2.jdbc.app.DB2Driver());
      connection = DriverManager.getConnection
("jdbc:db2:my400","myuserid","mypassword");

    Make sure your class has import com.ibm.db2.jdbc.app.* instead of import
com.ibm.as400.access.*

2. As far as I know the bit about QTMHHTTP applies only to the toolbox rec
level i/o.


Alex Garrison

----- Original Message -----
From: Richard Dean <rddean@gdi.net>
To: <JAVA400-L@midrange.com>
Sent: Friday, January 21, 2000 2:24 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
+---