Package com.commsen.stopwatch

Examples of com.commsen.stopwatch.StopwatchStorageException

443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
   */
  public void open() throws StopwatchStorageException {
      try {
          Class.forName(getDriver());
      } catch (ClassNotFoundException e) {
          throw new StopwatchStorageException("failed to load " + getDriver() + " driver.", e);
      }
 
    try {
        if (isDebug())getLogger().debug("Connecting to database ... ");
       
        updateConnection = DriverManager.getConnection(getConnectionString(), getUser(), getPassword());
        selectConnection = DriverManager.getConnection(getConnectionString(), getUser(), getPassword());
       
        if (isDebug())getLogger().debug("connection sucsessful. Checking tables ... ");
       
    } catch (SQLException e) {
          throw new StopwatchStorageException("database connection error", e);
    }

    // check if table exists
    try {
      Statement statement =  selectConnection.createStatement();
      statement.execute(getCheckTableQuery());
      statement.close();
      if (getTruncTableQuery() != null && !"".equals(getTruncTableQuery().trim())) {
        try {
          statement =  updateConnection.createStatement();
          statement.executeUpdate(getTruncTableQuery());
          statement.close();
        } catch (SQLException e) {
          throw new StopwatchStorageException("Can not truncate table", e);
        }
      }
        if (isDebug())getLogger().debug("table(s) exists. Engine will now attempt to create prepared statements ... ");
    } catch (SQLException e) {
      try {
        Statement statement =  updateConnection.createStatement();
        statement.execute(getCreateTableQuery());
        statement.close();
          if (isDebug())getLogger().debug("table(s) created. Engine will now attempt to create prepared statements ... ");
      } catch (SQLException e1) {
        throw new StopwatchStorageException("Can not create table(s)", e1);
      }
    }
   
    try {
      insertPreparedStatement = updateConnection.prepareStatement(getInsertQuery());
      updatePreparedStatement = updateConnection.prepareStatement(getUpdateQuery());
      deletePreparedStatement = updateConnection.prepareStatement(getDeleteQuery());
      lastIdentityStatement = updateConnection.prepareStatement(getLastIdentityQuery());
     
      allReportStatement = selectConnection.prepareStatement(getAllReportQuery());
      allByGroupReportStatement = selectConnection.prepareStatement(getAllByGroupReportQuery());
      allByLabelReportStatement = selectConnection.prepareStatement(getAllByLabelReportQuery());
      groupReportStatement = selectConnection.prepareStatement(getGroupReportQuery());
      labelReportStatement = selectConnection.prepareStatement(getLabelReportQuery());
      singleReportStatement = selectConnection.prepareStatement(getSingleReportQuery());
     
      loadStatement = selectConnection.prepareStatement(getLoadQuery());
      groupLoadStatement = selectConnection.prepareStatement(getGroupLoadQuery());
      labelLoadStatement = selectConnection.prepareStatement(getLabelLoadQuery());
      groupLabelLoadStatement = selectConnection.prepareStatement(getGroupLabelLoadQuery());
     
        if (isDebug()) getLogger().debug("Prepared statements created!");
    } catch (SQLException e) {
          throw new StopwatchStorageException("can not create prepared statements", e);
    }
  }
View Full Code Here
539
540
541
542
543
544
545
546
      updateConnection = null;
      selectConnection.close();
      selectConnection = null;
        if (isDebug()) getLogger().debug("Database shut down !!!");
    } catch (SQLException e) {
          throw new StopwatchStorageException("database error", e);
    }
  }
View Full Code Here
565
566
567
568
569
570
571
572
        long result = resultSet.getLong(1);
        resultSet.close();
        return result;
      }
    } catch (SQLException e) {
          throw new StopwatchStorageException("database error", e);
    }
  }
View Full Code Here
594
595
596
597
598
599
600
601
        deletePreparedStatement.setLong(1, id);
        deletePreparedStatement.executeUpdate();
        return true;
      }
    } catch (SQLException e) {
          throw new StopwatchStorageException("database error", e);
    }
  }
View Full Code Here
613
614
615
616
617
618
619
620
621
        updatePreparedStatement.setLong(2, id);
        updatePreparedStatement.executeUpdate();
        return true;
      }
    } catch (SQLException e) {
          throw new StopwatchStorageException("database error", e);
    }

  }
View Full Code Here
98
99
100
101
102
103
104
105
106
   */
  public void close() throws StopwatchStorageException {
    try {
      updateConnection.createStatement().execute("drop table stopwatch");
    } catch (SQLException e) {
          throw new StopwatchStorageException("database error", e);
    }
    super.close();
  }
View Full Code Here
99
100
101
102
103
104
105
106
        long result = resultSet.getLong(1);
        resultSet.close();
        return result;
      }
    } catch (SQLException e) {
          throw new StopwatchStorageException("database error", e);
    }
  } 
View Full Code Here
117
118
119
120
121
122
123
124
125
        updatePreparedStatement.setLong(3, id);
        updatePreparedStatement.executeUpdate();
        return true;
      }
    } catch (SQLException e) {
          throw new StopwatchStorageException("database error", e);
    }

  } 
View Full Code Here
108
109
110
111
112
113
114
115
        resultSet.close();
        byIdCount.put(new Long(result), key);
        return result;
      }
    } catch (SQLException e) {
          throw new StopwatchStorageException("database error", e);
    }
  } 
View Full Code Here
136
137
138
139
140
141
142
143
144
        }
       
        return true;
      }
    } catch (SQLException e) {
          throw new StopwatchStorageException("database error", e);
    }

  } 
View Full Code Here
TOP

Related Classes of com.commsen.stopwatch.StopwatchStorageException

  • com.commsen.stopwatch.storages.AbstractDatabaseStorage
  • com.commsen.stopwatch.storages.DefaultHSQLInMemoryStorage
  • com.commsen.stopwatch.storages.DefaultHSQLStorage
  • com.commsen.stopwatch.storages.LoadHSQLInMemoryStorage
  • com.commsen.stopwatch.storages.LoadHSQLStorage
  • com.commsen.stopwatch.storages.MemoryHSQLInMemoryStorage
  • com.commsen.stopwatch.storages.MemoryHSQLStorage
    • Copyright © 2018 www.massapicom. 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.