Database Abstraction

Steps to switch Database used by PF

1. Add jdbc driver to classpath of application.

2. Create policy_user user in database.

3. Create policy_admin database.

4. Edit the defaultConfig that is sent to start up your application and switch out the driver for the new database driver.

   Example DB Config

   "databaseProviderParameters": { "name": "PolicyProviderParameterGroup", "implementation": "org.onap.policy.models.provider.impl.DatabasePolicyModelsProviderImpl", "databaseDriver": "org.postgresql.jdbc.Driver", "databaseUrl": "jdbc:postgresql://localhost:5432/policyadmin", "databaseUser": "policy_user", "databasePassword": "cG9saWN5X3VzZXI=", "persistenceUnit": "PolicyMariaDb" },

   
   
   

5. Run PAP application and you should see the tables created correctly in the database.

Proven Compatibility with Postgres