hi everyone.
The problem did show up again in the web application.
So the solution of upgrading the dbcp.jar helped performance but did not
solve the situation.
I found this site:
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html/
"...
The JDBC-ODBC Bridge driver is recommended only for experimental use or
when no other alternative is available.
9.2 JDBC-ODBC Bridge
If possible, use a Pure Java JDBC driver instead of the Bridge and an
ODBC driver. This completely eliminates the client configuration
required by ODBC. It also eliminates the potential that the Java VM
could be corrupted by an error in the native code brought in by the
Bridge (that is, the Bridge native library, the ODBC driver manager
library, the ODBC driver library, and the database client library).
The JDBC-ODBC Bridge driver is recommended for use in prototyping
efforts and for cases where no other JDBC technology-based driver
exists. If a commercial, all-Java JDBC driver is available, we recommend
that it be used instead of the Bridge.
..."/
and this site:
http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/bridge.html
"...
/The JDBC-ODBC Bridge should be considered a transitional solution. Sun
Microsystems and DataDirect Technologies are working to make the Bridge
more reliable and robust, but they do not consider it a supported
product. With the development of pure Java JDBC drivers, the JDBC-ODBC
Bridge should become unnecessary./
..."
That clearly states that the JDBC Driver (sun.jdbc.odbc.JdbcOdbcDriver)
should not be used for production sites (ups!).
So i test the db2 app driver (db2java.zip)
(COM.ibm.db2.jdbc.app.DB2Driver) that comes with db2 connect in
development site and everything worked fine. I changed the production
site also, we just have to wait and see if the problems shows up again.
In mean time, i found out that the site perfoms faster with the new
driver (oohlala!).
Do any of you think that the problem maybe the java code in the web
application more than the application server?
or maybe the db2 server?
Friedrich Gonzalez