#888 64-bit windows problem

[eagle79]

I've recently started testing Squirrel on a Windows 7 machine and had a bit of trouble. After I realized I had to run the install jar from cmd.exe (run as administrator), I was able to successfully install, but after installation, it wouldn't start. Running the batch file directly didn't reveal much useful either (a strange error about \Java\jre6\bin\javaw.exe). After a bit of trial and error, I finally realized that the batch file was trying to execute the following line

set IZPACK_JAVA=C:\Program Files (x86)\Java\jre6

Apparently the (x86) confuses the batch script, so as a workaround, I simply enclosed the value in quotes:

set IZPACK_JAVA="C:\Program Files (x86)\Java\jre6"

It would be nice if the installer could quote this value, though. I believe the version I installed was the latest snapshot, in case that makes any difference. Windows 7/64 bit with the latest Sun JRE (32-bit).

[Gual61]

I would like to confirm this on Windows 7 64 and Vista 64.

My solution was to switch to the 64bit java version by removing the (x86) from IZPACK_JAVA path. It works perfectly on Vista64; on Win7 64 also but I cannot close the main window after work, only way is to kill the task.

[eagle79]

Possibly related, I also cannot use auto-update. When "checking" I get the following error:

Release file couldn't be downloaded. Please check your settings.

Of course, this might not be related at all, so I don't really know for sure.

[Anonymous]

Here is how I got Squirrel SQL to install in 64bit Windows using the 32bit Java so you can connect to a 32bit ODBC source.

1) Download and install the 32bit Java installer ( I downloaded the 32bit JDK, you may be able do just the JRE )
2) Download Squirrel SQL ( I downloaded the squirrel-sql-Snapshot-20101002_1104-install.jar snapshot)
3) Click start and type cmd in the search box. Right click it from the Programs list and choose Run as Administrator
4) cd to the directory your squirrel sql installer is located
5) paste this into the command box:
"\Program Files (x86)\Java\jdk1.6.0_21\bin\javaw.exe" -jar squirrel-sql-Snapshot-20101002_1104-install.jar
The jdk path may be different depending on your java release and if you installed JRE or JDK. Also your squirrel install jar may be different based on the snapshot you downloaded.
6) Follow the install prompts like normal.
7) goto c:\Program Files (x86). Right click the squirrel-sql folder you installed to and click Properties. Goto Security and click Edit.
8) Click the Users group and Click Full control from the Allow column in the Permissions block at the bottom. Click OK until you are all the way of the properties pages.
Alternatively you can add your specific user to the security group and just give yourself permissions
9) Go into the squirrel-sql folder.
10) Use a text editor to open squirrel-sql.bat ( wordpad and notepad++ work)
11) change
set IZPACK_JAVA=%JAVA_HOME
to
set IZPACK_JAVA="C:\Program Files (x86)\Java\jdk1.6.0_21"
again this may be different for you
12) change
if exist "%IZPACK_JAVA%\bin\javaw.exe" (
to
if exist %IZPACK_JAVA%"\bin\javaw.exe" (
13) find all instances of "%LOCAL_JAVA%" and change them to %LOCAL_JAVA%
I found 3 (lines: 32, 44, and 60)
14) Save and run the bat file.
If you have problems try running the bat file from the command line so you can see your error.
If you get an error like
Windows cannot fine 'C:\Program'.....
you missed a %LOCAL_JAVA% entry
If Squirrel starts but you get a
The specified DSN contains an architecture mismatch.......
then your IZPACK_JAVA path is incorrect

[Nobody/Anonymous]

Thank you very much for this post that saved my life after a couple of hour searching what was wrong with Squirrel on Windows 7.

[Nobody/Anonymous]

You saved me too! I had it already installed on XP, or so I thought. I was just getting the DOS box quickly showing "javaw.exe", then disappearing, then nothing. I followed your tip, but since I had already installed it, I did the following. From c:\Program Files\Java\jdk1.6.0_07\bin> java.exe -jar c:\squirrel-sql-3.1.2\squirrel-sql.jar
That actually caused Squirrel to start up.

[Gerd Wagner]

I done as suggested in the mail by Ben Stover quoted below:

set IZPACK_JAVA="%JAVA_HOME%"

in the 4th line (mind the new quotes). as suggested by Erwan DUROSELLE-2 seems to work.

As already posted byErwan DUROSELLE-2 this bug was already reported in
ID: 3026995 64-bit windows problem

Could you fix it with the next release?
Implementation cost is tiny.

Thank you
Ben