What are the differences between how database access is supported by the integrated Web application server vs. ASF Tomcat & WebSphere Application Server?
The integrated Web application server documentation uses the terminology database connections. WebSphere Application server documentation uses the terminology data sources. Both refer to the same thing. A data source represents a specific database that is used by one or more applications installed in your application server. Data sources provide connection pooling and a JNDI name which can be used by applications to access the data source. The integrated Web application server supports a single JNDI name source. WebSphere Application Server supports multiple JNDI name sources. You are only allowed one JNDI data base connection with the integrated Web application server. Applications with multiple JNDI names and connections will not be supported on the integrated Web application server. The integrated Web application server connection pooling support is done by Apache commons database connection pooling. WebSphere Application Server connection pooling is done by WebSphere connection poo
