The driver must also be in the Openfire classpath (for example, by placing it into the 'lib/' directory of your Openfire installation.

jdbcProvider.driver - the class name of the JDBC driver used to connect to your custom database.

You must specify the connection string for your database as well as the JDBC driver.

Edit conf/openfire.xml in your Openfire installation folder as described below using your favorite editor.

In order to configure your server to integrate with your custom database tables: Your custom database can be a different database on a different server from the Openfire database - you'll enter database connection information as part of the configuration. You'll need to be familiar with your database table structure and simple SQL. The integration requires that you enter customized database queries to access your database. Any group in Openfire can be designated as a shared group, which means that you can pre-populate user's rosters using groups.

Optionally, you can configure Openfire to load user profile and group information from your custom database. Simple integration with a custom database lets users authenticate using their existing username and password. If your user information is available via an LDAP directory rather than custom database tables, see the LDAP guide. This is useful when your users already have accounts in an external system and you do not wish to duplicate those accounts in Openfire. This document provides instructions for integrating Openfire authentication, users, and groups with your custom database tables.

Openfire sql server connection string