[ 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