Return-Path: 
 <derby-user-return-15227-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
X-Original-To: apmail-db-derby-user-archive@www.apache.org
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 4913710A92
	for <apmail-db-derby-user-archive@www.apache.org>;
 Mon, 23 Sep 2013 22:06:18 +0000 (UTC)
Received: (qmail 19691 invoked by uid 500); 23 Sep 2013 22:06:17 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 19665 invoked by uid 500); 23 Sep 2013 22:06:15 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 19658 invoked by uid 99); 23 Sep 2013 22:06:14 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Sep 2013 22:06:14 +0000
X-ASF-Spam-Status: No, hits=-2.3 required=5.0
	tests=RCVD_IN_DNSWL_MED,SPF_PASS,UNPARSEABLE_RELAY
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of knut.hatlen@oracle.com
 designates 156.151.31.81 as permitted sender)
Received: from [156.151.31.81] (HELO userp1040.oracle.com) (156.151.31.81)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Sep 2013 22:06:08 +0000
Received: from ucsinet21.oracle.com (ucsinet21.oracle.com [156.151.31.93])
	by userp1040.oracle.com (Sentrion-MTA-4.3.1/Sentrion-MTA-4.3.1) with ESMTP id
 r8NM5lkv017813
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK)
	for <derby-user@db.apache.org>; Mon, 23 Sep 2013 22:05:47 GMT
Received: from aserz7021.oracle.com (aserz7021.oracle.com [141.146.126.230])
	by ucsinet21.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id r8NM5kKC024988
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO)
	for <derby-user@db.apache.org>; Mon, 23 Sep 2013 22:05:47 GMT
Received: from abhmt101.oracle.com (abhmt101.oracle.com [141.146.116.53])
	by aserz7021.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id r8NM5kNc017439
	for <derby-user@db.apache.org>; Mon, 23 Sep 2013 22:05:46 GMT
Received: from mini (/46.9.75.177)
	by default (Oracle Beehive Gateway v4.0)
	with ESMTP ; Mon, 23 Sep 2013 15:05:45 -0700
From: Knut Anders Hatlen <knut.hatlen@oracle.com>
To: derby-user@db.apache.org
Subject: Re: beginner's question
References: <1379921050119-134127.post@n7.nabble.com>
Date: Tue, 24 Sep 2013 00:05:44 +0200
In-Reply-To: <1379921050119-134127.post@n7.nabble.com> (Bob M.'s message of
	"Mon, 23 Sep 2013 00:24:10 -0700 (PDT)")
Message-ID: <86k3i7i47b.fsf@oracle.com>
User-Agent: Gnus/5.130008 (Ma Gnus v0.8) Emacs/24.3 (cygwin)
MIME-Version: 1.0
Content-Type: text/plain
X-Source-IP: ucsinet21.oracle.com [156.151.31.93]
X-Virus-Checked: Checked by ClamAV on apache.org

Bob M <rgmatthews@orcon.net.nz> writes:

> Hi
> I am working through Derby tutorial and am up to step 2 using 'ij'
>
> I tried the command connect 'jdbc:derby:DBName;create=true';
>
> and got the following error result..........................
>
> Thread[main,5,main] java.io.File Not FoundException:derby.log <Access is
> denied>
> ERROR XJ028: The URL 'jdbc:derby:DBName;create=true; connect ' is not
> properly formed
>
> What does this mean?

Hi Bob,

It looks as if you may have forgotten the terminating single quote
character after the connection URL. And then, when nothing happened and
you tried to enter the CONNECT command again, the opening single quote
in the new command was be interpreted by ij as the missing terminating
quote in the first command.

This ij session produces the same error message as you are seeing
(notice the missing quote in the first CONNECT command):

ij version 10.10
ij> connect 'jdbc:derby:DBName;create=true;
connect 'jdbc:derby:DBName;create=true';
ERROR XJ028: The URL 'jdbc:derby:DBName;create=true;
connect ' is not properly formed.
ij> IJ ERROR: Unable to establish connection
ij>

Could this be what happened to you?

And, for completeness, here's an ij session using the correct syntax:

ij version 10.10
ij> connect 'jdbc:derby:DBName;create=true';
ij> select count(*) from sys.systables;
1
-----------
23

1 row selected
ij>


Hope this helps,

-Knut Anders