Examples of org.tmatesoft.sqljet.core.table.SqlJetDb.commit()

Class org.tmatesoft.sqljet.core.table.SqlJetDb

Examples of org.tmatesoft.sqljet.core.table.SqlJetDb.commit()

org.tmatesoft.sqljet.core.table.SqlJetDb.commit()
Commit transaction. @throws SqlJetException

            
            db.createTable(createTableQuery);
            db.createIndex(createFirstNameIndexQuery);
            db.createIndex(createDateIndexQuery);
        } finally {
            db.commit();
        }
        // close DB and open it again (as part of example code)
        
        db.close();        
        db = SqlJetDb.open(dbFile, true);

View Full Code Here

            calendar.set(1979, 8, 19);
            table.insert("Stadnik", "Dmitry", calendar.getTimeInMillis());
            calendar.set(1977, 9, 19);
            table.insert("Kitaev", "Alexander", calendar.getTimeInMillis());
        } finally {
            db.commit();
        }


        ISqlJetTable table = db.getTable(TABLE_NAME);


        // getting all rows in table, sorted by PK.

View Full Code Here

        System.out.println();
        db.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        try {
            printRecords(table.order(table.getPrimaryKeyIndexName()));
        } finally {
            db.commit();
        }


        // getting all rows in table, sorted by PK.        
        System.out.println();
        System.out.println(">All employees in order defined by " + DOB_INDEX + ", reversed:");

View Full Code Here

        System.out.println();
        db.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        try {
            printRecords(table.order(table.getPrimaryKeyIndexName()).reverse());
        } finally {
            db.commit();
        }
        
        // getting all rows in table, sorted by index.        
        System.out.println();
        System.out.println(">All employees in order defined by " + FULL_NAME_INDEX + " :");

View Full Code Here


        db.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        try {
            printRecords(table.order(FULL_NAME_INDEX));
        } finally {
            db.commit();
        }


        // getting rows in table with exact indexed field value.
        System.out.println();
        System.out.println(">Alexanders:");

View Full Code Here

        System.out.println();
        db.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        try {
            printRecords(table.lookup(FULL_NAME_INDEX, "Alexander"));
        } finally {
            db.commit();
        }
        
        // getting rows in table with indexed field value in certain scope.        
        System.out.println();
        System.out.println(">Employees with full name in scope [B, I]:");

View Full Code Here

        System.out.println();
        db.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        try {
            printRecords(table.scope(FULL_NAME_INDEX, new Object[] {"B"}, new Object[] {"I"}));
        } finally {
            db.commit();
        }


        Calendar calendar = Calendar.getInstance();
        calendar.setTime(new Date(System.currentTimeMillis()));
        calendar.add(Calendar.YEAR, -30);

View Full Code Here

                        formatDate(deleteCursor.getInteger(DOB_FIELD)));
                deleteCursor.delete();
            }
            deleteCursor.close();
        } finally {
            db.commit();
        }


        System.out.println();
        System.out.println(">After deletion in row id order:");
        System.out.println();

View Full Code Here

        System.out.println();
        db.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        try {
            printRecords(table.open());
        } finally {
            db.commit();
        }


        db.beginTransaction(SqlJetTransactionMode.WRITE);
        ISqlJetCursor updateCursor = null;
        try {

View Full Code Here

            do {
                updateCursor.update(updateCursor.getValue(SECOND_NAME_FIELD), updateCursor.getValue(FIRST_NAME_FIELD), calendar.getTimeInMillis());
            } while(updateCursor.next());
        } finally {
            updateCursor.close();
            db.commit();
        }


        System.out.println();
        System.out.println(">After insertion of a new record and updating dates (by PK):");
        System.out.println();

View Full Code Here

0 1 2

TOP

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.