[DERBY-6757] Driver.connect() returns null when using file-based URL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 10.11.1.1
• Component/s: JDBC
• Urgency: Normal
• Bug behavior facts: Embedded/Client difference
• Assignee: Unassigned
• Reporter: Lukas Eder
• Created: 06/Oct/14 14:26
• Updated: 16/Oct/14 04:45
• Resolved: 16/Oct/14 04:45

Description

The following program can be used to reproduce this issue:

import java.sql.Driver;
import java.sql.DriverManager;
import java.util.Properties;

public class Test {

    public static void main(String[] args) throws Exception {
        Driver d = (Driver) Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();

        Properties properties = new Properties();
        properties.setProperty("user", "TEST");
        properties.setProperty("password", "TEST");
        System.out.println(d.connect("jdbc:derby:C:/data/derby/test;create=true", properties));
        System.out.println(DriverManager.getConnection("jdbc:derby:C:/data/derby/test;create=true", properties));
    }
}

When run, the above program will output something like:

{monospace}
null
org.apache.derby.impl.jdbc.EmbedConnection@1226204845 (XID = 18681), (SESSIONID = 1), (DATABASE = C:/data/derby/test), (DRDAID = null) {monospace}