This wiki is now locked - both user registration and edits (except by admins) are disabled. We're currently migrating all the content to our new wiki. If you have time, please register and help us out!

You can still view the source code of every page. Once a page has been copied over to the new wiki, please add a link to it to MigratedPages (the only page which is still editable), to notify the admins to go and blank it.

Thaw Hsqldb Integration


Homepage

Plugins using Hsqldb


To access to the Hsql database of Thaw from a plugin, you need to pass by the Hsqldb plugin. Here is a basic example for a plugin using hsqldb in thaw:

package thaw.plugins;

import java.sql.*;
import thaw.core.*;

public class PluginUsingHsqldb implements Plugin {
    private Core core;
    private Hsqldb hsqldb;

    public PluginUsingHsqldb() {
            /* never called */
    }

    public boolean run(Core core) {
        this.core = core;

        /* If Hsqldb plugin is not already loaded, then we need to load it */
        if(core.getPluginManager().getPlugin("thaw.plugins.Hsqldb") == null) {
            Logger.info(this, "Loading Hsqldb plugin");

            if(!core.getPluginManager().loadPlugin("thaw.plugins.Hsqldb")
               || !core.getPluginManager().runPlugin("thaw.plugins.Hsqldb")) { /* Hsqldb.run() do almost nothing, see Hsqldb.registerChild() */
                Logger.error(this, "Unable to load thaw.plugins.Hsqldb !");
                return false;
            }
        }

        hsqldb = (Hsqldb)core.getPluginManager().getPlugin("thaw.plugins.Hsqldb");

       /* We need to register: Like this, Hsqldb plugin can know how many child plugins
         it has. When this number reach 0, then it can disconnect from the database.
        */
        hsqldb.registerChild(this);


                /* ADD YOUR CODE HERE */

        return true;
    }


    public boolean stop() {
        hsqldb.unregisterChild(this);
        return true;
    }

    public String getNameForUser() {
        return I18n.getMessage("thaw.plugin.PluginUsingHsqldb");
    }
}


When you have a reference to the Hsqldb plugin, then you can use getConnection() or executeQuery() or execute() to send query to the database (but be careful about the SQL Exception).
From this point, everything works as usual with Jdbc.

Regarding the methods registerChild() and unregisterChild(), you can look at the thaw.core.LibraryPlugin javadoc for more details.

SQL Console


You can access yourself to the database by using the Thaw SQL Console:
Put Thaw in advanced mode, and load the plugin "thaw.plugins.SqlConsole".

The SQL used is, of course, the Hsqldb one :)

Shortcut available:



Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki