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

Hi Folks,

I work on Ingres 2.6, with the driver supplied by CA.
Unfortunately, the Ingres driver has a bug where the values returned by the=
 DatabaseMetaData.getSchemas() method can't then be given straight back to =
the DatabaseMetaData .getTables() method (the schema names returned have a =
bunch of spaces at the end).
I fixed the issue by adding a single line to the Squirrel framework net.sou=
rceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables() method that tr=
immed the schema name, but I'm thinking that the better way to fix this is =
just to write a plugin for Squirrel that modifies the schema name before Sq=
uirrel tries to use it to list the table names.

Unfortunately, I just don't have time right now to learn how to write a Squ=
irrel plugin. =20
I'm just wondering if anyone can confirm that I can intercept and alter the=
 schema name from within a plugin before Squirrel tries to use it to list t=
he tables?

If this can't be done I'd like to submit a patch for the getTables() method=
 that will trim the schema name before giving it to the getTables() method.
Unfortunately I don't have access to CVS from work because of firewall and =
proxying issues.
If I can't do what I need to do from a plugin, how do I submit a patch for =
Squirrel (and will it be accepted?)
If it needs to be a framework patch, I'd really like to get it in before 1.=
2 goes final so that I can point people to a publicly distributed version o=
f Squirrel that will work with Ingres.

Cheers,
Shorn.


************************************************************************
The information in this e-mail together with any attachments is
intended only for the person or entity to which it is addressed
and may contain confidential and/or privileged material.
Any form of review, disclosure, modification, distribution
and/or publication of this e-mail message is prohibited. =20
If you have received this message in error, you are asked to
inform the sender as quickly as possible and delete this message
and any copies of this message from your computer and/or your
computer system network. =20
************************************************************************

Maury,
Thanks for looking them up...

Maury Hammel wrote:

