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

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

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

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

RE: [Squirrel-sql-users] Sybase Error

[Martin A. <ma...@ma...>]

Hi, I think this is not a Squirrel problem. Sybase, by default, doesn 't
come with the required metadata to be accessed by Java applications (at
least, the ones trying to query the metadata catalog, like squirrel).
Look into the jConnect distribution and you 'll find a SQL script that
you must execute (load) into your database to load the required tables.
I think there are two different versions depending of the version of the
server. I don 't have my installation at hand, otherwise I 'd point you
to the exact file. 

Regards, 

Martin



-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of Wes
Neal
Sent: Thursday, January 23, 2003 4:32 PM
To: squ...@li...
Subject: [Squirrel-sql-users] Sybase Error



I am getting this error when connecting to a sybase database.

Error closing opened connection: java.sql.SQLException: JZ0SJ: Metadata
accessor information was not found on this database. Please install the
required tables as mentioned in the jConnect.

I don't see anything in the document about this.  
----
Wes Neal
GNMSS - OSS
WorldCom, Inc.
(813)829-6915
VNET: 838-6915
Sametime: wes.neal
 



-------------------------------------------------------
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

[Squirrel-sql-users] Sybase Error

[Wes N. <wes...@wc...>]

I am getting this error when connecting to a sybase database.

Error closing opened connection: java.sql.SQLException: JZ0SJ: Metadata
accessor information was not found on this database. Please install the
required tables as mentioned in the jConnect.

I don't see anything in the document about this.  
----
Wes Neal
GNMSS - OSS
WorldCom, Inc.
(813)829-6915
VNET: 838-6915
Sametime: wes.neal
 

RE: RE: [Squirrel-sql-users] Sybase Question

[Martin A. <ma...@ma...>]

No, but knowing that you care, I 'll try to reproduce it. In fact, 
being so little the detail (after all, you just add the classpath
once), I 've never tested it much.

I 'm new to Squirrel but first impression was very good. I like very
much the idea of plugins. I 've took your Oracle plugin and made
an SQL Server plugin without any problems. I do have some things
that are either bugs or not clear how they work and some
enhacement proposals, but I was waiting to try the last CVS 
snapshot before reporting. 

Is there any document with guidelines about where Squirrel is 
going or what are the next changes to be expected ?

Martin


-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Colin Bell
Sent: Thursday, January 16, 2003 10:03 PM
To: squ...@li...
Subject: Re: RE: [Squirrel-sql-users] Sybase Question


> ps: by the way, I sometimes find that after adding extra classpath
> to a driver, the list doesn 't refresh (I still see the red X) and
> the check mark only appears after a restart.

Any idea of what might be different when it doesn't work? 

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

 



-------------------------------------------------------
This SF.NET email is sponsored by: Thawte.com
Understand how to protect your customers personal information by
implementing
SSL on your Apache Web Server. Click here to get our FREE Thawte Apache 
Guide: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0029en
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: RE: [Squirrel-sql-users] Sybase Question

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

> ps: by the way, I sometimes find that after adding extra classpath
> to a driver, the list doesn 't refresh (I still see the red X) and
> the check mark only appears after a restart.

Any idea of what might be different when it doesn't work? 

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

 

RE: [Squirrel-sql-users] Sybase Question

[Martin A. <ma...@ma...>]

Sorry, the correct class is com.sybase.jdbc2.jdbc.SybDriver



-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Martin Arpon
Sent: Thursday, January 16, 2003 7:38 PM
To: 'Wes Neal'; squ...@li...
Subject: RE: [Squirrel-sql-users] Sybase Question


I don 't use have 4.5 of jConnect but at least in version 5.5 
you must include both jTDS.jar and jconn2.jar (both in dir 
<install_path>/classes/)

If you want to be sure, open the jar file with "jar tvf jTDS.jar"
(or WinZip) and make sure class "com.sybase.jdbc2.SybDriver" is there.
If it 's not, search other libraries (like jconn2.jar in my case) 

Regards, 

Martin

ps: by the way, I sometimes find that after adding extra classpath
to a driver, the list doesn 't refresh (I still see the red X) and
the check mark only appears after a restart 




-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of Wes
Neal
Sent: Thursday, January 16, 2003 12:03 PM
To: squ...@li...
Subject: [Squirrel-sql-users] Sybase Question


I have downloaded the JDBC drivers for Oracle Thin and for mySQL and
Jconnect 4.5 for Sybase.  Basically I just went in to each driver and
went to the extra classpath area and chose add then gave it the path to
the jar file or the zip file for Oracle.  This made the big red X go to
a check mark and I was able to connect to those specific database types.
I have gone into both of the Sybase drivers and pointed them to the
jConnect-4_5\classes\jTDS.jar file.  This does not give me the blue
check mark meaning that it is loading ok.  Am I doing something wrong on
this one?

Thanks in advance
Wes


----
Wes Neal
GNMSS - OSS
WorldCom, Inc.
VNET: 838-6915
Sametime: wes.neal
 



-------------------------------------------------------
This SF.NET email is sponsored by: Thawte.com
Understand how to protect your customers personal information by
implementing
SSL on your Apache Web Server. Click here to get our FREE Thawte Apache 
Guide: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0029en
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users



-------------------------------------------------------
This SF.NET email is sponsored by: Thawte.com
Understand how to protect your customers personal information by
implementing
SSL on your Apache Web Server. Click here to get our FREE Thawte Apache 
Guide: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0029en
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

RE: [Squirrel-sql-users] Sybase Question

[Martin A. <ma...@ma...>]

I don 't use have 4.5 of jConnect but at least in version 5.5 
you must include both jTDS.jar and jconn2.jar (both in dir 
<install_path>/classes/)

If you want to be sure, open the jar file with "jar tvf jTDS.jar"
(or WinZip) and make sure class "com.sybase.jdbc2.SybDriver" is there.
If it 's not, search other libraries (like jconn2.jar in my case) 

Regards, 

Martin

ps: by the way, I sometimes find that after adding extra classpath
to a driver, the list doesn 't refresh (I still see the red X) and
the check mark only appears after a restart 




-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of Wes
Neal
Sent: Thursday, January 16, 2003 12:03 PM
To: squ...@li...
Subject: [Squirrel-sql-users] Sybase Question


I have downloaded the JDBC drivers for Oracle Thin and for mySQL and
Jconnect 4.5 for Sybase.  Basically I just went in to each driver and
went to the extra classpath area and chose add then gave it the path to
the jar file or the zip file for Oracle.  This made the big red X go to
a check mark and I was able to connect to those specific database types.
I have gone into both of the Sybase drivers and pointed them to the
jConnect-4_5\classes\jTDS.jar file.  This does not give me the blue
check mark meaning that it is loading ok.  Am I doing something wrong on
this one?

Thanks in advance
Wes


----
Wes Neal
GNMSS - OSS
WorldCom, Inc.
VNET: 838-6915
Sametime: wes.neal
 



-------------------------------------------------------
This SF.NET email is sponsored by: Thawte.com
Understand how to protect your customers personal information by
implementing
SSL on your Apache Web Server. Click here to get our FREE Thawte Apache 
Guide: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0029en
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Sybase Question

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

> I have gone into both of the Sybase drivers and pointed them 
> to the
> jConnect-4_5\classes\jTDS.jar file.  This does not give me the blue
> check mark meaning that it is loading ok.  Am I doing something 
> wrong on
> this one?
> 

Are you using the right jar file? From memory the 4.x series of jConnect
had its driver unpacked within the <jconnect>/classes directory and the
5.x series had the driver in jconn2.jar. I'll try to take a look at my
Sybase setup tomorrow just to confirm that.

If you are using the correct jar open up the Extra Classpath tab again
and click the "List Drivers" button after selecting the jar file in the
listbox. This will fill the drivers dropdown with the name of any driver
classes it finds.

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

 

[Squirrel-sql-users] Sybase Question

[Wes N. <wes...@wc...>]

I have downloaded the JDBC drivers for Oracle Thin and for mySQL and
Jconnect 4.5 for Sybase.  Basically I just went in to each driver and
went to the extra classpath area and chose add then gave it the path to
the jar file or the zip file for Oracle.  This made the big red X go to
a check mark and I was able to connect to those specific database types.
I have gone into both of the Sybase drivers and pointed them to the
jConnect-4_5\classes\jTDS.jar file.  This does not give me the blue
check mark meaning that it is loading ok.  Am I doing something wrong on
this one?

Thanks in advance
Wes


----
Wes Neal
GNMSS - OSS
WorldCom, Inc.
VNET: 838-6915
Sametime: wes.neal
 

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