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

            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

        }
    }


    long[] writeTableToDataFile(Table table) throws IOException {


        Session session = database.getSessionManager().getSysSession();
        PersistentStore    store      = table.getRowStore(session);
        RowOutputInterface rowOut     = dataCache.rowOut.duplicate();
        long[]             rootsArray = table.getIndexRootsArray();
        long               pos        = fileOffset;
        long               count      = 0;

View Full Code Here

        return rootsList;
    }


    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

            } else {
                scr = new ScriptReaderDecode(database, scriptFileName, crypto,
                                             false);
            }


            Session session =
                database.sessionManager.getSysSessionForScript(database);


            scr.readAll(session);
            scr.close();
        } catch (Throwable e) {

View Full Code Here

                inStream = new DataInputStream(request.getInputStream());


                int  databaseID = inStream.readInt();
                long sessionID  = inStream.readLong();
                int  mode       = inStream.readByte();
                Session session = DatabaseManager.getSession(databaseID,
                    sessionID);
                Result resultIn = Result.newResult(session, mode, inStream,
                                                   rowIn);


                resultIn.setDatabaseId(databaseID);
                resultIn.setSessionId(sessionID);


                Result resultOut;


                if (resultIn.getType() == ResultConstants.CONNECT) {
                    try {
                        session = DatabaseManager.newSession(
                            dbType, dbPath, resultIn.getMainString(),
                            resultIn.getSubString(), new HsqlProperties(),
                            resultIn.getZoneString(),
                            resultIn.getUpdateCount());


                        resultIn.readAdditionalResults(null, inStream, rowIn);


                        resultOut = Result.newConnectionAcknowledgeResponse(
                            session.getDatabase(), session.getId(),
                            session.getDatabase().getDatabaseID());
                    } catch (HsqlException e) {
                        resultOut = Result.newErrorResult(e);
                    }
                } else {
                    int  dbId      = resultIn.getDatabaseId();
                    long sessionId = resultIn.getSessionId();


                    session = DatabaseManager.getSession(dbId, sessionId);


                    resultIn.readLobResults(session, inStream, rowIn);


                    resultOut = session.execute(resultIn);
                }


                //
                response.setContentType("application/octet-stream");
                response.setContentLength(rowOut.size());

View Full Code Here

     */
    DatabaseInformationMain(Database db) {


        super(db);


        Session session = db.sessionManager.getSysSession();


        init(session);
    }

View Full Code Here

    }


    int[] writeTableToDataFile(Table table)
    throws IOException, HsqlException {


        Session session        = database.getSessionManager().getSysSession();
        RowOutputBinary rowOut = new RowOutputBinary();
        DoubleIntIndex pointerLookup =
            new DoubleIntIndex(table.getPrimaryIndex().sizeEstimate(), false);
        int[] rootsArray = table.getIndexRootsArray();
        long  pos        = fileOffset;

View Full Code Here

        database.txManager.convertTransactionIDs(transactionRowLookup);
    }


    int[] writeTableToDataFile(Table table) throws IOException {


        Session session = database.getSessionManager().getSysSession();
        PersistentStore    store      = table.getRowStore(session);
        RowOutputInterface rowOut     = cache.rowOut.duplicate();
        int[]              rootsArray = table.getIndexRootsArray();
        long               pos        = fileOffset;
        int                count      = 0;

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.