Examples of org.hsqldb.HSQLInterface

org.hsqldb.HSQLInterface
This class is built to create a single in-memory database which can then be easily manipulated by VoltDB code.
Primary interaction with HSQLDB in the following ways:
- Initialize an In-Memory SQL Store
- Execute DDL Statements
- Dump Serialized Catalog as XML
- Compile SQL DML Statements to XML

            "\"w_zip\" varchar(9) default NULL, " +
            "\"w_tax\" float default NULL, " +
            "PRIMARY KEY  (\"w_id\") " +
            ");";


        HSQLInterface hsql = HSQLInterface.loadHsqldb();


        hsql.runDDLCommand(ddl1);


        String xml = hsql.getXMLFromCatalog();
        System.out.println(xml);
        assertTrue(xml != null);


        hsql.close();
    }

View Full Code Here

        String line;
        while ((line = br.readLine()) != null) {
            ddl1 += line + "\n";
        }


        HSQLInterface hsql = HSQLInterface.loadHsqldb();


        hsql.runDDLCommand(ddl1);


        String xml = hsql.getXMLFromCatalog();
        System.out.println(xml);
        assertTrue(xml != null);


        hsql.close();
    }

View Full Code Here


public abstract class CompilerUtil {


    public static AbstractPlanNode compileSQL(final Procedure catalog_proc, String name, String sql) throws Exception {
        VoltCompiler compiler = new VoltCompiler();
        HSQLInterface hsql = HSQLInterface.loadHsqldb();


        Database catalog_db = (Database) catalog_proc.getParent();
        Catalog catalog = catalog_db.getCatalog();
        Statement catalog_stmt = catalog_proc.getStatements().add(name);

View Full Code Here

     * @return
     * @throws Exception
     */
    public static Catalog compileCatalog(String schema_file) throws Exception {


        HSQLInterface hzsql = HSQLInterface.loadHsqldb();
        String xmlSchema = null;
        hzsql.runDDLFile(schema_file);
        xmlSchema = hzsql.getXMLFromCatalog(true);


        //
        // Setup fake database connection. Pass stuff to database to get catalog
        // objects
        //

View Full Code Here

        //////////////////////
        // LOAD HSQL
        //////////////////////


        log("creating HSQLInterface");
        HSQLInterface hsql = HSQLInterface.loadHsqldb();
        String hexDDL = db.getSchema();
        String ddl = Encoder.hexDecodeToString(hexDDL);
        String[] commands = ddl.split(";");
        for (String command : commands) {
            command = command.trim();
            if (command.length() == 0)
                continue;
            try {
                hsql.runDDLCommand(command);
            } catch (HSQLParseException e) {
                // need a good error message here
                log("Error creating hsql: " + e.getMessage());
                System.exit(82);
            }

View Full Code Here

TOP

Related Classes of org.hsqldb.HSQLInterface

edu.brown.utils.CompilerUtil

org.hsqldb.lib.HashMappedList

org.hsqldb.persist.HsqlProperties

org.hsqldb.result.Result

org.voltdb.compiler.PlannerTool

org.voltdb.compiler.TestDDLCompiler

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.