It is direct integration of the chat server and the user database, through JDBC driver, which is abbreviation of Java DataBase Connectivity standard.

This way is for advanced user who not only understands how to connect database using JDBC driver, but also is capable of performance tuning to handle high traffic.

Configuration:

Firstly you need to check the existing database of your website, then configure the corresponding XML under this folder: <123flashchat installed directory>/etc/groups/<group name>/database/, ie:

- For Mysql, configure Mysql.xml
- For Oracle, configure Oracle.xml
- For Sql Server, configure ODBC.xml
- For the other database, configure Common.xml

a) Mysql.xml

Parameter	Type	Description
database-host	string	The hostname of the database server.
database-name	string	The database name you are using.
database-user	string	The user name which is required to connect to the database.
database-password	string	The password which is required to connect to the database.
user-table	string	The table to store the user information.
username-field	string	The column of names of the user names in the user-table.
password-field	string	The column of names of passwords in the user-table.
enable-md5	string	It defines whether the password is encrypted with MD5. On - encoded. Off - not encoded. Passwords in many portal systems and forum systems like php-nuke, post-nuke or phpBB, etc. are encrypted with MD5, thus you will need to set this value to ‘On'.
connection-pool->pool-size	number	Maximum number of pooled database connections, or 0 for no limit.
connection-pool-> max-size	number	Maximum number of possible database connections, or 0 for no limit.
connection-pool-> init-num	number	Initializes the given number of database connections.
connection-pool->expiry-time	number	Expiry time (milliseconds) for pooled database connections, or 0 for no expiry.

Oracle.xml

Parameter	Type	Description
mode	string	It could be “thin� or “oci� only. It indicates the way to access the database. The default value is “thin�. If you choose “oci�, then your server must have installed an oracle client.
database-host	string	The hostname of the database server.
database-port	number	The port of the database.
database-sid	string	The sid of the database server.
service-name	string	The service name to connect to oracle. It doesn’t take effect unless you choose the mode “oci�.
database-user	string	The user name which is required to connect to the database.
database-password	string	The password which is required to connect to the database.
user-table	string	The table to store the user information.
username-field	string	The column name of user names in the user-table.
password-field	string	The column name of passwords in the user-table.
enable-md5	string	It defines whether the password is encrypted with MD5. On - encoded. Off - not encoded . Passwords in many portal systems and forum systems such as php-nuke, post-nuke or phpBB, etc. are encrypted with MD5, thus you will need to set this value to “On�.
connection-pool->pool-size	number	Maximum number of pooled database connections , or 0 for no limit.
connection-pool-> max-size	number	Maximum number of possible database connections , or 0 for no limit.
connection-pool-> init-num	number	Initializes the given number of database connections.
connection-pool->expiry-time	number	Expiry time (milliseconds) for pooled database connections, or 0 for no expiry.

CommonDB.xml

Parameter	Type	Description
jdbc-driver	string	The name of the jdbc driver.
jdbc-url	string	The complete jdbc URL. If the user name and password are required when the database is accessed, they must also be included.
user-table	string	The table to store the user information.
username-field	string	The column name of the user names in the user-table.
password-field	string	The column name of passwords in the user-table.
enable-md5	string	It defines whether the password is encrypted with MD5. On - encoded. Off - not encoded . Passwords in many portal systems and forum systems such as php-nuke, post-nuke or phpBB, etc. are encrypted with MD5, thus you will need to set this value to “On�.
connection-pool->pool-size	number	Maximum number of pooled database connections , or 0 for no limit.
connection-pool-> max-size	number	Maximum number of possible database connections , or 0 for no limit.
connection-pool-> init-num	number	Initializes the given number of database connections.
connection-pool->expiry-time	number	Expiry time (milliseconds) for pooled database connections, or 0 for no expiry.

login the Admin Panel

System Setting -> Integration Panel
Choose a specific database and submit.
If error occurrs, please recheck the configuration and submit again.