Examples of java.sql.PreparedStatement.clearParameters()

java.sql.PreparedStatement.clearParameters()
Clear the current parameter values.
Typically, parameter values are retained for multiple executions of the Statement. Setting a parameter value replaces the previous value. This method clears the values for all parameters, releasing all resources used by those parameters. @throws SQLException if a database error happens

    }


    void closePoolableStatement(PoolablePreparedStatement stmt) throws SQLException {
        PreparedStatement rawStatement = stmt.getRawPreparedStatement();


        rawStatement.clearParameters();


        if (holder.isPoolPreparedStatements()) {
            this.holder.getStatementPool().put(stmt);
            stmt.clearResultSet();
            holder.removeTrace(stmt);

View Full Code Here

      } else {
        pstmt = conn.prepareStatement(getQuery());
      }
      preparedStatementMap.put(getQuery(), pstmt);
    }
    pstmt.clearParameters();
    return pstmt;
  }


  private static void closeAllStatements(Collection collection) {
    Iterator iterator = collection.iterator();

View Full Code Here

                entryUpdate.setBoolean(3, false);
                entryUpdate.setString( 4, websiteid);
                entryUpdate.executeUpdate();                               
                
                // add  permission for user in website
                permsInsert.clearParameters();
                permsInsert.setString( 1, websiteid+"p");
                permsInsert.setString( 2, websiteid);
                permsInsert.setString( 3, userid);
                permsInsert.setShort(  4, PermissionsData.ADMIN);
                permsInsert.setBoolean(5, false);

View Full Code Here

                    // set the new default page id
                    defaultpageid = websiteid+"q";
                }
                
                // update defaultpageid value
                updateDefaultPage.clearParameters();
                updateDefaultPage.setString( 1, defaultpageid);
                updateDefaultPage.setString( 2, websiteid);
                updateDefaultPage.executeUpdate();
            }

View Full Code Here

            } else {
                pstmt = conn.prepareStatement(getQuery());
            }
            preparedStatementMap.put(getQuery(), pstmt);
        }
        pstmt.clearParameters();
        return pstmt;
    }


    private static void closeAllStatements(Collection<PreparedStatement> collection) {
        for (PreparedStatement pstmt : collection) {

View Full Code Here

    try {
      pStmt = this.conn
          .prepareStatement("INSERT INTO testBug17857 VALUES (?)");
      pStmt.close();
      try {
        pStmt.clearParameters();
      } catch (SQLException sqlEx) {
        assertEquals("08003", sqlEx.getSQLState());
      }


      pStmt = ((com.mysql.jdbc.Connection) this.conn)

View Full Code Here


      pStmt = ((com.mysql.jdbc.Connection) this.conn)
          .clientPrepareStatement("INSERT INTO testBug17857 VALUES (?)");
      pStmt.close();
      try {
        pStmt.clearParameters();
      } catch (SQLException sqlEx) {
        assertEquals("08003", sqlEx.getSQLState());
      }


    } finally {

View Full Code Here

            } else {
                pstmt = conn.prepareStatement(getQuery());
            }
            preparedStatementMap.put(getQuery(), pstmt);
        }
        pstmt.clearParameters();
        return pstmt;
    }


    private static void closeAllStatements(Collection<PreparedStatement> collection) {
        for (PreparedStatement pstmt : collection) {

View Full Code Here

    
    try {
      pStmt = this.conn.prepareStatement("INSERT INTO testBug17857 VALUES (?)");
      pStmt.close();
      try {
        pStmt.clearParameters();
      } catch (SQLException sqlEx) {
        assertEquals("08003", sqlEx.getSQLState());
      }
      
      pStmt = ((com.mysql.jdbc.Connection)this.conn).clientPrepareStatement("INSERT INTO testBug17857 VALUES (?)");

View Full Code Here

      }
      
      pStmt = ((com.mysql.jdbc.Connection)this.conn).clientPrepareStatement("INSERT INTO testBug17857 VALUES (?)");
      pStmt.close();
      try {
        pStmt.clearParameters();
      } catch (SQLException sqlEx) {
        assertEquals("08003", sqlEx.getSQLState());
      }
      
    } finally {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.