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

[Squirrel-sql-users] Bug when displaying user defined data types(?)

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

Hi Folks,

I've just noticed a problem displaying a Postgres 
user defined data type in Squirrel 1.1 Final.
I have a data type of 'ISBN' which I can display
correctly with other clients (psql or a php script)
but Squirrel is displaying it as 'other'. The output
looks like this:

isbn_table
<Other>
<Other>
<Other>
<Other>
   .
   .
 
cheers,
Denis

Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ 

Re: [Squirrel-sql-users] Bug when displaying user defined data types(?)

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

Hi Denis,

In the SQL tab in the Session Properties dialog you can specify which
data types are shown. Just make sure that the "All Other Data Types"
checkbox is checked.

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

----- Original Message -----
From: "Denis Grannell" <dgr...@we...>
Date: Friday, May 9, 2003 7:17 am
Subject: [Squirrel-sql-users] Bug when displaying user defined data types(?)

> Hi Folks,
> 
> I've just noticed a problem displaying a Postgres 
> user defined data type in Squirrel 1.1 Final.
> I have a data type of 'ISBN' which I can display
> correctly with other clients (psql or a php script)
> but Squirrel is displaying it as 'other'. The output
> looks like this:
> 
> isbn_table
> <Other>
> <Other>
> <Other>
> <Other>
>   .
>   .
> 
> cheers,
> Denis
> 
> 
> Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
> Tel: +49 89 201 3672          Fax: +49 89 202 2875
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ 
> 
> 
> -------------------------------------------------------
> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
> The only event dedicated to issues related to Linux enterprise 
> solutionswww.enterpriselinuxforum.com
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
 

[Squirrel-sql-users] Bug when displaying user defined data types(?)

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

Hi Folks,

I've just noticed a problem displaying a Postgres 
user defined data type in Squirrel 1.1 Final.
I have a data type of 'ISBN' which I can display
correctly with other clients (psql or a php script)
but Squirrel is displaying it as 'other'. The output
looks like this:

isbn_table
<Other>
<Other>
<Other>
<Other>
   .
   .
 
cheers,
Denis


Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ 

Re: [Squirrel-sql-users] Feature request -- row limit reached

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

> From: Colin Bell <col...@te...>
> It'll be in 1.2  :-)

I *guess* that's quick enough service!  ;^)

Thanks.  Two steps ahead of me.

Ruffin Bailey

Re: [Squirrel-sql-users] Feature request -- row limit reached

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

