Package org.tmatesoft.sqljet.core.table

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

224
225
226
227
228
229
230
231
232
233
234
        }

        System.out.println();
        System.out.println(">After insertion of a new record and updating dates (by PK):");
        System.out.println();
        db.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        try {
            printRecords(table.order(table.getPrimaryKeyIndexName()));
            System.out.println();
            System.out.println(">Same in order defined by " + FULL_NAME_INDEX + " :");
            System.out.println();
View Full Code Here
238
239
240
241
242
243
244
245
246
247
248
        }
      
        System.out.println();
        System.out.println(">Dropping tables and indices:");
        System.out.println();
        db.beginTransaction(SqlJetTransactionMode.WRITE);
        try {
            Set<String> tables = db.getSchema().getTableNames();
            for (String tableName : tables) {
                ISqlJetTableDef tableDef = db.getSchema().getTable(tableName);
                Set<ISqlJetIndexDef> tableIndices = db.getSchema().getIndexes(tableDef.getName());
View Full Code Here
19
20
21
22
23
24
25
26
27
28
29
        public Object run(SqlJetDb db) throws SqlJetException {
          db.getOptions().setUserVersion(1);
          return true;
        }
      }, SqlJetTransactionMode.WRITE);
      db.beginTransaction(SqlJetTransactionMode.WRITE);
      String sql1 = "CREATE TABLE IF NOT EXISTS TESTXX (a int, b int, c int, "
          + "d int, blob blob, PRIMARY KEY (a,b,c,d))";
      String sql2 = "CREATE INDEX IF NOT EXISTS IND on TESTXX (a,b,c,d)";
      db.createTable(sql1);
      db.createIndex(sql2);
View Full Code Here
19
20
21
22
23
24
25
26
27
28
29
      connect2.beginTransaction(SqlJetTransactionMode.WRITE);
      connect2.getTable("t").insert("t");
      try {
        connect2.commit();
      } catch (SqlJetException e) {
        connect3.beginTransaction(SqlJetTransactionMode.READ_ONLY);
      } finally {
        try {
          connect1.rollback();
          connect2.rollback();
          connect3.rollback();
View Full Code Here
590
591
592
593
594
595
596
597
598
599
600
   
    lock.lock();
   
    try
    {
      database.beginTransaction(SqlJetTransactionMode.WRITE);
     
      try
      {
        transaction.execute(database);
       
View Full Code Here
629
630
631
632
633
634
635
636
637
638
639
   
    lock.lock();
   
    try
    {
      database.beginTransaction(SqlJetTransactionMode.READ_ONLY);
     
      try
      {
        return query.execute(database);
      }
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
     
      addColumnToTable(podsalinanDB,"podcasts","auto_queue","INTEGER");
     
      try {
        table = podsalinanDB.getTable("downloads");
        podsalinanDB.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        if (table!=null){
          ISqlJetCursor currentDBLine = table.order(table.getPrimaryKeyIndexName());
          if (!currentDBLine.eof()){
            do {
              URLDownload newDownload = new URLDownload(currentDBLine.getString("url"),
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
        }
      }
       
      try {
        table = podsalinanDB.getTable("settings");
        podsalinanDB.beginTransaction(SqlJetTransactionMode.READ_ONLY);
       
        if (table!=null){
          ISqlJetCursor currentDBLine = table.order(table.getPrimaryKeyIndexName());
          if (!currentDBLine.eof()){
            do {
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
        }
      }

      try {
        table = podsalinanDB.getTable("podcasts");
        podsalinanDB.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        if (table!=null){
          ISqlJetCursor currentDBLine = table.order(table.getPrimaryKeyIndexName());
          if (!currentDBLine.eof()){
            do {
              Podcast newPodcast = new Podcast(currentDBLine.getString("name"),
View Full Code Here
307
308
309
310
311
312
313
314
315
316
317
               ProgSettings settings) {
   
    File podsalinanDBFile = new File(settingsDir.concat("/podsalinan.db"));
    boolean dataFileExists = podsalinanDBFile.exists();
    SqlJetDb db = new SqlJetDb(podsalinanDBFile,true);
    db.beginTransaction(SqlJetTransactionMode.WRITE);
    if (!dataFileExists){
      try {
        db.createTable(CREATE_DOWNLOADS);
      } catch (SqlJetException e) {
        debugOutput.printStackTrace(e.getStackTrace());
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.