[Squirrel-sql-users] RE: Squirrel-sql-users digest, Vol 1 #158 - 3 msgs

[Mike G. <mik...@sp...>]

Hi Col!

My CLASSPATH is set to:

"C:\Program Files\Java\j2re1.4.2_03\lib\ext\QTJava.zip"

The squirrel-sql.bat file is now the default as below and I still get the
same error. I'm off traveling around the US for the next week and a half -
I'll return to this at the end of next week. Thanks for the tips!

squirrel-sql.bat file:

=================================
@echo off

IF "%JAVA_HOME%"=="" SET LOCAL_JAVA=java
IF NOT "%JAVA_HOME%"=="" SET LOCAL_JAVA=%JAVA_HOME%\bin\java

set SQUIRREL_SQL_HOME=D:\SQuirreLSQLClient

@rem dir /b "%SQUIRREL_SQL_HOME%\squirrel-sql.jar" > temp.tmp
@rem FOR /F %%I IN (temp.tmp) DO CALL "%SQUIRREL_SQL_HOME%\addpath.bat"
"%SQUIRREL_SQL_HOME%\%%I"
set TMP_CP="%SQUIRREL_SQL_HOME%\squirrel-sql.jar"

dir /b "%SQUIRREL_SQL_HOME%\lib\*.*" > temp.tmp
FOR /F %%I IN (temp.tmp) DO CALL "%SQUIRREL_SQL_HOME%\addpath.bat"
"%SQUIRREL_SQL_HOME%\lib\%%I"

SET TMP_CP=%TMP_CP%;"%CLASSPATH%"
SET TMP_PARMS=--log-config-file "%SQUIRREL_SQL_HOME%\log4j.properties"
--squirrel-home "%SQUIRREL_SQL_HOME%"

@rem Run with a command window.
"%LOCAL_JAVA%" -cp %TMP_CP% net.sourceforge.squirrel_sql.client.Main
%TMP_PARMS%

@rem Run with no command window. However this may not work with all versions
of Windows.
@rem start "SQuirreL SQL Client" /B "%LOCAL_JAVA%w" -cp %TMP_CP%
net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%

@rem Run the executable jar file with or without a cmd window. However the
@rem classes from the %CLASSPATH% environment variable will not be
available.
@rem "%LOCAL_JAVA%" -jar "%SQUIRREL_SQL_HOME%\squirrel-sql.jar" %TMP_PARMS%
@rem start "SQuirreL SQL Client" /B "%LOCAL_JAVA%w" -jar
"%SQUIRREL_SQL_HOME%\squirrel-sql.jar" %TMP_PARMS%
==========================================================

~Mike


-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
squ...@li...
Sent: Monday, June 14, 2004 11:15 PM
To: squ...@li...
Subject: Squirrel-sql-users digest, Vol 1 #158 - 3 msgs

Send Squirrel-sql-users mailing list submissions to
	squ...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
or, via email, send a message with subject or body 'help' to
	squ...@li...

You can reach the person managing the list at
	squ...@li...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Squirrel-sql-users digest..."


Today's Topics:

   1. Simply will not run for me! (Mike Griffin)
   2. RE: Sybase 12.5 ASE (Colin Bell)
   3. RE: Win2K J2 SDK j2sdk1.4.2_03 (Colin Bell)

--__--__--

Message: 1
From: "Mike Griffin" <mik...@sp...>
To: <squ...@li...>
Date: Mon, 14 Jun 2004 21:58:47 -0500
Subject: [Squirrel-sql-users] Simply will not run for me!

This is a multi-part message in MIME format.

------=_NextPart_000_0074_01C4525A.C53055B0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_0075_01C4525A.C53055B0"


------=_NextPart_001_0075_01C4525A.C53055B0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I think I've read everything that I can find on the web so far about
SQuirreL. Even the post on JBoss simply says to run the windows installer
and then double click on the squirrel-sql.bat file. Nothing anywhere has any
further config information.

 

But that simply doesn't work.

 

I've even tried to hard code things like:

 

SET JAVA_HOME=C:\PROGRA~1\Java\j2re1.4.2_03

