Examples of com.j256.ormlite.jdbc.JdbcPooledConnectionSource

com.j256.ormlite.stmt.query.Not
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

      throw new SQLException("Inner query must have only 1 select column specified instead of "
          + subQueryBuilder.getSelectColumnCount());
    }
    // we do this to turn off the automatic addition of the ID column in the select column list
    subQueryBuilder.enableInnerQuery();
    addClause(new InSubQuery(columnName, findColumnFieldType(columnName), new InternalQueryBuilderWrapper(
        subQueryBuilder)));
    return this;
  }

View Full Code Here


  /**
   * Add a 'IS NOT NULL' clause so the column must not be null. '<>' NULL does not work.
   */
  public Where<T, ID> isNotNull(String columnName) throws SQLException {
    addClause(new IsNotNull(columnName, findColumnFieldType(columnName)));
    return this;
  }

View Full Code Here


  /**
   * Add a 'IS NULL' clause so the column must be null. '=' NULL does not work.
   */
  public Where<T, ID> isNull(String columnName) throws SQLException {
    addClause(new IsNull(columnName, findColumnFieldType(columnName)));
    return this;
  }

View Full Code Here


  /**
   * AND operation which takes the previous clause and the next clause and AND's them together.
   */
  public Where<T, ID> and() {
    addNeedsFuture(new ManyClause(pop("AND"), ManyClause.AND_OPERATION));
    return this;
  }

View Full Code Here

   */
  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

    }
    Clause[] clauses = new Clause[numClauses];
    for (int i = numClauses - 1; i >= 0; i--) {
      clauses[i] = pop("AND");
    }
    addClause(new ManyClause(clauses, ManyClause.AND_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * OR operation which takes the previous clause and the next clause and OR's them together.
   */
  public Where<T, ID> or() {
    addNeedsFuture(new ManyClause(pop("OR"), ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here

   */
  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

    }
    Clause[] clauses = new Clause[numClauses];
    for (int i = numClauses - 1; i >= 0; i--) {
      clauses[i] = pop("OR");
    }
    addClause(new ManyClause(clauses, ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Used to NOT the next clause specified.
   */
  public Where<T, ID> not() {
    addNeedsFuture(new Not());
    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.