Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of
 geetha.bharathi.attili@oracle.com designates 141.146.126.69 as permitted
 sender)
Message-ID: <51C44BCB.1020702@oracle.com>
Date: Fri, 21 Jun 2013 13:49:15 +0100
From: Geetha Attili <geetha.bharathi.attili@oracle.com>
Organization: Oracle Corporation
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:17.0) Gecko/20130509 Thunderbird/17.0.6
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: Re: Cannot access DB on Classpath
References: <51C38B61.4000103@oracle.com> <51C44A93.2060604@oracle.com>
In-Reply-To: <51C44A93.2060604@oracle.com>
Content-Type: multipart/alternative;
 boundary="------------060607060200030806090904"

This is a multi-part message in MIME format.
--------------060607060200030806090904
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Thanks very much Rick , that explains the failing case.
I am using the 10.8 jdbc driver so wondered if its supposed to work .

-Geetha
On 21/06/2013 13:44, Rick Hillegas wrote:
> On 6/20/13 4:08 PM, Geetha Attili wrote:
>> Hi ,
>> I am trying to connect to a JavaDB Database  on Classpath , I tried 
>> various things as given in the doc, but I feel the behaviour is very 
>> inconsistent or may be I am doing some silly mistake.
>>
>> In a Command prompt
>> > cd D:\DerbyDemo
>> >ij
>> ij version 10.8
>> //created a sample database jdb_classpath
>> ij>connect 'jdbc:derby:jdb_classpath;create=true;';
>> //created a sample Table
>> ij>create table mytable(id numeric);
>> //Disconnected from the jdb_classpath database
>> ij>disconnect;
>>
>>
>> I have then Set the Classpath to include D:\DerbyDemo ;
>> Opened a new command prompt
>> >ij
>>  tried connecting to the jdb_classpath using the following syntax
>> ij>connect 'jdbc:derby:/jdb_classpath';
>>
>> ERROR XJ004: Database '/jdb_classpath' not found.
>>
>> As per the Doc 
>> <http://docs.oracle.com/javadb/10.8.1.2/devguide/rdevdvlp22102.html> 
>> as in example, this should have worked
>> "
>>
>>     * /jdbc:derby:/myDB/
>>
>>       Access /myDB/ (which is directly in a directory in the
>>       classpath) as a read-only database.
>>
>>       "
>>
>>
>> ij>connect 'jdbc:derby:classpath:jdb_classpath';
>> Connection successful. there is no other database with the same name 
>> in the classpath .
>> Do I have to use the classpath  subprotocol always?
>>
>> Many Thanks in Advance,
>> Geetha
> Hi Geetha,
>
> You are reading the 10.8 docs. The documentation in this area was 
> cleaned up in later releases. The failing example was removed from 
> that topic in the Developer's Guide. Please consult the corresponding 
> topic in the 10.10 version of the Developer's Guide: 
> http://db.apache.org/derby/docs/10.10/devguide/index.html
>
> Hope this helps,
> -Rick


--------------060607060200030806090904
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body text="#000099" bgcolor="#FFFFFF">
    <font face="Verdana">Thanks very much Rick , that explains the
      failing case.<br>
      I am using the 10.8 jdbc driver so wondered if its supposed to
      work .<br>
      <br>
      -Geetha<br>
    </font>
    <div class="moz-cite-prefix">On 21/06/2013 13:44, Rick Hillegas
      wrote:<br>
    </div>
    <blockquote cite="mid:51C44A93.2060604@oracle.com" type="cite">On
      6/20/13 4:08 PM, Geetha Attili wrote:
      <br>
      <blockquote type="cite">Hi ,
        <br>
        I am trying to connect to a JavaDB Database  on Classpath , I
        tried various things as given in the doc, but I feel the
        behaviour is very inconsistent or may be I am doing some silly
        mistake.
        <br>
        <br>
        In a Command prompt
        <br>
        &gt; cd D:\DerbyDemo
        <br>
        &gt;ij
        <br>
        ij version 10.8
        <br>
        //created a sample database jdb_classpath
        <br>
        ij&gt;connect 'jdbc:derby:jdb_classpath;create=true;';
        <br>
        //created a sample Table
        <br>
        ij&gt;create table mytable(id numeric);
        <br>
        //Disconnected from the jdb_classpath database
        <br>
        ij&gt;disconnect;
        <br>
        <br>
        <br>
        I have then Set the Classpath to include D:\DerbyDemo ;
        <br>
        Opened a new command prompt
        <br>
        &gt;ij
        <br>
         tried connecting to the jdb_classpath using the following
        syntax
        <br>
        ij&gt;connect 'jdbc:derby:/jdb_classpath';
        <br>
        <br>
        ERROR XJ004: Database '/jdb_classpath' not found.
        <br>
        <br>
        As per the Doc
        <a class="moz-txt-link-rfc2396E" href="http://docs.oracle.com/javadb/10.8.1.2/devguide/rdevdvlp22102.html">&lt;http://docs.oracle.com/javadb/10.8.1.2/devguide/rdevdvlp22102.html&gt;</a> 
        as in example, this should have worked
        <br>
        "
        <br>
        <br>
            * /jdbc:derby:/myDB/
        <br>
        <br>
              Access /myDB/ (which is directly in a directory in the
        <br>
              classpath) as a read-only database.
        <br>
        <br>
              "
        <br>
        <br>
        <br>
        ij&gt;connect 'jdbc:derby:classpath:jdb_classpath';
        <br>
        Connection successful. there is no other database with the same
        name in the classpath .
        <br>
        Do I have to use the classpath  subprotocol always?
        <br>
        <br>
        Many Thanks in Advance,
        <br>
        Geetha
        <br>
      </blockquote>
      Hi Geetha,
      <br>
      <br>
      You are reading the 10.8 docs. The documentation in this area was
      cleaned up in later releases. The failing example was removed from
      that topic in the Developer's Guide. Please consult the
      corresponding topic in the 10.10 version of the Developer's Guide:
      <a class="moz-txt-link-freetext" href="http://db.apache.org/derby/docs/10.10/devguide/index.html">http://db.apache.org/derby/docs/10.10/devguide/index.html</a>
      <br>
      <br>
      Hope this helps,
      <br>
      -Rick
      <br>
    </blockquote>
    <br>
  </body>
</html>

--------------060607060200030806090904--