List of lookupCursorActivation() Examples

Examples of lookupCursorActivation()

org.apache.derby.iapi.sql.conn.LanguageConnectionContext.lookupCursorActivation()
See if a given cursor is available for use. This is used to locate the cursor during its execution. @return the activation for the given cursor, null if none exists.

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

                 */


                boolean foundOneColumnAlready = false;
                StringBuffer insertSQL = new StringBuffer("INSERT INTO ");
                StringBuffer valuesSQL = new StringBuffer("VALUES (");
                CursorActivation activation = lcc.lookupCursorActivation(getCursorName());


                ExecCursorTableReference targetTable = 
                        activation.getPreparedStatement().getTargetTable();
                // got the underlying (schema.)table name
                insertSQL.append(getFullBaseTableName(targetTable));

View Full Code Here

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

                return; //nothing to do since no updates were made to this row


            //now construct the update where current of sql
            boolean foundOneColumnAlready = false;
            StringBuffer updateWhereCurrentOfSQL = new StringBuffer("UPDATE ");
            CursorActivation activation = lcc.lookupCursorActivation(getCursorName());




            ExecCursorTableReference targetTable = activation.getPreparedStatement().getTargetTable();
            updateWhereCurrentOfSQL.append(getFullBaseTableName(targetTable));//got the underlying (schema.)table name
            updateWhereCurrentOfSQL.append(" SET ");

View Full Code Here

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

            StatementContext statementContext = null;
            
            //now construct the delete where current of sql
            try {
                StringBuffer deleteWhereCurrentOfSQL = new StringBuffer("DELETE FROM ");
                CursorActivation activation = lcc.lookupCursorActivation(getCursorName());
                deleteWhereCurrentOfSQL.append(getFullBaseTableName(activation.getPreparedStatement().getTargetTable()));//get the underlying (schema.)table name
                //using quotes around the cursor name to preserve case sensitivity
                deleteWhereCurrentOfSQL.append(" WHERE CURRENT OF " + 
                        IdUtil.normalToDelimited(getCursorName()));

View Full Code Here

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

    if (ps == null)
      return;
      
    LanguageConnectionContext lcc = getLanguageConnectionContext();


    CursorActivation cursorActivation = lcc.lookupCursorActivation(cursorName);


    if (cursorActivation != null)
    {
      // check we are compiled against the correct cursor
      if (!psName.equals(cursorActivation.getPreparedStatement().getObjectName())) {

View Full Code Here

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


    if (cursor == null) {


      LanguageConnectionContext lcc = getLanguageConnectionContext();


      CursorActivation cursorActivation = lcc.lookupCursorActivation(cursorName);


      if (cursorActivation != null)
      {
        
        cursor = cursorActivation.getCursorResultSet();

View Full Code Here

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

    if (ps == null)
      return;
      
    LanguageConnectionContext lcc = getLanguageConnectionContext();


    CursorActivation cursorActivation = lcc.lookupCursorActivation(cursorName);


    if (cursorActivation != null)
    {
      // check we are compiled against the correct cursor
      if (!psName.equals(cursorActivation.getPreparedStatement().getObjectName())) {

View Full Code Here

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


    if (cursor == null) {


      LanguageConnectionContext lcc = getLanguageConnectionContext();


      CursorActivation cursorActivation = lcc.lookupCursorActivation(cursorName);


      if (cursorActivation != null)
      {
        
        cursor = cursorActivation.getCursorResultSet();

View Full Code Here

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

                 */


                boolean foundOneColumnAlready = false;
                StringBuffer insertSQL = new StringBuffer("INSERT INTO ");
                StringBuffer valuesSQL = new StringBuffer("VALUES (");
                CursorActivation activation = lcc.lookupCursorActivation(getCursorName());


                ExecCursorTableReference targetTable = 
                        activation.getPreparedStatement().getTargetTable();
                // got the underlying (schema.)table name
                insertSQL.append(getFullBaseTableName(targetTable));

View Full Code Here

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

                return; //nothing to do since no updates were made to this row


            //now construct the update where current of sql
            boolean foundOneColumnAlready = false;
            StringBuffer updateWhereCurrentOfSQL = new StringBuffer("UPDATE ");
            CursorActivation activation = lcc.lookupCursorActivation(getCursorName());




            ExecCursorTableReference targetTable = activation.getPreparedStatement().getTargetTable();
            updateWhereCurrentOfSQL.append(getFullBaseTableName(targetTable));//got the underlying (schema.)table name
            updateWhereCurrentOfSQL.append(" SET ");

View Full Code Here

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

            StatementContext statementContext = null;
            
            //now construct the delete where current of sql
            try {
                StringBuffer deleteWhereCurrentOfSQL = new StringBuffer("DELETE FROM ");
                CursorActivation activation = lcc.lookupCursorActivation(getCursorName());
                deleteWhereCurrentOfSQL.append(getFullBaseTableName(activation.getPreparedStatement().getTargetTable()));//get the underlying (schema.)table name
                //using quotes around the cursor name to preserve case sensitivity
                deleteWhereCurrentOfSQL.append(" WHERE CURRENT OF " + 
                        IdUtil.normalToDelimited(getCursorName()));

View Full Code Here

0 1 2 3 4

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.