squirrel-sql-develop Mailing List for SQuirreL SQL Client (Page 47)

<snip>
- TableSorting by pressing column headers, need small icons
(ascending/descending)
- Icon shown for drivers, instead of colors, that are loaded or not (Need
better Icons!!)
</snip>

Anybody got some better icons? I'm graphically illiterate.

<snip>
- longvarchars will also be displayed now instead of <null>
</snip>

Cool, this will fix a problem with Mckoi (and ignore my email to you asking
for you to fix this, you beat me to it).

<snip>
- Those strings (and everything else) can also be displayed in a TextArea if
  you double click on it, so that you can display the whole value of a cell
</snip>

Another popular feature request!!!

<snip>
- Drop table menu item on the ObjectTree (i personally really need this :-)
- Refresh table menu item option (so that you can refresh the selected item
instead of the complete tree)
</snip>

Go for it. I'haven't started the rewrite of the object tree yet (work is
crazy at the moment) so I'll wait you you to finish with the object tree
before I do.

<snip>
P.S. Why doesn't this list set the reply adress? (If i press reply then i
get the senders adress not the
        list adress filled in. The list should set this to itself.
</snip>

The long answer is here
http://sourceforge.net/docman/display_doc.php?docid=6693&group_id=1

Col

Almost finished with that.
I will check it in this evening
I am just adding 2 more things to the changes

But about that rendering problem:

You can't do that anymore at that place!
For example the IDataSetViewer (a combination of IDataSetViewerDestination
and DataSetViewer class)
is now incontrol of how it will render it!!

A IDataSetViewer implementation is for example the JTable view or the
JTextArea view
And the JTable view doesn't do toString() on the object when inserting them
in the model
like before. Because is need Date's and Numbers in the output and not a
String representation
of that, this is because i implemented Sorting on column now.
So i need real numbers or date's in them to get the sorting right.

