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.zip
        12 kB
        Kim Haase
      2. DERBY-5516.stat
        0.2 kB
        Kim Haase
      3. DERBY-5516.diff
        5 kB
        Kim Haase

        Activity

        Hide
        Kim Haase added a comment -

        Thanks for the guidance, Rick. I'm attaching DERBY-5516.diff, DERBY-5516.stat, and DERBY-5516.zip, with changes to the following:

        M src/devguide/cdevdvlp51654.dita
        M src/devguide/tdevdvlp36289.dita
        M src/ref/rrefattrib24612.dita
        M src/ref/rrefjdbc34565.dita
        M src/ref/rrefjdbc10889.dita

        The java.sql.Driver topic didn't seem like a logical place to put this information. I looked for other possibilities, but I think you found the best locations.

        Please let me know what changes might be needed here.

        Show
        Kim Haase added a comment - Thanks for the guidance, Rick. I'm attaching DERBY-5516 .diff, DERBY-5516 .stat, and DERBY-5516 .zip, with changes to the following: M src/devguide/cdevdvlp51654.dita M src/devguide/tdevdvlp36289.dita M src/ref/rrefattrib24612.dita M src/ref/rrefjdbc34565.dita M src/ref/rrefjdbc10889.dita The java.sql.Driver topic didn't seem like a logical place to put this information. I looked for other possibilities, but I think you found the best locations. Please let me know what changes might be needed here.
        Hide
        Rick Hillegas added a comment -

        Thanks, Kim. These changes look good to me. +1

        Show
        Rick Hillegas added a comment - Thanks, Kim. These changes look good to me. +1
        Hide
        Kim Haase added a comment -

        Thanks again for the preternaturally fast response, Rick!

        Committed patch DERBY-5516.diff to documentation trunk at revision 1329979.

        Show
        Kim Haase added a comment - Thanks again for the preternaturally fast response, Rick! Committed patch DERBY-5516 .diff to documentation trunk at revision 1329979.
        Hide
        Kim Haase added a comment -

        Changes have appeared in Latest Alpha Manuals.

        Show
        Kim Haase added a comment - Changes have appeared in Latest Alpha Manuals.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development