Examples of com.j256.ormlite.jdbc.JdbcPooledConnectionSource

com.j256.ormlite.stmt.query.In
Implementation of the ConnectionSource interface that supports basic pooled connections. New connections are created on demand only if there are no dormant connections otherwise released connections will be reused. This class is reentrant and can handle requests from multiple threads.
WARNING: As of 10/2010 this is one of the newer parts of ORMLite meaning it may still have bugs. Additional review of the code and any feedback would be appreciated.

NOTE: If you are using the Spring type wiring in Java, {@link #initialize} should be called after all of theset methods. In Spring XML, init-method="initialize" should be used.

NOTE: This class spawns a thread to test the pooled connections that are in the free-list as a keep-alive mechanism. It will test any dormant connections every so often to see if they are still valid. If this is not the behavior that you want then call {@link #setCheckConnectionsEveryMillis(long)} with 0 to disable the thread. You canalso call {@link #setTestBeforeGet(boolean)} and set it to true to test the connection before it is handed back toyou.
@author graywatson

    return true;
  }


  public ID extractId(T data) throws SQLException {
    checkForInitialized();
    FieldType idField = tableInfo.getIdField();
    @SuppressWarnings("unchecked")
    ID id = (ID) idField.extractJavaFieldValue(data);
    return id;
  }

View Full Code Here

    if (connectionSource != null) {
      return;
    }
    super.before();
    if (connectionSource != null) {
      connectionSource = new JdbcPooledConnectionSource(databaseUrl, userName, password);
    }
  }

View Full Code Here

  private static final DicConnection INSTANCE = new DicConnection();


  private DicConnection() {
    try {
      // h2 embedded
      connectionSource = new JdbcPooledConnectionSource("jdbc:h2:./dictionary", "sa", "");
      connectionSource.setMaxConnectionAgeMillis(5 * 60 * 1000);
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

View Full Code Here

   * <b>NOTE:</b> I couldn't remove the code warning associated with this method when used with more than 2 arguments.
   * </p>
   */
  public Where<T, ID> and(Where<T, ID> first, Where<T, ID> second, Where<T, ID>... others) {
    Clause[] clauses = buildClauseArray(others, "AND");
    Clause secondClause = pop("AND");
    Clause firstClause = pop("AND");
    addClause(new ManyClause(firstClause, secondClause, clauses, ManyClause.AND_OPERATION));
    return this;
  }

View Full Code Here

   * <b>NOTE:</b> I can't remove the code warning associated with this method. Use the iterator method below.
   * </p>
   */
  public Where<T, ID> or(Where<T, ID> left, Where<T, ID> right, Where<T, ID>... others) {
    Clause[] clauses = buildClauseArray(others, "OR");
    Clause secondClause = pop("OR");
    Clause firstClause = pop("OR");
    addClause(new ManyClause(firstClause, secondClause, clauses, ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here

  @Override
  public String toString() {
    if (clauseStackLevel == 0) {
      return "empty where clause";
    } else {
      Clause clause = peek();
      return "where clause: " + clause;
    }
  }

View Full Code Here

  private Clause pop(String label) {
    if (clauseStackLevel == 0) {
      throw new IllegalStateException("Expecting there to be a clause already defined for '" + label
          + "' operation");
    }
    Clause clause = clauseStack[--clauseStackLevel];
    // to help gc
    clauseStack[clauseStackLevel] = null;
    return clause;
  }

View Full Code Here

   * </p>
   */
  public Where<T, ID> exists(QueryBuilder<?, ?> subQueryBuilder) throws SQLException {
    // we do this to turn off the automatic addition of the ID column in the select column list
    subQueryBuilder.enableInnerQuery();
    addClause(new Exists(new InternalQueryBuilderWrapper(subQueryBuilder)));
    return this;
  }

View Full Code Here


  /**
   * Add a IN clause so the column must be equal-to one of the objects from the list passed in.
   */
  public Where<T, ID> in(String columnName, Iterable<?> objects) throws SQLException {
    addClause(new In(columnName, findColumnFieldType(columnName), objects));
    return this;
  }

View Full Code Here

   */
  public Where<T, ID> in(String columnName, Object... objects) throws SQLException {
    if (objects.length == 1 && objects[0].getClass().isArray()) {
      throw new IllegalArgumentException("in(Object... objects) seems to be an array within an array");
    }
    addClause(new In(columnName, findColumnFieldType(columnName), objects));
    return this;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.j256.ormlite.jdbc.JdbcPooledConnectionSource

android.database.sqlite.SQLiteStatement

com.j256.ormlite.android.AndroidDatabaseConnection

com.j256.ormlite.android.apptools.OrmLiteSqliteOpenHelper

com.j256.ormlite.dao.BaseDaoImpl

com.j256.ormlite.dao.BaseDaoImplTest

com.j256.ormlite.dao.Dao.CreateOrUpdateStatus

com.j256.ormlite.dao.DaoManager

com.j256.ormlite.dao.DaoManagerTest

com.j256.ormlite.dao.DoubleDbOpenTest

com.j256.ormlite.dao.RuntimeExceptionDaoTest

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.