So if you want to set some dateformatter then we need that for the different
implementations of IDataSetViewer.
For exasmple the JTable implementation has to do that through the normal
CellRenderers
So we could make a special Interface which definces how a renderer works
(with
giving it a object and getting back a string. Then the
DataSetViewerJTablePanel class
should be able to get that interface for a specific column and it access
that through
its CellRenderer. This is not to much work.

So i think:

IDataSetViewer has to get a setRenderer(int iColumn, IRenderer) method
this must be set right after the creation of it. How it is used depends on
the implementation.

The current changes:

- TableSorting by pressing column headers, need small icons
(ascending/descending)
- Icon shown for drivers, instead of colors, that are loaded or not (Need
better Icons!!)
- If only one cell selected in table when pressing copy then no header will
be appended.
- longvarchars will also be displayed now instead of <null>
- If selected String are longer then 50 chars then 45 chars + "......"  wil
be displayed.
- Those strings (and everything else) can also be displayed in a TextArea if
  you double click on it, so that you can display the whole value of a cell

2 i am busy on right now:

- Drop table menu item on the ObjectTree (i personally really need this :-)
- Refresh table menu item option (so that you can refresh the selected item
instead of the complete tree)

johan

P.S. Why doesn't this list set the reply adress? (If i press reply then i
get the senders adress not the
        list adress filled in. The list should set this to itself.




Johan


> Hi Brad,
>
> I knew there was something I forgot about this. Johan Compagner is
currently
> heavily refactoring this code so you might want to talk to him about these
> changes. One of the things he's looking at doing is allowing "renderers"
for
> columns.
>
> Col
>
> -----Original Message-----
> From: squ...@li...
> [mailto:squ...@li...]On Behalf Of
> Colin Bell
> Sent: Friday, 22 February 2002 10:59 AM
> To: 'BradLyon'; squ...@li...
> Subject: RE: [Squirrel-sql-develop] "Date" field display options?
>
>
> Hi Brad,
>
>
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResultSet(
> ..) is where the result set gets read. I'd suggest overloading this
function
> to take an additional parameter of type DataFormatter (or whatever you
want
> to call it).
>
> DataFormatter would be a new class that would contain the formatters for
> dates, time, timestamps etc. Also nice would be formatting for the
different
> numerics but these could be added later.
>
> I think that this formatting should be able to be specified at a "per
> session" basis so I think they should be specified on the SQL panel
> net.sourceforge.squirrel_sql.client.session.properties.SQLPropertiesPanel.
> This panel is used by both the New Sessions dialog and the Session
> Properties dialog.
>
> You'd need to store the new settings in the propeties class
> net.sourceforge.squirrel_sql.client.session.properties.SessionProperties
and
> its associated BeanInfo class.
>
> I think that should be it.
>
> Thanks
> Col
>
> -----Original Message-----
> From: BradLyon [mailto:bra...@nt...]
> Sent: Wednesday, 20 February 2002 2:20
> To: squ...@li...
> Subject: RE: [Squirrel-sql-develop] "Date" field display options?
>
>
> Colin:
>
> If you can point me to the relevant place (I want to be sure), I'll see if
> I can poke at it.
>
>
>
> At 11:24 AM 2/19/02 +1100, you wrote:
> >Hi Brad,
> >
> ><snip>
> >I need to see the date columns shown with seconds, etc.  It's not
happening
> >with the version I have (several months old).  Are there more options for
> >showing dates in the most recent version?
> ></snip>
> >
> >Not yet but there should be. Whats needed (I think, feel free to
disagree)
> >is replacing the getString() method with an appropriate getXXX() function
> >for date, time and timestamp and then using a DateFormat (or whatever its
> >called) to format that object for display. Both the New Session
Properties
> >dialog and the Session Properties dialog should allow the user to specify
> >the format they want to see date, time and timestamp columns in.
> >
> >If you've got the time to make the changes to the latest CVS source and
> send
> >me a diff I'd really appreciate it, otherwise I'll add it to my todo
list.
> >
> >Thanks
> >Col
> >
> >-----Original Message-----
> >From: BradLyon [mailto:bra...@nt...]
> >Sent: Sunday, 17 February 2002 1:52
> >To: squ...@li...
> >Subject: [Squirrel-sql-develop] "Date" field display options?
> >
> >
> >I need to see the date columns shown with seconds, etc.  It's not
happening
> >with the version I have (several months old).  Are there more options for
> >showing dates in the most recent version?
> >
> >Where in the code would I look to do this?  I poked around a little, and
it
> >looked like there was just a general toString called on object, but I
might
> >have been looking at the wrong place.
> >
> >_______________________________________________
> >Squirrel-sql-develop mailing list
> >Squ...@li...
> >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> >
> >_______________________________________________
> >Squirrel-sql-develop mailing list
> >Squ...@li...
> >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
>
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
>
>
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

I vote for Yes change
but you know that already.

johan

----- Original Message -----
From: "Colin Bell" <col...@bi...>
To: "Squirrel Developers List (E-mail)"
<squ...@li...>
Sent: Sunday, March 10, 2002 12:14 PM
Subject: [Squirrel-sql-develop] New Licence for Squirrel


> I'm looking at changing the licence for the SQuirreL application itself
from
> the GPL to the LGPL becauseof the "viral" nature of the GPL. In version
1.0
> it wasn't an issue but in version 1.1 with the addition of plugins it has
> become one.
>
> My intention with plugins was not to force a particular licence on them. I
> intended that the plugin developer could release their plugin under any
> licence they wanted although only those under an OSI recognized open
source
> licence could be released through the SQuirreL project on SourceForge
> (because of SourceForge rules). However according to the FAQ on the FSF
site
> http://www.fsf.org/licenses/gpl-faq.html#GPLAndPlugins the viral nature of
> the GPL means that all plugins have to be released under a GPL compatible
> licence.
>
> In order to give "freedom of choice" to the plugin developers I intend to
> change the licence of SQuirrel to the LGPL from the next release 1.1beta2.
>
> If anybody has a problem with this change (or if they think it won't give
> the required freedom to plugin developers) yell now. I don't want to
change
> the licence, find its still not correct and then have to change it again.
>
> Col
>
>
>
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

Hi Brad,

I knew there was something I forgot about this. Johan Compagner is currently
heavily refactoring this code so you might want to talk to him about these
changes. One of the things he's looking at doing is allowing "renderers" for
columns.

Col

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of
Colin Bell
Sent: Friday, 22 February 2002 10:59 AM
To: 'BradLyon'; squ...@li...
Subject: RE: [Squirrel-sql-develop] "Date" field display options?


Hi Brad,

net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResultSet(
..) is where the result set gets read. I'd suggest overloading this function
to take an additional parameter of type DataFormatter (or whatever you want
to call it).

DataFormatter would be a new class that would contain the formatters for
dates, time, timestamps etc. Also nice would be formatting for the different
numerics but these could be added later.

I think that this formatting should be able to be specified at a "per
session" basis so I think they should be specified on the SQL panel
net.sourceforge.squirrel_sql.client.session.properties.SQLPropertiesPanel.
This panel is used by both the New Sessions dialog and the Session
Properties dialog.

You'd need to store the new settings in the propeties class
net.sourceforge.squirrel_sql.client.session.properties.SessionProperties and
its associated BeanInfo class.

I think that should be it.

Thanks
Col

-----Original Message-----
From: BradLyon [mailto:bra...@nt...]
Sent: Wednesday, 20 February 2002 2:20
To: squ...@li...
Subject: RE: [Squirrel-sql-develop] "Date" field display options?


Colin:

If you can point me to the relevant place (I want to be sure), I'll see if
I can poke at it.



At 11:24 AM 2/19/02 +1100, you wrote:
>Hi Brad,
>
><snip>
>I need to see the date columns shown with seconds, etc.  It's not happening
>with the version I have (several months old).  Are there more options for
>showing dates in the most recent version?
></snip>
>
>Not yet but there should be. Whats needed (I think, feel free to disagree)
>is replacing the getString() method with an appropriate getXXX() function
>for date, time and timestamp and then using a DateFormat (or whatever its
>called) to format that object for display. Both the New Session Properties
>dialog and the Session Properties dialog should allow the user to specify
>the format they want to see date, time and timestamp columns in.
>
>If you've got the time to make the changes to the latest CVS source and
send
>me a diff I'd really appreciate it, otherwise I'll add it to my todo list.
>
>Thanks
>Col
>
>-----Original Message-----
>From: BradLyon [mailto:bra...@nt...]
>Sent: Sunday, 17 February 2002 1:52
>To: squ...@li...
>Subject: [Squirrel-sql-develop] "Date" field display options?
>
>
>I need to see the date columns shown with seconds, etc.  It's not happening
>with the version I have (several months old).  Are there more options for
>showing dates in the most recent version?
>
>Where in the code would I look to do this?  I poked around a little, and it
>looked like there was just a general toString called on object, but I might
>have been looking at the wrong place.
>
>_______________________________________________
>Squirrel-sql-develop mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
>_______________________________________________
>Squirrel-sql-develop mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop


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

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

I'm looking at changing the licence for the SQuirreL application itself from
the GPL to the LGPL becauseof the "viral" nature of the GPL. In version 1.0
it wasn't an issue but in version 1.1 with the addition of plugins it has
become one.

My intention with plugins was not to force a particular licence on them. I
intended that the plugin developer could release their plugin under any
licence they wanted although only those under an OSI recognized open source
licence could be released through the SQuirreL project on SourceForge
(because of SourceForge rules). However according to the FAQ on the FSF site
http://www.fsf.org/licenses/gpl-faq.html#GPLAndPlugins the viral nature of
the GPL means that all plugins have to be released under a GPL compatible
licence.

In order to give "freedom of choice" to the plugin developers I intend to
change the licence of SQuirrel to the LGPL from the next release 1.1beta2.

If anybody has a problem with this change (or if they think it won't give
the required freedom to plugin developers) yell now. I don't want to change
the licence, find its still not correct and then have to change it again.

Col

Colin,
On Fri, 22 Feb 2002, Colin Bell wrote:
> Would it be possible to have a small icon displayed in the list instead,
> maybe a green tick or a red cross? I just showed it to a colleague of mine
> and the poor blokes colour blind, couldn't see a thing. If you do make the
> change just be aware that I'm using your renderer for the drivers combobox
> in the Alias Maintenance dialog as well.

Yep, I'll do this when time permits. I am a bit busy currently as well..

I agree, that a little icon is better than color encoding.

-hen

> I find the colors a bit ugly :-(
>
> Make it configurable or even better.. let me choose that i don't want
> to use colors bug gray it out.. (Bold->Driver found->grayed text-> Driver
> not found)
>
> johan

I won't be able to update to the 1.4 jdk for a while.  Does anyone have a 
problem with adding some stuff so that

- You can exclude Java14.java from the build via an Ant parameter (I assume 
the javac task can handle this)
- We use reflection in Main.java on the "init" call to Java14, so that this 
file doesn't need to be changed when you're not using 1.4

Henner,

Would it be possible to have a small icon displayed in the list instead,
maybe a green tick or a red cross? I just showed it to a colleague of mine
and the poor blokes colour blind, couldn't see a thing. If you do make the
change just be aware that I'm using your renderer for the drivers combobox
in the Alias Maintenance dialog as well.

Col

-----Original Message-----
From: Johan Compagner [mailto:jco...@j-...]
Sent: Wednesday, 20 February 2002 7:33
To: SQuirreL list
Subject: Re: [Squirrel-sql-develop] Feature Patch: colored driver loaded
state.


hmmm

I find the colors a bit ugly :-(

Make it configurable or even better.. let me choose that i don't want
to use colors bug gray it out.. (Bold->Driver found->grayed text-> Driver
not found)

johan


>
> Hi,
> Sometimes I start up Squirrel and find out, that I didn't include the
> appropriate drivers in the classpath. But the only way to find out, is to
> actually connect to some database and get the 'no suitable driver'
> exception. It would be nice to have some visual notification up-front so
> that one knows whether drivers are loaded or not.
>
> So I changed the ListCellRenderer for the Drivers in a way, that it
> displays drivers, that couldn't be loaded, in red; in green otherwise. Had
> to change the ISQLDriver accordingly (isClassLoaded(), setClassLoaded()).
>
> IMHO this enhances the already well done UI of squirrel ..
>
> see attached patch against current CVS.
>
> my 2c,
>  -hen
>



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

Hi Brad,

net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResultSet(
..) is where the result set gets read. I'd suggest overloading this function
to take an additional parameter of type DataFormatter (or whatever you want
to call it).

DataFormatter would be a new class that would contain the formatters for
dates, time, timestamps etc. Also nice would be formatting for the different
numerics but these could be added later.

I think that this formatting should be able to be specified at a "per
session" basis so I think they should be specified on the SQL panel
net.sourceforge.squirrel_sql.client.session.properties.SQLPropertiesPanel.
This panel is used by both the New Sessions dialog and the Session
Properties dialog.

You'd need to store the new settings in the propeties class
net.sourceforge.squirrel_sql.client.session.properties.SessionProperties and
its associated BeanInfo class.

I think that should be it.

Thanks
Col

-----Original Message-----
From: BradLyon [mailto:bra...@nt...]
Sent: Wednesday, 20 February 2002 2:20
To: squ...@li...
Subject: RE: [Squirrel-sql-develop] "Date" field display options?


Colin:

If you can point me to the relevant place (I want to be sure), I'll see if 
I can poke at it.



At 11:24 AM 2/19/02 +1100, you wrote:
>Hi Brad,
>
><snip>
>I need to see the date columns shown with seconds, etc.  It's not happening
>with the version I have (several months old).  Are there more options for
>showing dates in the most recent version?
></snip>
>
>Not yet but there should be. Whats needed (I think, feel free to disagree)
>is replacing the getString() method with an appropriate getXXX() function
>for date, time and timestamp and then using a DateFormat (or whatever its
>called) to format that object for display. Both the New Session Properties
>dialog and the Session Properties dialog should allow the user to specify
>the format they want to see date, time and timestamp columns in.
>
>If you've got the time to make the changes to the latest CVS source and
send
>me a diff I'd really appreciate it, otherwise I'll add it to my todo list.
>
>Thanks
>Col
>
>-----Original Message-----
>From: BradLyon [mailto:bra...@nt...]
>Sent: Sunday, 17 February 2002 1:52
>To: squ...@li...
>Subject: [Squirrel-sql-develop] "Date" field display options?
>
>
>I need to see the date columns shown with seconds, etc.  It's not happening
>with the version I have (several months old).  Are there more options for
>showing dates in the most recent version?
>
>Where in the code would I look to do this?  I poked around a little, and it
>looked like there was just a general toString called on object, but I might
>have been looking at the wrong place.
>
>_______________________________________________
>Squirrel-sql-develop mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
>_______________________________________________
>Squirrel-sql-develop mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop


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

hmmm

I find the colors a bit ugly :-(

Make it configurable or even better.. let me choose that i don't want
to use colors bug gray it out.. (Bold->Driver found->grayed text-> Driver
not found)

johan


>
> Hi,
> Sometimes I start up Squirrel and find out, that I didn't include the
> appropriate drivers in the classpath. But the only way to find out, is to
> actually connect to some database and get the 'no suitable driver'
> exception. It would be nice to have some visual notification up-front so
> that one knows whether drivers are loaded or not.
>
> So I changed the ListCellRenderer for the Drivers in a way, that it
> displays drivers, that couldn't be loaded, in red; in green otherwise. Had
> to change the ISQLDriver accordingly (isClassLoaded(), setClassLoaded()).
>
> IMHO this enhances the already well done UI of squirrel ..
>
> see attached patch against current CVS.
>
> my 2c,
>  -hen
>

Colin:

If you can point me to the relevant place (I want to be sure), I'll see if 
I can poke at it.



At 11:24 AM 2/19/02 +1100, you wrote:
>Hi Brad,
>
><snip>
>I need to see the date columns shown with seconds, etc.  It's not happening
>with the version I have (several months old).  Are there more options for
>showing dates in the most recent version?
></snip>
>
>Not yet but there should be. Whats needed (I think, feel free to disagree)
>is replacing the getString() method with an appropriate getXXX() function
>for date, time and timestamp and then using a DateFormat (or whatever its
>called) to format that object for display. Both the New Session Properties
>dialog and the Session Properties dialog should allow the user to specify
>the format they want to see date, time and timestamp columns in.
>
>If you've got the time to make the changes to the latest CVS source and send
>me a diff I'd really appreciate it, otherwise I'll add it to my todo list.
>
>Thanks
>Col
>
>-----Original Message-----
>From: BradLyon [mailto:bra...@nt...]
>Sent: Sunday, 17 February 2002 1:52
>To: squ...@li...
>Subject: [Squirrel-sql-develop] "Date" field display options?
>
>
>I need to see the date columns shown with seconds, etc.  It's not happening
>with the version I have (several months old).  Are there more options for
>showing dates in the most recent version?
>
>Where in the code would I look to do this?  I poked around a little, and it
>looked like there was just a general toString called on object, but I might
>have been looking at the wrong place.
>
>_______________________________________________
>Squirrel-sql-develop mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
>_______________________________________________
>Squirrel-sql-develop mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

Hi Colin,
On Tue, 19 Feb 2002, Colin Bell wrote:
> This actually brings up something that I've been thinking about. At the
> moment if you have multiple logons onto the same computer each logon will
> get the same plugins. You should be able to install plugins only for
> specific logons, as well as for all logons.

In some small commandline-JDBC-tool I once wrote for everyday work
(maybe I should put it on sourceforge) I stored user specific settings
(like history, used drivers and connections) in a directory
$HOME/.henplus/, similar like the $HOME/.squirrel-sql/. However, if there
is an directory .henplus/ in the directory the tool is started in, then
this directory is used; so I created a empty .henplus in the projects'
directory and had my project specific settings there.

But maybe this kind of handling user specific settings is only viable for
commandline tools as they are usually invoked on -- the commandline.
Graphical tools may be started from some icon somewhere, and this allows
less control where the process is started in. But at least this could be
an idea considered as well.

> Squirrel a far better tool that if I was just working on it alone. So if you
> have any more ideas or patches, please don't be shy <hint/>.

My sourcefoge user name is 'hzeller', just in case you want to add it to
the developers list ;-)

ciao,
 -hen

Hi Henner,

<snip>
For a little project of mine (some object mapping database) I implemented
a JDBC-Driver that can return the hierarchy of tables with the
 DatabaseMetaData.getSuperTables().

I don't know, if there is any database out there, that already supports
this feature of recent JDBC (even though some object-oriented databases
might have it), but just in case someone is interested in this feature, I
extended the tree-view of the Database-objects of squirrel in a way,
that the hierarchical stucture of tables is represented as tree as well.

In the normal case (e.g. if DatabaseMetaData.getSuperTables() of the
driver does not return anything or is not implemented) this does not make
any difference, but if it returns something, the tables are shown as tree.

See attached patch; I'd be happy to see it included :-).
</snip>

I'm happy to include it<grin/>. Thanks for this, I've got no idea if there
is any dbms or driver out there that supports it either, but when they do
it'll be very nice for Squirrel to also support it. I'll try to have a
proper look at your patch this weekend.

<snip>
So I changed the ListCellRenderer for the Drivers in a way, that it
displays drivers, that couldn't be loaded, in red; in green otherwise. Had
to change the ISQLDriver accordingly (isClassLoaded(), setClassLoaded()).
</snip>

Just applied this patch to my source - looks good! Its funny how the little
things make a real difference in useability. BTW applying your patch found a
bug in my DriverManager class which I've fixed - thanks.

<snip>
So I'd like to suggest two things
 1)
  create a layout in dist of the form
    bin/squirrel
    share/squirrel/...
  that can be moved everywhere by the system administrator (usually /usr,
  /usr/local or /opt)

 2) make the shellscript independent from where it was called. This can
    simply be done by setting a variable like
    SQUIRREL_HOME=`dirname $0`/../share/squirrel
    .. and set the rest accordingly.
</snip>

This actually brings up something that I've been thinking about. At the
moment if you have multiple logons onto the same computer each logon will
get the same plugins. You should be able to install plugins only for
specific logons, as well as for all logons. If I changed Squirrel to look
for plugins with the user settings directory (which is now configurable
through the -settingsdir argument) _as_ well as in the
<squirrel_home>/plugins directory, would this give you what you want? The
SQUIRREL_HOME env variable is a good idea, both for Windows and Unix and
I'll put it on my todo list.

Thanks for both the code and the ideas. Its this kind of help that is making
Squirrel a far better tool that if I was just working on it alone. So if you
have any more ideas or patches, please don't be shy <hint/>.

Thanks
Col

Hi Brad,

<snip>
I need to see the date columns shown with seconds, etc.  It's not happening 
with the version I have (several months old).  Are there more options for 
showing dates in the most recent version?
</snip>

Not yet but there should be. Whats needed (I think, feel free to disagree)
is replacing the getString() method with an appropriate getXXX() function
for date, time and timestamp and then using a DateFormat (or whatever its
called) to format that object for display. Both the New Session Properties
dialog and the Session Properties dialog should allow the user to specify
the format they want to see date, time and timestamp columns in.

If you've got the time to make the changes to the latest CVS source and send
me a diff I'd really appreciate it, otherwise I'll add it to my todo list.

Thanks
Col

-----Original Message-----
From: BradLyon [mailto:bra...@nt...]
Sent: Sunday, 17 February 2002 1:52
To: squ...@li...
Subject: [Squirrel-sql-develop] "Date" field display options?


I need to see the date columns shown with seconds, etc.  It's not happening 
with the version I have (several months old).  Are there more options for 
showing dates in the most recent version?

Where in the code would I look to do this?  I poked around a little, and it 
looked like there was just a general toString called on object, but I might 
have been looking at the wrong place.

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

Hi,
On Mon, 18 Feb 2002, Johan Compagner wrote:
> When did we do a remove?

There wasn't a remove before, but I needed to add a remove() for the
hierachical table view, since the tree is build in two phases.

First, the table list is loaded, as usual.
In the second phase, the result from DatabaseMetaData.getSuperTables() is
processed: if there are supertables for a specific
table, then that table has to be removed from the list
(representing the toplevel in the tree) and to be added as child
of the supertable.

see the SQLConnection.java - part of my patch and look for the comment
'// remove from toplevel'

ciao,
 -hen

When did we do a remove?

johan


----- Original Message -----
From: "Henner Zeller" <HZ...@me...>
To: "SQuirreL list" <squ...@li...>
Sent: Monday, February 18, 2002 10:58 AM
Subject: [Squirrel-sql-develop] Update Feature Patch: hierachical table
display ..


>
> Hi,
> In the former patch to this topic I replaced the ArrayList to store the
> table infos with a HashSet - this was because its O(n) to remove from an
> ArrayList but only O(1) from an HashSet. Unfortunatly, this destroys the
> order of the tables, sine the hash function has no order ..
>
> .. so now I implemented this with a TreeSet that orders the tables
> alphabetically (for this, I made the IDatabaseObjectInfo extend Comparable
> and compare the qualified names in DatabaseObjectInfo). This has the nice
> side-effect, that table names are always sorted, even if JDBC-drivers
> fail so return them sorted.
>
> See attached patch. This is a patch agains current CVS.
>
> ciao,
>  -hen
>

Hi,
In the former patch to this topic I replaced the ArrayList to store the
table infos with a HashSet - this was because its O(n) to remove from an
ArrayList but only O(1) from an HashSet. Unfortunatly, this destroys the
order of the tables, sine the hash function has no order ..

.. so now I implemented this with a TreeSet that orders the tables
alphabetically (for this, I made the IDatabaseObjectInfo extend Comparable
and compare the qualified names in DatabaseObjectInfo). This has the nice
side-effect, that table names are always sorted, even if JDBC-drivers
fail so return them sorted.

See attached patch. This is a patch agains current CVS.

ciao,
 -hen

Hi,
Sometimes I start up Squirrel and find out, that I didn't include the
appropriate drivers in the classpath. But the only way to find out, is to
actually connect to some database and get the 'no suitable driver'
exception. It would be nice to have some visual notification up-front so
that one knows whether drivers are loaded or not.

So I changed the ListCellRenderer for the Drivers in a way, that it
displays drivers, that couldn't be loaded, in red; in green otherwise. Had
to change the ISQLDriver accordingly (isClassLoaded(), setClassLoaded()).

IMHO this enhances the already well done UI of squirrel ..

see attached patch against current CVS.

my 2c,
 -hen

Hi,
On unix systems, squirrel would probably be installed in an layout like
this
---
  /usr/bin/squirrel
  /usr/share/squirrel/lib
           ...       /plugins
---

Currently, the shellscript assumes, that it is installed in the
same directory; worse, it requires to be started in the same directory
the shellscript resides in, because it looks in relative paths.

So I'd like to suggest two things
 1)
  create a layout in dist of the form
    bin/squirrel
    share/squirrel/...
  that can be moved everywhere by the system administrator (usually /usr,
  /usr/local or /opt)

 2) make the shellscript independent from where it was called. This can
    simply be done by setting a variable like
    SQUIRREL_HOME=`dirname $0`/../share/squirrel
    .. and set the rest accordingly.


See attached shellscript.

Keep up the good work!
  -hen

Hi,
For a little project of mine (some object mapping database) I implemented
a JDBC-Driver that can return the hierarchy of tables with the
 DatabaseMetaData.getSuperTables().

I don't know, if there is any database out there, that already supports
this feature of recent JDBC (even though some object-oriented databases
might have it), but just in case someone is interested in this feature, I
extended the tree-view of the Database-objects of squirrel in a way,
that the hierarchical stucture of tables is represented as tree as well.

In the normal case (e.g. if DatabaseMetaData.getSuperTables() of the
driver does not return anything or is not implemented) this does not make
any difference, but if it returns something, the tables are shown as tree.

See attached patch; I'd be happy to see it included :-).

ciao,
 -hen

--
Henner Zeller <H.Z...@ac...>

I need to see the date columns shown with seconds, etc.  It's not happening 
with the version I have (several months old).  Are there more options for 
showing dates in the most recent version?

Where in the code would I look to do this?  I poked around a little, and it 
looked like there was just a general toString called on object, but I might 
have been looking at the wrong place.

The first beta of 1.1 is now available. SQuirreL now has a plugin
architecture and three plugins have been released at the same time.

The jEdit plugin allows you to use the text control from the jEdit text
editor (http://www.jedit.org). This is a far more powerful text control that
the standard Java text area with highlighting styles, bracket matching and
more. Requires at least JDK1.3 and SQuirreL SQL Client 1.1beta1.

The Look and Feel plugin allows you to change the Look and Feel for SQuirreL
SQL Client, as well as change the font used. It ships with both the
Kunststoff and SkinLF Look and Feels. Requires at least JDK1.3 and SQuirreL
SQL Client 1.1beta1.

The SQL Scripts plugin will allow you to save and restore SQL scripts
from/to text files as well as generate CREATE TABLE and INSERT scripts for
existing tables in a database. Requires at least JDK1.3 and SQuirreL SQL
Client 1.1beta1.

The full list of changes in 1.1beta1 are:

Plugin architecture added.
- Now under JDK1.4 have option to scroll tabbed
  pane tabs rather than wrap them.
- Look and Feel functionality moved to a plugin.
- The results of queries can be displayed in
  multiple tabs and these tabs can be "torn off"
  (Johan Compagner).
- Can now enter execute multiple SQL statements
  (Johan Compagner).
- The message panel is now resizable (Johan
  Compagner).
- New "Info" tab on SQL query results.
- No longer try to load blob fields from SQL
  Result set.
- View SQL data entry caret line/column in
  statusbar
- Removed control characters from SQL Result tab
  headings.
- The characters -- at the beginning of a line of
  SQL will turn it into a comment.
- Properties windows are now modeless.
- Driver and Alias maintenance windows are now
  modeless.
- Aliaes and Drivers tool window now resized when
  Look and Feel changed (if required).
- Now displaying SQL Error Code and State when an
  SQL error occurs.
- Can now select the Font for the SQL entry area.
- New "Show Native SQL" item in Session menu.
- "New Session" options moved from Global
  Prefernces dialog to new Session Properties
  dialog.
- New options on the session menu - Close all
  result tabs and close all Result windows.
- New option on the Windows menu - Close all
  sessions.
- Bring aliases/driver window to front if action
  requested.
- New application argument -noplugins which will
  run SQuirreL without any plugins being loaded.
- Undo/redo support now added to the SQL entry
  area (Johan Compagner).
- Copying SQL results now includes the column
  headings (Johan Compagner).
- New "Copy as HTML" option for SQL results
  (Johan Compagner).
- Bug fixed in About Box where the thread that
  updates the memory status continued updating
  when the About Box was not being displayed.
- Dialogs have been cleaned up.
- Apache log4j is used for the logging subsystem.
- JDBC debug can be specified in the global
  preferences.
- New application argument allows you to override
  the user settings directory.
  E.G. -settingsdir=c:\my-squirrel-settings
- Stored proc column information now available.
- Connection window is now modeless.
- SQL execution and object tree expansion now run
  in a separate thread so that the user interface
  is still responsive (Johan Compagner).
- Row count is now available on the Info tab for a
  table.
- Meta data is available for the results of SQL
  execution.
- Replaced the JDOM library with NanoXML.

Enjoy.

<snip>
> I just want to let you know that I'm finding
Squirrel to be fantastically
> convenient for working with an Oracle db here.  I
keep wanting more
> features, and I only have myself to blame for not
implementing them.

come on... implement :-)
</snip>

Like Johan said.

<snip>
I know, I need to do it... I'll need to install jdk1.4
first... Have there been any problems with 1.4
screwing up existing systems (on Windows)
</snip>

I'm running jEdit and Squirrel happily with 1.4
Release Candidate. 

<snip>
The main thing I want is to be able to click on a cell
in a table, and change the value - I realize there's
some issues here, but for simple column types it
should work ok.  That's the plug-in I was going to
work on, but no time, etc...
</snip>

Johans been talking about this as well. Everybodys
waiting for me to finish the data model for SQL
results. The second major job I have to do.

Col



What do you miss?
If you are a Oracle user then i think you know TOAD.
what does toad has that you really would like to see
in Squirrel?


I heard about TOAD, then when I checked it out it
didn't seem to be free anymore, so I never really
messed with it.
_______________________________________________
Squirrel-sql-develop mailing list
Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

http://my.yahoo.com.au - My Yahoo!
- It's My Yahoo! Get your own!

<snip>
BTW, does it still close the treeview on a dbrefresh? 
I haven't looked at 
the code, and maybe it's doing that because you just
rebuild the thing, in 
which case the code would need to save where you
currently are before doing 
the refresh, and then try to navigate back there if it
still existed.
</snip>

Theres code in there to save and restore the tree
state. Its actually rebuilding the expanded nodes but
not expanding them - don't know why. My next big job
is going to be rewriting all the object tree code. Its
some of the earliest (and worst) code in Squirrel.
Hopefully this bug will vanish as part of the rewrite.

Col


http://my.yahoo.com.au - My Yahoo!
- It's My Yahoo! Get your own!

<html>
At 04:01 PM 1/30/02 +0100, you wrote:<br>
<blockquote type=cite cite>&gt; I just want to let you know that I'm
finding Squirrel to be fantastically<br>
&gt; convenient for working with an Oracle db here.&nbsp; I keep wanting
more<br>
&gt; features, and I only have myself to blame for not implementing
them.<br>
<br>
come on... implement :-)<br>
</blockquote><br>
I know, I need to do it... I'll need to install jdk1.4 first... Have
there been any problems with 1.4 screwing up existing systems (on
Windows)<br>
<br>
<blockquote type=cite cite>What kind of features are you looking
for?<br>
</blockquote><br>
The main thing I want is to be able to click on a cell in a table, and
change the value - I realize there's some issues here, but for simple
column types it should work ok.&nbsp; That's the plug-in I was going to
work on, but no time, etc...<br>
<br>
<br>
<br>
<blockquote type=cite cite>What do you miss?<br>
If you are a Oracle user then i think you know TOAD.<br>
what does toad has that you really would like to see in Squirrel?<br>
</blockquote><br>
I heard about TOAD, then when I checked it out it didn't seem to be free
anymore, so I never really messed with it.</html>