Derby
  1. Derby
  2. DERBY-2417

Network client disallows Statement.setCursorName if an open result set is associated with the Statement object.

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2.2.0
    • Fix Version/s: None
    • Component/s: JDBC, Network Client
    • Urgency:
      Normal
    • Bug behavior facts:
      Embedded/Client difference

      Description

      The Javadoc says that this cursor name applies to future execute methods so the current state of the statement object should be irrelevant.

      Embedded allows the setCursorName and applies it to future executes.

        Issue Links

          Activity

          Daniel John Debrunner created issue -
          Hide
          Daniel John Debrunner added a comment -

          1) testSetCursorNextExecute(org.apache.derbyTesting.functionTests.tests.lang.CursorTest)java.sql.SQLException: Operation 'setCursorName()' cannot be performed o
          n object 'Statement' because there is an open ResultSet dependent on that object
          .
          at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:46)
          at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:346)
          at org.apache.derby.client.am.Statement.setCursorName(Statement.java:801)
          at org.apache.derbyTesting.functionTests.tests.lang.CursorTest.testSetCursorNextExecute(CursorTest.java:171)

          Show
          Daniel John Debrunner added a comment - 1) testSetCursorNextExecute(org.apache.derbyTesting.functionTests.tests.lang.CursorTest)java.sql.SQLException: Operation 'setCursorName()' cannot be performed o n object 'Statement' because there is an open ResultSet dependent on that object . at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:46) at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:346) at org.apache.derby.client.am.Statement.setCursorName(Statement.java:801) at org.apache.derbyTesting.functionTests.tests.lang.CursorTest.testSetCursorNextExecute(CursorTest.java:171)
          Hide
          Daniel John Debrunner added a comment -

          CursorTest has a fixture called 'derby2417testSetCursorNextExecute' tests this issue and only runs in embedded. Once this is fixed the fixture can be run in both.

          Show
          Daniel John Debrunner added a comment - CursorTest has a fixture called 'derby2417testSetCursorNextExecute' tests this issue and only runs in embedded. Once this is fixed the fixture can be run in both.
          Hide
          Rick Hillegas added a comment -

          Triaged for 10.5.2: assigned normal urgency and flagged as embedded/client difference.

          Show
          Rick Hillegas added a comment - Triaged for 10.5.2: assigned normal urgency and flagged as embedded/client difference.
          Rick Hillegas made changes -
          Field Original Value New Value
          Summary Network client disallows Statement.setCursorName if an open result set is associated with the Statement object.
          Network client disallows Statement.setCursorName if an open result set is associated with the Statement object.
          Bug behavior facts [Embedded/Client difference]
          Urgency Normal
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Tiago R. Espinha made changes -
          Link This issue blocks DERBY-5091 [ DERBY-5091 ]
          Kathey Marsden made changes -
          Affects Version/s 10.2.2.0 [ 12312027 ]
          Kathey Marsden made changes -
          Labels derby_triage10_5_2 derby_triage10_9
          Gavin made changes -
          Link This issue blocks DERBY-5091 [ DERBY-5091 ]
          Gavin made changes -
          Link This issue is depended upon by DERBY-5091 [ DERBY-5091 ]
          Gavin made changes -
          Workflow jira [ 12399036 ] Default workflow, editable Closed status [ 12800967 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Daniel John Debrunner
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development