Derby
  1. Derby
  2. DERBY-5516

Document the fact that attributes on the connection URL trump attributes specified in a connection Properties object.

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: 10.9.1.0
    • Component/s: Documentation, JDBC
    • Labels:
      None
    • Urgency:
      Normal

      Description

      Attributes for a Derby connection can be set via semicolon-separated lists on the connection url as well as in a Properties object passed to the java.sql.DriverManager.getConnection() and java.sql.Driver.connect() methods. The JDBC spec does not indicate what should happen if an attribute is specified both on the connection url and in the Properties object. For some databases, like Derby, the attributes on the connection url trump the attributes in the Properties object. For other databases, like MySQL, the reverse is true.

      Because the JDBC spec does not dictate standard behavior here, we should document what Derby does. This information would be useful in some or all of the following sections:

      Reference Manual:

      Setting attributes for the database connection URL
      Attributes of the Derby database connection URL
      java.sql.Driver interface
      java.sql.DriverManager.getConnection method

      Developer's Guide:

      Working with the database connection URL attributes
      Specifying attributes in a properties object

      1. DERBY-5516.diff
        5 kB
        Kim Haase
      2. DERBY-5516.stat
        0.2 kB
        Kim Haase
      3. DERBY-5516.zip
        12 kB
        Kim Haase

        Activity

        Rick Hillegas created issue -
        Kim Haase made changes -
        Field Original Value New Value
        Assignee Kim Haase [ chaase3 ]
        Kim Haase made changes -
        Attachment DERBY-5516.diff [ 12524023 ]
        Attachment DERBY-5516.stat [ 12524024 ]
        Attachment DERBY-5516.zip [ 12524025 ]
        Kim Haase made changes -
        Issue & fix info Patch Available [ 10102 ]
        Kim Haase made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Issue & fix info Patch Available [ 10102 ]
        Fix Version/s 10.9.0.0 [ 12316344 ]
        Resolution Fixed [ 1 ]
        Kim Haase made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12644222 ] Default workflow, editable Closed status [ 12796987 ]

          People

          • Assignee:
            Kim Haase
            Reporter:
            Rick Hillegas
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development