Re: JDBC Connection problem

["Luther Ananda Miller" <luther.miller@xxxxxxxxxx>]

There seems to be a lot of overhead in connecting. One minute does seem
pretty long though. If you are using the connection in a servlet, you might
want to look into connection pooling so that the connections are already
open when they need to be used.
If you are running the code below on the AS/400, perhaps optimizing the
toolbox jar with CRTJVAPGM might help (level 30), although is is alreday
done on newer releases.
Have you tried connecting with ODBC and do you get similar results?

Luther

----- Original Message -----
From: Pétur Friðriksson <petur@takn.is>
To: <JAVA400-L@midrange.com>
Sent: Tuesday, 9 November 1999 15:55
Subject: JDBC Connection problem


When running the following code to connect to a DB2 via JDBC, the connection
time is very long or up to a minute.

Connection m_conConnection = null;
try
{
DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver());
m_conConnection = DriverManager.getConnection("jdbc:as400://" + "MySystem",
"userid", "passwd");
m_conConnection.close();
}

Does anyone have a clue what might be the problem.

Regards

-----------------------------------------------------------------
Petur Fridriksson petur@cardopt.com
Card Optimisation fax: +354 510 3309
Suðurlandsbraut 52 tel: +354 510 3305
108 Reykjavík gsm: +354 898 9027
Iceland www.clear.is
-----------------------------------------------------------------


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