Examples of org.hsqldb.Session

org.hsqldb.Session
Implementation of SQL sessions. @author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.7.0

        }
    }


    static boolean checkAllTables(Database database) {


        Session       session   = database.getSessionManager().getSysSession();
        HsqlArrayList allTables = database.schemaManager.getAllTables(true);


        for (int i = 0, tSize = allTables.size(); i < tSize; i++) {
            Table t     = (Table) allTables.get(i);
            int   count = 0;

View Full Code Here

            t.createPrimaryKeyConstraint(name, new int[]{ 0 }, false);


            return t;
        }


        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        String sql = (String) statementMap.get("/*sql_packages*/");
        Result rs  = sys.executeDirectStatement(sql);


        t.insertSys(session, store, rs);


        return t;
    }

View Full Code Here

            t.createPrimaryKeyConstraint(name, new int[]{ 0 }, false);


            return t;
        }


        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        String sql = (String) statementMap.get("/*sql_parts*/");
        Result rs  = sys.executeDirectStatement(sql);


        t.insertSys(session, store, rs);


        return t;
    }

View Full Code Here

            t.createPrimaryKeyConstraint(name, new int[]{ 0 }, false);


            return t;
        }


        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        String sql = (String) statementMap.get("/*sql_sizing*/");
        Result rs  = sys.executeDirectStatement(sql);


        t.insertSys(session, store, rs);


        return t;
    }

View Full Code Here

            t.createPrimaryKeyConstraint(name, new int[]{ 0 }, false);


            return t;
        }


        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());


        /*
                Result rs = sys.executeDirectStatement(
                    "VALUES "

View Full Code Here

        final int it_latch_count = 13;


        //
        // intermediate holders
        Session[] sessions;
        Session   s;
        Object[]  row;


        // Initialisation
        sessions = database.sessionManager.getVisibleSessions(session);


        // Do it.
        for (int i = 0; i < sessions.length; i++) {
            if (sessions[i].isClosed()) {
                continue;
            }


            s              = sessions[i];
            row            = t.getEmptyRowData();
            row[isid]      = ValuePool.getLong(s.getId());
            row[ict]       = new TimestampData(s.getConnectTime() / 1000);
            row[iuname]    = s.getUsername();
            row[iis_admin] = ValuePool.getBoolean(s.isAdmin());
            row[iautocmt]  = s.sessionContext.isAutoCommit;
            row[ireadonly] = s.isReadOnlyDefault;


            Number lastId = s.getLastIdentity();


            if (lastId != null) {
                row[ilast_id] = ValuePool.getLong(lastId.longValue());
            }


            row[it_tx]   = Boolean.valueOf(s.isInMidTransaction());
            row[it_size] = ValuePool.getLong(s.getTransactionSize());


            HsqlName name = s.getCurrentSchemaHsqlName();


            if (name != null) {
                row[it_schema] = name.name;
            }

View Full Code Here


            return t;
        }


        //
        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        Result rs = sys.executeDirectStatement(
            "select DISTINCT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, "
            + "CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME "
            + "from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE");


        t.insertSys(session, store, rs);
        sys.close();


        return t;
    }

View Full Code Here


            return t;
        }


        //
        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        String sql = (String) statementMap.get("/*data_type_privileges*/");
        Result rs  = sys.executeDirectStatement(sql);


        t.insertSys(session, store, rs);
        sys.close();


        return t;
    }

View Full Code Here

            }, false);


            return t;
        }


        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        Result rs = sys.executeDirectStatement(
            "SELECT GRANTOR, GRANTEE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, PRIVILEGE_TYPE, IS_GRANTABLE "
            + "FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES "
            + "JOIN INFORMATION_SCHEMA.APPLICABLE_ROLES ON GRANTEE = ROLE_NAME;");


        t.insertSys(session, store, rs);
        sys.close();


        return t;
    }

View Full Code Here

            }, false);


            return t;
        }


        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        Result rs = sys.executeDirectStatement(
            "SELECT GRANTOR, GRANTEE, SPECIFIC_CATALOG, SPECIFIC_SCHEMA, "
            + "SPECIFIC_NAME, ROUTINE_CATALOG, ROUTINE_SCHEMA, ROUTINE_NAME, "
            + "PRIVILEGE_TYPE, IS_GRANTABLE "
            + "FROM INFORMATION_SCHEMA.ROUTINE_PRIVILEGES "
            + "JOIN INFORMATION_SCHEMA.APPLICABLE_ROLES ON GRANTEE = ROLE_NAME;");


        t.insertSys(session, store, rs);
        sys.close();


        // Column number mappings
        final int grantor          = 0;
        final int grantee          = 1;
        final int table_name       = 2;

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.Session

org.hsqldb.dbinfo.DatabaseInformationFull

org.hsqldb.dbinfo.DatabaseInformationMain

org.hsqldb.HsqlNameManager.HsqlName

org.hsqldb.jdbc.jdbcConnection

org.hsqldb.jdbc.JDBCConnection

org.hsqldb.lib.HashMap

org.hsqldb.lib.HashMappedList

org.hsqldb.lib.HsqlArrayList

org.hsqldb.lib.HsqlDeque

org.hsqldb.lib.IntKeyHashMap

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.