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

Re: [Squirrel-sql-users] Connection Timeout/Drop

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

Hi Ethan,

> I am attempting to connection to a remote oracle database over the 
> internetand through the remote network's firewall.  I can 
> establish a connection,
> but because I am going through the remote network's fire wall I 
> have only
> one minute of idle time before the connection is terminated.
> 
> I can ssh through the remote network's fire wall and the timeout 
> does not
> occur because my local ssh client(Putty) sends keep alive packets 
> every 15
> seconds.
> 
> Is there a way to keep my connection in squirrel alive 
> automatically using
> some sort of sql heartbeat?  Or is there a way I can make squirrel 
> use the
> connection established by my local ssh client?

Currently in Squirrel theres no way to have a "heartbeat" sent to the
server, it would be possible for somebody to write a plugin to do this.

The connection to the database is under the control of the JDBC driver
that you are using so you'd need to check the documentation for your 
driver to see if it is possible to piggyback your existing ssh
connection.

Although it doesn't solve your problem there is a "Reconnect" option
on the session menu which will attempt to close the existing connection
and open a new one using the user name and password that you used to
establish the initial connection. This would be more convenient than
going back to the aliases list and reslogging on.

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


 

[Squirrel-sql-users] Connection Timeout/Drop

[Knepp, E. <eK...@c-...>]

I am attempting to connection to a remote oracle database over the internet
and through the remote network's firewall.  I can establish a connection,
but because I am going through the remote network's fire wall I have only
one minute of idle time before the connection is terminated.

I can ssh through the remote network's fire wall and the timeout does not
occur because my local ssh client(Putty) sends keep alive packets every 15
seconds.

Is there a way to keep my connection in squirrel alive automatically using
some sort of sql heartbeat?  Or is there a way I can make squirrel use the
connection established by my local ssh client?

Thanks,
Ethan

/**
 Ethan Knepp
 Software Engineer
 Broadband Management Solutions, LLC
 http://www.c-cor.net
*/

[Squirrel-sql-users] SQuirreL SQL Client bug fix release 1.1final1

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

Version 1.1final1 has just been released. This is a minor bug fix release=
=20
which addresses two issues:

- Fix for error when displaying
  catalogs/schemas when using
  jTDS 4 and above.
- Fix column privileges display
  for MySQL.

The homepage can be found at http://squirrel-sql.sourceforge.net/ and the
downloads are at
https://sourceforge.net/project/showfiles.php?group_id=3D28383&release_id=
=3D124587

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

Re: [Squirrel-sql-users] Accessing queries stored in text files...

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

Hi Michael,

You need Johans SQL Scripts plugin. This will allow you to save/restore
SQL commands to/from text files as well as generate CREATE TABLE and
INSERT scripts. Check out the plugins page at the SQuirreL site
http://squirrel-sql.sourceforge.net/index.php?page=plugins.html

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

----- Original Message -----
From: Michael Hieb <mh...@ny...>
Date: Friday, November 22, 2002 3:04 am
Subject: [Squirrel-sql-users] Accessing queries stored in text files...

> I tend to keep my fav queries in text files e.g. fav.sql. I can 
> see that
> Squirrel will allow me to dump my session to a text file, but this 
> isn'tquite the same thing. I would like to write out my sql 
> scratchboard and
> read it in later. Did I miss how to do this?
> 
> Other than that everything works like a charm.
> 
> Michael
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
 

[Squirrel-sql-users] Accessing queries stored in text files...

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

I tend to keep my fav queries in text files e.g. fav.sql. I can see that
Squirrel will allow me to dump my session to a text file, but this isn't
quite the same thing. I would like to write out my sql scratchboard and
read it in later. Did I miss how to do this?

Other than that everything works like a charm.

Michael

[Squirrel-sql-users] Accessing queries stored in text files...

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

I tend to keep my fav queries in text files e.g. fav.sql. I can see that
Squirrel will allow me to dump my session to a text file, but I don't
see how to read it back in later (except editor+copy/paste). Did I miss
it?

Other than that everything works like a charm.

Michael

[Squirrel-sql-users] Oppinions on data representation?

[Glenn <gw...@co...>]

Hi folks,

I'm well into the work on making the ContentTab tables editable, and as 
part of that work I'm going to have to deal with a couple of issues of 
how the data is formatted and displayed.

Squirrel's default operation is to display binary data types as
	<Binary>
or
	<Other>
unless the user sets the Session Properties to show those fields as 
Strings, in which case they show something like:
	1001010010

When a table is editable, the "<Binary>" representation cannot be 
directly edited, which means that when you enter a binary field, the 
data would have to automatically switch representations just in case you 
wanted to edit it.  This can be done, but it would be simpler to 
implement and simpler for the user if there was only one representation. 
  An easy way to do this is to remove the options in the Session 
Properties and always display the data in the String form.  So my first 
set of questions are:

	- Does anyone prefer to see "<Binary>" in the field instead of the actual 
data, and if so, why?
	- How upset would you be if we removed the options and set it so that you 
always see the actual data?

The second issue is this.  If I am editing a nullable VARCHAR field and 
I remove all of the characters from the visible display and save it, 
does that mean:
	- set the field to null, or
	- put a zero-length string into the table?
My suggestion is that when you remove all the characters, that means a 
zero-length string, and if you hit the delete key again, the field 
toggles between a zero-length string an a <null>.  Would that work for you?

That raises another thought, which is how to deal with that "Oh #*@%&" 
moment just after you have accidentially touched a field that you did 
not want to change and you don't remember how it looked originally.  Ome 
way might be to have a right-click menu item for "Restore original Cell 
contents", but that may be hard to implement.  Another approach could be 
that when you delete everything from the cell and hit the delete key 
again, the original contents are restored.  With a nullable field, this 
would cycle through the possibilities as follows:
	- delete the data in the cell => the data is zero-length
	- hitting delete key again => <Null>
	- hitting delete key again => original contents of the field
Would this be ok?


Glenn

PS. Sorry for cross-posting, but I haven't seen much activity in the 
user's forum.  I'm not sure if there are folks watching that list who 
are not also on the developer's list, and I wanted to include everyone.

Re: [Squirrel-sql-users] Command line interface?

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

Hi=2C

One of the items on my todo list is the ability to run sql scripts
non-interactively=2C but it will be a while before that gets done as
it will require considerable refactoring of the code=2E

I don=27t know of any other tool that does this but I=27m sure that there=

will be several out there=2E A search on www=2Efreshmeat=2Enet or
www=2Esourceforge=2Enet would be a good starting point=2E

--
Colin Bell
http=3A//squirrel-sql=2Esf=2Enet

----- Original Message -----
From=3A Anke=2ESelig=40gmx=2Enet
Date=3A Tuesday=2C November 12=2C 2002 10=3A22 pm
Subject=3A =5BSquirrel-sql-users=5D Command line interface=3F

=3E Hi=2C
=3E Is there a way to execute an sql-based text file non-interactively =

=3E fromcommand-line using the squirrel-sql client=3F
=3E I=27m very new to this=2C but like it so far=2E I=27ve installed the =
sql =

=3E scripts and
=3E the session script plugins=2C but would like to automate script =

=3E executionnon-interactively after interactive testing=2E If this is =

=3E not foreseen=2C do you know
=3E of a command line based jdbc client I could use instead=3F
=3E =

=3E thanks in advance=2C
=3E Anke
=3E =

=3E -- =

=3E +++ GMX - Mail=2C Messaging =26 more  http=3A//www=2Egmx=2Enet +++
=3E NEU=3A Mit GMX ins Internet=2E Rund um die Uhr f=FCr 1 ct/ Min=2E sur=
fen!

 

[Squirrel-sql-users] Command line interface?

[<Ank...@gm...>]

Hi,
Is there a way to execute an sql-based text file non-interactively from
command-line using the squirrel-sql client?
I'm very new to this, but like it so far. I've installed the sql scripts and
the session script plugins, but would like to automate script execution
non-interactively after interactive testing. If this is not foreseen, do you know
of a command line based jdbc client I could use instead?

thanks in advance,
Anke

-- 
+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen!

[Squirrel-sql-users] SQuirreL SQL Client 1.1final released at last !!!

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

After a year of development the stable version of 1.1 is finally
available. It can be downloaded from
http://sourceforge.net/project/showfiles.php?group_id=28383&release_id=121639

Many thanks to all the people who contributed to this release.

The full change log will be copied up to the website tonight. The major
changes include:

Plugin Architecture Added
-------------------------
SQuirreL now supports plugins. These are applications written in Java
thatrun within SQuirreL. This allows developers to enhance the
functionality of SQuirreL without having to rebuild the SQuirreL
application itself. Some of the plugins that have been written for
SQuirreL include the jEdit plugin, Look and Feel Plugin, MySQL plugin,
Oracle Plugin, Session Scripts plugin, SQL Scripts plugin, and the SQL
Validator plugin.

SQL Execution Enhanced
----------------------
Multiple SQL statements can be executed simultaneoulsy or sequentially.
The results of these queries are now displayed in multiple tabs and
these tabs can be "torn off"

Many more data types are now displayed.

Undo/redo support has been added to the SQL entry area.

Meta data is now available for the results of SQL execution.

Object Tree Enhancements
------------------------
The object tree code has been rewritten and now executes faster.

JDBC Drivers
------------
Multiple jar files (and directories) can now be specified for a JDBC
driver. You can now list the JDBC driver classes within a jar file.

General
-------
The licence for the application has been changed from GPL to LGPL.

SQL execution and object tree expansion now run in separate threads so
that the user interface is still responsive.

Tables can now be sorted by clicking on the column headers. Full column
data in tables can now be displayed in a popup window by double clicking
in the column. 

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

[Squirrel-sql-users] SQuirreL SQL Client 1.1rc2

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

