List of queryForLong() Examples

Examples of queryForLong()

com.j256.ormlite.support.DatabaseConnection.queryForLong()
Perform a query whose result should be a single long-integer value. @param statement SQL statement to use for the query.
org.springframework.jdbc.core.JdbcOperations.queryForLong()
Execute a query that results in a long value, given static SQL.
Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForLong method with null as argument array.
This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in a long value. @param sql SQL query to execute @return the long value, or 0 in case of SQL NULL @throws IncorrectResultSizeDataAccessException if the query does not returnexactly one row, or does not return exactly one column in that row @throws DataAccessException if there is any problem executing the query @see #queryForLong(String,Object[])
org.springframework.jdbc.core.JdbcTemplate.queryForLong()

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

      pooled.releaseConnection(conn1);
      // close it behind the pool's back, bad dog
      conn1.close();
      DatabaseConnection conn2 = pooled.getReadWriteConnection();
      assertSame(conn1, conn2);
      conn2.queryForLong(pingStatement);
    } finally {
      pooled.close();
    }
  }

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

    long delay = 100;
    pooled.setCheckConnectionsEveryMillis(delay);
    String pingStatement = pooled.getDatabaseType().getPingStatement();
    try {
      DatabaseConnection conn1 = pooled.getReadWriteConnection();
      conn1.queryForLong(pingStatement);
      pooled.releaseConnection(conn1);
      // make it test ok once
      Thread.sleep(delay * 2);
      DatabaseConnection conn2 = pooled.getReadWriteConnection();
      assertSame(conn1, conn2);

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

      pooled.releaseConnection(conn1);
      // make it test ok once
      Thread.sleep(delay * 2);
      DatabaseConnection conn2 = pooled.getReadWriteConnection();
      assertSame(conn1, conn2);
      conn2.queryForLong(pingStatement);
      pooled.releaseConnection(conn2);
      // close it behind the pool's back, bad dog
      conn2.close();
      // now it should find out that the connection is bad and pull it
      Thread.sleep(delay * 2);

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

      // now it should find out that the connection is bad and pull it
      Thread.sleep(delay * 2);
      DatabaseConnection conn3 = pooled.getReadWriteConnection();
      assertNotSame(conn2, conn3);
      // this should work
      conn3.queryForLong(pingStatement);
      pooled.releaseConnection(conn3);
    } finally {
      pooled.close();
    }
  }

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

    pooled.setCheckConnectionsEveryMillis(delay);
    pooled.setMaxConnectionAgeMillis(delay);
    String pingStatement = pooled.getDatabaseType().getPingStatement();
    try {
      DatabaseConnection conn1 = pooled.getReadWriteConnection();
      conn1.queryForLong(pingStatement);
      pooled.releaseConnection(conn1);
      // make it test ok once
      Thread.sleep(delay * 2);
      DatabaseConnection conn2 = pooled.getReadWriteConnection();
      assertNotSame(conn1, conn2);

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

      pooled.releaseConnection(conn1);
      // make it test ok once
      Thread.sleep(delay * 2);
      DatabaseConnection conn2 = pooled.getReadWriteConnection();
      assertNotSame(conn1, conn2);
      conn2.queryForLong(pingStatement);
      pooled.releaseConnection(conn2);
    } finally {
      pooled.close();
    }
  }

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

    JdbcPooledConnectionSource pooled = new JdbcPooledConnectionSource(DEFAULT_DATABASE_URL);
    String pingStatement = pooled.getDatabaseType().getPingStatement();
    pooled.setTestBeforeGet(true);
    try {
      DatabaseConnection conn1 = pooled.getReadWriteConnection();
      conn1.queryForLong(pingStatement);
      pooled.releaseConnection(conn1);
      // close it behind the pool's back, bad dog
      conn1.close();
      DatabaseConnection conn2 = pooled.getReadWriteConnection();
      assertNotSame(conn1, conn2);

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

      pooled.releaseConnection(conn1);
      // close it behind the pool's back, bad dog
      conn1.close();
      DatabaseConnection conn2 = pooled.getReadWriteConnection();
      assertNotSame(conn1, conn2);
      conn2.queryForLong(pingStatement);
      pooled.releaseConnection(conn2);
      DatabaseConnection conn3 = pooled.getReadWriteConnection();
      assertSame(conn2, conn3);
      conn3.queryForLong(pingStatement);
      pooled.releaseConnection(conn3);

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

      assertNotSame(conn1, conn2);
      conn2.queryForLong(pingStatement);
      pooled.releaseConnection(conn2);
      DatabaseConnection conn3 = pooled.getReadWriteConnection();
      assertSame(conn2, conn3);
      conn3.queryForLong(pingStatement);
      pooled.releaseConnection(conn3);
    } finally {
      pooled.close();
    }
  }

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseConnection.queryForLong()

      return;
    }
    String ping = databaseType.getPingStatement();
    DatabaseConnection conn = connectionSource.getReadOnlyConnection();
    try {
      testPingValue(conn.queryForLong(ping));
    } finally {
      connectionSource.releaseConnection(conn);
    }
  }

View Full Code Here

0 1 2 3

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.