> Any chance I could feature request a visible cue (orange outline 
> to the session?  A little icon in the status bar saying "Row limit 
> reached"?  Something like that) that a row limit has been reached 
> when that session property in the SQL tab is limiting the rows 
> returned?  
> 
> And yes, this is a "It's not only useful, it also helps idiots..." 
> request.  I bout killed myself over that one earlier today, 
> forgetting I'd put in a fresh install of SQuirreL on a new work 
> box...  "Why aren't there more rows?!!  And why are there always 
> EXACTLY 100?!!!!"  ;  

It'll be in 1.2  :-)
--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: Ruffin Bailey <Ruf...@Bl...>
Date: Thursday, May 8, 2003 7:43 am
Subject: [Squirrel-sql-users] Feature request -- row limit reached

> Any chance I could feature request a visible cue (orange outline 
> to the session?  A little icon in the status bar saying "Row limit 
> reached"?  Something like that) that a row limit has been reached 
> when that session property in the SQL tab is limiting the rows 
> returned?  
> 
> And yes, this is a "It's not only useful, it also helps idiots..." 
> request.  I bout killed myself over that one earlier today, 
> forgetting I'd put in a fresh install of SQuirreL on a new work 
> box...  "Why aren't there more rows?!!  And why are there always 
> EXACTLY 100?!!!!"  ;^D  
> 
> Guess it's time I pulled the source!
> 
> With the bookmark plugin, no, it's not behaving the way it 
> normally does after a bookmark-paste.  I'll try and get you a 
> better description/test case before too long.
> 
> Thanks,
> 
> Ruffin Bailey
> 
> 
> -------------------------------------------------------
> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
> The only event dedicated to issues related to Linux enterprise 
> solutionswww.enterpriselinuxforum.com
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
 

[Squirrel-sql-users] Feature request -- row limit reached

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

Any chance I could feature request a visible cue (orange outline to the =
session?  A little icon in the status bar saying "Row limit reached"?  =
Something like that) that a row limit has been reached when that session =
property in the SQL tab is limiting the rows returned? =20

And yes, this is a "It's not only useful, it also helps idiots..." =
request.  I bout killed myself over that one earlier today, forgetting =
I'd put in a fresh install of SQuirreL on a new work box...  "Why aren't =
there more rows?!!  And why are there always EXACTLY 100?!!!!"  ;^D =20

Guess it's time I pulled the source!

With the bookmark plugin, no, it's not behaving the way it normally does =
after a bookmark-paste.  I'll try and get you a better description/test =
case before too long.

Thanks,

Ruffin Bailey

Re: [Squirrel-sql-users] Possible bug in 'drop' function

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

Hi Denis,

Its a bug. The problem is the JDBC driver (and its not just PostgreSQL)
can return more than just tables for DataBaseMetaData.getTables. Oracle
for instance will return synonyms as well as views.

What I could do is use the table type in the drop command. E.G.

DROP TABLE
DROP VIEW
DROP SYNONYM

This wouldn't be 100% correct (e.g. SYSTEM TABLE is a common table type)
but would be better than the current situation.

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

----- Original Message -----
From: "Denis Grannell" <dgr...@we...>
Date: Sunday, May 4, 2003 4:26 am
Subject: [Squirrel-sql-users] Possible bug in 'drop' function

> Hi,
> 
> I think I've stumbled on a bug in squirrel 1.1-Final
> when accessing a Postgres 7.3.2 database.
> To reproduce:
> 
> 1. Create a view in a database
> 
> 2. Refresh the Objects tree.
>   (The new view appears under 'View')
> 
> 3. Right click on the view name and select 'Drop'
> 
> 4. A confirmation popup opens with "Are you sure?"
> 
> 5. Execute the drop
> 
> 6. The following error message appears:  
>   java.sql.SQLException: ERROR:  "<Your-View-Name>" is not a 
> table. 
>   Use DROP VIEW to remove a view
> 
> 7. The view is not removed.
> 
> cheers,
> Denis
> 
> 
> Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
> Tel: +49 89 201 3672          Fax: +49 89 202 2875
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ 
> 
> 
> -------------------------------------------------------
> 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] Re: New Plugin - SQL Bookmark (bug)

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

Hi Joe,

There are several different ways of setting the text in the SQL Entry
area. Within ISQLPanelAPI.java there are:

/**
 * Append the passed SQL script to the SQL entry area but don't select
 * it.
 * 
 * @param	sqlScript	The script to be appended.
 */
void appendSQLScript(String sqlScript);

/**
 * Append the passed SQL script to the SQL entry area and specify
 * whether it should be selected.
 * 
 * @param	sqlScript	The script to be appended.
 * @param	select		If <TT>true</TT> then select the passed 		 */
void appendSQLScript(String sqlScript, boolean select);

/**
 * Replace the contents of the SQL entry area with the passed
 * SQL script without selecting it.
 * 
 * @param	sqlScript	The script to be placed in the SQL entry 	 */
void setEntireSQLScript(String sqlScript);

/**
 * Replace the contents of the SQL entry area with the passed
 * SQL script and specify whether to select it.
 * 
 * @param	sqlScript	The script to be placed in the SQL entry 	 *
@param	select		If <TT>true</TT> then select the passed 		 */
void setEntireSQLScript(String sqlScript, boolean select);

I'd suggest using 

void appendSQLScript(String sqlScript, boolean select);

which will append the shortcut SQL to the end of the SQL entry area and
if you pass treu for 'select' the shortcut SQL should be selected ready
for a <CTRL><ENTER>.

Having said all that I have had problems with focus in the SQL entry
area (especially using the jEdit plugin) so this may still not work. Let
me know if it doesn't.

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

----- Original Message -----
From: Joseph Mocker <mo...@mi...>
Date: Sunday, May 4, 2003 11:40 am
Subject: [Squirrel-sql-users] Re: New Plugin - SQL Bookmark (bug)

> 
> Ruffin,
> 
> Do you see this only with the plugin? I know I've seen this behavior
> without the plugin, and just using the SQL edit buffer. I think this
> is just how Squirrel SQL works. I can, however, in the plugin make 
> sure to set the input carat to the beginning of the buffer when 
> inserting a bookmark into it, just in case.
> 
>  --joe
> 
> On Sat, 2003-05-03 at 18:33, Joseph Mocker wrote:
> > 
> > 
> > 
> >  This plugin is a great idea, but I think I've stumbled over a 
> bug. 
> > Seems after pasting in
> > a bookmark, you have to select the SQL you want to execute or
> > ctrl-return only executes the
> > line you're currently on.  Closing out the window and opening a 
> new one
> > gets rid of the
> > behaviour, at least until you open another bookmark.
> >  
> >  That said, and that bug aside, something this simple really is 
> awful> helpful.
> >  
> >  Ruffin Bailey
> >  
> > 
> > 
> >  
> > 
> 
> 
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> 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] RE: New Plugin - SQL Bookmark

[Joseph M. <mo...@mi...>]

Hi Denis,

Glad you like the plugin. The hierarchical list is 
something I've thought about. I wanted to get this 
initial version "out the door". But I'll put it on 
the TODO list.

   --joe


> 
>  Hi,
>  
>  > This plugin is a great idea
>  
>  I agree, it most certainly is a huge help.
>  Would it be viable though to make the bookmarks menu
>  hierarchical?. If you could group bookmarks together
>  under a folder icon, I think that would make the 
>  function really super.  
>  I was thinking of a display that would look similar to 
>  the way the objects tree is displayed at the moment.
>  
>  cheers,
>  Denis
> 
> 

[Squirrel-sql-users] Re: New Plugin - SQL Bookmark (bug)

[Joseph M. <mo...@mi...>]

Ruffin,

Do you see this only with the plugin? I know I've seen this behavior
without the plugin, and just using the SQL edit buffer. I think this
is just how Squirrel SQL works. I can, however, in the plugin make 
sure to set the input carat to the beginning of the buffer when 
inserting a bookmark into it, just in case.

  --joe

On Sat, 2003-05-03 at 18:33, Joseph Mocker wrote:
> 
> 
> 
>  This plugin is a great idea, but I think I've stumbled over a bug. 
> Seems after pasting in
> a bookmark, you have to select the SQL you want to execute or
> ctrl-return only executes the
> line you're currently on.  Closing out the window and opening a new one
> gets rid of the
> behaviour, at least until you open another bookmark.
>  
>  That said, and that bug aside, something this simple really is awful
> helpful.
>  
>  Ruffin Bailey
>  
> 
> 
>  
> 

[Squirrel-sql-users] Possible bug in 'drop' function

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

Hi,

I think I've stumbled on a bug in squirrel 1.1-Final
when accessing a Postgres 7.3.2 database.
To reproduce:

1. Create a view in a database

2. Refresh the Objects tree.
   (The new view appears under 'View')

3. Right click on the view name and select 'Drop'

4. A confirmation popup opens with "Are you sure?"

5. Execute the drop

6. The following error message appears:  
   java.sql.SQLException: ERROR:  "<Your-View-Name>" is not a table. 
   Use DROP VIEW to remove a view

7. The view is not removed.

cheers,
Denis


Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ 

[Squirrel-sql-users] Plugin Update - Look and Feel 0.31

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

Version 0.31 of the Look and Feel Plugin has
been released. Downloads can be found here:

https://sourceforge.net/project/showfiles.php?group_id=28383&release_id=156824

This plugin allows you to change the Look
and Feel for SQuirreL SQL Client, as well as
change the font used. It ships with several
Look and Feel implementations.

Requires at least JDK1.3 and SQuirreL SQL
Client 1.1final1. To install you need to
download the appropriate .zip or .tar.gz file
and unpack it into the plugins directory
within the SQuirreL SQL Client
application making sure that you keep the
directory structure.

Bug Fixes
---------
- the default Metal Theme (Steel) can now be Specified.


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

[Squirrel-sql-users] Plugin Update - Look and Feel 0.30

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

Version 0.30 of the Look and Feel Plugin has
been released. Downloads can be found here:

http://sourceforge.net/project/showfiles.php?group_id=28383&release_id=156391

This plugin allows you to change the Look
and Feel for SQuirreL SQL Client, as well as
change the font used. It ships with several
Look and Feel implementations.

Requires at least JDK1.3 and SQuirreL SQL
Client 1.1final1. To install you need to
download the appropriate .zip or .tar.gz file
and unpack it into the plugins directory
within the SQuirreL SQL Client
application making sure that you keep the
directory structure.