Version 1.1rc2 of SQuirreL SQL Client has been released. This is
intended to be the last release candidate before the stable version of
1.1 is released.

Downloads are here
http://sourceforge.net/project/showfiles.php?group_id=28383&release_id=118650

List of changes:

Enhancements
------------
- Add default catalog selection to popup menu
- Add plugin class path to application dump.
- Allow for some drivers that don't return 'guest'
  as a schema for Microsoft SQL and Sybase.
- Catalogs and Schemas tabs added to the session
  node.
- Catalogs and schemas added to session dump.
- Drivers and Aliases windows can now be closed.

Bug Fixes
---------
- Fix shell script to work with Cygwin.
- Fix NullPointerException when changing output
  type for result sets in New Session Properties
  dialog.
- Fix Copy cmd in tables so that if only a single
  column selected it doesn't put all the rows on one
  line.
- Make tree node refresh work.
- Fix line wrapping in multiple line labels.
- Allow for spaces in %CLASSPATH% in
  squirrel-sql.bat (again).
- Save and restore current catalog, transaction
  isolation and auto-commit settings when
  executing the Session/Reconnect commmand.

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

RE: [Squirrel-sql-users] Help with Informix needed

[<And...@ho...>]

This works for me at least:

jdbc:informix-sqli://host:1540/db:informixserver=3Difxserver

/Anders

-----Original Message-----
From: mihha [mailto:mi...@in...]
Sent: den 24 oktober 2002 16:22
To: squ...@li...
Subject: [Squirrel-sql-users] Help with Informix needed


I am able to connect to my Informix database with following code:

    java.sql.Connection conn;

    Class.forName("com.informix.jdbc.IfxDriver");
    conn =3D
java.sql.DriverManager.getConnection("jdbc:informix-sqli://disko:1540/ht
racu
ni:INFORMIXSERVER=3Ddiskotcp;user=3D<user>;password=3D<password>");

Can someone explain me what I have to put in URL textbox of alias for my
connection. I have tried everything but
all I get is message box with java.lang.NullPointerException error

Thanks,
Igor



-------------------------------------------------------
This sf.net email is sponsored by: Influence the future=20
of Java(TM) technology. Join the Java Community=20
Process(SM) (JCP(SM)) program now.=20
http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javav
ote
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Help with Informix needed

[mihha <mi...@in...>]

I am able to connect to my Informix database with following code:

    java.sql.Connection conn;

    Class.forName("com.informix.jdbc.IfxDriver");
    conn =
java.sql.DriverManager.getConnection("jdbc:informix-sqli://disko:1540/htracu
ni:INFORMIXSERVER=diskotcp;user=<user>;password=<password>");

Can someone explain me what I have to put in URL textbox of alias for my
connection. I have tried everything but
all I get is message box with java.lang.NullPointerException error

Thanks,
Igor

[Squirrel-sql-users] Running SQuirreL on Windows with spaces in paths

[Brian T. <br...@cr...>]

Hi, Just wanted to save people a bit of time if they're trying to run
SQuirreL and they have spaces in their JAVA_HOME and/or CLASSPATH variables.
Just add quotes around those sections (see below) in your batch file.

"%JAVA_HOME%\bin\java" -cp
"squirrel-sql.jar;lib\jdom-b4.jar;lib\xerces.jar;lib\skinlf.jar;%CLASSPATH%"
com.bigfoot.colbell.squirrel.Main

It's obvious once you realize what's wrong, but I spent a long time looking
for other problems. Cheers, Brian

Re: [Squirrel-sql-users] Re: First impressions

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

> Another possible option is to have an options to 'spawn' a MDI 
> child window
> into a separate SDI window.  I remember seeing an application (the 
> nameescapes me at the moment) that allowed you to do such a thing 
> (i.e. take the
> contents of a JInteralFrame and dump them into a JFrame).

Thats a pretty good idea and would be simpler than having SDI/MDI modes.
I'll look at it for 1.2.

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

 

[Squirrel-sql-users] Re: First impressions

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

>>>- I hate the MDI interface/subwindows. I usually only work with one
>>>database at once - I only want that window up. Even when I do work with
>>>two databases, I'd prefer they be entirely separate windows. The connect
>>>stuff could be a dialog box that pops up when you first start the
>>>program and when you hit ctrl-N or something (new connection).
>>
>> As I said recently to somebody, this is a religious issue. I personally
like
>> the MDI interface and hate the SDI one, this was the main reason I
stopped
>> using Netbeans. A possibility for the future when the code has been
cleaned
>> up would be making it an option as it is in the current version of
Netbeans.
>> You specify whether you want an SDI or an MDI interface.
>
> Okay, I'm going to take a shot at trying to convince you. ;) I'd be
> happy with a preference (though I'm likely to disagree with you about
> which the default should be). Please forgive my long-windedness...

Another possible option is to have an options to 'spawn' a MDI child window
into a separate SDI window.  I remember seeing an application (the name
escapes me at the moment) that allowed you to do such a thing (i.e. take the
contents of a JInteralFrame and dump them into a JFrame).

> I think SQuirreL is in the second category: only one window necessary to
> do work, multiple connections can be thought of pretty independently, so
> should be in fully independent windows. The grouping of resultsets

I'd agree with Scott here.  As a DBA/developer, I am often connected to
multiple databases at the same time.  I'd like to have a separate window for
each connection.  As well, I use virtual-desktops, and having each
connection in a separate window allows me move different connections to
different desktops.

> Anyway, thanks for your responses. I'm encouraged and very much looking
> forward to ditching Oracle's various SQL-Plus, SQL Worksheet, and SQL
> Scratchpad things. (Each version of each one has completely different
> deficiencies, any of which I hate. Ergh.)

I'm in the same boat.  I'd like to dump Oracle's stuff.  I'm still looking
for the tool to replace them.


Maury...

--
Maury Hammel
Cronus Technologies Inc.

http://www.cronustech.com

[Squirrel-sql-users] SQuirreL SQL Client 1.1rc1 released

[Colin B. <Col...@as...>]

SQuirreL SQL Client 1.1rc1 released

Version 1.1rc1 is now available. Downloads are
available at
http://sourceforge.net/project/showfiles.php?group_id=28383&release_id=11362
9

This is the first release candidate for
1.1. There should be no changes other
than bug fixes and documentation
updates for the stable version.

The following plugins have also been
updated to work with this version of
SQuirreL.

jEdit 0.17, MySQL 0.11, Oracle 0.11,
SessionScript 0.12, SQLScripts 0.21,
and SQL Validator 0.12.

The changes in this release include:

Enhancements
------------
- Information windows (such as Help) can now be moved
  outside of the main window.
- Add home toolbar button to the HTML Viewer.
- Fix Refresh in HtmlViewer.
- Change icons for commit/rollback. The old icons were
  too similar and confused people.
- Add Proxy settings to Application Preferences.
- Add file sizes into SQuirreL Logs dropdown.
- Sort the driver names in dropdown box in a
  case-insensitive manner.
- Make all windows resizeable.
- Add Refresh button to HTLM Viewer toolbar.
- Add FAQ to the Help menu.
- Added "Install Default Drivers" menu option which will
  copy driver definitions from the default drivers file to
  the drivers list.
- Add SAPDB, DB2 and PointBase to default drivers.
- Add HSQL to list of default drivers (Glenn Griffin).
- Cleanup example URLs for many of the default drivers (Glenn Griffin).
- Add toolbar to HTML Viewer with back, forward and close buttons.
- Documentation updated.
- Allow Squirrel to be run from directories other than the current
  directory (Tim Shadel).
- Treat Types.OTHER columns as strings when displaying data.
- Add plugins location to plugin summary dialog.
- Add plugins location to application dump.
- Create Windows shortcut in installer.
- Make shell script executable in installer.
- Add icons for program shortcuts (Greg Mackness).
- Add an icon to the main window (Greg Mackness).
- The name of the item selected in the object tree will
  be displayed in the statusbar.
- Remove unnecessary borders on UI components.
- Add jTDS to list of default drivers.
- The "Start of line comment" characters can now be
  specified in preferences instead of just using '--'.

Bug Fixes
---------
- Reload Metal Look and Feel when first loading
  SQuirreL so that the "Blue" theme is used.
- Position focus to the text area when first displaying
  the HTML viewer window.
- Stop driver maintenance window from resizing when jars
  added/removed.
- Improve error handling when loading drivers and aliases.
- Incorrect error message was displayed in View Help
  command (Glenn Griffin).
- Fix Nullpointer exception in HTML viewer under JDK1.3.
- CLOB/BLOB columns weren't handled correctly on metadata and
  Content tabs.
- The line/column number displayed for the SQL entry area
  now starts from 1,1 not 0,0
- Make multiple line label use the same font as static text controls not
  editable text controls.
- Links in the Help file now work (Victor Ott).
- Fix deadlock when viewing logs.
- Add missing "contributors" file for About Box.

Plugin API
----------
- Move metadata methods to metadata classes.

Other
-----
- Don't display icons in menus.
- Cleanup ResultSetMetaData handling.
- Make the installation window resizeable.


jEdit Plugin Changes
====================
- "TRIGGER" is now recognized as an SQL keyword.

SQL Validator Plugin Changes
============================
- Add Connect and Disconnet options to the menus system.
- Move validation menu options to their own hierarchical menu
  off the Session menu.
- Only display logon menu and open a session to the web service
  if a session doesn't already exist.
- Make login dialog resizeable.
- Cleaned up the preference panels.
- Updated for SQuirrel SQL Client 1.1rc1.

Re: [Squirrel-sql-users] First impressions

[Scott L. <sl...@sl...>]

Colin Bell wrote:
>>- I hate the MDI interface/subwindows. I usually only work with one
>>database at once - I only want that window up. Even when I do work with
>>two databases, I'd prefer they be entirely separate windows. The connect
>>stuff could be a dialog box that pops up when you first start the
>>program and when you hit ctrl-N or something (new connection).
> 
> As I said recently to somebody, this is a religious issue. I personally like 
> the MDI interface and hate the SDI one, this was the main reason I stopped 
> using Netbeans. A possibility for the future when the code has been cleaned 
> up would be making it an option as it is in the current version of Netbeans. 
> You specify whether you want an SDI or an MDI interface. 

Okay, I'm going to take a shot at trying to convince you. ;) I'd be 
happy with a preference (though I'm likely to disagree with you about 
which the default should be). Please forgive my long-windedness...

I agree that subwindow MDIs are better in one class of applications - 
ones like Netbeans, Photoshop, PageMaker, and Oracle Forms/Reports where 
you need a lot of closely related windows for one task.Typically there's 
a main document window and a bunch of tool palettes. You only want to 
show/hide them together.

In all other cases, I hate the conventional subwindow form of MDI. 
Usability research tends to back me up here - that's why its deprecated 
in KDE, most new Microsoft products (Office), etc.

I think SQuirreL is in the second category: only one window necessary to 
do work, multiple connections can be thought of pretty independently, so 
should be in fully independent windows. The grouping of resultsets 
within a connection with tabs (another form of MDI, I'd say) is 
completely appropriate for several reasons:

- I potentially want several open at once
- They're very related
- I don't want the hassle of managing their windows
- Only being able to see one at a time is not a problem, especially 
since switching is very quick.

In SQuirreL's current state, it pops up a large window and the 
connection only uses part of it. You go to maximize it and find the 
subwindow buttons are completely unlike native windows, adding a moment 
of confusion. (Really, even when I've seen such things a million times, 
it still slows me down.) Once you maximize, there's a few extra lines 
taking up screen real estate: the main toolbar, the subwindow frame, and 
the main status bar. (I realize two of those can be turned off. I'm 
talking about first use only.) If you shrink the main window, the 
subwindow doesn't shrink with it. You have to scroll over and fix it.

My ideal: you start SQuirreL. You get the driver manager/database 
aliases stuff dialog stuff, open a new connection. A single window pops 
up. If you want a new connection, you do "New Connection" in the menu 
and the same thing is repeated independently. For me, this is a lot 
simpler in the common case of one connection at a time. And I'd argue 
that it's still simpler for multiple connections at a time.

> Sounds like something that could be put into the Oracle plugin. Its also not 
> something I'd probably do myself (I'm no Oracle expert) so if you are 
> interested in enhancing Squirrel this could be a good starting point. 
> Squirrel is starting to be used in a lot of Oracle shops and theres a lot of 
> oracle specific functionality that could be added to the plugin. Let me know 
> if you are interested.

Hmm. I have had this inexplicable urge to do GUI programming lately. And 
my first hunch is that it would be a lot easier for me to start here 
than restructing any of the existing stuff and trying not to break 
plugins that use all those listeners. So maybe I will.

Anyway, thanks for your responses. I'm encouraged and very much looking 
forward to ditching Oracle's various SQL-Plus, SQL Worksheet, and SQL 
Scratchpad things. (Each version of each one has completely different 
deficiencies, any of which I hate. Ergh.)

-- 
Scott Lamb

Re: [Squirrel-sql-users] First impressions

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

Hi Scott,

> First, I think current CVS is ready, as it's a definite improvement ove=
r
> the last released version for me. When I tried 0.9.6, it took a very
> long time to connect (I think it was trying to load all of the metadata
> right away, correct? I'm connecting over the Internet to a large Oracle
> database, so that's not a good idea.) It's better now. Also, I think th=
e
> old one leaked cursors - I got maximum cursors exceeded messages when
> browsing metadata.

Theres a release candidate coming out in the next couple of days (when I =
get=20
the time). Apart from finishing the documentation and bug fixing this sho=
uld=20
be the same as the final release.

> That doesn't mean I think it's perfect, though. I've got some
> problems/interface comments/feature requests:

Unfortunately its never going to be perfect, but the more feedback we get=
 the=20
closer we can make it :-)

> - Typing "./squirrel-sql.sh" doesn't work for me right in the dist
> directory unless I set INSTALL_PATH=3D`pwd`. Was this supposed to be
> substituted in the ant file? If so, it didn't work.

The Izpack installer sets it up during the installation. Its done this wa=
y so=20
that the script can be run when the working directory isn't the Squirrel=20
directory.

> - Ideally, just a "java -jar squirrel-sql.jar" would work, so I wouldn'=
t
> need the shell script/batch file at all. I think you can have classpath=
s
> in the meta-inf. If not, the other jars would have to be included in
> that one. This would be better because batch files/java pop up
> unnecessary terminal windows on Windows. Clicking on the jar file
> directly launches javaw, which doesn't have that problem.

The squirrel-sql.jar file has been executable for the last few betas. Tak=
e a=20
look in the supplied batch file for other ways of executing Squirrel. The=
=20
only issue with using the executable jar file is you don't get the conten=
ts=20
of the %CLASSPATH% variable appended to the Squirrel class path and so yo=
u=20
don't have access to any JDBC drivers in the %CLASSPATH%.

>
> - It's slow when browsing metadata. It would be nice if it cached more
> (column-level information particularly) so looking at it a second time
> would be quick.

Info for the object tree is cached while the object is selected. I.E. if =
a=20
table is selected and you display the column info, then the primary keys =
and=20
then return to the column info the second display of the column info is f=
rom=20
a cache and is much faster. It was a deliberate design decision on my par=
t so=20
that changes to the object would be seen the next time you displayed it. =
I=20
assumed that retrieving the metadata for a single tab would be a relative=
ly=20
quick operation. It never occured to me that people would be connecting t=
o=20
databases across slow connections. I'll make a change in 1.2 to cache the=
=20
metadata when its first displayed and leave it cached until the object tr=
ee=20
is refreshed.

> - IMHO auto commit should be off by default. Or at least there should b=
e
> a preference for it per-database alias, not per-session, so I don't nee=
d
> to toggle it every time I connect.

In the SQL tab on the New Session properties dialog (File/New Session=20
Properties) you can specify whether new sessions default to autocommit on=
 or=20
off.

>
> - I'm glad to see it doesn't block waiting for a database response. Thi=
s
> was what started me looking for an alternative to the Oracle 8i SQL
> Worksheet to begin with. Killing the program when I forgot a join
> condition was not pleasant.

IMHO one of the best enhancements to 1.1 over 1.0 was Johan Compagners=20
threading code. Its made Squirrel much more useable.

> - The metadata views show a lot of useless columns. Ones that are
> consistently <null>: schema on PostgreSQL (even 7.3b1 - I guess they
> haven't updated their JDBC drivers), table_cat on Oracle. And some
> things not really intended for humans (data_type; the numbers mean
> nothing to me; I just want type_name). If these all went away, it would
> be easier to find what I'm looking for.

Originally I only showed the _important_ columns in metadata but a couple=
 of=20
people were getting SQL errors when retrieving only some of the columns. =
The=20
quick fix was to retrieve all columns but I wasn't able to track the prob=
lem=20
down. It was one of those intermittent issues. Longer term I intend to ha=
ve a=20
GUI whereby you can select the columns (and the sequence) you want for ea=
ch=20
metadata tab. Shorter term I could put up a session property called somet=
hing=20
like "Only show important metadata" true/false. - If you could come up wi=
th a=20
better name for it I might put it in 1.1

>    * I tend to work with a couple queries at once and refine them. It'd
> be nice if a new tab replaced the current one unless I hit ctrl-T (as i=
n
> Mozilla). This way, older versions of the current query would go away.
>
>    * And also, if the SQL was per-tab as well, so I could refine a
> couple queries in parallel without doing as much copying and pasting.

Better handling of the tabs is on my todo list but as yet I haven't reall=
y=20
worked out what I want it to do.

>    * I'd like to see each SQL tab go into the top-level tab bar instead
> of the one "SQL" one and subtabs of that. Maybe not conceptually quite
> as clean - "Objects" would be different from all the others then - but
> less clutter.

You'd have a hard time convincing me on this one. I think it would make i=
t a=20
lot messier.

>
> - I hate the MDI interface/subwindows. I usually only work with one
> database at once - I only want that window up. Even when I do work with
> two databases, I'd prefer they be entirely separate windows. The connec=
t
> stuff could be a dialog box that pops up when you first start the
> program and when you hit ctrl-N or something (new connection).

As I said recently to somebody, this is a religious issue. I personally l=
ike=20
the MDI interface and hate the SDI one, this was the main reason I stoppe=
d=20
using Netbeans. A possibility for the future when the code has been clean=
ed=20
up would be making it an option as it is in the current version of Netbea=
ns.=20
You specify whether you want an SDI or an MDI interface.=20

> - It would be nice if the statement division stuff was smarter. I'd lik=
e
> to be able to type in PL/SQL blocks without changing the statement
> seperator. If it could do everything as the Oracle SQL Worksheet 8i doe=
s
> (not the 9i; blank lines in "create table" commands confuse it; grr),
> I'd be really, really happy.

Changing the statement separator and beginning of line comment gets round=
=20
these issues so I'd look at this as being low priority.

> - Feature request: Oracle query execution plans, like their "SQL
> Scratchpad" in the "Enterprise Manager Console" has. SQL Scratchpad
> really annoys me, but as is I've gotta use it occasionally. "explain
> plan for" dumps all this info into a table, but the SQL Scratchpad is
> the only thing I've seen that does a decent job of formatting it. (The
> only second is this utlxplp.sql thing that does text-based formatting.)

Sounds like something that could be put into the Oracle plugin. Its also =
not=20
something I'd probably do myself (I'm no Oracle expert) so if you are=20
interested in enhancing Squirrel this could be a good starting point.=20
Squirrel is starting to be used in a lot of Oracle shops and theres a lot=
 of=20
oracle specific functionality that could be added to the plugin. Let me k=
now=20
if you are interested.

> If I'm feeling ambitious later and have time, I might try to implement
> some of my suggestions. No promises.

Squirrel is turning out to be bigger than Ben Hur so any help you can giv=
e=20
would be appreciated. As I said the oracle plugin needs a lot of work and=
 I=20
would be extremely happy if you were to have a look at that.
--=20
Colin Bell
http://squirrel-sql.sf.net

[Squirrel-sql-users] First impressions

[Scott L. <sl...@sl...>]

Hi,

I've been playing around with Squirrel SQL a bit. I'm hoping to use it 
in place of Oracle's stuff.

First, I think current CVS is ready, as it's a definite improvement over 
the last released version for me. When I tried 0.9.6, it took a very 
long time to connect (I think it was trying to load all of the metadata 
right away, correct? I'm connecting over the Internet to a large Oracle 
database, so that's not a good idea.) It's better now. Also, I think the 
old one leaked cursors - I got maximum cursors exceeded messages when 
browsing metadata.

That doesn't mean I think it's perfect, though. I've got some 
problems/interface comments/feature requests:

- Typing "./squirrel-sql.sh" doesn't work for me right in the dist 
directory unless I set INSTALL_PATH=`pwd`. Was this supposed to be 
substituted in the ant file? If so, it didn't work.

- Ideally, just a "java -jar squirrel-sql.jar" would work, so I wouldn't 
need the shell script/batch file at all. I think you can have classpaths 
in the meta-inf. If not, the other jars would have to be included in 
that one. This would be better because batch files/java pop up 
unnecessary terminal windows on Windows. Clicking on the jar file 
directly launches javaw, which doesn't have that problem.

- It's slow when browsing metadata. It would be nice if it cached more 
(column-level information particularly) so looking at it a second time 
would be quick.

- IMHO auto commit should be off by default. Or at least there should be 
a preference for it per-database alias, not per-session, so I don't need 
to toggle it every time I connect.

- I'm glad to see it doesn't block waiting for a database response. This 
was what started me looking for an alternative to the Oracle 8i SQL 
Worksheet to begin with. Killing the program when I forgot a join 
condition was not pleasant.

- The metadata views show a lot of useless columns. Ones that are 
consistently <null>: schema on PostgreSQL (even 7.3b1 - I guess they 
haven't updated their JDBC drivers), table_cat on Oracle. And some 
things not really intended for humans (data_type; the numbers mean 
nothing to me; I just want type_name). If these all went away, it would 
be easier to find what I'm looking for.

- I loved the way it keeps around multiple resultsets in tabs, but I 
think it could be even better:

   * I tend to work with a couple queries at once and refine them. It'd 
be nice if a new tab replaced the current one unless I hit ctrl-T (as in 
Mozilla). This way, older versions of the current query would go away.

   * And also, if the SQL was per-tab as well, so I could refine a 
couple queries in parallel without doing as much copying and pasting.

   * I'd like to see each SQL tab go into the top-level tab bar instead 
of the one "SQL" one and subtabs of that. Maybe not conceptually quite 
as clean - "Objects" would be different from all the others then - but 
less clutter.

- I hate the MDI interface/subwindows. I usually only work with one 
database at once - I only want that window up. Even when I do work with 
two databases, I'd prefer they be entirely separate windows. The connect 
stuff could be a dialog box that pops up when you first start the 
program and when you hit ctrl-N or something (new connection).

- It would be nice if the statement division stuff was smarter. I'd like 
to be able to type in PL/SQL blocks without changing the statement 
seperator. If it could do everything as the Oracle SQL Worksheet 8i does 
(not the 9i; blank lines in "create table" commands confuse it; grr), 
I'd be really, really happy.

- Feature request: Oracle query execution plans, like their "SQL 
Scratchpad" in the "Enterprise Manager Console" has. SQL Scratchpad 
really annoys me, but as is I've gotta use it occasionally. "explain 
plan for" dumps all this info into a table, but the SQL Scratchpad is 
the only thing I've seen that does a decent job of formatting it. (The 
only second is this utlxplp.sql thing that does text-based formatting.)

Hope those are useful.

If I'm feeling ambitious later and have time, I might try to implement 
some of my suggestions. No promises.

Scott

RE: [Squirrel-sql-users] MySQL plugin

[Colin B. <Col...@as...>]

Hi Jason,

The MySQL plugin isn't a MySQL JDBC driver, instead it add some MySQL
specific functionality to Squirrel. You need to be running the 1.1 version
of Squirrel to use plugins.

You need to download a JDBC driver for MySQL. I would suggest using MM.MySQL
https://sourceforge.net/projects/mmmysql/

If you are using a recent version of 1.1 then the Help option from the Help
menu should tell you all you need to know about using JDBC drivers with
Squirrel. If you are using Squirrel 1.0 then read the files within the doc
directory within your Squirrel program directory.

Because of the amount of spam received this mailing list is now "subscribers
only" so if you have any further questions please subscribe to the list
before sending a message.

Col

-----Original Message-----
From: Jason Frinchaboy [mailto:ja...@vi...]
Sent: Tuesday, 24 September 2002 4:37
To: squ...@li...
Subject: [Squirrel-sql-users] MySQL plugin


I just downloaded Squirrel for Solaris and the MySQL Plugin for it but
I'm a little confused.  I did a gunzip mysql-0.10.tar.gz; tar -xvf
mysql-0.10.tar while in the plugins folder.  It made some directories,
and a mysql.jar file.  When I'm trying to create a new driver in
Squirrel, do I put that .jar file in the JAR field? What do I use for
the driver?  Where are the other JDBC drivers located??



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] MySQL plugin

[Jason F. <ja...@vi...>]

I just downloaded Squirrel for Solaris and the MySQL Plugin for it but
I'm a little confused.  I did a gunzip mysql-0.10.tar.gz; tar -xvf
mysql-0.10.tar while in the plugins folder.  It made some directories,
and a mysql.jar file.  When I'm trying to create a new driver in
Squirrel, do I put that .jar file in the JAR field? What do I use for
the driver?  Where are the other JDBC drivers located??

Re: [Squirrel-sql-users] Mac Users of Squirrel SQL?

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

Thanks John. I took the liberty of forwarding this to the users list.

You're quite right, SQuirreL 1.0 required JDK 1.2 and SQuirreL 1.1
requires JDK 1.3. It does run on the Mac but requires OSX.

Jason, I'm sorry I didn't read your email properly and missed the
reference to OS 9.1.

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

----- Original Message -----
From: "John K. Watson" <jo...@sl...>
Date: Monday, September 23, 2002 1:37 am
Subject: Re: [Squirrel-sql-users] Mac Users of Squirrel SQL?

> I would be very surprised if Squirrel would run on OS 9.  I
> believe
> that the jre is stuck at 1.1.8, or something thereabouts, and I'm
> pretty sure you need at least java 1.2 to run Squirrel.  Squirrel
> does
> run fine on OS X, where java 1.3.1 is part of the base install.
> John
>
> On Sunday, September 22, 2002, at 05:11 AM, Colin Bell wrote:
>
> > Hi Jason,
> >
> > I'm afraid I don't know the first thing about running Java apps
> on the
> > Macintosh however I have been told that Squirrel does runs on
> the Mac.
> >
> > It sounds llike you're trying to run Squirrel as a java applet,
> rather
> > than an
> > application. Squirrel is an application, if you take a look at
> the file
> > squirrel-sql.sh you'll see how to call it.
> >
> > --
> > Colin Bell
> > http://squirrel-sql.sf.net
> >
> > On Sun, 22 Sep 2002 08:21, Jason M. Sullivan wrote:
> >> I'm trying to get the Squirrel SQL client to run under the Mac
> runtime>> Java environment (2.2), under OS 9.1.  I can't seem to
> figure out
> >> what to
> >> do with the installer.jar file.  The applet runner won't load
> it, and
> >> I
> >> even hacked a little on an .html file to try and get it to run.
> No
> >> luck.
> >>
> >> Anyone got any clues to share?
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

 

Re: [Squirrel-sql-users] Mac Users of Squirrel SQL?

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

Hi Jason,

I'm afraid I don't know the first thing about running Java apps on the=20
Macintosh however I have been told that Squirrel does runs on the Mac.

It sounds llike you're trying to run Squirrel as a java applet, rather th=
an an=20
application. Squirrel is an application, if you take a look at the file=20
squirrel-sql.sh you'll see how to call it.

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

On Sun, 22 Sep 2002 08:21, Jason M. Sullivan wrote:
> I'm trying to get the Squirrel SQL client to run under the Mac runtime
> Java environment (2.2), under OS 9.1.  I can't seem to figure out what =
to
> do with the installer.jar file.  The applet runner won't load it, and I
> even hacked a little on an .html file to try and get it to run.  No luc=
k.
>
> Anyone got any clues to share?

[Squirrel-sql-users] Mac Users of Squirrel SQL?

[Jason M. S. <jsu...@nc...>]

I'm trying to get the Squirrel SQL client to run under the Mac runtime
Java environment (2.2), under OS 9.1.  I can't seem to figure out what to
do with the installer.jar file.  The applet runner won't load it, and I
even hacked a little on an .html file to try and get it to run.  No luck.  

Anyone got any clues to share?

-- 
   ////           Jason M. SULLIVAN   jsu...@nc...
  |c-oo                  http://www.jason0x21.org
   \_-     "That's not music, that's just sound!" - J. David Fries