db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5612) Puzzling documentation about the URL to a database on the classpath
Date Tue, 10 Apr 2012 18:29:13 GMT

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

Kim Haase commented on DERBY-5612:

> A database doesn't need to be in a jar file in order to be accessed via the
> classpath, although that is probably common usage. If the classpath contains
> a directory and that directory has a database as a subdirectory, then the
> database can be accessed via the classpath subprotocol. Thanks. 

I think my question is sort of from the other end. I know that a database can be accessed
from the classpath whether it is in a jar/zip or not. But is the syntax exactly the same in
both cases? That is, if the db is in a jar/zip, is the classpath subsubprotocol required and
must there be no backslash after the colon?

> Puzzling documentation about the URL to a database on the classpath
> -------------------------------------------------------------------
>                 Key: DERBY-5612
>                 URL: https://issues.apache.org/jira/browse/DERBY-5612
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions:
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
> The "Accessing databases from the classpath" section of the Derby Developer's Guide says
that you can access a database on the classpath by putting a forward slash in front of the
database name (and then adding other path legs as needed). I don't find that it works this
way. I ran the following experiment:
> 1) I put a database called nast in the testRun/extin subdirectory of the current directory.
> 2) Then I put testRun/extin on the classpath.
> 3) Then I tried connecting to the database with various URLs.
> The following URLs could not find the database:
> connect 'jdbc:derby:/nast;user=KIWI;password=KIWI_password';
> connect 'jdbc:derby:nast;user=KIWI;password=KIWI_password';
> connect 'jdbc:derby:classpath:/nast;user=KIWI;password=KIWI_password';
> But the following URL found the database:
> connect 'jdbc:derby:classpath:nast;user=KIWI;password=KIWI_password';
> This is not what I expected from the documentation in the Developer's Guide.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message