DB Connection Pool

Many webservers provide the db connection pool. J-ASP ADODB uses the db connection pool of the webservers directly. We have tested it with Weblogic, WebSphere, Tomcat etc.
You need change the connection string to following format:

"DSN=JNDI-name;UID=userID;PWD=password;"

For example:
If you have set a JNDI name 'jdbc/oraDemo' in WebSphere, you need change the connection string as following:

"DSN=jdbc/oraDemo;UID=scott;PWD=tiger;"

How to use the connection pool ?

• Configure the JNDI DataSource and db connection pool in webserver.
  • For Apache Tomcat, please see Database Connection Pool (DBCP) Configurations.
  • For WebLogc 8.1, please see Configuring and Using WebLogic JDBC.
  • For WebSphere 5.1, please see the document of WebSphere 5.1
  • For Sun Java System Application Server, please see Creating a JDBC Resource.
  • For Oracle9iAS Containers for J2EE, please see Data Sources Primer
• Modify the connection string to "DSN=JNDI-name;UID=userID;PWD=password;" in the converted jsp codes.
• Test the jsp codes.

Please contact asp2jsp@netcoole.com if you have any questions.