Re: squirrel not starting after java update -- JAVA400-L

Hi Gary,

I think you should put your Java\bin directory in your Windows path and not worry about all the other stuff. I have actually never set JAVA_HOME on any of my Windows PC's. I m not saying you shouldn't, but I haven't had to since 1996. It's sort of a hassle if you install to the recommended directories because they change with each version so you have to update the path, but the kinds of issues you're seeing seldom come up.

I use a simplified method. I partition my drives into OS, programs and data - that part doesn't matter. On my program drive, I have a Java directory. It always has the current install, and always remains the same on my Windows path. I also only install the JDK "private" JRE, but since it's on the path, virtually everything has access to it. And I never discover, as I did once, that a copy exists in the Windows system directories.

If I have to use an older version to match a client, I have those installed from zip downloads, and call Java the old fashioned way.

Squirrel is a great tool. I hope you get past these issues and on to using it.

HTH, or just throw tomatoes,

Joe Sam

Joe Sam Shirah - www.conceptgo.com (904) 302-6870
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: www.ibm.com/developerworks/java
Just the JDBC FAQs: www.jguru.com/faq/JDBC
Going International? www.jguru.com/faq/I18N
Que Java400? www.jguru.com/faq/Java400

-----Original Message----- From: Gary Thompson
Sent: Monday, December 09, 2013 3:13 PM
To: Java Programming on and around the IBM i
Subject: RE: squirrel not starting after java update

Dan,

%LOCAL_JAVA% : javaw.exe

%SQUIRREL_SQL_HOME% : C:\Program Files\squirrel-sql-3.5.0

The value for %SQUIRREL_SQL_HOME% looks correct to me.

So %LOCAL_JAVA% is wrong to me because there is no path
and squirrel-sql.bat is looking in %IZPACK_JAVA% to get
path info as a path prefix to "\bin\javaw.exe

"IZPACK_JAVA" : seems an odd choice

Ok, I'll add IZPACK_JAVA as a system env variable and
report back . . .

thank you, again

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

See if %LOCAL_JAVA% and %SQUIRREL_SQL_HOME% contain expected values before this line executes.

LOCAL_JAVA should have the path to your new java installation ending in "javaw.exe".
SQUIRREL_SQL_HOME should be the path, probably in "Program Files" where Squirrel lives.

Supposedly versioncheck.jar is compiled in Java 1.2 which should run anywhere.

ErrorLevel 1 could indicate that the jar file is not found in "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar", or that the javaw.exe in LOCAL_JAVA is not java version 1.6, 1.7, or 1.8. There should be a log file somewhere with the messages. If you can't find the jar file, you need to display the contents of LOCAL_JAVA and SQUIRREL_SQL_HOME just before this command is run in the .bat file to see what to do next.

I very strongly suspect that JAVA_HOME is not set correctly on your machine.

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

Last week Dan Kimmel kindly suggested some changes to squirrel-sql.bat
that may help identify the problem that started when I updated java on
my windows 7 laptop and also followed the java update suggestion that
old versions be removed.

My first change was removing the "/B" option.

That apparently did nothing, so I added "pause" cmds until I think I
have located the failing line:

"%LOCAL_JAVA%" -cp "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar"
JavaVersionChecker 1.6 1.7 1.8

The next line is:

if ErrorLevel 1 goto ExitForWrongJavaVersion

And this is the path the batch file takes.

>From my Windows laptop:
Java Control Panel
General tab, click About, I see:
Java Standard Edition
Version 7 Update 45 (build 1.7.0_45-b18)

So, apparently this does not meet JavaVersionChecker expectations

but I don't know what to do next . . .
--
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.