RE: squirrel not starting after java update

Dan,
JAVA_HOME and IZPACK_JAVA are, I believe, set identically:

IZPACK_JAVA C:\Program Files (x86)\Java\jre7
JAVA_HOME C:\Program Files (x86)\Java\jre7

I copied both from windows: Edit System Variable

I also changed squirrel-sql.bat to:

set LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe"

I then entered the command you suggest from command prompt
but LOCAL_JAVA still has the value "javaw.exe", which means
my attempt to modify the bat file failed . . .

Thanks everyone for your help!

I have other business now . . .


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: Monday, December 09, 2013 4:31 PM
To: Java Programming on and around the IBM i
Subject: RE: squirrel not starting after java update

About the first command in that bat file is

set IZPACK_JAVA="%JAVA_HOME%"

so it doesn't matter what IZPACK_JAVA had in it to begin with. It'll be set to nothing if JAVA_HOME is not set.

I think the installer will start squirrel going at its end. It is probably the only thing that sets IZPACK_JAVA, and it probably sets JAVA_HOME as well, both only at the job level, not the system level.

Try this: run a command prompt as administrator. Type

Set JAVA_HOME="/Program Files/Java/PathWhereYourBinIs/"
<Enter>
"C:\Program Files\squirrel-sql-3.5.0\squirrel-sql.bat"
<Enter>

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Monday, December 09, 2013 5:21 PM
To: Java Programming on and around the IBM i
Subject: RE: squirrel not starting after java update

Ahh, had not thought of that.
What you said on the set command, not my sloppy spelling.
Thanks Chuck.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Monday, December 09, 2013 3:20 PM
To: java400-l@xxxxxxxxxxxx
Subject: Re: squirrel not starting after java update

On 09-Dec-2013 13:06 -0800, Gary Thompson wrote:

Don't yet know why, but the batch file seems to mishandle "set
LOCAL_JAVA=%IZPACK_JAVA%\bin\javaw.exe"

I'm guessing the line of code:

if exist "%IZPAK_JAVA%\bin\javaw.exe"

does not work because of double quotes ?

Or perhaps a side effect of the spelling error? That is,
%IZPACK_JAVA% <> %IZPAK_JAVA%

Or the opposite problem of what is alluded? That is, the lack of
double- quote delimiting on the SET is an issue rather than the
existence of the delimiters on the existence test.? Without
delimiters, if the path has embedded blanks [e.g. \Program Files\...],
then the value set for the one variable LOCAL_JAVA might contain only
the characters up to the first blank in the value of the other variable IZPACK_JAVA [e.g.
such that LOCAL_JAVA becomes just \Program and the exists appended
with \bin\javaw.exe checks for the non-existent \Program\bin\javaw.exe file?
I have no Win client on which to test. For both consistency and
requirements to support a path with blanks, but perhaps the following
modifications should be made in the .bat file?:

SET LOCAL_JAVA="%IZPACK_JAVA%\bin\javaw.exe"

IF EXIST "%IZPACK_JAVA%\bin\javaw.exe"


The following [effective; may require reformatting] web search
reveals some possible issues [none mentioning IZPAK_JAVA so the above
possibly originated as a transcription error into the message] and
resolutions:
https://www.google.com/search?&q="if+exist"+"IZPACK_JAVA";

The following link [from the above search] seems to confirm
something similar to my suggestion above.
http://sourceforge.net/p/squirrel-sql/bugs/888/

--
Regards, Chuck
--
This is the Java Programming on and around the IBM i (JAVA400-L)
mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/java400-l.

--
This is the Java Programming on and around the IBM i (JAVA400-L)
mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/java400-l.

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.