A client-scoped database pool is maintained by the Java EE client container, which runs in a JVM instance separate from the server. The database pool will be visible to the application client instance that runs inside this container. The client container will connect as a separate process to the database instance, and the database should be configured to accept connections from the client container. To illustrate, we have provided a sample application. This sample application is present at samples\Chapter-3 Database Connectivity\JDBC Sample ear.
The module plan for creating a client-scoped connection pool is shown below:
<module> <java>JDBCSample-client-1.0.jar</java> <application-client xmlns="http://geronimo.apache.org/xml/ns/j2ee/application-client-2.0"> <client-environment xmlns="http://geronimo.apache.org/xml/ns/deployment-1.2"> <moduleId> <groupId>com.packtpub.jdbc</groupId> <artifactId>JDBCSample-client...