You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <de...@db.apache.org> on 2005/09/17 01:07:54 UTC
[jira] Resolved: (DERBY-530) ClientDriver ignores Properties object in connect(String url, Properties connectionProperties) method
[ http://issues.apache.org/jira/browse/DERBY-530?page=all ]
Kathey Marsden resolved DERBY-530:
----------------------------------
Fix Version: 10.1.2.0
10.2.0.0
Resolution: Fixed
Committed to trunk (2892227) and 10.1 (289672)
Date: Fri Sep 16 15:59:43 2005
New Revision: 289672
URL: http://svn.apache.org/viewcvs?rev=289672&view=rev
Log:
DERBY-530
ClientDriver ignores Properties object in connect(String url, Properties connectionProperties) method
Merge from trunk
svn merge -r289226:289227 https://svn.apache.org/repos/asf/db/derby/code/trunk
> ClientDriver ignores Properties object in connect(String url, Properties connectionProperties) method
> -----------------------------------------------------------------------------------------------------
>
> Key: DERBY-530
> URL: http://issues.apache.org/jira/browse/DERBY-530
> Project: Derby
> Type: Bug
> Components: Network Client
> Versions: 10.1.1.0
> Environment: windows XP, JRE 1.5.0_04
> Reporter: Piet Blok
> Assignee: Kathey Marsden
> Fix For: 10.2.0.0, 10.1.2.0
> Attachments: DERBY530.diff
>
> In contrast to EmbeddedDriver, a connection attribute create=true is not recognized when presented as a property in a Properties object.
> As a workaround I append the attributes from the Properties object to the url string before invoking the connect() method: then a new database is created and a connection is established.
> Next code fragment illustrates the bug and the workaround:
> private static final ClientDriver clientDriver = new ClientDriver();
> private Connection getClientConnection(String database,
> Properties connectionProperties) throws SQLException {
> try {
> System.out.println("Try to connect with properties");
> String connectionURL = "jdbc:derby://127.0.0.1:1527/" + database;
> System.out.println("connectionURL: " + connectionURL);
> Connection rv = clientDriver.connect(connectionURL,
> connectionProperties);
> System.out.println("Connection: " + rv);
> return rv;
> } catch (SQLException e) {
> System.out.println("Try to connect with URL attributes");
> StringBuffer sb = new StringBuffer();
> for (Enumeration enu = connectionProperties.propertyNames(); enu
> .hasMoreElements();) {
> String key = (String) enu.nextElement();
> sb.append(';');
> sb.append(key);
> sb.append('=');
> sb.append(connectionProperties.getProperty(key, ""));
> }
> String connectionURL = "jdbc:derby://127.0.0.1:1527/" + database
> + sb.toString();
> System.out.println("connectionURL: " + connectionURL);
> Connection rv = clientDriver.connect(connectionURL,
> connectionProperties);
> System.out.println("Connection: " + rv);
> System.out
> .println("!!!!!!!!!!! seems a bug: Properties argument in ClientDriver.connect(String, Properties) has not been used");
> return rv;
> }
> }
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira