{"id":41650,"date":"2024-05-20T10:18:57","date_gmt":"2024-05-20T10:18:57","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=41650"},"modified":"2026-02-19T05:23:20","modified_gmt":"2026-02-19T05:23:20","slug":"jdbc-connection-payara","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/jdbc-connection-payara","title":{"rendered":"How To Perform Connection Pooling In JDBC With Payara Appllication Server?"},"content":{"rendered":"

How To Perform Connection Pooling In JDBC With Payara Application Server?<\/h2>\n

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

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

Here are simple steps to set up JDBC for Payara with AccuWeb.Cloud.<\/a><\/p>\n

Create Environment<\/h2>\n

Step 1.<\/strong> Log<\/a> into your AccuWeb.Cloud dashboard and click the “New environment”<\/strong> button.<\/p>\n

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

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

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

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

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

Setting Up Database<\/h2>\n

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

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

Step 2.<\/strong> Once logged in, go to the User Accounts tab and click “Add user account”<\/strong>. Fill in all the necessary information in the form, and make sure to check the box that says “Create a database with the same name and grant all privileges”<\/strong>.<\/p>\n

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

Finally, click “Go”<\/strong> at the bottom of the page 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 by default, so there’s no need to manually upload it. You can find it in the path \/opt\/payara\/glassfish\/domains\/domain1\/lib.<\/strong><\/p>\n

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

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

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

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

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

In The Form That Appears, Fill In The Following Fields<\/h3>\n