JBoss Enterprise Application Platform can deploy and manage any Java application you have as part of your stack — and to really optimize our performance, we want to leverage one of JBoss EAP’s principal tools, connection pools. Connection pools work with datasources and resource adapters to reduce the cost of connections by pooling all connections available on the application. In this lab, we configure the connection pools for two datasources, both on the CLI and the Console.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Update the ExampleDS
Log in to the HAL Management Console using the username
adminand the passwordpinehead.Navigate to Configuration > Subsystems > Datasources and Drivers, then select View for ExampleDS.
Select the Pools tab and click Edit.
Set the Initial Pool Size to
1, the Minimum Pool Size to1, and the Maximum Pool Size to 10. Enable strict minimums. Save.
- Update the MySQLDS
Move to the CLI and access the JBoss EAP home directory:
cd /opt/jboss-eapAccess the JBoss CLI:
sudo ./bin/jboss-cli.sh connectAdd the minimum value:
/subsystem=datasources/data-source=MySQLDS/:write-attribute(name=min-pool-size,value=5)Enable pool prefilling:
/subsystem=datasources/data-source=MySQLDS/:write-attribute(name=pool-prefill,value=true)
- Restart the Service
Exit the CLI:
exit
For changes to take effect, we must restart the service:
sudo systemctl restart jboss-eap-rhel
