db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4622) Specify "database:" URL prefix in documentation
Date Tue, 20 Apr 2010 14:58:49 GMT

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

Kristian Waagan commented on DERBY-4622:

Hi Chris,

I'm pretty sure Derby expects the protocol to be longer than one char. In that case, this
isn't a doc issue, but a bug.
Can you post the exception (and the stack trace if any [1]) you get?
What's the Derby version you are using?
And for good measure, which Windows version?

On Windows XP with Derby 10.5.3 I can connect to the database below in ij:
  ij> connect 'jdbc:derby:c:/test/kwdb;create=true'
If I specify s instead of c (non-existing drive), I get:
  ERROR XBM0H: Directory S:\test\kwdb cannot be created.


[1] With ij, specify -Dij.exceptionTrace=true

> Specify "database:" URL prefix in documentation
> -----------------------------------------------
>                 Key: DERBY-4622
>                 URL: https://issues.apache.org/jira/browse/DERBY-4622
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>            Reporter: Chris Dolan
>            Priority: Trivial
> The tutorial step titled "Activity 3: Run a JDBC program using the embedded driver" at
the following URL (http://db.apache.org/derby/docs/10.4/getstart/getstart-single.html#tgsactivity3_Setup)
recommends this syntax for specifying a directory-based datasource:
>   String connectionURL = "jdbc:derby:" + dbName + ";create=true";
> For Windows users who need to specify an absolute path to the database, this is a problem
because the connection interprets "c:/path/to/db" as non-existent protocol "c" and a database
name of "/path/to/db".  Better documentation would be explicitly specify the protocol:
>   String connectionURL = "jdbc:derby:directory:" + dbName + ";create=true";
> (this would have saved me about a day of troubleshooting...)

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message