List of prepareStatement() Examples

Examples of prepareStatement()

com.alibaba.druid.pool.DruidPooledConnection.prepareStatement()
com.cloud.utils.db.Transaction.prepareStatement()
com.cloud.utils.db.TransactionLegacy.prepareStatement()
com.fathomdb.jdbc.JdbcConnection.prepareStatement()
com.knowgate.jdc.JDCConnection.prepareStatement()
com.mysql.jdbc.Connection.prepareStatement()
A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.
Note: This method is optimized for handling parametric SQL statements that benefit from precompilation if the driver supports precompilation. In this case, the statement is not sent to the database until the PreparedStatement is executed. This has no direct effect on users; however it does affect which method throws certain java.sql.SQLExceptions

MySQL does not support precompilation of statements, so they are handled by the driver.
@param sql a SQL statement that may contain one or more '?' IN parameter placeholders @return a new PreparedStatement object containing the pre-compiledstatement. @exception SQLException if a database access error occurs.
com.salesforce.phoenix.jdbc.PhoenixConnection.prepareStatement()
com.sun.star.sdbc.XConnection.prepareStatement()
connectivity.tools.sdb.Connection.prepareStatement()
de.kilobyte22.app.kibibyte.Database.prepareStatement()
fi.luomus.commons.db.connectivity.PreparedStatementStoringAndClosingTransactionConnection.prepareStatement()
fi.luomus.commons.db.connectivity.TransactionConnection.prepareStatement()
java.sql.Connection.prepareStatement()
A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.
Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, prepareStatement will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until the PreparedStatement is executed. This has no direct affect on users; however, it does affect which method throws certain SQLExceptions. @param sql a SQL statement that may contain one or more '?' INparameter placeholders @return a new PreparedStatement object containing thepre-compiled statement @exception SQLException if a database-access error occurs.
l2p.database.ThreadConnection.prepareStatement()
liquibase.database.jvm.JdbcConnection.prepareStatement()
marauroa.server.db.DBTransaction.prepareStatement()
Prepares a statement for a batch operation. @param query SQL statement @param params parameter values @return PreparedStatement @throws SQLException in case of an database error
net.sourceforge.squirrel_sql.fw.sql.ISQLConnection.prepareStatement()
org.apache.derby.iapi.jdbc.EngineConnection.prepareStatement()
Prepare a statement with holdability. Identical to JDBC 3.0 method, to allow holdabilty to be supported in JDK 1.3 by the network server, e.g. when the client is jdk 1.4 or above. Can be removed once JDK 1.3 is no longer supported.
org.apache.hadoop.hbase.hbql.client.HConnection.prepareStatement()
org.apache.jena.jdbc.connections.JenaConnection.prepareStatement()
org.apache.olio.workload.loader.framework.ThreadConnection.prepareStatement()
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement()
Create and populate the parameters of a prepared statement using the SQL in this buffer.
org.apache.phoenix.jdbc.PhoenixConnection.prepareStatement()
org.conserve.connection.ConnectionWrapper.prepareStatement()
@param statement @return a new PreparedStatement, ready to fill in values and execute. @throws SQLException
org.exoplatform.services.jcr.impl.checker.InspectionQuery.prepareStatement()
Creates a PreparedStatement object for sending parameterized SQL statements to the database. @param connection connection to workspace storage @return a new default PreparedStatement object containing the pre-compiled SQL statement @throws SQLException if a database access error occurs or this method is called on a closed connection
org.jboss.soa.esb.helpers.persist.JdbcCleanConn.prepareStatement()
org.mule.module.db.internal.domain.connection.DbConnection.prepareStatement()
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement()
Prepare a statement. In case no connection has been given, allocate a new one. @param sql The SQL statement to be executed @throws GenericDataSourceException @throws GenericEntityException
org.opensolaris.opengrok.jdbc.ConnectionResource.prepareStatement()
Prepare a statement. This method should only be used to prepare statements that are used infrequently. If a statement is likely to be used frequently, a {@code StatementCreator} object should becreated for it, and the method {@link #getStatement(StatementCreator)}should be used instead. @param sql the SQL text to compile @return a prepared statement @throws SQLException if a database error occurs
se.rupy.pool.Connection.prepareStatement()

Examples of org.apache.olio.workload.loader.framework.ThreadConnection.prepareStatement()

    }
    
     public void load() {
        ThreadConnection c = ThreadConnection.getInstance();
        try {
            PreparedStatement s = c.prepareStatement(STATEMENT);
            for (int i = 0; i < fields.length; i++)
                if (fields[i] != null)
                    s.setString(i + 1, fields[i]);
                else
                    s.setNull(i + 1, Types.VARCHAR);

View Full Code Here

Examples of org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement()


        Connection conn = store.getConnection();
        PreparedStatement stmnt = null;
        ResultSet rs = null;
        try {
            stmnt = sql.prepareStatement(conn,
                ResultSet.TYPE_SCROLL_INSENSITIVE,
                ResultSet.CONCUR_UPDATABLE);
            rs = stmnt.executeQuery();
            rs.next();

View Full Code Here

Examples of org.apache.phoenix.jdbc.PhoenixConnection.prepareStatement()

        mutations.add(put);
        hTable.batch(mutations);
    
        // Demonstrates weakness of HBase Bytes serialization. Negative numbers
        // show up as bigger than positive numbers
        PreparedStatement statement = conn.prepareStatement(query);
        ResultSet rs = statement.executeQuery();
        assertTrue(rs.next());
        assertEquals("e", rs.getString(1));
        assertFalse(rs.next());
    }

View Full Code Here

Examples of org.conserve.connection.ConnectionWrapper.prepareStatement()


    PersistenceManager persist = new PersistenceManager(driver, database,
        login, password);
    ConnectionWrapper cw = persist.getConnectionWrapper();
    
    PreparedStatement stmt = cw.prepareStatement("SELECT COUNT(*) FROM C__ARRAY");
    ResultSet rs = stmt.executeQuery();
    if(rs.next())
    {
      System.out.println("Found " + rs.getInt(1) + " objects.");
    }

View Full Code Here

Examples of org.exoplatform.services.jcr.impl.checker.InspectionQuery.prepareStatement()

      Connection jdbcConnection = openConnection();
      try
      {
         InspectionQuery query = getSelectQuery();


         preparedStatement = query.prepareStatement(jdbcConnection);
         resultSet = preparedStatement.executeQuery();


         while (resultSet.next())
         {
            String idColumn = query.getFieldNames()[0];

View Full Code Here

Examples of org.jboss.soa.esb.helpers.persist.JdbcCleanConn.prepareStatement()

    JdbcCleanConn oConn = null;
    PreparedStatement ps = null;
    try
    {
      oConn = createJdbcCleanConnection();
      ps = oConn.prepareStatement(getInsertStmt());
      oConn.execUpdWait(ps, 3); // TODO the executeUpdate routine doesn't check return code, which could mask a problem https://jira.jboss.org/jira/browse/SOA-642                  
      // TODO the executeUpdate routine doesn't check return code, which could mask a problem https://jira.jboss.org/jira/browse/SOA-642
      oConn.commit();
    } 
    catch( SQLException e)

View Full Code Here

Examples of org.mule.module.db.internal.domain.connection.DbConnection.prepareStatement()

            }


            PreparedStatement preparedStatement;
            try
            {
                preparedStatement = connection.prepareStatement(query.getQueryTemplate().getSqlText());
            }
            catch (SQLException e)
            {
                return new DefaultResult<MetaData>(null, Result.Status.FAILURE, e.getMessage(), FailureType.INVALID_CONFIGURATION, e);
            }

View Full Code Here

Examples of org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement()

        sqlBuffer.append(SqlJdbcUtil.makeWhereClause(modelEntity, modelEntity.getPkFieldsUnmodifiable(), entity, "AND", datasourceInfo.joinStyle));


        SQLProcessor sqlP = new SQLProcessor(helperInfo);


        try {
            sqlP.prepareStatement(sqlBuffer.toString(), true, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            SqlJdbcUtil.setPkValues(sqlP, modelEntity, entity, modelFieldTypeReader);
            sqlP.executeQuery();


            if (sqlP.next()) {
                for (int j = 0; j < partialFields.size(); j++) {

View Full Code Here

Examples of org.opensolaris.opengrok.jdbc.ConnectionResource.prepareStatement()

    private void clearHistoryForRepository(Repository repository)
            throws SQLException {
        final ConnectionResource conn =
                connectionManager.getConnectionResource();
        try {
            try (PreparedStatement ps = conn.prepareStatement(
                         getQuery("clearRepository"))) {
                ps.setInt(1, getRepositoryId(conn, repository));
                ps.execute();
                conn.commit();
            }

View Full Code Here

Examples of se.rupy.pool.Connection.prepareStatement()

      if(Sprout.SQL.driver().equals("org.postgresql.Driver") || 
          Sprout.SQL.driver().equals("oracle.jdbc.OracleDriver")) {
        sql = "SELECT count(*) AS count FROM poll_table WHERE poll_type = " + type;
      }
      
      stmt = conn.prepareStatement(sql);
      result = stmt.executeQuery();
      if(result.next()) {
        return result.getLong("count");
      }
    } catch(SQLException e) {

View Full Code Here

0 1 2 3 4 5 6 7

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.