SET SQUIRREL_SQL_HOME=D:\SQUIRR~1

 

In the startup batch file, because it looks like there is a problem with
spaces in C:\Program Files, but all to no avail.

 

On my Win2k machine with Java 2 SDK 1.4.2_03, irrespective of what I do to
try to start the application, I only get:

================================

Exception in thread "main" java.lang.NoClassDefFoundError:
Files\Java\j2re1/4/2_03\lib\ext\QTJava/zip

 

My developers don't have time to look through the code to figure out what is
going on. I'll be traveling for the rest of the week. I'd sure appreciate
some guidance or some insight by the time I'm back next Sunday!

 

Thanks! 

 

~Mike

 

~Mike Griffin

Product Manager

    651-334-1465

http://www.spiderstrategies.com

http://www.tryscoreboard.com

    Spider Strategies, Inc.

 


------=_NextPart_001_0075_01C4525A.C53055B0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I think I&#8217;ve read everything that I can find on =
the
web so far about SQuirreL. Even the post on JBoss simply says to run the
windows installer and then double click on the squirrel-sql.bat file. =
Nothing
anywhere has any further config information.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>But that simply doesn&#8217;t work.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I&#8217;ve even tried to hard code things =
like:</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New"'>SET
JAVA_HOME=3DC:\PROGRA~1\Java\j2re1.4.2_03</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>SET =
SQUIRREL_SQL_HOME=3DD:\SQUIRR~1</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>In the startup batch file, because it looks like =
there is a
problem with spaces in C:\Program Files, but all to no =
avail.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>On my Win2k machine with Java 2 SDK 1.4.2_03, =
irrespective
of what I do to try to start the application, I only =
get:</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</span></font></p>

<div style=3D'border:none;border-bottom:double windowtext =
2.25pt;padding:0in 0in 1.0pt 0in'>

<p class=3DMsoNormal style=3D'border:none;padding:0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>Exception in thread =
&quot;main&quot;
java.lang.NoClassDefFoundError: =
Files\Java\j2re1/4/2_03\lib\ext\QTJava/zip</span></font></p>

</div>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>My developers don&#8217;t have time to look through =
the code
to figure out what is going on. I&#8217;ll be traveling for the rest of =
the
week. I&#8217;d sure appreciate some guidance or some insight by the =
time I&#8217;m
back next Sunday!</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thanks! </span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>~Mike</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><img width=3D32 height=3D32
src=3D"cid:image001.gif@01C4525A.C4AD1BF0" align=3Dleft border=3D0><font =
face=3DArial><span
style=3D'font-family:Arial'>~<b><span style=3D'font-weight:bold'>Mike =
Griffin</span></b></span></font></p>

<p class=3DMsoNormal><b><font size=3D3 face=3DArial><span =
style=3D'font-size:12.0pt;
font-family:Arial;font-weight:bold'>Product =
Manager</span></font></b></p>

<p class=3DMsoNormal><b><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;font-weight:bold'>&nbsp;&nbsp;&nbsp; =
651-334-1465</span></font></b></p>

<p class=3DMsoNormal><b><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;font-weight:bold'><a =
href=3D"http://www.spiderstrategies.com">http://www.spiderstrategies.com<=
/a></span></font></b></p>

<p class=3DMsoNormal><b><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;font-weight:bold'><a =
href=3D"http://www.tryscoreboard.com">http://www.tryscoreboard.com</a></s=
pan></font></b></p>

<p class=3DMsoNormal><b><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;font-weight:bold'>&nbsp;&nbsp;&nbsp; Spider =
Strategies, Inc.</span></font></b></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;</span></font></p>

</div>

</body>

</html>

------=_NextPart_001_0075_01C4525A.C53055B0--

------=_NextPart_000_0074_01C4525A.C53055B0
Content-Type: application/octet-stream;
	name="image001.gif"
Content-Transfer-Encoding: base64
Content-ID: <image001.gif@01C4525A.C4AD1BF0>

R0lGODlhIAAgAIcAAAAAAAQEAgYGBg8OAw4ODhUUDBsXBhgVChcXFyUhDColCzcwDzoyDCMjIyop
JS8vLzw8PEpBEUlAGlpNEl5RF1tQHE1FI0pHNFRLI1JNNllTN2FVHm1eGWJYJWNaL2ldJmJbOWhe
MHNjF3xrG2piO3hqKXZsOXptMUVFRWplTnRuTn90Qn93ToNwGoh1GoFyKYt9PZJ/J6F9MYB3T4J9
YJ2HIJaCMpSDPpmIOKOLK62GNKeQIqmSKa6YMLCXKrWcJLmeJL2fLrefM7ObPb6iIbehO7ykM7yl
PY+CS42CUJmOXomBYZyPZ5qOa5KOd5yRaJeReKaVQ6CSTbKWSb+fRrOcWKqdYa+ea6mbd7mkS7il
X7+sWK+hZrWibrytbcapJsyuIsisK8emNMCoNcqnPs6wKNGrOdqzKty7Jd65LNG3P9e4PduyOuW3
NOG6Me29Mu2+PvC9NfG9OsepQcqpTsexScqyRsSxWM6wXs25WtW3Qda6Rdi+RsOtYsq6b8eycce4
dtC/b963Yty5ata2cOaxTOi0S+C5YePAJOrBJOnCK+rIKuTDNObGOOvKMvTLJfXMLfrPOvzVJvrT
Kv/YJ//YKfbUM/vUNvrQPv7aM/7bOt3BRd3DStbAW9vDVNfHe+3CSenMQ+zQUvbXRPbYTf7cQ/7e
Tf/fUenTb+PRfu7XcPfcYP/gVv7hW//iYP/mcp2blaSahaSdiaueg6CclKKenKajkqyok7Csl7Gv
nbWxn7iwkqWlpaqqqrW0tLi3t7u7u8m+l9LEitnGjd3IiNDEndfJk9HGotXKpNTSt9jXu+fWjezZ
hevaju3ck/Hdhf/phv/piPPil//sl//tmf/upfLmsvTosv/xr//xssTExMfIyMvLy8/R0djXztTU
1NbY2N7d1NrZ2dvc3N3c3ODf3+TjzOfm1Obm2uHh4ePk5OTj4+bl5ejn5+jq5+rp6ezr6+7t7fDu
7vLy8vLz9PP18/Tz8/X19ff69/j39/n5+fn9/fz7+/7+/v///wAAACH5BAMAAP4ALAAAAAAgACAA
AAj/AP0JHEhQoD5579q1gzcPX8GHEAfmayduG7BfGH8B4zbuncOIEPWt4+arVy9eJ3mhRPmLmzp+
IAna+1YyZS2VKm+i7PULXL2Y/uJtO3mS1qw+exoxUrMFCy2cvbjJAwlPm0letbpwshGIWrVq1D7d
2FQF1s5t8SDa45Yy1pBGr3BZy5YNW7ZruqCFytFEZa9u9wryE1eSV6xGFVJVuyWNmmNq0mxVc+ZB
EROW42AOrFpSViNKLJZBg8Ismuloz5xEa7aEUqInvXyhHchvHDBgvdZQomTFy6slqF4Jf6WKxis/
SnafsXWbXD+B9rrdvrKbkqgUrZLcccXdVZ4ZrlR4/6o+BZi2bvYEwuO2zZfu3ZlM2OGk4ZQp+yTm
g9BUPU2ubd3A408/I22zyyTVURJGB5p0IAQGGIxhgSYl+FBJdY9wsQ037fijTzndbKNFgrstsEMZ
BQggwAE/fKGAJAlKQgU33ZTDTz7lfNPNHJRcWB0iEzBgAAAADBAkGD5WZ0Y336SjTz7qiPMNI5JU
YqWVkhAxAZEABDABGlda2SMj34yzDj/6sEMOOG6EWYkICVDQggIB1BkBAwq44KYb4JDTjj76vJPO
OGSEyQEHlfyQgIoqHlDDIhSMUEkmPZpBTjrw8MOPPOqs08ekmWTCgyUbSLABAagSQEGpjsQQaiaT
0P+hDjvyPDdPO+wEM0mommhixAeajIHAsAj0oMkLPJSiSaiQANKOO/QIlM878HjDRiaalFLKCUeU
MooDDYQbSilqhKBtKZm0kQy1+gi0KTzv/IFtKaZcQIoppoDwwAMZ2HeKvdpegoc78NQqUD/3yCNP
ONeWwgcJrLTCihQQQICExKysUIcpmrShjMIfuWuPPPMc84YmOETBiiutdIICCtuxnAUMpbwhDD3y
2KPZQPrYYw89xbzxQhGntNKKd3mswjIrdZQQx83z2NNuQf3oc8/VyOgQBL2msBIxK6ecUooYMhhT
Tz5SP/dQ1fkAig4hcERy7rmYyDGIOYC2rTZE/aA4qQ+a5wwjSCGggGLIIcSYgw+amu4dUT99Nw75
Pvjos88+k0sO1ECQd+7555Bvvjbon4seE+iiBwQAOw==

