List of prepareInternalStatement() Examples

Examples of prepareInternalStatement()

org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()
Return a PreparedStatement object for the query. This method first tries to locate the PreparedStatement object from a statement cache. If the statement is not found in the cache, the query will be compiled and put into the cache. @param compilationSchema schema @param sqlText sql query string @param isForReadOnly read only status for resultset. Set to true if the concurrency mode for the resultset is CONCUR_READ_ONLY @param allowInternalSyntax If true, then this query is allowed to use internal sql syntax. One instance where this will be true is if a metadata query is getting executed.

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()

                // which will be the activation of the pushed statement
                // context.
                statementContext.setActivation(parentAct);


                org.apache.derby.iapi.sql.PreparedStatement ps = 
                        lcc.prepareInternalStatement(insertSQL.toString());
                Activation act = ps.getActivation(lcc, false);


                statementContext.setActivation(act);


                // in this for loop we are assigning values for parameters

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()

            // the existing statementContext, so that that activation ends up
            // as parent of the new activation 'act' created below, which will
            // be the activation of the pushed statement context.
            statementContext.setActivation(parentAct);


            org.apache.derby.iapi.sql.PreparedStatement ps = lcc.prepareInternalStatement(updateWhereCurrentOfSQL.toString());
            Activation act = ps.getActivation(lcc, false);


            statementContext.setActivation(act);


            //in this for loop we are assigning values for parameters in sql constructed earlier with columnname=?,...

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()

                // ends up as parent of the new activation 'act' created below,
                // which will be the activation of the pushed statement
                // context.
                statementContext.setActivation(parentAct);


                org.apache.derby.iapi.sql.PreparedStatement ps = lcc.prepareInternalStatement(deleteWhereCurrentOfSQL.toString());
                // Get activation, so that we can get the warning from it
                Activation act = ps.getActivation(lcc, false);


                statementContext.setActivation(act);

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()

    String maxStmt = "SELECT " + maxStr + "(\"" + columnName + "\")"  +
        "FROM \"" + td.getSchemaName() + "\".\"" + td.getName() + "\"";




    LanguageConnectionContext lcc = activation.getLanguageConnectionContext();
    PreparedStatement ps = lcc.prepareInternalStatement(maxStmt);


        // This is a substatement, for now we do not set any timeout for it
        // We might change this later by linking timeout to parent statement
    ResultSet rs = ps.execute(lcc, false, 0L);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()

    String maxStmt = "SELECT " + maxStr + "(\"" + columnName + "\")"  +
        "FROM \"" + td.getSchemaName() + "\".\"" + td.getName() + "\"";




    LanguageConnectionContext lcc = activation.getLanguageConnectionContext();
    PreparedStatement ps = lcc.prepareInternalStatement(maxStmt);


        // This is a substatement, for now we do not set any timeout for it
        // We might change this later by linking timeout to parent statement
    ResultSet rs = ps.executeSubStatement(lcc, false, 0L);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()

                        insertSQL.toString(), 
                        null, 
                        false, 
                        0L);
                org.apache.derby.iapi.sql.PreparedStatement ps = 
                        lcc.prepareInternalStatement(insertSQL.toString());
                Activation act = ps.getActivation(lcc, false);


                // in this for loop we are assigning values for parameters 
                //in sql constructed earlier VALUES (?, ..)
                for (int i=1, paramPosition=0; i<=rd.getColumnCount(); i++) {

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()

                    quoteSqlIdentifier(getCursorName()));
            lcc = getEmbedConnection().getLanguageConnection();


            // Context used for preparing, don't set any timeout (use 0)
            statementContext = lcc.pushStatementContext(isAtomic, false, updateWhereCurrentOfSQL.toString(), null, false, 0L);
            org.apache.derby.iapi.sql.PreparedStatement ps = lcc.prepareInternalStatement(updateWhereCurrentOfSQL.toString());
            Activation act = ps.getActivation(lcc, false);


            //in this for loop we are assigning values for parameters in sql constructed earlier with columnname=?,... 
            for (int i=1, paramPosition=0; i<=rd.getColumnCount(); i++) { 
                if (columnGotUpdated[i-1])  //if the column got updated, do following

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()


                lcc = getEmbedConnection().getLanguageConnection();
                
                // Context used for preparing, don't set any timeout (use 0)
                statementContext = lcc.pushStatementContext(isAtomic, false, deleteWhereCurrentOfSQL.toString(), null, false, 0L);
                org.apache.derby.iapi.sql.PreparedStatement ps = lcc.prepareInternalStatement(deleteWhereCurrentOfSQL.toString());
                // Get activation, so that we can get the warning from it
                Activation act = ps.getActivation(lcc, false);
                // Don't set any timeout when deleting rows (use 0)
                //execute delete where current of sql
                org.apache.derby.iapi.sql.ResultSet rs =

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()

    String maxStmt = "SELECT " + maxStr + "(\"" + columnName + "\")"  +
        "FROM \"" + td.getSchemaName() + "\".\"" + td.getName() + "\"";




    LanguageConnectionContext lcc = activation.getLanguageConnectionContext();
    PreparedStatement ps = lcc.prepareInternalStatement(maxStmt);


        // This is a substatement, for now we do not set any timeout for it
        // We might change this later by linking timeout to parent statement
    ResultSet rs = ps.execute(lcc, false, 0L);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.prepareInternalStatement()

    String maxStmt = "SELECT " + maxStr + "(\"" + columnName + "\")"  +
        "FROM \"" + td.getSchemaName() + "\".\"" + td.getName() + "\"";




    LanguageConnectionContext lcc = activation.getLanguageConnectionContext();
    PreparedStatement ps = lcc.prepareInternalStatement(maxStmt);


        // This is a substatement, for now we do not set any timeout for it
        // We might change this later by linking timeout to parent statement
    ResultSet rs = ps.execute(lcc, false, 0L);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();

View Full Code Here

0 1 2 3 4 5

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.