> Glenn:
> 
>> Well, that depends....
>> The data type in the DBMS gets mapped to a SQL type code somewhere 
>> (either in the DBMS or in the Java driver - I don't know).  There is a 
>> list of standard "known" codes in java.sql.Types.java, but every DBMS 
>> I've seen so far implements lots of other data types that do not map 
>> to codes in that file.  The only codes that we can reliably build 
>> editors for are those in the Types.java file (since different DBMSs 
>> might use the same non-standard code for different purposes).  
>> Therefore, to know if we will be able to create an editor for the 
>> NUMBER type, we will need to know the SQL code used by Oracle for that 
>> type.  This can be found in the COLUMNS tab field named "DATA_TYPE".  
>> If you let me know what that number is, I can tell you if it is 
>> possible to make an editor for it, but we still won't know whether 
>> we'll get around to it or not.
> 
> 
> Ah, okay.  I did a quick check of some databases and got the types that 
> don't appear to be editable:
> 
> TYPE_NAME value     DATA_TYPE value      java.sql.Types.?
> ---------------     ---------------      -------------------------
> NUMBER              3                    java.sql.Types.DECIMAL
> DATE                93                   java.sql.Types.TIMESTAMP
> TIMESTAMP           1111                 java.sql.Types.OTHER
> BLOB                1111                 java.sql.Types.OTHER
> CLOB                1111                 java.sql.Types.OTHER
> 
> Ugh, I don't like the look of the TIMESTAMP, BLOB and CLOB values.  Can 
> you not base the decision about editing on the "TYPE_NAME" column?  Or 
> will there be the API to allow a database-specific plug-in to handle the 
> 'OTHER's?


I don't like their looks either :-).

The problem is how to handle things that do not have a "standard" type 
associated with them.  What java object are they transformed into 
internally?  What rules do we allow/disallow on editing of the string 
representation of that type?

The 3 OTHERs listed here are prime examples of the problems.  Each DBMS 
seems to have its own representation of TIMESTAMP, and there is no 
guarantee that they would look or work the same from one DBMS to 
another.  Does your DMBS include milliseconds?  Yes?  Well too bad - we 
couldn't include those because someone else's DBMS does not allow them. 
  Your DBMS wants TIMESTAMPs as "hh:mm:ss"?  Well your neighbor's stores 
them in "seconds since beginning of the epoch".  You get the idea.

BLOBs and CLOBs are even worse.  You may have noticed in java.sql.Types 
that BLOB and CLOB have special codes of their own (2004 & 2005 
respectivly).  These have special meaning since they are handled by Blob 
and Clob objects within Java.  When you get the data from the resultset, 
you read it into a Blob/Clob object which does _not_ include the actual 
data.  That column data is read from the DB by making a call on the 
Blob/Clob object.  Since Oracle maps type-name "BLOB" to 
java.sql.Type.OTHER, it would not use that 2-stage mechanism, and thus 
would not operate as a "BLOB" should, even though it has that name. 
(Actually, this surprises the heck out of me since I had the impression 
from some info from Colin that Oracle had real BLOB/CLOB types, not 
something fudged.  By the way, every DBMS I've been able to get running 
on my machine uses some funky non-standard BLOB/CLOB mechanism while 
calling the types "BLOB" and "CLOB".  Postgess actually stores them as 
LONGVARBINARY objects!)

So you see my problem is how to handle things consistantly from DBMS to 
DBMS when the DMBS manufacturers haven't agreed on how to handle things 
consistantly.  I really think that relying on the name would get us in 
trouble (witness the "BLOB/CLOB" case).  I haven't thought about the 
DBMS-specific plug-in approach, but that might work.  Any other good ideas?

Glenn


> 
> 
> Maury...

Glenn:

> Well, that depends....
> The data type in the DBMS gets mapped to a SQL type code somewhere 
> (either in the DBMS or in the Java driver - I don't know).  There is a 
> list of standard "known" codes in java.sql.Types.java, but every DBMS 
> I've seen so far implements lots of other data types that do not map to 
> codes in that file.  The only codes that we can reliably build editors 
> for are those in the Types.java file (since different DBMSs might use 
> the same non-standard code for different purposes).  Therefore, to know 
> if we will be able to create an editor for the NUMBER type, we will need 
> to know the SQL code used by Oracle for that type.  This can be found in 
> the COLUMNS tab field named "DATA_TYPE".  If you let me know what that 
> number is, I can tell you if it is possible to make an editor for it, 
> but we still won't know whether we'll get around to it or not.

Ah, okay.  I did a quick check of some databases and got the types that don't 
appear to be editable:

TYPE_NAME value     DATA_TYPE value      java.sql.Types.?
---------------     ---------------      -------------------------
NUMBER              3                    java.sql.Types.DECIMAL
DATE                93                   java.sql.Types.TIMESTAMP
TIMESTAMP           1111                 java.sql.Types.OTHER
BLOB                1111                 java.sql.Types.OTHER
CLOB                1111                 java.sql.Types.OTHER

Ugh, I don't like the look of the TIMESTAMP, BLOB and CLOB values.  Can you not 
base the decision about editing on the "TYPE_NAME" column?  Or will there be the 
API to allow a database-specific plug-in to handle the 'OTHER's?


Maury...
-- 

Maury Hammel
Cronus Technologies Inc.

http://www.cronustech.com

Maury Hammel wrote:

> I've noticed that you cannot edit columns that have the Oracle datatype 
> NUMBER.  Is it planned to add this for 1.2 final?


Well, that depends....
The data type in the DBMS gets mapped to a SQL type code somewhere 
(either in the DBMS or in the Java driver - I don't know).  There is a 
list of standard "known" codes in java.sql.Types.java, but every DBMS 
I've seen so far implements lots of other data types that do not map to 
codes in that file.  The only codes that we can reliably build editors 
for are those in the Types.java file (since different DBMSs might use 
the same non-standard code for different purposes).  Therefore, to know 
if we will be able to create an editor for the NUMBER type, we will need 
to know the SQL code used by Oracle for that type.  This can be found in 
the COLUMNS tab field named "DATA_TYPE".  If you let me know what that 
number is, I can tell you if it is possible to make an editor for it, 
but we still won't know whether we'll get around to it or not.


> 
> As well, is it planned to allow deletion and/or insertion of rows from 
> the Contents Tab for 1.2 final (if at all)?


Obviously desireable features!  That's somewhere on my to-do list, but 
not near the top.  Delete should be easy, but I don't know about insert...

Glenn


> 
> 
> Thanks (yet again)... Maury.

I've noticed that you cannot edit columns that have the Oracle datatype NUMBER. 
  Is it planned to add this for 1.2 final?

As well, is it planned to allow deletion and/or insertion of rows from the 
Contents Tab for 1.2 final (if at all)?


Thanks (yet again)... Maury.
-- 

Maury Hammel
Cronus Technologies Inc.

http://www.cronustech.com

Hi Maury,

Its what is known as an unintentional bug :-) I'll take a look at it.
Could you please create a bug report on SF?

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

----- Original Message -----
From: Maury Hammel <mh...@cr...>
Date: Thursday, July 17, 2003 9:23 am
Subject: [Squirrel-sql-develop] Change in behaviour of SQL textarea

> Colin/All:
> 
> I've noticed a difference in the behaviour of the execution of 
> statements in the 
> SQL textarea in 1.2 beta.  For example, you have the following 
> text in the SQL 
> textarea:
> 
> select * from people;
> 
> select * from students;
> select * from plumbers;
> 
> In 1.2, if you press Ctrl-Enter, all three statements are 
> executed.  In 1.1, 
> only the statements in the text block where the cursor was 
> situated was 
> executed.  To be more clear:  If the cursor was on the 'select * 
> from people' 
> line, only that query would execute.  If the cursor was anywhere 
> on the lines 
> containing the 'select * from students' or the 'select * from 
> plumbers' queries, 
> then only those two queries would be executed.  The blank line 
> between the two 
> code blocks seemed to act as a terminator of some sort in 1.1, but 
> no longer is 
> in 1.2.
> 
> Is this an intentional change, and if not, may I have it changed 
> back? :-)
> 
> 
> Thanks... Maury.
> -- 
> 
> Maury Hammel
> Cronus Technologies Inc.
> 
> http://www.cronustech.com
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: VM Ware
> With VMware you can run multiple operating systems on a single 
> machine.WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual 
> machines at the
> same time. Free trial click here: http://www.vmware.com/wl/offer/345/0
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
 

Colin/All:

I've noticed a difference in the behaviour of the execution of statements in the 
SQL textarea in 1.2 beta.  For example, you have the following text in the SQL 
textarea:

select * from people;

select * from students;
select * from plumbers;

In 1.2, if you press Ctrl-Enter, all three statements are executed.  In 1.1, 
only the statements in the text block where the cursor was situated was 
executed.  To be more clear:  If the cursor was on the 'select * from people' 
line, only that query would execute.  If the cursor was anywhere on the lines 
containing the 'select * from students' or the 'select * from plumbers' queries, 
then only those two queries would be executed.  The blank line between the two 
code blocks seemed to act as a terminator of some sort in 1.1, but no longer is 
in 1.2.

Is this an intentional change, and if not, may I have it changed back? :-)


