Examples of CursorActivation

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

3599
3600
3601
3602
3603
3604
3605
3606
3607
3608
3609
3610
3611
3612
                 */

                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));
                ResultDescription rd = theResults.getResultDescription();

                insertSQL.append(" (");
View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

3713
3714
3715
3716
3717
3718
3719
3720
3721
3722
3723
3724
3725
3726
                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 ");
            ResultDescription rd = theResults.getResultDescription();

            for (int i=1; i<=rd.getColumnCount(); i++) { //in this for loop we are constructing columnname=?,... part of the update sql
View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

3813
3814
3815
3816
3817
3818
3819
3820
3821
3822
3823
3824
            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()));

                StatementContext currSC = lcc.getStatementContext();
View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
    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())) {

        // our prepared statement is now invalid since there
        // exists another cursor with the same name but a different
        // statement.
        ps.makeInvalid(DependencyManager.CHANGED_CURSOR, lcc);
View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
    if (cursor == null) {

      LanguageConnectionContext lcc = getLanguageConnectionContext();

      CursorActivation cursorActivation = lcc.lookupCursorActivation(cursorName);

      if (cursorActivation != null)
      {
       
        cursor = cursorActivation.getCursorResultSet();
        target = cursorActivation.getTargetResultSet();
        /* beetle 3865: updateable cursor using index. 2 way communication between
         * update activation and cursor activation. Cursor passes index scan to
         * update and update passes heap conglom controller to cursor.
         */
        activation.setForUpdateIndexScan(cursorActivation.getForUpdateIndexScan());
        if (cursorActivation.getHeapConglomerateController() != null)
          cursorActivation.getHeapConglomerateController().close();
        cursorActivation.setHeapConglomerateController(activation.getHeapConglomerateController());       
      }
    }

    if (cursor == null || cursor.isClosed()) {
      throw StandardException.newException(SQLState.LANG_CURSOR_NOT_FOUND, cursorName); 
View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
    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())) {

        // our prepared statement is now invalid since there
        // exists another cursor with the same name but a different
        // statement.
        ps.makeInvalid(DependencyManager.CHANGED_CURSOR, lcc);
View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

3615
3616
3617
3618
3619
3620
3621
3622
3623
3624
3625
3626
3627
3628
3629
                 */

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

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

                insertSQL.append(" (");
View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

3715
3716
3717
3718
3719
3720
3721
3722
3723
3724
3725
3726
3727
3728
                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 = getEmbedConnection().getLanguageConnection().lookupCursorActivation(getCursorName());


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

            for (int i=1; i<=rd.getColumnCount(); i++) { //in this for loop we are constructing columnname=?,... part of the update sql
View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

3799
3800
3801
3802
3803
3804
3805
3806
3807
3808
3809
3810
            StatementContext statementContext = null;
           
            //now construct the delete where current of sql
            try {
                StringBuffer deleteWhereCurrentOfSQL = new StringBuffer("DELETE FROM ");
                CursorActivation activation = getEmbedConnection().getLanguageConnection().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 " +
                        quoteSqlIdentifier(getCursorName()));

                lcc = getEmbedConnection().getLanguageConnection();
View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.CursorActivation

305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
    if (cursor == null) {

      LanguageConnectionContext lcc = getLanguageConnectionContext();

      CursorActivation cursorActivation = lcc.lookupCursorActivation(cursorName);

      if (cursorActivation != null)
      {
       
        cursor = cursorActivation.getCursorResultSet();
        target = cursorActivation.getTargetResultSet();
        /* beetle 3865: updateable cursor using index. 2 way communication between
         * update activation and cursor activation. Cursor passes index scan to
         * update and update passes heap conglom controller to cursor.
         */
        activation.setForUpdateIndexScan(cursorActivation.getForUpdateIndexScan());
        if (cursorActivation.getHeapConglomerateController() != null)
          cursorActivation.getHeapConglomerateController().close();
        cursorActivation.setHeapConglomerateController(activation.getHeapConglomerateController());       
      }
    }

    if (cursor == null || cursor.isClosed()) {
      throw StandardException.newException(SQLState.LANG_CURSOR_CLOSED, cursorName); 
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.