5.5. Database Configuration

Procedure 5.6. Configure Database

1. Remove ExampleDS and h2 database driver

   Using the CLI, execute the following commands to remove the example DS, and h2 database driver:

   [standalone@localhost:9999 /] /subsystem=datasources/data-source=ExampleDS/:remove
   [standalone@localhost:9999 /] /subsystem=datasources/jdbc-driver=h2/:remove

   Copy to Clipboard Toggle word wrap

2. Add JDBC Grant Statement

   Add the following grant statement to the Java Security Manager policy file for the JDBC driver you are using. The policy file is located at EAP_HOME/bin/eap62.policy. Substitute the directory name of the JDBC driver where [cc.jdbc.driver] is specified in the code sample.

   Important

   Each JDBC driver can use different permissions. Check the JDBC driver documentation and replace java.security.AllPermission; with a secure permission scheme supported by the driver.

   // granting permissions to JDBC driver 
   grant codeBase "file:${jboss.home.dir}/standalone/deployments/[cc.jdbc.driver]" {
     permission java.security.AllPermission;
   };

   Copy to Clipboard Toggle word wrap