Uploaded image for project: '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
    • Status: Closed
    • Priority: 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

        Attachments

        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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: