When installing openfire, you can choose the built-in database-hypersql for simplicity.
Hypersql is a lightweight open-source relational database system developed in pure Java. Please refer to its official website: http://hsqldb.org/
Next we will record how to use hypersql step by step
- Find the installation path of HSQLDB. Jar
In ubuntu9.10, the installation path of HSQLDB. jar is in/usr/share/openfire/lib. You can also use the following command to find
$ Dpkg-s openfire | grep HSQLDB. Jar
- Suspend openfire Service
Because openfire locks the database and stops the openfire service for access
$ Sudo service openfire stop
- Run the hypersql database management tool
$ Sudo Java-cp hsqldb. Jar org. HSQLDB. util. databasemanagerswing
- Connect to a hypersql Database
Select hsql Database Engine standalone for Type
Select JDBC: HSQLDB:/var/lib/openfire/Embedded-DB/openfire as the URL.
The default user is Sa.
The password is empty by default.
- Connection successful. You can operate hypersql !!
From: http://blog.csdn.net/liuyu790810/article/details/5511588