Enhancements
---------------------
- Improved plugin startup time.
- Skin Look and Feel updated to 1.2.3.
- Now supports themes for the Metal Look
  and Feel.
- Plastic Look and Feel added.

Bug Fixes
---------
- If a themepack/skin hasn't been specified
  then default to the first one in the
  dropdown in the preferences dialog.
- Only change the current Look and Feel
  when a new Look and Feel is actually
  selected in the preferences dialog.

Other
-----
- Display the licences for all the supplied Look
  and Feel implementations in the Licence
  menu option.

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

 

Re: [Squirrel-sql-users] Re: New Plugin - SQL Bookmark (bug)

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

Hi Ruffin,

I've passed your message on to Joe Mocker the developer of the plugin.

Thanks for the feedback.

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

----- Original Message -----
From: "Ruffin Bailey" <Ruf...@Bl...>
Date: Wednesday, April 30, 2003 3:08 am
Subject: [Squirrel-sql-users] Re: New Plugin - SQL Bookmark (bug)

> This plugin is a great idea, but I think I've stumbled over a bug.
> Seems after pasting in a bookmark, you have to select the SQL you
> want to execute or ctrl-return only executes the line you're
> currently on.  Closing out the window and opening a new one gets
> rid of the behaviour, at least until you open another bookmark.
>
> That said, and that bug aside, something this simple really is
> awful helpful.
>
> Ruffin Bailey
> 
 

Re: [Squirrel-sql-users] RE: New Plugin - SQL Bookmark

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

Hi Denis,

I've passed this on to Joe Mocker the developer of the plugin. Thanks
for the feedback.

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

----- Original Message -----
From: "Denis Grannell" <dgr...@we...>
Date: Wednesday, April 30, 2003 9:45 pm
Subject: [Squirrel-sql-users] RE: New Plugin - SQL Bookmark

> Hi,
>
> > This plugin is a great idea
>
> I agree, it most certainly is a huge help.
> Would it be viable though to make the bookmarks menu
> hierarchical?. If you could group bookmarks together
> under a folder icon, I think that would make the
> function really super.  
> I was thinking of a display that would look similar to
> the way the objects tree is displayed at the moment.
>
> cheers,
> Denis
>
> Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
> Tel: +49 89 201 3672          Fax: +49 89 202 2875
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
 

[Squirrel-sql-users] RE: New Plugin - SQL Bookmark

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

Hi,

> This plugin is a great idea

I agree, it most certainly is a huge help.
Would it be viable though to make the bookmarks menu
hierarchical?. If you could group bookmarks together
under a folder icon, I think that would make the 
function really super.  
I was thinking of a display that would look similar to 
the way the objects tree is displayed at the moment.

cheers,
Denis

Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

[Squirrel-sql-users] Re: New Plugin - SQL Bookmark (bug)

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

This plugin is a great idea, but I think I've stumbled over a bug.  =
Seems after pasting in a bookmark, you have to select the SQL you want =
to execute or ctrl-return only executes the line you're currently on.  =
Closing out the window and opening a new one gets rid of the behaviour, =
at least until you open another bookmark.

That said, and that bug aside, something this simple really is awful =
helpful.

Ruffin Bailey

[Squirrel-sql-users] New Plugin - SQL Bookmark

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

This is the first release of a new, "SQL 
Bookmark" plugin for SQuirrel-SQL. This 
plugin allows you to manage commonly used 
SQL code for easy reuse. The plugin also 
provides a simple syntax for parameter 
replacement within the bookmarked SQL. As 
the SQL is reloaded, the user is prompted to 
enter values for any embedded parameters, 
after which the SQL is loaded into the edit 
buffer for execution. 

The plugin requires SQuirreL SQL Client 
1.1final1 and JDK 1.3+. 

To install you need to download the 
appropriate .zip or .tar.gz file and unpack it 
into the plugins directory within the SQuirreL 
SQL Client application making sure that you 
keep the directory structure. 

Downloads can be found at: 
http://sourceforge.net/project/showfiles.php?
group_id=28383&release_id=155627

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

Re: [Squirrel-sql-users] Oracle Extension Can't Display PL/SQL in Packages

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

Hi Mike,

I'm glad SQuirreL is useful for you.

