How to use the database hypersql provided by openfire (interface settings)

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

1. 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

2. Suspend openfire Service

   Because openfire locks the database and stops the openfire service for access

   $ Sudo service openfire stop

    

3. Run the hypersql database management tool

   $ Sudo Java-cp hsqldb. Jar org. HSQLDB. util. databasemanagerswing

4. 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.

5. Connection successful. You can operate hypersql !!

From: http://blog.csdn.net/liuyu790810/article/details/5511588