Thanks... Maury.
-- 

Maury Hammel
Cronus Technologies Inc.

http://www.cronustech.com

The second beta of 1.2 is now available. This release is primarily to 
address a bug in data editing that could lead to data corruption.

The changes are:

Enhancements
------------
- Change the background of the contents tab when in "edit mode" (Glenn
   Griffin)
- Put quotes around character data in the contents tab Filter (Maury
   Hammel).
- Column names in the Contents Tab Filter are now sorted (Maury Hammel).
- The IN operator has been added to the Contents Tab Filter (Maury
   Hammel).
- New application setting allows you to specify whether the coloured
   icons are shown in toolbars (Bai Yuhong).

Bug Fixes
---------
- Fix data corruption issue if you change the selected table in the
   object tree while editing data (Glenn Griffin)

The homepage can be found at http://squirrel-sql.sf.net and downloads 
are at 
https://sourceforge.net/project/showfiles.php?group_id=28383&release_id=171889


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

Yes its harmless. Theres a number of similar errors that are written to
the log that shouldn't be. I'll clean this up in 1.2

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

----- Original Message -----
From: KosherJava <kos...@od...>
Date: Tuesday, July 15, 2003 6:49 am
Subject: Re: [Squirrel-sql-develop] [Beta 1.2] Syntax plug-in.  Is this
a bug?

> I have the same stack trace in my logs. So far it does not seem to 
> be causing any problems  
>  
> -----Original Message----- 
>  
> To whom it may concern: 
>  
> I noticed that the SQuirreL log contains the following exceptions 
> when starting 
> up the new syntax plug-in. Are these a problem or should they just 
> be ignored? 
>  
> 907 [main] ERROR 
> net.sourceforge.squirrel_sql.client.plugin.PluginManager - 
> Error loading class com.Ostermiller.Syntax.ToHTMLAntTask$1 
> java.lang.NoClassDefFoundError: 
> org/apache/tools/ant/util/FileNameMapper 
> at java.lang.ClassLoader.defineClass0(Native Method) 
> at java.lang.ClassLoader.defineClass(ClassLoader.java:502) 
> at 
> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) 
> at java.net.URLClassLoader.defineClass(URLClassLoader.java:250) 
> at java.net.URLClassLoader.access$100(URLClassLoader.java:54) 
> at java.net.URLClassLoader$1.run(URLClassLoader.java:193) 
> at java.security.AccessController.doPrivileged(Native Method) 
> at java.net.URLClassLoader.findClass(URLClassLoader.java:186) 
> at 
>
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113)

> at java.lang.ClassLoader.loadClass(ClassLoader.java:299) 
> at java.lang.ClassLoader.loadClass(ClassLoader.java:255) 
> at 
>
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:86)

> at 
>
net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugins(PluginManager.java:366)

> at 
>
net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:425)

> at 
>
net.sourceforge.squirrel_sql.client.Application.startup(Application.java:155)

> at net.sourceforge.squirrel_sql.client.Main.main(Main.java:43) 
> 907 [main] ERROR 
> net.sourceforge.squirrel_sql.client.plugin.PluginManager - 
> Error loading class com.Ostermiller.Syntax.ToHTMLAntTask 
> java.lang.NoClassDefFoundError: 
> org/apache/tools/ant/taskdefs/MatchingTask 
> at java.lang.ClassLoader.defineClass0(Native Method) 
> at java.lang.ClassLoader.defineClass(ClassLoader.java:502) 
> at 
> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) 
> at java.net.URLClassLoader.defineClass(URLClassLoader.java:250) 
> at java.net.URLClassLoader.access$100(URLClassLoader.java:54) 
> at java.net.URLClassLoader$1.run(URLClassLoader.java:193) 
> at java.security.AccessController.doPrivileged(Native Method) 
> at java.net.URLClassLoader.findClass(URLClassLoader.java:186) 
> at 
>
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113)

> at java.lang.ClassLoader.loadClass(ClassLoader.java:299) 
> at java.lang.ClassLoader.loadClass(ClassLoader.java:255) 
> at 
>
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:86)

> at 
>
net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugins(PluginManager.java:366)

> at 
>
net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:425)

> at 
>
net.sourceforge.squirrel_sql.client.Application.startup(Application.java:155)

> at net.sourceforge.squirrel_sql.client.Main.main(Main.java:43) 
>  
> Thanks... Maury. 
> -- 
>  
> Maury Hammel 
> Cronus Technologies Inc. 
>  
> http://www.cronustech.com 
>  
>  
> ------------------------------------------------------- 
> This SF.Net email sponsored by: Parasoft 
> Error proof Web apps, automate testing & more. 
> Download & eval WebKing and get a free book. 
> www.parasoft.com/bulletproofapps1 
> _______________________________________________ 
> Squirrel-sql-develop mailing list 
> Squ...@li... 
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop 
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Parasoft
> Error proof Web apps, automate testing & more.
> Download & eval WebKing and get a free book.
> www.parasoft.com/bulletproofapps1
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
 

I have the same stack trace in my logs. So far it does not seem to be causing any problems  
  
-----Original Message----- 
  
To whom it may concern: 
  
I noticed that the SQuirreL log contains the following exceptions when starting 
up the new syntax plug-in. Are these a problem or should they just be ignored? 
  
907 [main] ERROR net.sourceforge.squirrel_sql.client.plugin.PluginManager - 
Error loading class com.Ostermiller.Syntax.ToHTMLAntTask$1 
java.lang.NoClassDefFoundError: org/apache/tools/ant/util/FileNameMapper 
at java.lang.ClassLoader.defineClass0(Native Method) 
at java.lang.ClassLoader.defineClass(ClassLoader.java:502) 
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) 
at java.net.URLClassLoader.defineClass(URLClassLoader.java:250) 
at java.net.URLClassLoader.access$100(URLClassLoader.java:54) 
at java.net.URLClassLoader$1.run(URLClassLoader.java:193) 
at java.security.AccessController.doPrivileged(Native Method) 
at java.net.URLClassLoader.findClass(URLClassLoader.java:186) 
at 
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113) 
at java.lang.ClassLoader.loadClass(ClassLoader.java:299) 
at java.lang.ClassLoader.loadClass(ClassLoader.java:255) 
at 
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:86) 
at 
net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugins(PluginManager.java:366) 
at 
net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:425) 
at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:155) 
at net.sourceforge.squirrel_sql.client.Main.main(Main.java:43) 
907 [main] ERROR net.sourceforge.squirrel_sql.client.plugin.PluginManager - 
Error loading class com.Ostermiller.Syntax.ToHTMLAntTask 
java.lang.NoClassDefFoundError: org/apache/tools/ant/taskdefs/MatchingTask 
at java.lang.ClassLoader.defineClass0(Native Method) 
at java.lang.ClassLoader.defineClass(ClassLoader.java:502) 
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) 
at java.net.URLClassLoader.defineClass(URLClassLoader.java:250) 
at java.net.URLClassLoader.access$100(URLClassLoader.java:54) 
at java.net.URLClassLoader$1.run(URLClassLoader.java:193) 
at java.security.AccessController.doPrivileged(Native Method) 
at java.net.URLClassLoader.findClass(URLClassLoader.java:186) 
at 
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113) 
at java.lang.ClassLoader.loadClass(ClassLoader.java:299) 
at java.lang.ClassLoader.loadClass(ClassLoader.java:255) 
at 
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:86) 
at 
net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugins(PluginManager.java:366) 
at 
net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:425) 
at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:155) 
at net.sourceforge.squirrel_sql.client.Main.main(Main.java:43) 
  
Thanks... Maury. 
-- 
  
Maury Hammel 
Cronus Technologies Inc. 
  
http://www.cronustech.com 
  
  
------------------------------------------------------- 
This SF.Net email sponsored by: Parasoft 
Error proof Web apps, automate testing & more. 
Download & eval WebKing and get a free book. 
www.parasoft.com/bulletproofapps1 
_______________________________________________ 
Squirrel-sql-develop mailing list 
Squ...@li... 
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop 

To whom it may concern:

I noticed that the SQuirreL log contains the following exceptions when starting 
up the new syntax plug-in.  Are these a problem or should they just be ignored?

907  [main] ERROR net.sourceforge.squirrel_sql.client.plugin.PluginManager  - 
Error loading class com.Ostermiller.Syntax.ToHTMLAntTask$1
java.lang.NoClassDefFoundError: org/apache/tools/ant/util/FileNameMapper
	at java.lang.ClassLoader.defineClass0(Native Method)
	at java.lang.ClassLoader.defineClass(ClassLoader.java:502)
	at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
	at java.net.URLClassLoader.defineClass(URLClassLoader.java:250)
	at java.net.URLClassLoader.access$100(URLClassLoader.java:54)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:193)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
	at 
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
	at 
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:86)
	at 
net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugins(PluginManager.java:366)
	at 
net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:425)
	at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:155)
	at net.sourceforge.squirrel_sql.client.Main.main(Main.java:43)
907  [main] ERROR net.sourceforge.squirrel_sql.client.plugin.PluginManager  - 
Error loading class com.Ostermiller.Syntax.ToHTMLAntTask
java.lang.NoClassDefFoundError: org/apache/tools/ant/taskdefs/MatchingTask
	at java.lang.ClassLoader.defineClass0(Native Method)
	at java.lang.ClassLoader.defineClass(ClassLoader.java:502)
	at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
	at java.net.URLClassLoader.defineClass(URLClassLoader.java:250)
	at java.net.URLClassLoader.access$100(URLClassLoader.java:54)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:193)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
	at 
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
	at 
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.getAssignableClasses(MyURLClassLoader.java:86)
	at 
net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugins(PluginManager.java:366)
	at 
net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:425)
	at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:155)
	at net.sourceforge.squirrel_sql.client.Main.main(Main.java:43)


Thanks... Maury.
-- 

Maury Hammel
Cronus Technologies Inc.

http://www.cronustech.com

The first beta of 1.2 is now available. A new version of the MySQL 
plugin has been released and the jEdit plugin has been replaced by the 
Syntax Highlighting plugin. The main changes in 1.2beta1 include:

You can now maintain data in the Contents Tab for a table, check the 
help file under "Editing Data in the Contents Tab" for more information.

You can filter data in the contents tab in order to "drill down" to the 
data you want to see.

JDBC driver properties can now be specified for a connection.

SQL history is now persistent and shareable between aliases.

Results will now be displayed for all the result sets returned by an
executed SQL statement, not just the first one.

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

The full list of changes is at
http://sourceforge.net/project/shownotes.php?release_id=170667

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

Sounds good.

> Hey, are those hooks in the beta for adding the "drop view if 
> the view already exists" plugin?  No rush.  That's probably 
> longer than a July 4th weekend project.

Not yet. If I get 1.2beta1 out this next week (and its looking good) then
I'll be starting on my todo list.

Col

