Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4886

Client and embedded don't agree on connection attributes in DatabaseMetaData.getURL()

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.7.1.1
    • Fix Version/s: None
    • Component/s: JDBC
    • Urgency:
      Low
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Embedded/Client difference

      Description

      The embedded driver strips away all connection attributes before returning the URL from DatabaseMetaData.getURL(). The client driver also returns the connection attributes (except user and password, see DERBY-559).

      The attached repro (GetURL.java) demonstrates this behaviour (note that it uses both connection attributes directly in the URL and connection attributes in a java.util.Properties object):

      Connecting with URL jdbc:derby:wombat;create=true and properties

      {territory=no_NO}
      getURL() => jdbc:derby:wombat

      Connecting with URL jdbc:derby://localhost/wombat;create=true and properties {territory=no_NO}

      getURL() => jdbc:derby://localhost:1527/wombat;create=true;territory=no_NO

        Attachments

        1. GetURL.java
          0.7 kB
          Knut Anders Hatlen

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              knutanders Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: