db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Piet Blok (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-530) ClientDriver ignores Properties object in connect(String url, Properties connectionProperties) method
Date Tue, 23 Aug 2005 15:27:09 GMT
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


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


Mime
View raw message