> -----Original Message-----
> From: Ruffin Bailey [mailto:Ruf...@Bl...]
> Sent: Thursday, 3 July 2003 22:11
> To: squ...@li...
> Subject: [Squirrel-sql-develop] Re: Printing?
> 
> 
> > If somebody (Ruffin?) wants to look at adding print 
> functionality either
> > through the link Ruffin found or Glenns code please do, I 
> don't have the
> > time at the moment.
> 
> Super.  Sounds like a good "Independence Day Weekend if 
> you're an American Project" type project.
> 
> I'll let you know how it went next Monday...  I'm hopeful 
> you'll be able to print any way you like, as long as it's 
> using the font, point-size, and margins I want to use.  ;^)
> 
> Hey, are those hooks in the beta for adding the "drop view if 
> the view already exists" plugin?  No rush.  That's probably 
> longer than a July 4th weekend project.
> 
> Thanks,
> 
> Ruffin Bailey
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_06
1203_01/01
_______________________________________________
Squirrel-sql-develop mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

> If somebody (Ruffin?) wants to look at adding print functionality =
either
> through the link Ruffin found or Glenns code please do, I don't have =
the
> time at the moment.

Super.  Sounds like a good "Independence Day Weekend if you're an =
American Project" type project.

I'll let you know how it went next Monday...  I'm hopeful you'll be able =
to print any way you like, as long as it's using the font, point-size, =
and margins I want to use.  ;^)

Hey, are those hooks in the beta for adding the "drop view if the view =
already exists" plugin?  No rush.  That's probably longer than a July =
4th weekend project.

Thanks,

Ruffin Bailey

Hi,

If somebody (Ruffin?) wants to look at adding print functionality either
through the link Ruffin found or Glenns code please do, I don't have the
time at the moment.

Pat Connors has just started looking at the "XML output for a query" RFE
but I'm not sure how much time he will be able to spend on it.

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

----- Original Message -----
From: gwg <gw...@co...>
Date: Thursday, July 3, 2003 5:16 am
Subject: Re: [Squirrel-sql-develop] Printing?

> In my previous squirrel-like product I had a simple print function 
> that 
> would take a table that was larger than the page and chop it up 
> into 
> page-size pieces for printing.  It included a header as well as 
> the 
> position of the page in the output (i.e. row and column of this 
> page 
> when putting the pages together in a 2-dimensional array).  I had 
> thought to try reusing that code in squirrel, but I'm still tied 
> up with 
> the editing functions.  I don't know how that compares with the 
> functionality referenced by Ruffin or how easy it would be to 
> adjust 
> that code to squirrel, but if someone would like to try, let me 
> know and 
> I'll send it.
> 
> Glenn
> 
> Ruffin Bailey wrote:
> 
> > Looks like there's some easy to steal code to add *really* basic 
> print functionality to SQrL here:
> > 
> > http://www.cafeaulait.org/course/week13/07.html
> > 
> > I'd be happy to give it a shot this wkend, but didn't want to 
> step on toes.  ;^)  The quick hack would give no font selection, 
> so size selection, no page setup, etc, but I'd be fine with that!
> > 
> > Ruffin Bailey
> > 
> > 
> > -------------------------------------------------------
> > This SF.Net email sponsored by: Free pre-built ASP.NET sites 
> including> Data Reports, E-commerce, Portals, and Forums are 
> available now.
> > Download today and enter to win an XBOX or Visual Studio .NET.
> > http://aspnet.click-
> url.com/go/psa00100006ave/direct;at.asp_061203_01/01> 
> _______________________________________________> Squirrel-sql-
> develop mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> > 
> > 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-
>
url.com/go/psa00100006ave/direct;at.asp_061203_01/01_______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
 

In my previous squirrel-like product I had a simple print function that 
would take a table that was larger than the page and chop it up into 
page-size pieces for printing.  It included a header as well as the 
position of the page in the output (i.e. row and column of this page 
when putting the pages together in a 2-dimensional array).  I had 
thought to try reusing that code in squirrel, but I'm still tied up with 
the editing functions.  I don't know how that compares with the 
functionality referenced by Ruffin or how easy it would be to adjust 
that code to squirrel, but if someone would like to try, let me know and 
I'll send it.

Glenn

Ruffin Bailey wrote:

> Looks like there's some easy to steal code to add *really* basic print functionality to SQrL here:
> 
> http://www.cafeaulait.org/course/week13/07.html
> 
> I'd be happy to give it a shot this wkend, but didn't want to step on toes.  ;^)  The quick hack would give no font selection, so size selection, no page setup, etc, but I'd be fine with that!
> 
> Ruffin Bailey
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
> 

In regards to printing, if http://sourceforge.net/tracker/index.php?func=detail&aid=736286&group_id=28383&atid=393417 were ever implemented it would give very nice printing options because it uses FOP to generate PDF that can be printed very easily. Treebeard has the ability to print directly from the app (WYSIWYG like preview) without the need to go through an Acrobat Reader. I will admit that your solution is easier and quicker. 
  