> 1) Allow viewing PL/SQL in Packages (this one shouldn't be too big)

This should work now. The Oracle plugin adds several new nodes to the
object tree including a "PACKAGE" node. Under this node the stored
procedures should be grouped by their package. Let me know if this
doesn't work for you.

> 2) Allow Editing/Recompiling PL/SQL Packages (obviously, this 
> could mushroom
> into a full-blown
>    PL/SQL editor tool and that is what I'm intending here)
> 3) Provide a feature to do EXPLAIN PLANs on SQL statements (I know 
> this one
> is not small either)

With everything else happening with SQuirreL at the moment I don't have
any time to work on the oracle plugin, however a couple of people have
expressed an interest in taking on further development of the Oracle
plugin so I'll pass on your request and we'll see what happens.
 
--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: "CORUM, M E [AG/1000]" <m.e...@mo...>
Date: Saturday, April 26, 2003 0:38 am
Subject: [Squirrel-sql-users] Oracle Extension Can't Display PL/SQL in
Packages

> 
> The tool is great.  We are hoping that it will eventually become a
> replacement for Toad.
> I installed the Oracle extension because I wanted to look at our 
> PL/SQL.Like most Oracle
> sites, we have a rule that there shall be no "orphan'd" PL/SQL.  
> This means
> that all PL/SQL
> code -must- be in Packages and not just straight procedures and 
> functionsoutside of 
> packages.  The Oracle extension is great but it can't show PL/SQL in
> packages, only
> orphan'd procedures and functions.  So I have three enhancement 
> requests:
> 1) Allow viewing PL/SQL in Packages (this one shouldn't be too big)
> 2) Allow Editing/Recompiling PL/SQL Packages (obviously, this 
> could mushroom
> into a full-blown
>    PL/SQL editor tool and that is what I'm intending here)
> 3) Provide a feature to do EXPLAIN PLANs on SQL statements (I know 
> this one
> is not small either)
> 
> Mike Corum
> Monsanto
> 
> 
> -------------------------------------------------------
> 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] Oracle Extension Can't Display PL/SQL in Packages

[CORUM, M E [AG/1000] <m.e...@mo...>]

The tool is great.  We are hoping that it will eventually become a
replacement for Toad.
I installed the Oracle extension because I wanted to look at our PL/SQL.
Like most Oracle
sites, we have a rule that there shall be no "orphan'd" PL/SQL.  This means
that all PL/SQL
code -must- be in Packages and not just straight procedures and functions
outside of 
packages.  The Oracle extension is great but it can't show PL/SQL in
packages, only
orphan'd procedures and functions.  So I have three enhancement requests:

1) Allow viewing PL/SQL in Packages (this one shouldn't be too big)
2) Allow Editing/Recompiling PL/SQL Packages (obviously, this could mushroom
into a full-blown
    PL/SQL editor tool and that is what I'm intending here)
3) Provide a feature to do EXPLAIN PLANs on SQL statements (I know this one
is not small either)

Mike Corum
Monsanto

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

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

Hi,

Colin - sorry about the confusion surrounding my posting
that(allegedly) disappeared! I just didn't wait long enough
before getting hysterical :-)
Anyway, your tip to update the JRE to 1.3.1 was spot on 
and did the trick. Much appreciated.

cheers,
Denis

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

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

Hi Denis,

It made it to the list - at least for me :-)   I've cced you this time
in case you're having problems receiving emails from the list.

Heres the reply I sent:
<snip>
I've managed to duplicate your problem. Its appears to be a bug in Java
1.3.0. Updating to Java 1.3.1 will fix it.
</snip>

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

----- Original Message -----
From: "Denis Grannell" <dgr...@we...>
Date: Wednesday, April 16, 2003 4:56 am
Subject: [Squirrel-sql-users] Re:Object tree displays OK, but SQL
commands won't exececute

