db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6757) Driver.connect() returns null when using file-based URL
Date Thu, 16 Oct 2014 00:10:33 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14173171#comment-14173171
] 

Myrna van Lunteren commented on DERBY-6757:
-------------------------------------------

If you're using the ClientDriver, you need to use the networkserver style url with the //hostname:portnr/
format - because the networkserver is in charge of creating/connecting to the database.
For example using localhost:
        System.out.println(d.connect("jdbc:derby://localhost:1527/C:/data/derby/test;create=true",
properties));
        System.out.println(DriverManager.getConnection("jdbc:derby://localhost:1527/C:/data/derby/test;create=true",
properties));


> Driver.connect() returns null when using file-based URL
> -------------------------------------------------------
>
>                 Key: DERBY-6757
>                 URL: https://issues.apache.org/jira/browse/DERBY-6757
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.11.1.1
>            Reporter: Lukas Eder
>
> The following program can be used to reproduce this issue:
> {code}
> 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));
>     }
> }
> {code}
> 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}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message