You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (Created) (JIRA)" <ji...@apache.org> on 2012/02/13 19:50:59 UTC
[jira] [Created] (DERBY-5612) Puzzling documentation about the URL
to a database on the classpath
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: 10.9.0.0
Reporter: Rick Hillegas
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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254693#comment-13254693 ]
Kim Haase commented on DERBY-5612:
----------------------------------
Thanks, Knut! I was wondering about those two subtopics (cdevdeploy18716 and cdevdeploy856333) and am happy to remove them.
I don't understand why the "standard syntax" in tdevdeploy39856 is wrong, though. It seems to be the same as what is shown in http://db.apache.org/derby/docs/dev/devguide/cdevdvlp24155.html for accessing jar files.
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13251536#comment-13251536 ]
Kim Haase commented on DERBY-5612:
----------------------------------
Thanks, Knut. I've been working on that assumption (same syntax for jars and directories) and am glad to have it confirmed.
> 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: 10.9.0.0
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Knut Anders Hatlen (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13251526#comment-13251526 ]
Knut Anders Hatlen commented on DERBY-5612:
-------------------------------------------
Hi Kim,
The syntax appears to be the same in both cases. In my experiments, both when the db was in a jar and when it was in a directory, the classpath subsubprotocol was required and there should be no slash 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: 10.9.0.0
> 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
[jira] [Resolved] (DERBY-5612) Puzzling documentation about the URL
to a database on the classpath
Posted by "Kim Haase (Resolved) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase resolved DERBY-5612.
------------------------------
Resolution: Fixed
Fix Version/s: 10.9.0.0
Issue & fix info: (was: Patch Available)
Thanks again, Knut!
Committed patch DERBY-5612-2.diff to documentation trunk at revision 1327511.
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Fix For: 10.9.0.0
>
> Attachments: DERBY-5612-2.diff, DERBY-5612-2.stat, DERBY-5612-2.zip, DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Closed] (DERBY-5612) Puzzling documentation about the URL
to a database on the classpath
Posted by "Kim Haase (Closed) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase closed DERBY-5612.
----------------------------
Changes have appeared in Latest Alpha Manuals.
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Fix For: 10.9.0.0
>
> Attachments: DERBY-5612-2.diff, DERBY-5612-2.stat, DERBY-5612-2.zip, DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Updated] (DERBY-5612) Puzzling documentation about the URL
to a database on the classpath
Posted by "Kim Haase (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-5612:
-----------------------------
Attachment: DERBY-5612-2.zip
DERBY-5612-2.stat
DERBY-5612-2.diff
I hope we've made more progress here -- attaching DERBY-5612-2.diff, DERBY-5612-2.stat, and DERBY-5612-2.zip, which modifies 5 topics and removes 2:
M src/devguide/tdevdeploy39856.dita
M src/devguide/derbydev.ditamap
D src/devguide/cdevdeploy18716.dita
M src/devguide/cdevdvlp17453.dita
M src/devguide/cdevdvlp24155.dita
M src/devguide/rdevdvlp22102.dita
M src/devguide/cdevdvlp40350.dita
D src/devguide/cdevdeploy856333.dita
Thanks again, Knut -- further edits are welcome.
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612-2.diff, DERBY-5612-2.stat, DERBY-5612-2.zip, DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Updated] (DERBY-5612) Puzzling documentation about the URL
to a database on the classpath
Posted by "Kim Haase (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-5612:
-----------------------------
Issue & fix info: Patch Available (was: Repro attached,Patch Available)
(Not sure why "Repro attached" was checked.)
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207763#comment-13207763 ]
Kim Haase commented on DERBY-5612:
----------------------------------
Thanks for noticing this, Rick. Looks like the change fell through the documentation cracks back in 2005. Better late than never.
> 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: 10.9.0.0
> 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
[jira] [Assigned] (DERBY-5612) Puzzling documentation about the URL
to a database on the classpath
Posted by "Kim Haase (Assigned) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase reassigned DERBY-5612:
--------------------------------
Assignee: Kim Haase
> 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: 10.9.0.0
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254773#comment-13254773 ]
Kim Haase commented on DERBY-5612:
----------------------------------
Thanks, Knut -- I suddenly noticed one more in the "Database connection examples" after I sent that one, but of course you found more.
I bet there are more still. Take a look at "Derby JDBC database connection URL" (cdevdvlp17453). Is there any point at all to the "directory" subsubprotocol now?
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Updated] (DERBY-5612) Puzzling documentation about the URL
to a database on the classpath
Posted by "Kim Haase (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-5612:
-----------------------------
Attachment: DERBY-5612.zip
DERBY-5612.stat
DERBY-5612.diff
Attaching DERBY-5612.diff, DERBY-5612.stat, and DERBY-5612.zip, with changes as follows:
M src/devguide/rdevdvlp847152.dita
M src/devguide/cdevdvlp91854.dita
M src/devguide/tdevdeploy39856.dita
M src/devguide/cdevdeploy18716.dita
M src/devguide/cdevdvlp17453.dita
M src/devguide/rdevdvlp22102.dita
M src/devguide/cdevdvlp40350.dita
I hope I made all the needed fixes. I also have to confess that the change to cdevdvlp40350.dita merely adds a missing topic link. I thought I might need to make changes to it and noticed the problem.
Thanks in advance.
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Knut Anders Hatlen (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207600#comment-13207600 ]
Knut Anders Hatlen commented on DERBY-5612:
-------------------------------------------
I didn't get it to work without the classpath sub-sub-protocol in any version, but with 10.0 and 10.1 it looks like it works with a leading slash when specifying the classpath sub-sub-protocol explicitly. Not so with 10.2 and later.
> 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: 10.9.0.0
> Reporter: Rick Hillegas
>
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254740#comment-13254740 ]
Kim Haase commented on DERBY-5612:
----------------------------------
Another possible discovery in the revised "Database connection examples" (rdevdvlp22102): Under the third bullet, on the example jdbc:derby:/reference/phrases/french, should the last sentence be removed?
"If a jar file storing databases were in the user's classpath, this could also be a path within the jar file."
This would be another item for a second patch.
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Knut Anders Hatlen (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254763#comment-13254763 ]
Knut Anders Hatlen commented on DERBY-5612:
-------------------------------------------
> I don't understand why the "standard syntax" in tdevdeploy39856 is wrong, though.
It lacks the classpath subsubprotocol that's required to access a database in a jar on the classpath, and it has a leading slash. If those two problems are fixed, it becomes identical to the other URL mentioned there, so it can be removed.
> It seems to be the same as what is shown in http://db.apache.org/derby/docs/dev/devguide/cdevdvlp24155.html for accessing jar files.
Yes, that one looks wrong too. :)
> Another possible discovery in the revised "Database connection examples" (rdevdvlp22102): Under the third bullet, on the example jdbc:derby:/reference/phrases/french, should the last sentence be removed?
Yes, I believe so. In the same topic, the eighth bullet (jdbc:derby:/myDB) should be removed, the tenth bullet (jdbc:derby:classpath:myDB) should have its last sentence removed, and the twelfth bullet (jdbc:derby:directory:myDB) should have its last sentence removed too.
Do you think we've found them all now? :)
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Rick Hillegas (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13250778#comment-13250778 ]
Rick Hillegas commented on DERBY-5612:
--------------------------------------
Hi Kim,
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.
> 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: 10.9.0.0
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Knut Anders Hatlen (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13256540#comment-13256540 ]
Knut Anders Hatlen commented on DERBY-5612:
-------------------------------------------
+1 to the patch.
You're probably right that there's not much point in the directory subsubprotocol now, since it will always be picked implicitly if no subsubprotocol is specified.
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612-2.diff, DERBY-5612-2.stat, DERBY-5612-2.zip, DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Updated] (DERBY-5612) Puzzling documentation about the URL
to a database on the classpath
Posted by "Kim Haase (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-5612:
-----------------------------
Issue & fix info: Patch Available,Repro attached (was: Repro attached)
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Knut Anders Hatlen (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254619#comment-13254619 ]
Knut Anders Hatlen commented on DERBY-5612:
-------------------------------------------
The changes look fine to me. +1 to commit.
Some other things we might need to change:
tdevdeploy39856: There's still a reference to a URL that uses the wrong syntax. (The "standard syntax" in bullet 2.)
cdevdeploy18716: If I read this topic correctly, it still implies that it is possible to access a db in the classpath without specifying the classpath subsubprotocol. Perhaps the entire topic should go away, as the ambiguity it describes does not exist?
cdevdeploy856333: Same here. Remove topic?
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ 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: 10.9.0.0
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13250763#comment-13250763 ]
Kim Haase commented on DERBY-5612:
----------------------------------
Is there a distinction between jar and zip files on the classpath and databases on the classpath? Several topics mention the initial backslash for jar/zip files. For example:
http://db.apache.org/derby/docs/dev/devguide/tdevdeploy39856.html
http://db.apache.org/derby/docs/dev/devguide/rdevdvlp847152.html
It also looks as if not just the "Accessing databases from the classpath" topic but some others need fixes:
http://db.apache.org/derby/docs/dev/devguide/rdevdvlp22102.html
http://db.apache.org/derby/docs/dev/devguide/cdevdeploy18716.html
http://db.apache.org/derby/docs/dev/devguide/cdevdvlp17453.html
> 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: 10.9.0.0
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Knut Anders Hatlen (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207612#comment-13207612 ]
Knut Anders Hatlen commented on DERBY-5612:
-------------------------------------------
The change was introduced by this commit:
------------------------------------------------------------------------
r240111 | djd | 2005-08-25 20:02:57 +0200 (Thu, 25 Aug 2005) | 9 lines
DERBY-540 Do not prepend database name for classpath databases with leading slash.This causes
databases to be not found when in jar files on the database. Correct the lookup of resources
in the class path storage factory to not use the methods that prepend the current class name,
instead use methods from ClassLoader directly. The leading slash was incorrectly added to avoid
the automatic package prepending performed by Class.getResource.
Removed code that tried to optimise not using the thread context class loader, simply have a
fixed lookup for resources of thread context class loader followed by class loader for Derby/system classloader.
Add lang/dbjar.sql to test databases within a jar and within a jar on the classpath and class loading from such databases.
------------------------------------------------------------------------
> 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: 10.9.0.0
> Reporter: Rick Hillegas
>
> 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
[jira] [Commented] (DERBY-5612) Puzzling documentation about the
URL to a database on the classpath
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254759#comment-13254759 ]
Kim Haase commented on DERBY-5612:
----------------------------------
Committed patch DERBY-5612.diff to documentation trunk at revision 1326640. A second patch with additional fixes will follow.
> 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: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5612.diff, DERBY-5612.stat, DERBY-5612.zip
>
>
> 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