squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] Object tree displays OK, but SQL commands won't exececute

[Colin B. <col...@te...>]

Hi Denis,

Forget my comment below, this is an issue _only_ with the current CVS
code. In 1.1 having the cursor on the next line will still execute the
code. However having a blank line between the SQL statement and the
caret will cause this problem.

E.G.

select * from table

|

will not work.

--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: Colin Bell <col...@bi...>
Date: Monday, April 14, 2003 1:43 pm
Subject: Re: [Squirrel-sql-users] Object tree displays OK, but SQL
commands won't exececute

> Hi Denis,
> 
> I've tested SQuirreL with slightly older versions of PostgreSQL 
> and it
> has worked fine.
> 
> The SQL entry area allows you to execute multiple SQL statements 
> as well
> as single ones so the actual text selected in the entry area means
> something. The Help file that comes with SQuirreL explains it:
> 
> "If a single statement is entered then pressing <ctrl><enter> will
> execute just that statement.
> If you only want to execute part of the SQL entered then highlight the
> SQL that you want to execute and press <ctrl><enter>.
> To only execute a single statement amongst several statements 
> (separatedfrom the other statements by at least one blank line) 
> within the SQL
> entry area then click on the line containing the statement that 
> you want
> to execute and press <ctrl><enter>."
> 
> What it _doesn't_ explain (because I've only just realized it 
> myself) is
> that if you put the cursor on the line after the SQL and then press
> <CTRL><ENTER> it _doesn't_ execute. E.G. (if | represents the cursor)
> 
> select * from table|
> 
> will work but
> 
> select * from table
> |
> 
> won't work.
> 
> Let me know whether this is your problem. I intend to fix this in the
> next release.
> 
> --
> Colin Bell
> http://squirrel-sql.sf.net
> 
> 
> -----Original Message-----
> From: Denis Grannell [mailto:dgr...@we...]
> Sent: Monday, 14 April 2003 2:29
> To: squ...@li...
> Subject: [Squirrel-sql-users] Object tree displays OK, but SQL 
> commandswon't exececute
> 
> 
> Hi folks,
> 
> I hope someone may be able to throw some light on the 
> following odd behaviour. I have a postgres 7.3.2 
> installation on Solaris9 that I want to access from 
> Windows PCs using the squirrel 1.1-final client.
> The windows version is Windows2000 Professional/SP3.
> The java version on the PCs is:
> "Java(TM) 2 Runtime Environment, Standard Edition 
> (build 1.3.0-C)"
> I am using a jdbc driver called 'pg73jdbc2ee.jar.zip'
> that I got from the Postgresql java website.
> The driver loads up OK and appears in the client as 
> active. I can connect to the database without any
> problems.
> In the client GUI I can view everything under the
> 'Objects' tab such as table content, table columns, 
> primary keys, views, etc. If I click on 'Content' for 
> any given table I get an instant list of all the rows.
> However the SQL tab is not working. I can type in
> any simple select statement (select * from <tablename>;)
> for the same table for which I just viewed the content 
> and nothing happens at all. 
> No list, no new tab, nothing. I'm not a java expert, so 
> I would appreciate any help on how to try and 
> troubleshoot this.
> 
> thanks
> 
> Denis
> _________________________________________________________
> | Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany |
> | Tel: +49 89 2013672                 Fax: +49 89 2022875 |
> |_________________________________________________________|
> 
> 
> 
 

Re: [Squirrel-sql-users] Object tree displays OK, but SQL commands won't exececute

[Colin B. <col...@te...>]

Hi Denis,

I've tested SQuirreL with slightly older versions of PostgreSQL and it
has worked fine.

The SQL entry area allows you to execute multiple SQL statements as well
as single ones so the actual text selected in the entry area means
something. The Help file that comes with SQuirreL explains it:

"If a single statement is entered then pressing <ctrl><enter> will
execute just that statement.
If you only want to execute part of the SQL entered then highlight the
SQL that you want to execute and press <ctrl><enter>.
To only execute a single statement amongst several statements (separated
from the other statements by at least one blank line) within the SQL
entry area then click on the line containing the statement that you want
to execute and press <ctrl><enter>."

What it _doesn't_ explain (because I've only just realized it myself) is
that if you put the cursor on the line after the SQL and then press
<CTRL><ENTER> it _doesn't_ execute. E.G. (if | represents the cursor)

select * from table|

will work but

select * from table
|

won't work.

Let me know whether this is your problem. I intend to fix this in the
next release.

--
Colin Bell
http://squirrel-sql.sf.net


-----Original Message-----
From: Denis Grannell [mailto:dgr...@we...]
Sent: Monday, 14 April 2003 2:29
To: squ...@li...
Subject: [Squirrel-sql-users] Object tree displays OK, but SQL commands
won't exececute


Hi folks,

I hope someone may be able to throw some light on the 
following odd behaviour. I have a postgres 7.3.2 
installation on Solaris9 that I want to access from 
Windows PCs using the squirrel 1.1-final client.
The windows version is Windows2000 Professional/SP3.
The java version on the PCs is:
"Java(TM) 2 Runtime Environment, Standard Edition 
 (build 1.3.0-C)"
I am using a jdbc driver called 'pg73jdbc2ee.jar.zip'
that I got from the Postgresql java website.
The driver loads up OK and appears in the client as 
active. I can connect to the database without any
problems.
In the client GUI I can view everything under the
'Objects' tab such as table content, table columns, 
primary keys, views, etc. If I click on 'Content' for 
any given table I get an instant list of all the rows.
However the SQL tab is not working. I can type in
any simple select statement (select * from <tablename>;)
for the same table for which I just viewed the content 
and nothing happens at all. 
No list, no new tab, nothing. I'm not a java expert, so 
I would appreciate any help on how to try and 
troubleshoot this.

thanks
 
Denis
 _________________________________________________________
| Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany |
| Tel: +49 89 2013672                 Fax: +49 89 2022875 |
|_________________________________________________________|

 

[Squirrel-sql-users] Object tree displays OK, but SQL commands won't exececute

[Denis G. <dgr...@we...>]

Hi folks,

I hope someone may be able to throw some light on the 
following odd behaviour. I have a postgres 7.3.2 
installation on Solaris9 that I want to access from 
Windows PCs using the squirrel 1.1-final client.
The windows version is Windows2000 Professional/SP3.
The java version on the PCs is:
"Java(TM) 2 Runtime Environment, Standard Edition 
 (build 1.3.0-C)"
I am using a jdbc driver called 'pg73jdbc2ee.jar.zip'
that I got from the Postgresql java website.
The driver loads up OK and appears in the client as 
active. I can connect to the database without any
problems.
In the client GUI I can view everything under the
'Objects' tab such as table content, table columns, 
primary keys, views, etc. If I click on 'Content' for 
any given table I get an instant list of all the rows.
However the SQL tab is not working. I can type in
any simple select statement (select * from <tablename>;)
for the same table for which I just viewed the content 
and nothing happens at all. 
No list, no new tab, nothing. I'm not a java expert, so 
I would appreciate any help on how to try and 
troubleshoot this.

thanks
 
Denis
 _________________________________________________________
| Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany |
| Tel: +49 89 2013672                 Fax: +49 89 2022875 |
|_________________________________________________________|

[Squirrel-sql-users] RE: Squirrel-sql-users digest, Vol 1 #82 - 4 msgs

[Ruffin B. <Ruf...@Bl...>]

> Try upgrading to 1.4.1_02 (or downgrading to 1.4.0_x).  There=20
> have been reports=20
> that bugs in Java 1.4.1 has caused similar problems with=20
> other Java applications=20
> (apparently laptops were affected more than others -- I'm not=20
> sure why), and I=20
> have recently seen a report that 1.4.1_02 seems to be better behaved.

Yeehaw!  Works!  Hopefully this means my tempermental machine back home =
will be less tempermental as well.

Thanks,

Ruffin Bailey

Re: [Squirrel-sql-users] Lock-ups on Win2k?

[<jay...@ya...>]

Hi,

I too faced the same problem in my new laptop which had java 1.4.1_01
and had posted the problem here.

The problem is attributed to a bug in JRE 1.4.1 + ATI RADEON video
driver. More details about this bug could be found at
http://developer.java.sun.com/developer/bugParade/bugs/4713003.html

edit the squirrel startup script and pass the following startup
parameter to java:
-Dsun.java2d.noddraw=true

jayanand.


 --- Maury Hammel <mh...@cr...> wrote: > Ruffin:
> 
>  > Every time I close SQuirreL (1.1final1) on my laptop (an IBM
> ThinkPad R32 with
>  > Win2k), my cursor starts moving awfully slow and all other
> interactions with
>  > the OS stop (no alt-tab, not even ctrl-alt-del does anything). 
> Eventually the
>  > cursor will lock.
> 
> [snip]
> 
>  > I'm using java 1.4.1_01, Standard Edition.
> 
> Try upgrading to 1.4.1_02 (or downgrading to 1.4.0_x).  There have
> been reports 
> that bugs in Java 1.4.1 has caused similar problems with other Java
> applications 
> (apparently laptops were affected more than others -- I'm not sure
> why), and I 
> have recently seen a report that 1.4.1_02 seems to be better behaved.
> 
> 
> Maury...
> -- 
> 
> Maury Hammel
> Cronus Technologies Inc.
> 
> http://www.cronustech.com
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: ValueWeb: 
> Dedicated Hosting for just $79/mo with 500 GB of bandwidth! 
> No other company gives more support or power for your dedicated
> server
> http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users 

__________________________________________________
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer

Re: [Squirrel-sql-users] Lock-ups on Win2k?

[Maury H. <mh...@cr...>]

Ruffin:

 > Every time I close SQuirreL (1.1final1) on my laptop (an IBM ThinkPad R32 with
 > Win2k), my cursor starts moving awfully slow and all other interactions with
 > the OS stop (no alt-tab, not even ctrl-alt-del does anything).  Eventually the
 > cursor will lock.

[snip]

 > I'm using java 1.4.1_01, Standard Edition.

Try upgrading to 1.4.1_02 (or downgrading to 1.4.0_x).  There have been reports 
that bugs in Java 1.4.1 has caused similar problems with other Java applications 
(apparently laptops were affected more than others -- I'm not sure why), and I 
have recently seen a report that 1.4.1_02 seems to be better behaved.


Maury...
-- 

Maury Hammel
Cronus Technologies Inc.

http://www.cronustech.com

[Squirrel-sql-users] Lock-ups on Win2k?

[Ruffin B. <Ruf...@Bl...>]

Every time I close SQuirreL (1.1final1) on my laptop (an IBM ThinkPad =
R32 with Win2k), my cursor starts moving awfully slow and all other =
interactions with the OS stop (no alt-tab, not even ctrl-alt-del does =
anything).  Eventually the cursor will lock.

SQuirreL is about the only Java app I use daily on my work machines, but =
I've tried a few trivial examples without issue and JEdit works just =
fine.  Closing with Ctrl-Q, the "x" button on the window, or closing the =
console that's opened SQuirreL will all cause the same lock-up.  This =
happens whether I start up with the *.bat or by double-clicking the =
*.jar.  It seems to only happen after I've opened a connection to a =
datasource.

I'm using java 1.4.1_01, Standard Edition.

As a random red herring, occasionally my Gateway laptop at home will =
lock up when I close Eclipse and/or some other Java apps I've written.  =
I do not use SQuirreL at home, preferring to leave the rdbms work at =
work for the most part!  ;^)

SQuirreL works fine on my tower at work, fwiw, so this is a relatively =
strange error that I can't quite debug.  If anyone's seen anything =
similar, I'd be interested to hear what's what.  If somebody has things =
working on an IBM R32 with 1.4.1_01, please lemme know!

Thanks,

Ruffin Bailey

[Squirrel-sql-users] SQuirreL 1.1 and JDK 1.4

[Colin B. <col...@te...>]

Now that Apple has finally released Java 1.4 for OS X, all the platforms
that SQuirreL runs on have Java 1.4. I'd like to make 1.4.0 the minimum
version of Java required for the next release of SQuirreL.

Are there any objections to this?

--
Colin Bell
http://squirrel-sql.sf.net
 

[Squirrel-sql-users] Re: OS X

[Colin B. <col...@te...>]

My apologies if you have already received this email but it doesn't
appear to have been sent out to the list.

Col

====================================
From  	Colin Bell <col...@bi...>
Date  	Monday, March 31, 2003 12:58 pm
To  	squ...@li...
Subject  	Re: OS X
Hi,

I have some comments here from Lynn Pye who built the OS X installer for
SQuirreL.

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

Hi Colin,

I can help. I noticed the same behavior after I upgraded as well. Apple
didn't so much upgrade as add 1.4.1. Any applications packaged prior to
the arrival of 1.4.1 will, by default, continue to request and use the
1.3.1 VM, unless repackaged or tweaked. The tweak is simple, so I will
provide instructions here which you can pass on, and then we can
discuss whether to provide a repackaged version for 1.4.1.

In OS X, an application is actually a specially named folder with a
special directory tree beneath it. For the package I put together for
SQSC, the install creates a folder named Squirrel SQL Client, in which
several directories are created as well as the actual application.
Right click the application (SQuirrelSQLClient) and select 'Show
Package Contents'. This will open a new Finder window showing a single
folder, 'Contents'. Double click that folder. In this folder, you will
a file named Info.plist. Double click it to open it in the the Property
Editor. Expand the tree until you see an option named 'Java'. Expand
Java. Look for a suboption named JVM. If you see it, it will likely say
'1.3'. Change it to '1.3+', which will look for a minimum VM version of
1.3 and will use the highest version available. This will enable 1.4.1
to be used.

But wait, if you do just this, the next time you launch SQSC, your Dock
icon will become a bland icon rather than the acorn! Apple has
acknowledged this as a bug. To avoid this problem, expand the suboption
under Java called 'Properties'. One option will be named
'com.apple.mrj.application.apple.menu.about.name'. Remove it. If you
have already "lost" your Dock icon, you will have to remove it from the
Dock and re-add it to get your icon back to normal.

 

[Squirrel-sql-users] Re: Squirrel-sql-users digest, Vol 1 #80 - 2 msgs

[Ruffin B. <ru...@co...>]

On Thursday, March 27, 2003, at 04:06 PM, 
squ...@li... wrote:

> I'm not using Mac OS X here, but after upgrading to jdk1.4.1 under 
> Linux
> (SuSE8.1), I had to manually alter the shell script which starts 
> SQuirreL.

If you find this is the culprit, SQuirreL must be doing something 
slightly odd.  OS X is supposed to have a location to the VM aliased 
that changes as you upgrade VM versions.  There are folders to the 
individual VMs in case you, for some reason, wanted to explicitly use 
one or the other, but everything should point to the "generic" location 
by default.

You might try the Apple Java list if things stay confusing: 
http://www.lists.apple.com/mailman/listinfo/java-dev

Ruffin Bailey

Re: [Squirrel-sql-users] Use JDK1.4.1 on Mac OS X

[Patric S. <pat...@iw...>]

I'm not using Mac OS X here, but after upgrading to jdk1.4.1 under Linux 
(SuSE8.1), I had to manually alter the shell script which starts SQuirreL.

Right at the start of the file (named "squirrel-sql.sh" in the directory 
"SQuirreL SQL Client"), there is an option which on my system now states
"[ /usr/lib/java/jre ] && JAVA=/usr/lib/java/jre/bin/java || JAVA=java".

I had to change the part after "JAVA=" and (if i remember correctly) the 
part within the [...] at the beginning of the line to "/usr/lib/java" , 
which is the path to my actual jdk. SQuirreL now says that it is running 
under JDK1.4.1.

I really don't know, if the environment for SQuirreL under Mac OS X is 
even slightly similar to that under Linux, but perhaps I could give a 
hint in the right direction :-)

Patric Schirrmann
pat...@iw...

[Squirrel-sql-users] Use JDK1.4.1 on Mac OS X

[David W S. <dav...@ho...>]

I am now using the Mac OS X version but it seems to be using JDK1.3 instead
of the JDK1.4.1 I have updated to on my Mac.  Any idea on how to force it to
use the 1.4.1 JDK?

David Sica
dav...@ho...

Re: [Squirrel-sql-users] graphing plugin

[Niall W. <wh...@gt...>]

Okay,

	Ok, thanks for that tip. I will try to set myself in the next 
couple of weeks and then see about writing some code.

Niall

On Wed, 12 Mar 2003, John K. Watson wrote:

> I strongly recommend using JFreechart to assist with creating the 
> charts.  It should be *very* easy to make it work, as JFreechart does 
> all the hard work for you.   http://www.object-refinery.com/jfreechart/
> 
> 	John
> 
> On Wednesday, Mar 12, 2003, at 18:50 US/Pacific, Colin Bell wrote:
> 
> > Hi,
> >
> >> Is this something which is planned? If not, I could even be
> >> coerced into
> >> trying it myself but I am pretty new to both JDBC and the Java Swing
> >> libraries so I would be worried about the buginess of the code I would
> >> produce.
> >
> > Consider this a coercion :-)
> >
> > Its not something I have planned (or even thought of) so if you are
> > interested then go for it.
> >
> > Don't worry about being unfamilar with Swing/JDBC, Squirrel was my
> > method of learning Swing which explains some of the quality of the 
> > code :-(
> >
> > Any questions you have just post them to the developers list
> > http://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> >
> > Because of past experiences with spam all the Squirrel lists allow
> > posting by subscribers only.
> >
> > I look forward to seeing what you come up with.
> >
> > --
> > Colin Bell
> > http://squirrel-sql.sf.net
> >
> > ----- Original Message -----
> > From: Niall Whelan <wh...@gt...>
> > Date: Wednesday, March 12, 2003 2:25 pm
> > Subject: [Squirrel-sql-users] graphing plugin
> >
> >> Hello.
> >>
> >> This is great software which you have written.
> >>
> >> I see from the lists that it seems to be open season on suggesting new
> >> features and enhancements. One idea for a plugin which I would
> >> find useful
> >> in my applications is the ability to graph the results of an SQL
> >> query.This obviously only makes sense if at least one of the
> >> columns returned is
> >> numerical.
> >>
> >> Some sort of a wizard that would query for the x axis and the y
> >> axis and
> >> would complain if the y axis was not numerical. The x axis could be
> >> non-numerical since it can make sense to graph a stock price
> >> versus dates
> >> or to graph grades versus student_name, for example.
> >>
> >> Is this something which is planned? If not, I could even be
> >> coerced into
> >> trying it myself but I am pretty new to both JDBC and the Java Swing
> >> libraries so I would be worried about the buginess of the code I would
> >> produce.
> >>
> >> Niall
> >>
> >>
> >> -- 
> >> Niall D. Whelan
> >>
> >>
> >>
> >> -------------------------------------------------------
> >> This SF.net email is sponsored by:Crypto Challenge is now open!
> >> Get cracking and register here for some mind boggling fun and
> >> the chance of winning an Apple iPod:
> >> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> >> _______________________________________________
> >> Squirrel-sql-users mailing list
> >> Squ...@li...
> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >>
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by:Crypto Challenge is now open!
> > Get cracking and register here for some mind boggling fun and
> > the chance of winning an Apple iPod:
> > http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

-- 
Niall D. Whelan

Re: [Squirrel-sql-users] graphing plugin

[John K. W. <jo...@sl...>]

I strongly recommend using JFreechart to assist with creating the 
charts.  It should be *very* easy to make it work, as JFreechart does 
all the hard work for you.   http://www.object-refinery.com/jfreechart/

	John

On Wednesday, Mar 12, 2003, at 18:50 US/Pacific, Colin Bell wrote:

> Hi,
>
>> Is this something which is planned? If not, I could even be
>> coerced into
>> trying it myself but I am pretty new to both JDBC and the Java Swing
>> libraries so I would be worried about the buginess of the code I would
>> produce.
>
> Consider this a coercion :-)
>
> Its not something I have planned (or even thought of) so if you are
> interested then go for it.
>
> Don't worry about being unfamilar with Swing/JDBC, Squirrel was my
> method of learning Swing which explains some of the quality of the 
> code :-(
>
> Any questions you have just post them to the developers list
> http://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
> Because of past experiences with spam all the Squirrel lists allow
> posting by subscribers only.
>
> I look forward to seeing what you come up with.
>
> --
> Colin Bell
> http://squirrel-sql.sf.net
>
> ----- Original Message -----
> From: Niall Whelan <wh...@gt...>
> Date: Wednesday, March 12, 2003 2:25 pm
> Subject: [Squirrel-sql-users] graphing plugin
>
>> Hello.
>>
>> This is great software which you have written.
>>
>> I see from the lists that it seems to be open season on suggesting new
>> features and enhancements. One idea for a plugin which I would
>> find useful
>> in my applications is the ability to graph the results of an SQL
>> query.This obviously only makes sense if at least one of the
>> columns returned is
>> numerical.
>>
>> Some sort of a wizard that would query for the x axis and the y
>> axis and
>> would complain if the y axis was not numerical. The x axis could be
>> non-numerical since it can make sense to graph a stock price
>> versus dates
>> or to graph grades versus student_name, for example.
>>
>> Is this something which is planned? If not, I could even be
>> coerced into
>> trying it myself but I am pretty new to both JDBC and the Java Swing
>> libraries so I would be worried about the buginess of the code I would
>> produce.
>>
>> Niall
>>
>>
>> -- 
>> Niall D. Whelan
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by:Crypto Challenge is now open!
>> Get cracking and register here for some mind boggling fun and
>> the chance of winning an Apple iPod:
>> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] graphing plugin

[Colin B. <col...@te...>]

Hi,

> Is this something which is planned? If not, I could even be 
> coerced into
> trying it myself but I am pretty new to both JDBC and the Java Swing
> libraries so I would be worried about the buginess of the code I would
> produce.

Consider this a coercion :-)

Its not something I have planned (or even thought of) so if you are
interested then go for it.

Don't worry about being unfamilar with Swing/JDBC, Squirrel was my
method of learning Swing which explains some of the quality of the code :-(

Any questions you have just post them to the developers list
http://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

Because of past experiences with spam all the Squirrel lists allow
posting by subscribers only.

I look forward to seeing what you come up with.

--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: Niall Whelan <wh...@gt...>
Date: Wednesday, March 12, 2003 2:25 pm
Subject: [Squirrel-sql-users] graphing plugin

> Hello.
> 
> This is great software which you have written.
> 
> I see from the lists that it seems to be open season on suggesting new
> features and enhancements. One idea for a plugin which I would 
> find useful
> in my applications is the ability to graph the results of an SQL 
> query.This obviously only makes sense if at least one of the 
> columns returned is
> numerical.
> 
> Some sort of a wizard that would query for the x axis and the y 
> axis and
> would complain if the y axis was not numerical. The x axis could be
> non-numerical since it can make sense to graph a stock price 
> versus dates
> or to graph grades versus student_name, for example.
> 
> Is this something which is planned? If not, I could even be 
> coerced into
> trying it myself but I am pretty new to both JDBC and the Java Swing
> libraries so I would be worried about the buginess of the code I would
> produce.
> 
> Niall
> 
> 
> -- 
> Niall D. Whelan
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open! 
> Get cracking and register here for some mind boggling fun and 
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
 

[Squirrel-sql-users] graphing plugin

[Niall W. <wh...@gt...>]

Hello.

This is great software which you have written.

I see from the lists that it seems to be open season on suggesting new
features and enhancements. One idea for a plugin which I would find useful
in my applications is the ability to graph the results of an SQL query.
This obviously only makes sense if at least one of the columns returned is
numerical.

Some sort of a wizard that would query for the x axis and the y axis and
would complain if the y axis was not numerical. The x axis could be
non-numerical since it can make sense to graph a stock price versus dates
or to graph grades versus student_name, for example.

Is this something which is planned? If not, I could even be coerced into
trying it myself but I am pretty new to both JDBC and the Java Swing
libraries so I would be worried about the buginess of the code I would
produce.

Niall


-- 
Niall D. Whelan

[Squirrel-sql-users] Native OS X Installer Available for 1.1final1

[Colin B. <col...@te...>]

Thanks to Lynn Pye there is now a native installer for
OS X 10.2.x. This will not work with 10.1.x. This has
minor adjustments to use the Aqua LAF and with the
menu bar appropriately positioned.

To install download
osx-squirrel-sql-1.1final1-install.pkg.tar.gz from 
http://sourceforge.net/project/showfiles.php?group_id=28383&release_id=124587
and use StuffIt Expander or equivalent to open the
installer (doubleclicking on the .tar.gz file should do
this). Double click on the .pkg file and the installation
will begin. It is set up with appropriate defaults, so
you should only need to click through to complete
the install. It will be in a folder in /Applications.

--
Colin Bell
http://squirrel-sql.sf.net
 

[Squirrel-sql-users] jEdit Plugin 0.21 Released

[Colin B. <col...@te...>]

Version 0.21 of the jEdit plugin has been released.

This plugin uses the syntax highlighting and other features from the
text control developed for the jEdit text editor (http://www.jedit.org).

The homepage is here http://squirrel-sql.sourceforge.net/ and downloads
can be found at
http://sourceforge.net/project/showfiles.php?group_id=28383&release_id=144237

Bug Fixes
---------
- Fixed NullPointerException when retrieving
  previous queries from the dropdown under JDK1.4.1. 

--
Colin Bell
http://squirrel-sql.sf.net
 

Re: [Squirrel-sql-users] squirrel-sql-1.1 in Win XP Pro ?

[<jay...@ya...>]

Thanks for the additional info, Victor.

Earlier I tried the suggestion from Collin.. and that too was working
fine.

Thanks for all your help.

Regards,
Jayanand.

 --- vic...@q-... wrote: > Colin Bell wrote:
> >>I had been using Squirrel on Win NT 4.0 and Win 2000 for the past 8
> >>months. Recently I installed it on Win XP Pro.
> >>
> >>Using the desktop shortcut I am able to run the application. But
> >>when I close it, the whole OS hangs. I was able to reproduce this
> 3-4 times
> >>repeatedly. Squirrel, being an OS independent application, should
> not
> >>ideally cause this.
> >>
> >>My JAVA_HOME points to my j2sdk1.4.1_01 installation.
> >>
> > Sounds like a java bug supposedly fixed in the not yet released
> 1.4.1_02
> > http://developer.java.sun.com/developer/bugParade/bugs/4713003.html
> 
> It is definitely that bug. Stroke me too after I updated my video
> drivers, *extreme showstopper* which puzzled me two weeks long.
> 
> > Updating your video drivers may help or try passing
> > -Dsun.java2d.noddraw=true to the Java executable.
> 
> Alternative command line option: "-Dsun.java2d.d3d=false", this
> disables *only* the Direct3D optimizations (the ones which conflict
> with the ATI drivers) thus still allowing some other optimizations.
> "-Dsun.java2d.noddraw=true" disables the *whole* DirectDraw,
> including Direct3D.
> 
> --
> Freundliche Grüße/Kind Regards       Victor Ott
> Salutari cordiale/Saludos cordiales  victor.ott at q-dsl dot de
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SlickEdit Inc. Develop an edge.
> The most comprehensive and flexible code editor you can use.
> Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day
> Trial.
> www.slickedit.com/sourceforge
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users 

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

Re: [Squirrel-sql-users] squirrel-sql-1.1 in Win XP Pro ?

[<vic...@q-...>]

Colin Bell wrote:
>>I had been using Squirrel on Win NT 4.0 and Win 2000 for the past 8
>>months. Recently I installed it on Win XP Pro. 
>>
>>Using the desktop shortcut I am able to run the application. But 
>>when I close it, the whole OS hangs. I was able to reproduce this 3-4 times
>>repeatedly. Squirrel, being an OS independent application, should not
>>ideally cause this.
>>
>>My JAVA_HOME points to my j2sdk1.4.1_01 installation.
>>
> Sounds like a java bug supposedly fixed in the not yet released 1.4.1_02
> http://developer.java.sun.com/developer/bugParade/bugs/4713003.html

It is definitely that bug. Stroke me too after I updated my video drivers, *extreme showstopper* which puzzled me two weeks long.

> Updating your video drivers may help or try passing
> -Dsun.java2d.noddraw=3Dtrue to the Java executable.

Alternative command line option: "-Dsun.java2d.d3d=3Dfalse", this disables *only* the Direct3D optimizations (the ones which conflict with the ATI drivers) thus still allowing some other optimizations. "-Dsun.java2d.noddraw=3Dtrue" disables the *whole* DirectDraw, including Direct3D.

-- 
Freundliche Gr=FC=DFe/Kind Regards       Victor Ott
Salutari cordiale/Saludos cordiales  victor.ott at q-dsl dot de

Re: [Squirrel-sql-users] squirrel-sql-1.1 in Win XP Pro ?

[Colin B. <col...@te...>]

> I had been using Squirrel on Win NT 4.0 and Win 2000 for the past 8
> months. Recently I installed it on Win XP Pro. 
> 
> Using the desktop shortcut I am able to run the application. But 
> when I
> close it, the whole OS hangs. I was able to reproduce this 3-4 times
> repeatedly. Squirrel, being an OS independent application, should not
> ideally cause this.
> 
> My JAVA_HOME points to my j2sdk1.4.1_01 installation.
>

Sounds like a java bug supposedly fixed in the not yet released 1.4.1_02
http://developer.java.sun.com/developer/bugParade/bugs/4713003.html

Updating your video drivers may help or try passing
-Dsun.java2d.noddraw=true to the Java executable.

--
Colin Bell
http://squirrel-sql.sf.net

 

[Squirrel-sql-users] squirrel-sql-1.1 in Win XP Pro ?

[<jay...@ya...>]

Hi All,

I had been using Squirrel on Win NT 4.0 and Win 2000 for the past 8
months. Recently I installed it on Win XP Pro. 

Using the desktop shortcut I am able to run the application. But when I
close it, the whole OS hangs. I was able to reproduce this 3-4 times
repeatedly. Squirrel, being an OS independent application, should not
ideally cause this.

My JAVA_HOME points to my j2sdk1.4.1_01 installation.

Just wanted to check with you all if any one else has noticed this
before.

Thanks for any help.

Regards,
Jayanand.

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

Re: [Squirrel-sql-users] X-Window Cut and Paste

[Colin B. <col...@te...>]

Hi Michael,

> Again I mis-spoke (this is getting embaressing). All the copy-paste
> issues with the edit window are solved with the latest jedit plug-
> in. I
> still cannot seem to copy data from the results window into a cut
> buffer.

Works for me in Mandrake9, Gnome 2 and the Javasoft 1.4.0 VM. There were
issues with Java copy and paste in X back in JDK1.3. Which version of
the Java VM are you using?

--
Colin Bell
http://squirrel-sql.sf.net


 

Re: [Squirrel-sql-users] X-Window Cut and Paste

[Michael H. <mh...@ny...>]

Again I mis-spoke (this is getting embaressing). All the copy-paste
issues with the edit window are solved with the latest jedit plug-in. I
still cannot seem to copy data from the results window into a cut
buffer.

Any suggestions, gratefully received...

On Wed, 29 Jan 2003 11:44:55 -0500
Michael Hieb <mh...@ny...> wrote:

> Please ignore, an upgrade of the jedit plugin fixed the problem...
> 
> On Wed, 29 Jan 2003 11:36:35 -0500
> Michael Hieb <mh...@ny...> wrote:
> 
> > It seems SQuirrel does not use the X cut-paste buffer anytine I cut
> > from SQuirrel I can only paste back into SQuirrel and not into any
> > other window. Conversely, I can cut from any other window and paste
> > into any other window, but not into SQuirrel.
> > 
> > Did I miss something when I configured SQuirrel. Copy-paste
> > functionality would vastly improve my SQuirrel experience...
> > 
> > Michael
> > 
> > 
> > -------------------------------------------------------
> > This SF.NET email is sponsored by:
> > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> > http://www.vasoftware.com
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
> 
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> http://www.vasoftware.com
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] X-Window Cut and Paste

[Michael H. <mh...@ny...>]

Please ignore, an upgrade of the jedit plugin fixed the problem...

On Wed, 29 Jan 2003 11:36:35 -0500
Michael Hieb <mh...@ny...> wrote:

> It seems SQuirrel does not use the X cut-paste buffer anytine I cut
> from SQuirrel I can only paste back into SQuirrel and not into any
> other window. Conversely, I can cut from any other window and paste
> into any other window, but not into SQuirrel.
> 
> Did I miss something when I configured SQuirrel. Copy-paste
> functionality would vastly improve my SQuirrel experience...
> 
> Michael
> 
> 
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> http://www.vasoftware.com
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users