> Hi Colin,
> 
> I tried to post this reply yesterday but it didn't 
> appear in the list, anyway...
> first of all, thanks for the response.
> 
> 
> > However having a blank line between the SQL statement and the
> > caret will cause this problem.
> 
> I definitely have the cursor on the same line as 
> the sql statement.
> 
> > In 1.1 having the cursor on the next line will still execute
> 
> The version I have is 1.1-final.
> 
> This is what appears in the client window, maybe
> you can interpret what it says.
> 
> cheers,
> Denis Grannell
> 
> at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
> at java.awt.Component.processMouseEvent(Unknown Source)
> at java.awt.Component.processEvent(Unknown Source)
> at java.awt.Container.processEvent(Unknown Source)
> at java.awt.Component.dispatchEventImpl(Unknown Source)
> at java.awt.Container.dispatchEventImpl(Unknown Source)
> at java.awt.Component.dispatchEvent(Unknown Source)
> at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
> at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
> at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
> at java.awt.Container.dispatchEventImpl(Unknown Source)
> at java.awt.Window.dispatchEventImpl(Unknown Source)
> at java.awt.Component.dispatchEvent(Unknown Source)
> at java.awt.EventQueue.dispatchEvent(Unknown Source)
> at java.awt.EventDispatchThread.pumpOneEvent(Unknown Source)
> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.awt.EventDispatchThread.run(Unknown Source)
> 
> 
> _________________________________________________________
> | Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany |
> | Tel: +49 89 2013672                 Fax: +49 89 2022875 |
> |_________________________________________________________|
> 
> 
> 
> -------------------------------------------------------
> 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] Re:Object tree displays OK, but SQL commands won't exececute

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

Hi Colin,

I tried to post this reply yesterday but it didn't 
appear in the list, anyway...
first of all, thanks for the response.


> However having a blank line between the SQL statement and the
> caret will cause this problem.

I definitely have the cursor on the same line as 
the sql statement.

> In 1.1 having the cursor on the next line will still execute

The version I have is 1.1-final.

This is what appears in the client window, maybe
you can interpret what it says.

cheers,
Denis Grannell

 at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
 at java.awt.Component.processMouseEvent(Unknown Source)
 at java.awt.Component.processEvent(Unknown Source)
 at java.awt.Container.processEvent(Unknown Source)
 at java.awt.Component.dispatchEventImpl(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Window.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.EventQueue.dispatchEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpOneEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.run(Unknown Source)


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

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

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

Hi Denis,

I've managed to duplicate your problem. Its appears to be a bug in Java
1.3.0. Updating to Java 1.3.1 will fix it.

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

----- Original Message -----
From: "Denis Grannell" <dgr...@we...>
Date: Tuesday, April 15, 2003 4:42 am
Subject: [Squirrel-sql-users] Re: Object tree displays OK, but SQL
commands won't exececute

> Hi Colin,
> 
> First of all, thanks for the response.
> 
> > However having a blank line between the SQL statement and the
> > caret will cause this problem.
> 
> I definitely have the cursor on the same line as 
> the sql statement.
> 
> > In 1.1 having the cursor on the next line will still execute
> 
> The version I have is 1.1-final.
> 
> This is what appears in the client window, maybe
> you can interpret what it says.
> 
> cheers,
> Denis Grannell
> 
> at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
> at java.awt.Component.processMouseEvent(Unknown Source)
> at java.awt.Component.processEvent(Unknown Source)
> at java.awt.Container.processEvent(Unknown Source)
> at java.awt.Component.dispatchEventImpl(Unknown Source)
> at java.awt.Container.dispatchEventImpl(Unknown Source)
> at java.awt.Component.dispatchEvent(Unknown Source)
> at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
> at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
> at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
> at java.awt.Container.dispatchEventImpl(Unknown Source)
> at java.awt.Window.dispatchEventImpl(Unknown Source)
> at java.awt.Component.dispatchEvent(Unknown Source)
> at java.awt.EventQueue.dispatchEvent(Unknown Source)
> at java.awt.EventDispatchThread.pumpOneEvent(Unknown Source)
> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.awt.EventDispatchThread.run(Unknown Source)
> 
> 
> 
> 
> _________________________________________________________
> | Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany |
> | Tel: +49 89 2013672                 Fax: +49 89 2022875 |
> |_________________________________________________________|
> 
> 
> 
> 
> 
> -------------------------------------------------------
> 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] Re: Object tree displays OK, but SQL commands won't exececute

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

Hi Colin,

First of all, thanks for the response.

> However having a blank line between the SQL statement and the
> caret will cause this problem.

I definitely have the cursor on the same line as 
the sql statement.

> In 1.1 having the cursor on the next line will still execute

The version I have is 1.1-final.

This is what appears in the client window, maybe
you can interpret what it says.

cheers,
Denis Grannell

 at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
 at java.awt.Component.processMouseEvent(Unknown Source)
 at java.awt.Component.processEvent(Unknown Source)
 at java.awt.Container.processEvent(Unknown Source)
 at java.awt.Component.dispatchEventImpl(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Window.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.EventQueue.dispatchEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpOneEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.run(Unknown Source)


 

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