Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Fri, 25 Aug 2006 08:55:17 -0700
From: Rick Hillegas <Richard.Hillegas@Sun.COM>
Subject: Re: installation issue: problems caused by spaces in path pointed to
 by DERBY_HOME or DERBY_INSTALL
In-reply-to: <54ac72d70608241400n6b93a276ha758ee9f47e31bc6@mail.gmail.com>
Sender: Richard.Hillegas@Sun.COM
To: derby-dev@db.apache.org
Message-id: <44EF1D65.6010202@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <44EE0A8D.6090902@sun.com>
 <54ac72d70608241400n6b93a276ha758ee9f47e31bc6@mail.gmail.com>
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)

Hey  Andrew,

Here's a bit more information on this problem. Regards-Rick

It does not work correctly on Windows XP SP2. It adds extra characters
that are not the DOS 8.3 format and even changes the name of the db
directory in the PATH to db0. The error message we get is

    Exception in thread "main" java.lang.NoClassDefFoundError:
org/apache/derby/tools/ij

The problem is the CLASSPATH set by setEmbeddedCP.bat. Once you set
DERBY_INSTALL, then run this batch file, the resulting CLASSPATH is:


CLASSPATH=C:\PROGRA~1\Java\JDK16~1.0\db0\db\lib\derby.jar;C:\PROGRA~1\Java\JDK16~1.0\db0\db\lib\derbytools.jar;.;

which you can clearly see has some strange problems in it. Somehow it
ads the directory db0 and really messes up the name of the jdk1.6.0
directory. However, if you remove that FOR statement, everything works
just fine.


Andrew McIntyre wrote:

> On 8/24/06, Rick Hillegas <Richard.Hillegas@sun.com> wrote:
>
>> The following line in setEmbeddedCP.bat raises errors if there are
>> spaces in the path identified by DERBY_HOME or DERBY_INSTALL:
>>
>> @FOR %%X in ("%DERBY_HOME%") DO SET DERBY_HOME=%%~sX
>>
>> Is this a known problem? I'm not a DOS expert and I don't know
>> understand what "%%~sX" means.
>
>
> That should convert the value of DERBY_HOME to it's DOS 8.3 short form
> to avoid further problems with the path containing spaces. This is
> working for me on Windows 2000. What version of Windows are you using,
> and what is the error you are getting?
>
> andrew