Looks like there's some easy to steal code to add *really* basic print =
functionality to SQrL here:

http://www.cafeaulait.org/course/week13/07.html

I'd be happy to give it a shot this wkend, but didn't want to step on =
toes.  ;^)  The quick hack would give no font selection, so size =
selection, no page setup, etc, but I'd be fine with that!

Ruffin Bailey

Hi Maury,

A number of plugins have been broken by the 1.2 code and new versions
will be released when 1.2beta1 is released. I'm in bugfix mode at the
moment, with just a handful of serious bugs still to fix. Once I've
finished with the core I'll fix the remaining plugins.

The jEdit plugin is a special case in that it will be replaced by the
syntax plugin which is up in CVS at /sql12/plugins/syntax. I'm no longer
using the jEdit text control as the standalone version is now very old
and is not supported. It has a number of problems with JDK 1.4. Slava
has mentiond on the jEdit mailing list that he intends to release a new
version of the jEdit text control and once he does that I may use that
in the syntax plugin.

If you grabbed CVS late last week then you should have the latest code
for the syntax plugin. There are some issues with the syntax
highlighting, and it doesn't yet highlight column/table names.

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

----- Original Message -----
From: Maury Hammel <mh...@cr...>
Date: Tuesday, July 1, 2003 4:35 am
Subject: [Squirrel-sql-develop] Alpha 1.2 and JEdit plug-in

> In case nobody has noticed this yet (or maybe it is my 
> configuration)...
> I am attempting to run a fairly recent extract of 1.2 from CVS 
> (checked out late 
> last week) and have the most recent JEdit plug-in installed, the 
> following error 
> is generated when I attempt to connect to a database:
> 
> java.lang.AbstractMethodError: 
>
net.sourceforge.squirrel_sql.plugins.jedit.JeditSQLEntryPanel.getDoesTextComponentHaveScroller()Z
>         at 
>
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.installSQLEntryPanel(SQLPanel.java:383)
>         at 
>
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.createGUI(SQLPanel.java:933)
>         at 
>
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.<init>(SQLPanel.java:154)
>         at 
>
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.getComponent(SQLTab.java:78)
>         at 
>
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.getSQLPanel(SQLTab.java:128)
>         at 
>
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.setSession(SQLTab.java:89)
>         at 
>
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.<init>(SQLTab.java:50)
>         at 
>
net.sourceforge.squirrel_sql.client.session.MainPanel.createGUI(MainPanel.java:239)
>         at 
>
net.sourceforge.squirrel_sql.client.session.MainPanel.<init>(MainPanel.java:93)
>         at 
>
net.sourceforge.squirrel_sql.client.session.SessionSheet.createUserInterface(SessionSheet.java:350)
>         at 
>
net.sourceforge.squirrel_sql.client.session.SessionSheet.<init>(SessionSheet.java:98)
>         at 
>
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:445)
>         at 
> java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)  
>       at java.awt.EventQueue.dispatchEvent(EventQueue.java:448)
>         at 
>
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:197)
>         at 
>
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
>         at 
> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)
>         at 
> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)
>         at 
> java.awt.EventDispatchThread.run(EventDispatchThread.java:99)
> 
> Maury...
> -- 
> 
> Maury Hammel
> Cronus Technologies Inc.
> 
> http://www.cronustech.com

 

In case nobody has noticed this yet (or maybe it is my configuration)...

I am attempting to run a fairly recent extract of 1.2 from CVS (checked out late 
last week) and have the most recent JEdit plug-in installed, the following error 
is generated when I attempt to connect to a database:

java.lang.AbstractMethodError: net.sourceforge.squirrel_sql.plugins.jedit.JeditS
QLEntryPanel.getDoesTextComponentHaveScroller()Z
         at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.instal
lSQLEntryPanel(SQLPanel.java:383)
         at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.create
GUI(SQLPanel.java:933)
         at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.<init>
(SQLPanel.java:154)
         at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.getCompo
nent(SQLTab.java:78)
         at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.getSQLPa
nel(SQLTab.java:128)
         at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.setSessi
on(SQLTab.java:89)
         at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLTab.<init>(S
QLTab.java:50)
         at net.sourceforge.squirrel_sql.client.session.MainPanel.createGUI(MainP
anel.java:239)
         at net.sourceforge.squirrel_sql.client.session.MainPanel.<init>(MainPane
l.java:93)
         at net.sourceforge.squirrel_sql.client.session.SessionSheet.createUserIn
