Derby
  1. Derby
  2. DERBY-3039

ParameterMetaData.isNullable() returns differenet SQLState in Embedded and Network Client

    Details

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

      Description

      ParameterMetaData.isNullable(int param) returns SQLState in Embedded and Network Client.
      Reproducible test case is attached with this bug report.

      1. Nullable.java
        5 kB
        Ramin Moazeni

        Issue Links

          Activity

          Ramin Moazeni created issue -
          Hide
          Ramin Moazeni added a comment -

          The SQLState is different as shown below:

          [ramin@romin ~]$ java Nullable
          Could not connect to Derby Network Server on host 0:0:0:0:0:0:0:1, port 1527: Connection refused
          [NsSample] Unable to obtain a connection to network server, trying again after 3000 ms.
          Apache Derby Network Server - 10.4.0.0 alpha - (1) started and ready to accept connections on port 1527 at 2007-09-01 20:46:11.845 GMT

          • Testing with org.apache.derby.jdbc.ClientDriver
            SQLState = XCL14
            SQLState = XCL14
            SQLState = XCL14
          • Testing with org.apache.derby.jdbc.EmbeddedDriver
            SQLState = XCL13
            SQLState = XCL13
            SQLState = XCL13
            Apache Derby Network Server - 10.4.0.0 alpha - (1) shutdown at 2007-09-01 20:46:16.024 GMT
          Show
          Ramin Moazeni added a comment - The SQLState is different as shown below: [ramin@romin ~] $ java Nullable Could not connect to Derby Network Server on host 0:0:0:0:0:0:0:1, port 1527: Connection refused [NsSample] Unable to obtain a connection to network server, trying again after 3000 ms. Apache Derby Network Server - 10.4.0.0 alpha - (1) started and ready to accept connections on port 1527 at 2007-09-01 20:46:11.845 GMT Testing with org.apache.derby.jdbc.ClientDriver SQLState = XCL14 SQLState = XCL14 SQLState = XCL14 Testing with org.apache.derby.jdbc.EmbeddedDriver SQLState = XCL13 SQLState = XCL13 SQLState = XCL13 Apache Derby Network Server - 10.4.0.0 alpha - (1) shutdown at 2007-09-01 20:46:16.024 GMT
          Ramin Moazeni made changes -
          Field Original Value New Value
          Attachment Nullable.java [ 12364961 ]
          Ramin Moazeni made changes -
          Link This issue relates to DERBY-2658 [ DERBY-2658 ]
          Kathey Marsden made changes -
          Derby Categories [Embedded/Client difference]
          Hide
          Rick Hillegas added a comment -

          Triage for 10.5.2: Assign normal urgency.

          Show
          Rick Hillegas added a comment - Triage for 10.5.2: Assign normal urgency.
          Rick Hillegas made changes -
          Component/s JDBC [ 11407 ]
          Urgency Normal
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Kathey Marsden made changes -
          Labels derby_triage10_5_2 derby_triage10_9
          Gavin made changes -
          Workflow jira [ 12411953 ] Default workflow, editable Closed status [ 12796904 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Ramin Moazeni
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development