[jira] [Commented] (DERBY-6462) Provide more information about database name and path syntax

["Dag H. Wanvik (JIRA)" <ji...@apache.org>]

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

Dag H. Wanvik commented on DERBY-6462:
--------------------------------------

I think the directory subsubprotocol is the default one; I found I *can* specify like this:

ij> connect 'jdbc:derby:directory:mydir/wombat;create=true'; 

instead of just the normal

ij> connect 'jdbc:derby:mydir/wombat;create=true'; 

So there is no difference in semantics here. The database name here ("mydir/wombat") is a relative path name (in my proposed terminology). It is slightly troubling that the database name isn't unique: the name "mydir/../mydir/wombat" will denote the same data base. But is it the same data base name(?)... It would all have been easier if we said that the database identified by a file name (at least when we explicitly or implicitly use the directory subsubprotocol).



> Provide more information about database name and path syntax
> ------------------------------------------------------------
>
>                 Key: DERBY-6462
>                 URL: https://issues.apache.org/jira/browse/DERBY-6462
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.11.0.0
>            Reporter: Dag H. Wanvik
>            Assignee: Kim Haase
>         Attachments: DERBY-6462-2.diff, DERBY-6462-2.stat, DERBY-6462-2.zip, DERBY-6462-3.diff, DERBY-6462-3.zip, DERBY-6462.diff, DERBY-6462.stat, DERBY-6462.zip
>
>
> Except for initial Windows drive letters (e.g. K:/derby), colons break Derby.
> Windows can't have colons in directory of file names, so this is a Unix issue.
> [http://msdn.microsoft.com/en-us/library/aa365247%28VS.85%29.aspx#file_and_directory_names]



--
This message was sent by Atlassian JIRA
(v6.2#6252)