DB2/400 JDBC Connections -- JAVA400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

We are currently working on a tree-tiers architecture based on
Java/CORBA/JDBC technologies.
A Java Applet talks with a Java CORBA server on AS400 which talks with a
DB2/400 database.
We have two possible JDBC connection strategies :

1) create a JDBC connection for each user when he connects to the system.

2) create a pool of JDBC connections and affect one connection of the pool
to a requesting user for the time of the request.

For the first solution, the question is :

for each IBM DB2/400 JDBC driver (native and non-native), how many
simultaneous JDBC connections could a DB2 database on AS400 handle ???

Thanks for an answer

Serge

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.