Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A4C419A40 for ; Tue, 24 Apr 2012 19:15:57 +0000 (UTC) Received: (qmail 95726 invoked by uid 500); 24 Apr 2012 19:15:57 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 95699 invoked by uid 500); 24 Apr 2012 19:15:57 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 95687 invoked by uid 99); 24 Apr 2012 19:15:57 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Apr 2012 19:15:57 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Apr 2012 19:15:54 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id A1D4A40D8C0 for ; Tue, 24 Apr 2012 19:15:33 +0000 (UTC) Date: Tue, 24 Apr 2012 19:15:33 +0000 (UTC) From: "Rick Hillegas (JIRA)" To: derby-dev@db.apache.org Message-ID: <1566563988.11015.1335294933664.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <126540464.32493.1322772880474.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (DERBY-5516) Document the fact that attributes on the connection URL trump attributes specified in a connection Properties object. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-5516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13260847#comment-13260847 ] Rick Hillegas commented on DERBY-5516: -------------------------------------- Thanks, Kim. These changes look good to me. +1 > Document the fact that attributes on the connection URL trump attributes specified in a connection Properties object. > --------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-5516 > URL: https://issues.apache.org/jira/browse/DERBY-5516 > Project: Derby > Issue Type: Improvement > Components: Documentation, JDBC > Affects Versions: 10.9.0.0 > Reporter: Rick Hillegas > Assignee: Kim Haase > Attachments: DERBY-5516.diff, DERBY-5516.stat, DERBY-5516.zip > > > 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 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira