{"id":41790,"date":"2024-05-21T11:29:52","date_gmt":"2024-05-21T11:29:52","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=41790"},"modified":"2026-02-19T05:18:11","modified_gmt":"2026-02-19T05:18:11","slug":"jdbc-connection-glassfish","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/jdbc-connection-glassfish","title":{"rendered":"How to Perform Connection Pooling In JDBC with GlassFish Appllication Server?"},"content":{"rendered":"

How to Perform Connection Pooling in JDBC with GlassFish Application Server?<\/h2>\n

Java<\/a> application servers, such as GlassFish and Payara, use JDBC connection pooling to speed up database access. This means they reuse existing database connections from a pool instead of creating new ones each time.<\/p>\n

Setting up a JDBC connection pool on your server helps reduce delays and resource use, which boosts database performance, especially for dynamic applications.<\/p>\n

Here are easy steps to set up JDBC for GlassFish with AccuWeb.cloud.<\/a><\/p>\n

Create Environment<\/h2>\n

Step 1.<\/strong> Log into your Accuweb.cloud<\/a> dashboard and click “New environment.”<\/strong><\/p>\n

\"New<\/a><\/p>\n

Step 2.<\/strong> In the topology wizard, go to the Java<\/strong> tab, select GlassFish<\/strong> as your application server, and add the required database (like MySQL<\/strong>). Set the resource limits for your containers and choose an environment name.<\/p>\n

\"GlassFish<\/a><\/p>\n

Step 3.<\/strong> Click “Create.”<\/strong> Wait a few minutes for your new environment to be ready, then proceed to create the JDBC connection pool.<\/p>\n

Setting Up Database<\/h2>\n

Step 1.<\/strong> Open your MySQL node in the browser by clicking “Open in browser.”<\/strong> Use the email you received with database credentials to log into the phpMyAdmin panel.<\/p>\n

\"Open<\/a><\/p>\n

Step 2.<\/strong> Once logged in, go to the User Accounts<\/strong> tab and click “Add user account.”<\/strong><\/p>\n

\"Add<\/a><\/p>\n

Step 3.<\/strong> Fill in the form, and check “Create a database with the same name and grant all privileges.”<\/strong><\/p>\n

\"Fill<\/a><\/p>\n

Step 4.<\/strong> Finally, click “Go”<\/strong> to add the database and user for connection pooling.<\/p>\n

\"Connection<\/a><\/p>\n

Setting Up Java Application Server<\/h2>\n

Step 1.<\/strong> The JDBC MySQL connector is already included in the stack, located in the \/opt\/glassfish\/glassfish\/domains\/domain1\/lib<\/strong> directory on your GlassFish server.<\/p>\n

\"SFTP<\/a><\/p>\n

Step 2.<\/strong> Log in to the GlassFish Admin panel<\/strong> using the credentials provided in your email.<\/p>\n

\"GlassFish<\/a><\/p>\n

Step 3.<\/strong> Go to Resources > JDBC > JDBC<\/strong> Connection Pools and click the “New”<\/strong> button.<\/p>\n

\"JDBC<\/a><\/p>\n

Fill in The Form with These Details<\/h3>\n