------=_NextPart_000_0074_01C4525A.C53055B0--



--__--__--

Message: 2
From: Colin Bell <Col...@as...>
To: squ...@li...
Subject: RE: [Squirrel-sql-users] Sybase 12.5 ASE
Date: Tue, 15 Jun 2004 13:28:29 +1000

> -----Original Message-----
> From: Paul White [mailto:pau...@ne...]
> Sent: Wednesday, 9 June 2004 10:12 PM
> To: squ...@li...
> Subject: [Squirrel-sql-users] Sybase 12.5 ASE

Hi Paul,

> So I downloaded jconnect 55, pointed squirrel to the location of the 
> jar, and it STILL did not work. At this point I did a bit of 
> research on 
> the Sybase site, and I saw that the class name on the Sybase site was 
> different from the default class name in Squirrel. Once I changed the 
> class name to the one listed on the Sybase site, I was able 
> to connect 
> to my Sybase ASE db sucesfully. The default class name in the 
> Squirrel 
> client was incorrect for jconnect 55. I still dont know why 

The default class name for JConnect in SQuirreL is
"com.sybase.jdbc2.jdbc.SybDriver" which is correct according to the
JConnect FAQ

http://www.sybase.com/detail/1,6904,1009876,00.html#sec2q1

Which class name did you end up using?

There is also a "List Drivers" button in the driver maintenance dialog which
will list all the Driver class names in the selected jar file.

http://squirrelsql.org/user-manual/quick_start.html#the_driver

Col


--__--__--

Message: 3
From: Colin Bell <Col...@as...>
To: squ...@li...
Subject: RE: [Squirrel-sql-users] Win2K J2 SDK j2sdk1.4.2_03
Date: Tue, 15 Jun 2004 13:34:13 +1000

Hi Mike,

Either your squirrel-sql.bat file has been modified incorrectly or you have
a problem with your classpath. The error you are getting is saying that
"Files\Java\j2re1/4/2_03\lib\ext\QTJava/zip" is the main class for SQuirreL
which is obviously not the case.

Check your CLASSPATH environment variable (Settings/Control Panel/System -
Advanced tab, Environement variables in XP). Check that the CLASSPATH
variable
is specified correctly, no unbalanced quotes etc.

Col

-----Original Message-----
From: Mike Griffin [mailto:mik...@sp...]
Sent: Sunday, 13 June 2004 12:58 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Win2K J2 SDK j2sdk1.4.2_03


I've just completed an install of both the last release and then the latest
beta release.

I'm using the Sun Java J2 SDK release j2sdk1.4.2_03.

In both cases, the startup batch file, squirrel-sql.bat, results in the
following error:


Exception in thread "main" java.lang.NoClassDefFoundError:
Files\Java\j2re1/4/2_03\lib\ext\QTJava/zip


I cannot find a config file that would allow me to fix this. The program is
apparently supposed to be looking for 

\Program Files\Java\j2re1.4.2_03\lib\ext\QTJava.zip 

but this is appears to be being misinterpreted.

What can I do to fix this? Thanks!

~Mike



--__--__--

_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


End of Squirrel-sql-users Digest