[ http://issues.apache.org/jira/browse/DERBY-530?page=all ]
Deepa Remesh updated DERBY-530:
-------------------------------
Fix Version: 10.1.1.1
> 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, 10.1.1.1
> 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