terface(SessionSheet.java:350)
         at net.sourceforge.squirrel_sql.client.session.SessionSheet.<init>(Sessi
onSheet.java:98)
         at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCo
mmand$Runner.run(ConnectToAliasCommand.java:445)
         at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
         at java.awt.EventQueue.dispatchEvent(EventQueue.java:448)
         at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:197)
         at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:150)
         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)

         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)

         at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)


Maury...
-- 

Maury Hammel
Cronus Technologies Inc.

http://www.cronustech.com

Hi Ronald,

Just to let you know, Glenn Griffin has already enhanced SQuirreL to =
allow
data maintenance in the Contents Tab for a table. This is in the CVS =
module
SQL12 and will be available in the soon to be released 1.2beta.

> i started to write a plugin, so you can update your data in a table. =
The
plugin has now some
> bugs. But my main problem is, that right now my plugin works only for =
one
session. I using a
> static method. With this static method I advise the session to the =
other
class. I looked at the
> jedit plugin, but i couldn=B4t figure out how it works.=20
> my code:=20
> plugin.sessionCreated(ISession session)
> {
> ...
> session.getProperties().setSQLResultsOutputClassName
>
("net.sourceforge.squirrel_sql.plugins.plugin.DataSetViewerTablePanelPlu=
gin"
);
> DataSetViewerTablePanelPlugin.setSession(session);
> }

sessionCreated() is called when a new session is created. Therefore its
called when session1 is created and then called for session2. I don't =
know
what your DataSetViewerTablePanelPlugin.setSession(session) method does =
but
I suspect you are only keeping track of the most recent session. You'll =
need
to keep track of each session.

Col

Hi,
i started to write a plugin, so you can update your data in a table. The plugin has now some bugs. But my main problem is, that right now my plugin works only for one session. I using a static method. With this static method I advise the session to the other class. I looked at the jedit plugin, but i couldn´t figure out how it works. 
my code: 
plugin.sessionCreated(ISession session)
{
...
session.getProperties().setSQLResultsOutputClassName("net.sourceforge.squirrel_sql.plugins.plugin.DataSetViewerTablePanelPlugin");
DataSetViewerTablePanelPlugin.setSession(session);
}
Best regards
Ronald Günther



---------------------------------
Gesendet von http://mail.yahoo.de

Hi,
i started to write a plugin, so you can update your data in a table. The plugin has now some bugs. But my main problem is, that right now my plugin works only for one session. I using a static method. With this static method I advise the session to the other class. I looked at the jedit plugin, but i couldn´t figure out how it works. 
my code: 
plugin.sessionCreated(ISession session)
{
...
session.getProperties().setSQLResultsOutputClassName("net.sourceforge.squirrel_sql.plugins.plugin.DataSetViewerTablePanelPlugin");
DataSetViewerTablePanelPlugin.setSession(session);
}
Best regards
Ronald Günther



---------------------------------
Gesendet von http://mail.yahoo.de

I'm going on hearsay myself as I don't use OS X so some of this could be
wrong.

I know of a couple of organizations that are sticking with java 1.3 on
OS X until 1.4 "stabilizes". These are desktop installs, not server.
Exactly what problems they're having I don't know.

There are some Swing issues where Java just crashes. They sound similar
to the DirectX issues that some video drivers have with 1.4 under Windows.

The Swing printing code isn't in the OS X version. This doesn't affect
SQuirreL as there is currently no print facility in it but having a
chunk of Swing missing makes me nervous.

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

----- Original Message -----
From: "Ruffin Bailey" <Ruf...@Bl...>
Date: Monday, June 23, 2003 10:39 pm
Subject: [Squirrel-sql-develop] Mac OS X Java 1.4.1 -- What went wrong?

> > Colin's mail last week about not using joke 1.4 due to sox 
> issues has me
> > wondering.
> 
> Just out of curiosity (and as an OS X user [at home] myself), what 
> specifically were the issues?  Another project that I at least 
> monitor, Furthurnet, has been reporting a similar bad taste.  
> Anything other than GUI issues?
> 
> Thanks,
> 
> Ruffin Bailey

 

> Colin's mail last week about not using joke 1.4 due to sox issues has =
me
> wondering.

Just out of curiosity (and as an OS X user [at home] myself), what =
specifically were the issues?  Another project that I at least monitor, =
Furthurnet, has been reporting a similar bad taste.  Anything other than =
GUI issues?

Thanks,

Ruffin Bailey