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

[Squirrel-sql-users] Hex display support or Oracle raw?

[Fong, G. <Gar...@US...>]

I just discovered this great program and I need to know how to display=0D=
=0AOracle's raw(16) as hex, not decimal=2E I tried various settings in Data=
=0D=0AType Control but to no avail=2E I thought it might be a driver option=
 but=0D=0AI don't see it listed nor does it seem possible to add options=2E=
=0D=0A=0D=0AThanks=0D=0A=0D=0AGary Fong=0D=0ACode Monkey=0D=0AiKnowMed, A D=
ivision of US Oncology=0D=0A(510) 558-4540=0D=0A(510) 558-4501 fax=0D=0A=0D=
=0A=0D=0A =0D=0A=0D=0A-----------------------------------------=0D=0AThe co=
ntents of this electronic mail message and any attachments=0Aare confidenti=
al, possibly privileged and intended for the=0Aaddressee(s) only=2E  Only t=
he addressee(s) may read, disseminate,=0Aretain or otherwise use this messa=
ge=2E  If received in error, please=0Aimmediately inform the sender and the=
n delete this message without=0Adisclosing its contents to anyone=2E

Re: [Squirrel-sql-users] How to default to dbo?

[Robert M. <rob...@gm...>]

I added it as a feature request here:

http://sourceforge.net/tracker/index.php?func=detail&aid=1763219&group_id=28383&atid=393417

Thanks!

Rob

On 7/28/07, Hans Loeblich <hlo...@kp...> wrote:
> Thank you, that helps a lot.  Very nice feature.
>
> I do still have a few of gripes(feature requests) because I think this
> feature could be made much more useful.
>
> 1. Limiting Catalog Objects by prefix is not the optimal solution for
> me.  For example, I have a catalog "ABC", and "ABC_BAK".  If I only want
> to see ABC, there is no way to do this.
> I think what would be much more powerful, and probably not too difficult
> to implement would be the option to use regular expressions.  Or even
> just a glob matcher (eg "ABC*" to denote anything with a "ABC" prefix).
> You could still do comma delimited globs even.
> This would be good to use for limiting schemas too, but it doesn't
> affect me personally since I only need to see "dbo" (and luckily no
> other schemas begin with dbo).  I think that whatever the final
> decision, a *consistent* form of limiting for all three filters here
> would be a good thing.
>
> 2. The object filter is a nice touch, but ideally I would like to limit
> objects differently per catalog.  All the important tables in one of my
> catalogs have a specific prefix, so I thought I could put this to good
> use.  But in another catalog, there is no particular prefix on any of
> the tables.  So if I limit it for the first catalog, then all my tables
> are gone in the second catalog.  This makes this feature useless in my
> particular case.
>
> 3.  The object filter seems to implement a sort of glob search, but why
> were "%" and "_" chosen?  In my experience, the standard characters are
> usually "*" for zero or more of any character, and "?" to match any one
> character.  The main problem I see with this is that "_" is a valid(and
> very commonly used) character for a table name.
>
> Would these suggestions be better posted to the dev list?
>
> -Hans
>
>
> Robert Manning wrote:
> > On 7/28/07, Hans Loeblich <hlo...@kp...> wrote:
> >
> >> I am just trying out SQuirreL SQL for the first time, and noticed that
> >> it behaves differently than some other database management tools I am
> >> accustomed to.
> >>
> >> I am logging in to a MS SQL Server database, using the jTDS driver, as
> >> user "hloeblich".  At the top level, I see the list of catalogs(i think
> >> this is the word), and I can choose one.  After choosing a catalog, it
> >> looks like I am seeing a list of all usernames.  The problem is that
> >> there is nothing under any of the usernames except for dbo.  It seems
> >> that other tools I have used would default to dbo, and not show the
> >> other folders(if i remember correctly, this whole heirarchy level is
> >> omitted, directly under catalog shows the tables, views, etc.
> >> directories).  Is there some way I can make SQuirreL behave this way.
> >> Please forgive me cause I don't completely understand the user
> >> permissioning, etc.  I did not set up this database, I just have limited
> >> access under my username/login.
> >>
> >
> > There isn't a way to collapse this hiearchy.  The driver tells
> > SQuirreL that a particular table that you see in the tree is in the
> > <username> catalog, and that the it's schema is "dbo".  Theses two
> > pieces of information are required to fully qualify a tablename in
> > SQLServer.  SQuirreL's object tree mirrors the information given by
> > the driver for the database.  You can however add a filter to remove
> > the unused schemas from the tree.  Simply right-click on the top-level
> > node and choose "Edit Objects Filter".  Then type "dbo" in the schema
> > filter textfield.
> >
> > Rob
> >
>
>

Re: [Squirrel-sql-users] How to default to dbo?

[Hans L. <hlo...@kp...>]

Thank you, that helps a lot.  Very nice feature. 

I do still have a few of gripes(feature requests) because I think this 
feature could be made much more useful.

1. Limiting Catalog Objects by prefix is not the optimal solution for 
me.  For example, I have a catalog "ABC", and "ABC_BAK".  If I only want 
to see ABC, there is no way to do this.
I think what would be much more powerful, and probably not too difficult 
to implement would be the option to use regular expressions.  Or even 
just a glob matcher (eg "ABC*" to denote anything with a "ABC" prefix).  
You could still do comma delimited globs even. 
This would be good to use for limiting schemas too, but it doesn't 
affect me personally since I only need to see "dbo" (and luckily no 
other schemas begin with dbo).  I think that whatever the final 
decision, a *consistent* form of limiting for all three filters here 
would be a good thing.

2. The object filter is a nice touch, but ideally I would like to limit 
objects differently per catalog.  All the important tables in one of my 
catalogs have a specific prefix, so I thought I could put this to good 
use.  But in another catalog, there is no particular prefix on any of 
the tables.  So if I limit it for the first catalog, then all my tables 
are gone in the second catalog.  This makes this feature useless in my 
particular case.

3.  The object filter seems to implement a sort of glob search, but why 
were "%" and "_" chosen?  In my experience, the standard characters are 
usually "*" for zero or more of any character, and "?" to match any one 
character.  The main problem I see with this is that "_" is a valid(and 
very commonly used) character for a table name.

Would these suggestions be better posted to the dev list?

-Hans


Robert Manning wrote:
> On 7/28/07, Hans Loeblich <hlo...@kp...> wrote:
>   
>> I am just trying out SQuirreL SQL for the first time, and noticed that
>> it behaves differently than some other database management tools I am
>> accustomed to.
>>
>> I am logging in to a MS SQL Server database, using the jTDS driver, as
>> user "hloeblich".  At the top level, I see the list of catalogs(i think
>> this is the word), and I can choose one.  After choosing a catalog, it
>> looks like I am seeing a list of all usernames.  The problem is that
>> there is nothing under any of the usernames except for dbo.  It seems
>> that other tools I have used would default to dbo, and not show the
>> other folders(if i remember correctly, this whole heirarchy level is
>> omitted, directly under catalog shows the tables, views, etc.
>> directories).  Is there some way I can make SQuirreL behave this way.
>> Please forgive me cause I don't completely understand the user
>> permissioning, etc.  I did not set up this database, I just have limited
>> access under my username/login.
>>     
>
> There isn't a way to collapse this hiearchy.  The driver tells
> SQuirreL that a particular table that you see in the tree is in the
> <username> catalog, and that the it's schema is "dbo".  Theses two
> pieces of information are required to fully qualify a tablename in
> SQLServer.  SQuirreL's object tree mirrors the information given by
> the driver for the database.  You can however add a filter to remove
> the unused schemas from the tree.  Simply right-click on the top-level
> node and choose "Edit Objects Filter".  Then type "dbo" in the schema
> filter textfield.
>
> Rob
>   

Re: [Squirrel-sql-users] How to default to dbo?

[Robert M. <rob...@gm...>]

On 7/28/07, Hans Loeblich <hlo...@kp...> wrote:
> I am just trying out SQuirreL SQL for the first time, and noticed that
> it behaves differently than some other database management tools I am
> accustomed to.
>
> I am logging in to a MS SQL Server database, using the jTDS driver, as
> user "hloeblich".  At the top level, I see the list of catalogs(i think
> this is the word), and I can choose one.  After choosing a catalog, it
> looks like I am seeing a list of all usernames.  The problem is that
> there is nothing under any of the usernames except for dbo.  It seems
> that other tools I have used would default to dbo, and not show the
> other folders(if i remember correctly, this whole heirarchy level is
> omitted, directly under catalog shows the tables, views, etc.
> directories).  Is there some way I can make SQuirreL behave this way.
> Please forgive me cause I don't completely understand the user
> permissioning, etc.  I did not set up this database, I just have limited
> access under my username/login.

There isn't a way to collapse this hiearchy.  The driver tells
SQuirreL that a particular table that you see in the tree is in the
<username> catalog, and that the it's schema is "dbo".  Theses two
pieces of information are required to fully qualify a tablename in
SQLServer.  SQuirreL's object tree mirrors the information given by
the driver for the database.  You can however add a filter to remove
the unused schemas from the tree.  Simply right-click on the top-level
node and choose "Edit Objects Filter".  Then type "dbo" in the schema
filter textfield.

Rob

[Squirrel-sql-users] How to default to dbo?

[Hans L. <hlo...@kp...>]

I am just trying out SQuirreL SQL for the first time, and noticed that 
it behaves differently than some other database management tools I am 
accustomed to.

I am logging in to a MS SQL Server database, using the jTDS driver, as 
user "hloeblich".  At the top level, I see the list of catalogs(i think 
this is the word), and I can choose one.  After choosing a catalog, it 
looks like I am seeing a list of all usernames.  The problem is that 
there is nothing under any of the usernames except for dbo.  It seems 
that other tools I have used would default to dbo, and not show the 
other folders(if i remember correctly, this whole heirarchy level is 
omitted, directly under catalog shows the tables, views, etc. 
directories).  Is there some way I can make SQuirreL behave this way.  
Please forgive me cause I don't completely understand the user 
permissioning, etc.  I did not set up this database, I just have limited 
access under my username/login.

Thank You,
Hans

Re: [Squirrel-sql-users] problem wiht db connection

[Robert M. <rob...@gm...>]

Great.  Thanks for the update!

Rob

On 7/17/07, Radoslaw Tomaszewski <rad...@gm...> wrote:
> Hallo all,
>
> I just solved the problem. The problem is on the db site, with the db
> engine. It has nothing to do with the SQuirreL!  A good description
> you can find at:
>
> http://www-1.ibm.com/support/docview.wss?rs=71&dc=D600&uid=swg21215626
>
> In sort. The db after the fixpac 8.1 FixPak 10 (also known as Version
> 8.2 FixPak 3), can encounter an SQL0443N error if invoking a DB2 Call
> Level Interface (CLI) catalog function (such as SQLTables(),
> SQLColumns(), or SQLStatistics()).
>
> The solution:
>
> db2 terminate
> db2 connect to <database-name>
> db2 bind <path>/db2schema.bnd blocking all grant public sqlerror continue
> db2 terminate
>
> Thanks all, have a nice day
> Radoslaw
>
> 2007/7/17, Robert Manning <rob...@gm...>:
> > Hello,
> >
> > Looks like you have 8.1 fixpak 11 installed.  You might try to get
> > fixpak 14 (that's what I updated to recently).  There is some newer
> > support for IBM's driver in the latest snapshot for getting more
> > detailed error messages from the exceptions that DB2 driver throws.
> > You may want to try that, and report back with a more detailed error
> > message.  The snapshot can be found here:
> >
> > http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=523220
> >
> > The symptom appears to be that whenever SQuirreL asks the driver for
> > metadata about tables, schemas, etc. the driver throws an Exception.
> > I'm guessing - perhaps the system catalogs aren't installed/configured
> > properly - or you don't have access to them?
> >
> > Rob
>
> --
> ITIL,RHCE,CCNA,Linux enthusiast.
> M.Sc. Radoslaw Tomaszewski
>

Re: [Squirrel-sql-users] problem wiht db connection

[Radoslaw T. <rad...@gm...>]

Hallo all,

I just solved the problem. The problem is on the db site, with the db
engine. It has nothing to do with the SQuirreL!  A good description
you can find at:

http://www-1.ibm.com/support/docview.wss?rs=71&dc=D600&uid=swg21215626

In sort. The db after the fixpac 8.1 FixPak 10 (also known as Version
8.2 FixPak 3), can encounter an SQL0443N error if invoking a DB2 Call
Level Interface (CLI) catalog function (such as SQLTables(),
SQLColumns(), or SQLStatistics()).

The solution:

db2 terminate
db2 connect to <database-name>
db2 bind <path>/db2schema.bnd blocking all grant public sqlerror continue
db2 terminate

Thanks all, have a nice day
Radoslaw

2007/7/17, Robert Manning <rob...@gm...>:
> Hello,
>
> Looks like you have 8.1 fixpak 11 installed.  You might try to get
> fixpak 14 (that's what I updated to recently).  There is some newer
> support for IBM's driver in the latest snapshot for getting more
> detailed error messages from the exceptions that DB2 driver throws.
> You may want to try that, and report back with a more detailed error
> message.  The snapshot can be found here:
>
> http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=523220
>
> The symptom appears to be that whenever SQuirreL asks the driver for
> metadata about tables, schemas, etc. the driver throws an Exception.
> I'm guessing - perhaps the system catalogs aren't installed/configured
> properly - or you don't have access to them?
>
> Rob

-- 
ITIL,RHCE,CCNA,Linux enthusiast.
M.Sc. Radoslaw Tomaszewski

[Squirrel-sql-users] problem wiht db connection

[Radoslaw T. <rad...@gm...>]

Hallo All,

I'm new to squirrel, so maybe I will just tell a few word about me :).
My name is Radoslaw Tomaszewski, came from Polen. I'm a linux fan and
found this great tool on the net :).

My problem:
I have some problem with db db2 (ibm udb db2 v8.2) , I will be very
appropriate if some body could give me some advises what is wrong:

Some info about my system:

$db2level
07.16@15:00 db2inst2@proddb:~/sqllib/bnd> db2level
DB21085I  Instance "db2inst2" uses "32" bits and DB2 code release "SQL08024"
with level identifier "03050106".
Informational tokens are "DB2 v8.1.2.104", "s060120", "MI00152", and FixPak
"11".
Product is installed at "/opt/IBM/db2/V8.1".

$ uname -a
Linux u35 2.6.15-28-386 #1 PREEMPT Thu May 10 09:45:43 UTC 2007 i686 GNU/Linux

#i'm using the ubuntu system
$ cat /etc/debian_version
testing/unstable

$ java -version /usr/bin/java
java version "1.5.0_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode, sharing)


There is a db: coretest and when I'm connecting to this db, the log
file have following informations:

76869 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache
 - Could not get table types
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
        at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
        at com.ibm.db2.jcc.b.jb.l(jb.java:356)
        at com.ibm.db2.jcc.b.jb.e(jb.java:92)
        at com.ibm.db2.jcc.b.w.e(w.java:72)
        at com.ibm.db2.jcc.b.cc.i(cc.java:202)
        at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
        at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
        at com.ibm.db2.jcc.a.tf.X(tf.java:188)
        at com.ibm.db2.jcc.a.t.a(t.java:7199)
        at com.ibm.db2.jcc.a.t.Yd(t.java:5973)
        at com.ibm.db2.jcc.a.t.getTableTypes(t.java:5901)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTableTypes(SQLDatabaseMetaData.java:1007)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.initTypes(SchemaInfoCache.java:147)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.setSession(SchemaInfoCache.java:61)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCacheSerializer.load(SchemaInfoCacheSerializer.java:30)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:128)
        at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:595)
76989 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  -
failed to load catalog names
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
        at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
        at com.ibm.db2.jcc.b.jb.l(jb.java:356)
        at com.ibm.db2.jcc.b.jb.e(jb.java:92)
        at com.ibm.db2.jcc.b.w.e(w.java:72)
        at com.ibm.db2.jcc.b.cc.i(cc.java:202)
        at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
        at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
        at com.ibm.db2.jcc.a.tf.X(tf.java:188)
        at com.ibm.db2.jcc.a.t.a(t.java:7199)
        at com.ibm.db2.jcc.a.t.Xd(t.java:5884)
        at com.ibm.db2.jcc.a.t.getCatalogs(t.java:5809)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDatabaseMetaData.java:583)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadCatalogs(SchemaInfo.java:500)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadCatalogs(SchemaInfo.java:390)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:186)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
        at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:595)
77082 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.SessionManager  - Failed
to get allowed Schemas
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
        at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
        at com.ibm.db2.jcc.b.jb.l(jb.java:356)
        at com.ibm.db2.jcc.b.jb.e(jb.java:92)
        at com.ibm.db2.jcc.b.w.e(w.java:72)
        at com.ibm.db2.jcc.b.cc.i(cc.java:202)
        at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
        at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
        at com.ibm.db2.jcc.a.tf.X(tf.java:188)
        at com.ibm.db2.jcc.a.t.a(t.java:7199)
        at com.ibm.db2.jcc.a.t.Wd(t.java:5795)
        at com.ibm.db2.jcc.a.t.getSchemas(t.java:5723)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:351)
        at net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:648)
        at net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:600)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadSchemas(SchemaInfo.java:525)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadSchemas(SchemaInfo.java:365)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:188)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
        at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:595)
77343 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  -
Error occured creating data types collection
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC:
SYSIBM.SQLGETTYPEINFO;GETTYPEINFO;SYSIBM:CLI:-805
        at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
        at com.ibm.db2.jcc.b.jb.l(jb.java:356)
        at com.ibm.db2.jcc.b.jb.e(jb.java:92)
        at com.ibm.db2.jcc.b.w.e(w.java:72)
        at com.ibm.db2.jcc.b.cc.i(cc.java:202)
        at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
        at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
        at com.ibm.db2.jcc.a.tf.X(tf.java:188)
        at com.ibm.db2.jcc.a.t.a(t.java:7199)
        at com.ibm.db2.jcc.a.t.Zd(t.java:6960)
        at com.ibm.db2.jcc.a.t.getTypeInfo(t.java:6895)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypes(SQLDatabaseMetaData.java:886)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:775)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:223)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
        at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:595)
77672 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.SessionManager  - Failed
to check allowed Schemas
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
        at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
        at com.ibm.db2.jcc.b.jb.l(jb.java:356)
        at com.ibm.db2.jcc.b.jb.e(jb.java:92)
        at com.ibm.db2.jcc.b.w.e(w.java:72)
        at com.ibm.db2.jcc.b.cc.i(cc.java:202)
        at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
        at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
        at com.ibm.db2.jcc.a.tf.X(tf.java:188)
        at com.ibm.db2.jcc.a.t.a(t.java:7199)
        at com.ibm.db2.jcc.a.t.Wd(t.java:5795)
        at com.ibm.db2.jcc.a.t.getSchemas(t.java:5723)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:351)
        at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:584)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:74)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:109)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1080)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:340)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:253)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
        at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:595)
77720 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  -
failed to load table names
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
        at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
        at com.ibm.db2.jcc.b.jb.l(jb.java:356)
        at com.ibm.db2.jcc.b.jb.e(jb.java:92)
        at com.ibm.db2.jcc.b.w.e(w.java:72)
        at com.ibm.db2.jcc.b.cc.i(cc.java:202)
        at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
        at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
        at com.ibm.db2.jcc.a.tf.X(tf.java:188)
        at com.ibm.db2.jcc.a.t.a(t.java:7199)
        at com.ibm.db2.jcc.a.t.a(t.java:5705)
        at com.ibm.db2.jcc.a.t.getTables(t.java:5616)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:1147)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1084)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:340)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:253)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
        at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:595)
77781 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.SessionManager  - Failed
to check allowed Schemas
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
        at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
        at com.ibm.db2.jcc.b.jb.l(jb.java:356)
        at com.ibm.db2.jcc.b.jb.e(jb.java:92)
        at com.ibm.db2.jcc.b.w.e(w.java:72)
        at com.ibm.db2.jcc.b.cc.i(cc.java:202)
        at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
        at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
        at com.ibm.db2.jcc.a.tf.X(tf.java:188)
        at com.ibm.db2.jcc.a.t.a(t.java:7199)
        at com.ibm.db2.jcc.a.t.Wd(t.java:5795)
        at com.ibm.db2.jcc.a.t.getSchemas(t.java:5723)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:351)
        at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:584)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:74)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:109)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:102)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:469)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:316)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:257)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
        at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:595)
77786 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  -
Failed to load stored procedures
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC:
SYSIBM.SQLPROCEDURES;PROCEDURES;SYSIBM:CLI:-805
        at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
        at com.ibm.db2.jcc.b.jb.l(jb.java:356)
        at com.ibm.db2.jcc.b.jb.e(jb.java:92)
        at com.ibm.db2.jcc.b.w.e(w.java:72)
        at com.ibm.db2.jcc.b.cc.i(cc.java:202)
        at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
        at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
        at com.ibm.db2.jcc.a.tf.X(tf.java:188)
        at com.ibm.db2.jcc.a.t.a(t.java:7199)
        at com.ibm.db2.jcc.a.t.a(t.java:5499)
        at com.ibm.db2.jcc.a.t.getProcedures(t.java:5427)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:952)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:475)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:316)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:257)
        at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
        at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:595)

Have any one some ideas what can be wrong? I restared the db instance,
re-create the bind files for the db.

db2 bind @db2cli.lst BLOCKING all grant public
db2 bind @db2ubind.lst blocking all grant public

db2stop
db2start

Is it a problem on the db site or maybe in the application. With other
db'ses the tool works great!!! Only with this one is something wrong
:(.

Thanks and best regards,
Radoslaw

Re: [Squirrel-sql-users] Small Font problem (8px) in version stable 2.5

[James I. <im-...@ho...>]

What I found in the font preference panel is that no font where
selected. I had to check the 4 check boxes and choose a font for each
one. After restarting the program, things where back to normal! Thanks a
lot!

Robert Manning wrote:
>I would recommend not installing over top of an existing directory.
>Our installer doesn't properly handle this (removing old versions of
>plugins, for example).  Try installing into a new directory and launch
>from there.  Be sure to install the "standard" plugins - this will
>give you the Look and Feel plugin which allows you to customize the
>fonts.  The font preference panel is in "Global Preferences" ->
>"Fonts"
>
>Rob
>
>On 7/14/07, James Im <im-...@ho...> wrote:
>>I've just downloaded the last stable version of the program.
>>
>>I was using the version 2.3.2 without problem so I've installed the new
>>version on the same directory as the old one.
>>
>>I've been very disappointed to see that the font size is very very small
>>almost everywhere (in menus, tabs, sql results, history, etc..). The
>>font size is 8 px high ! Yes 8 px I've measured it! Almost unreadable.
>>
>>The text area where you write the sql sentences is almost the only place
>>where the font size is normal. The other place where the font seems to
>>be normal is the status bar.
>>
>>I'm using windows 2000.
>>
>>Could you try to see what's wrong? Thanks
>>
>>_________________________________________________________________
>>Opret en personlig blog og del dine billeder på MSN Spaces:
>>http://spaces.msn.com/
>>
>>
>>
>>-------------------------------------------------------------------------
>>This SF.net email is sponsored by DB2 Express
>>Download DB2 Express C - the FREE version of DB2 express and take
>>control of your XML. No limits. Just data. Click to get it now.
>>http://sourceforge.net/powerbar/db2/
>>_______________________________________________
>>Squirrel-sql-users mailing list
>>Squ...@li...
>>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>>
>
>
>

_________________________________________________________________
Opret en personlig blog og del dine billeder på MSN Spaces:  
http://spaces.msn.com/

Re: [Squirrel-sql-users] Small Font problem (8px) in version stable 2.5

[Robert M. <rob...@gm...>]

I would recommend not installing over top of an existing directory.
Our installer doesn't properly handle this (removing old versions of
plugins, for example).  Try installing into a new directory and launch
from there.  Be sure to install the "standard" plugins - this will
give you the Look and Feel plugin which allows you to customize the
fonts.  The font preference panel is in "Global Preferences" ->
"Fonts"

Rob

On 7/14/07, James Im <im-...@ho...> wrote:
> I've just downloaded the last stable version of the program.
>
> I was using the version 2.3.2 without problem so I've installed the new
> version on the same directory as the old one.
>
> I've been very disappointed to see that the font size is very very small
> almost everywhere (in menus, tabs, sql results, history, etc..). The
> font size is 8 px high ! Yes 8 px I've measured it! Almost unreadable.
>
> The text area where you write the sql sentences is almost the only place
> where the font size is normal. The other place where the font seems to
> be normal is the status bar.
>
> I'm using windows 2000.
>
> Could you try to see what's wrong? Thanks
>
> _________________________________________________________________
> Opret en personlig blog og del dine billeder p=E5 MSN Spaces:
> http://spaces.msn.com/
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

[Squirrel-sql-users] Small Font problem (8px) in version stable 2.5

[James I. <im-...@ho...>]

I've just downloaded the last stable version of the program.

I was using the version 2.3.2 without problem so I've installed the new
version on the same directory as the old one.

I've been very disappointed to see that the font size is very very small
almost everywhere (in menus, tabs, sql results, history, etc..). The
font size is 8 px high ! Yes 8 px I've measured it! Almost unreadable.

The text area where you write the sql sentences is almost the only place
where the font size is normal. The other place where the font seems to
be normal is the status bar.

I'm using windows 2000.

Could you try to see what's wrong? Thanks

_________________________________________________________________
Opret en personlig blog og del dine billeder på MSN Spaces:  
http://spaces.msn.com/

Re: [Squirrel-sql-users] SQuirreL 2.5 not responding on startup

[Robert M. <rob...@gm...>]

On 7/11/07, David Wynter <da...@st...> wrote:
> Hi,
>
> I have used SQuirreL a while now, it suddenly stopped working. I started
> it from the ususal squirrel-sql.bat and the icon appears in the task bar
> but when you click it the application does not Restore.  So I
> uninstalled using th eUninstaller.jar. Then reinstalled. Same issue. I
> looked in the log, nothing particularly out of place that I can see.
>
> Was using JRE 1.5.0_09, now tried 1.6. On Windows 2000 Server. SQuirreL 2.5
>
> Here is the stack trace.
<snip>
>
> I had an earlier log where it tried to use a jtds driver and threw and
> exception, I remove the reference to that driver in the SQLAlias.xml, no
> difference.

As of 2.3, that file is only read to produce the SQLAlias23.xml file
if it is not found.  I would expect that editing it would have no
effect.  Do you have multiple versions of SQuirreL: installed?  Did
you install 2.5 overtop of an existing installation?

>
> Any advice?

Can you try temporarily moving your <user.home>/.squirrel-sql
directory to a backup folder and restarting SQuirreL.  This will tell
us if it's settings-related.

Rob

[Squirrel-sql-users] SQuirreL 2.5 not responding on startup

[David W. <da...@st...>]

Hi,

I have used SQuirreL a while now, it suddenly stopped working. I started 
it from the ususal squirrel-sql.bat and the icon appears in the task bar 
but when you click it the application does not Restore.  So I 
uninstalled using th eUninstaller.jar. Then reinstalled. Same issue. I 
looked in the log, nothing particularly out of place that I can see.

Was using JRE 1.5.0_09, now tried 1.6. On Windows 2000 Server. SQuirreL 2.5

Here is the stack trace.

0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
#############################################################################################################
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - # Starting 
SQuirreL SQL Client Version 2.5 at 11/07/07 11:14
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
#############################################################################################################
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - SQuirreL 
SQL Client Version 2.5 started: Wed Jul 11 11:14:54 BST 2007
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - Copyright 
(c) 2001-2007
Colin Bell, Gerd Wagner, Rob Manning and others
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
java.vendor: Sun Microsystems Inc.
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
java.version: 1.5.0_11
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.name: 
Windows 2000
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.version: 5.0
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - os.arch: x86
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.dir: 
C:\Program Files\SQuirreL SQL Client
0    [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - user.home: 
C:\Documents and Settings\Administrator.ROAMWARE-2EG62K.000
15   [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - java.home: 
c:\Program Files\Java\jdk1.5.0_11\jre
15   [main] INFO  
net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
java.class.path: C:\Program Files\SQuirreL SQL 
Client\squirrel-sql.jar;C:\Program Files\SQuirreL SQL 
Client\lib\antlr-2.7.5H3.jar;C:\Program Files\SQuirreL SQL 
Client\lib\commons-cli.jar;C:\Program Files\SQuirreL SQL 
Client\lib\commons-logging-1.0.4.jar;C:\Program Files\SQuirreL SQL 
Client\lib\forms.jar;C:\Program Files\SQuirreL SQL 
Client\lib\fw.jar;C:\Program Files\SQuirreL SQL 
Client\lib\hibernate3.jar;C:\Program Files\SQuirreL SQL 
Client\lib\jxl.jar;C:\Program Files\SQuirreL SQL 
Client\lib\log4j.jar;C:\Program Files\SQuirreL SQL 
Client\lib\nanoxml-2.1.jar;.;D:\tomcat_5.5\webapps\transformer\WEB-INF\lib\ojdbc14.jar;C:\Program 
Files\Java\jre1.5.0_11\lib\ext\QTJava.zip
2078 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load org.netbeans.modules.editor.java.JCFinderFactory$GlobalPathListener 
in C:\Program Files\SQuirreL SQL 
Client\plugins\syntax\lib\org-netbeans-modules-editor.jar to check if it 
is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. 
Reason: java.lang.NoClassDefFoundError: 
org/netbeans/api/java/classpath/GlobalPathRegistryListener
2078 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load org.netbeans.modules.editor.java.JMIUtils$FakeCallableFeature in 
C:\Program Files\SQuirreL SQL 
Client\plugins\syntax\lib\org-netbeans-modules-editor.jar to check if it 
is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. 
Reason: java.lang.NoClassDefFoundError: 
org/netbeans/jmi/javamodel/CallableFeature
2078 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load org.netbeans.modules.editor.java.JMIUtils$FakeConstructor in 
C:\Program Files\SQuirreL SQL 
Client\plugins\syntax\lib\org-netbeans-modules-editor.jar to check if it 
is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. 
Reason: java.lang.NoClassDefFoundError: 
org/netbeans/jmi/javamodel/Constructor
2078 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load org.netbeans.modules.editor.java.JMIUtils$FakeJavaDoc in C:\Program 
Files\SQuirreL SQL 
Client\plugins\syntax\lib\org-netbeans-modules-editor.jar to check if it 
is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. 
Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/JavaDoc
2078 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load org.netbeans.modules.editor.java.JMIUtils$FakeMethod in C:\Program 
Files\SQuirreL SQL 
Client\plugins\syntax\lib\org-netbeans-modules-editor.jar to check if it 
is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. 
Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/Method
2078 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load org.netbeans.modules.editor.java.JMIUtils$FakeParameter in 
C:\Program Files\SQuirreL SQL 
Client\plugins\syntax\lib\org-netbeans-modules-editor.jar to check if it 
is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. 
Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/Parameter
2078 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load org.netbeans.modules.editor.java.JMIUtils$FakeTagValue in 
C:\Program Files\SQuirreL SQL 
Client\plugins\syntax\lib\org-netbeans-modules-editor.jar to check if it 
is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. 
Reason: java.lang.NoClassDefFoundError: org/netbeans/jmi/javamodel/TagValue
2125 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load 
org.netbeans.modules.editor.java.NbJavaFoldManager$WeakParsingListener 
in C:\Program Files\SQuirreL SQL 
Client\plugins\syntax\lib\org-netbeans-modules-editor.jar to check if it 
is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. 
Reason: java.lang.NoClassDefFoundError: 
org/netbeans/modules/javacore/internalapi/ParsingListener
2125 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load org.netbeans.modules.editor.java.NbJavaFoldManager in C:\Program 
Files\SQuirreL SQL 
Client\plugins\syntax\lib\org-netbeans-modules-editor.jar to check if it 
is assignable to net.sourceforge.squirrel_sql.client.plugin.IPlugin. 
Reason: java.lang.NoClassDefFoundError: 
org/netbeans/modules/javacore/internalapi/ParsingListener
2203 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load com.Ostermiller.Syntax.ToHTMLAntTask$1 in C:\Program Files\SQuirreL 
SQL Client\plugins\syntax\lib\syntax.jar to check if it is assignable to 
net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: 
java.lang.NoClassDefFoundError: org/apache/tools/ant/util/FileNameMapper
2203 [main] INFO  
net.sourceforge.squirrel_sql.client.plugin.PluginManager  - Failed to 
load com.Ostermiller.Syntax.ToHTMLAntTask in C:\Program Files\SQuirreL 
SQL Client\plugins\syntax\lib\syntax.jar to check if it is assignable to 
net.sourceforge.squirrel_sql.client.plugin.IPlugin. Reason: 
java.lang.NoClassDefFoundError: org/apache/tools/ant/taskdefs/MatchingTask
3406 [main] INFO  
net.sourceforge.squirrel_sql.plugins.oracle.prefs.PreferencesManager  - 
prefs.xml not found - will be created
3406 [main] INFO  
net.sourceforge.squirrel_sql.plugins.SybaseASE.prefs.PreferencesManager  
- prefs.xml not found - will be created
3422 [main] INFO  
net.sourceforge.squirrel_sql.plugins.mssql.prefs.PreferencesManager  - 
prefs.xml not found - will be created
3422 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin informix created in 0 ms, loaded in 0 ms, initialized in 0 ms, 
total 0 ms.
3422 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin codecompletion created in 0 ms, loaded in 0 ms, initialized in 16 
ms, total 16 ms.
3422 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin sqlbookmark created in 15 ms, loaded in 0 ms, initialized in 0 
ms, total 15 ms.
3422 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin mysql created in 0 ms, loaded in 0 ms, initialized in 16 ms, 
total 16 ms.
3422 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin graph created in 0 ms, loaded in 0 ms, initialized in 0 ms, total 
0 ms.
3422 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin db2 created in 0 ms, loaded in 0 ms, initialized in 0 ms, total 0 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin dbcopy created in 0 ms, loaded in 0 ms, initialized in 156 ms, 
total 156 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin firebird created in 0 ms, loaded in 0 ms, initialized in 16 ms, 
total 16 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin sqlval created in 0 ms, loaded in 0 ms, initialized in 0 ms, 
total 0 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin sessionscript created in 0 ms, loaded in 0 ms, initialized in 15 
ms, total 15 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin syntax created in 0 ms, loaded in 0 ms, initialized in 16 ms, 
total 16 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin derby created in 0 ms, loaded in 0 ms, initialized in 0 ms, total 
0 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin h2 created in 0 ms, loaded in 0 ms, initialized in 0 ms, total 0 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin sqlscript created in 0 ms, loaded in 0 ms, initialized in 15 ms, 
total 15 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin editextras created in 15 ms, loaded in 0 ms, initialized in 0 ms, 
total 15 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin oracle created in 0 ms, loaded in 0 ms, initialized in 16 ms, 
total 16 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin sybase created in 0 ms, loaded in 0 ms, initialized in 0 ms, 
total 0 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin refactoring created in 0 ms, loaded in 0 ms, initialized in 16 
ms, total 16 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin laf created in 0 ms, loaded in 375 ms, initialized in 0 ms, total 
375 ms.
3437 [main] INFO  net.sourceforge.squirrel_sql.client.Application  - 
Plugin mssql created in 16 ms, loaded in 0 ms, initialized in 0 ms, 
total 16 ms.

I had an earlier log where it tried to use a jtds driver and threw and 
exception, I remove the reference to that driver in the SQLAlias.xml, no 
difference.



Any advice?

Thanks,

David



-- 
_David Wynter _
*Director *
STPenable Ltd.
+44 (0) 20 83711590 Office
+44 (0) 20 77887845 Reception
+44 (0) 7879 605706 Mobile
mailto:da...@st...
www.stpenable.com

Re: [Squirrel-sql-users] SQuirrel SQL Client is not Opended

[Robert M. <rob...@gm...>]

Kishore,

The behavior that you are describing is odd.  You should only see that
dialog when you attempt to connect to a database.  SQuirreL should
start successfully without opening a session (unless of course you
have turned on "Connect at Startup").  Even still, though it is a
modal dialog, it should have an "OK" button that you can click to make
it go away.  I am not sure why you wouldn't be able to see the dialog
or the button.

In any case, you can disable this setting manually if it is causing
you to not be able to launch SQuirreL. Edit the file :

<user.home>/.squirrel-sql/prefs.xml

By setting :

<warnJreJdbcMismatch>true</warnJreJdbcMismatch>

to

<warnJreJdbcMismatch>false</warnJreJdbcMismatch>


By the way, preferences are saved in <user.home>/.squirrel-sql, so
removing SQuirreL from the install directory will have no effect if
the problem is related to settings.  And <user.home> is typically
something like /home/<username> on Linux and
C:\Documents and Settings\<username> on Win32.

Rob


On 7/11/07, kishore bonthala <kis...@gm...> wrote:
>
>
>
> Hi,
>
>  After that warning message i am not able to open SQuirrel SQL Client.
>
> Regards,
> Kishore
>
>
>
> On 7/11/07, Robert Manning <rob...@gm...> wrote:
> > On 7/10/07, kishore bonthala <kis...@gm...> wrote:
> > >
> > > Hi,
> > >
> > > When i tried to connect SQL Server Through SQuirrel I got an Warring
> Message
> > > as follows.
> > >
> > > JRE/JDBC Version Mismatch

[Squirrel-sql-users] My SQuirrel is not Opended

[kishore b. <kis...@gm...>]

Hi,



When i tried to connect SQL Server Through SQuirrel I got an Warring Message
as follows.

JRE/JDBC Version Mismatch

The Driver being used for alias'KCSSYS9_SQLSERVER_GCTRANSFORM' is not JDBC
3.0 Cmpliant.

you should consider Getting A More Recent Version of this driver.



My SQuirrel Client Was Opened and It appeared at Taskbar but it is not
Opened.



I uninstalled and Installed squirrel SQL Client, Even though i am facing the
Same problem.



Regards,

Kishore

Re: [Squirrel-sql-users] creating a mysql stored procedure

[Robert M. <rob...@gm...>]

On 7/2/07, Robert Manning <rob...@gm...> wrote:
> On 6/29/07, Dan Climan <dc...@my...> wrote:
> >
> >
> >
> >
> > Is there a way to creat a stored procedure in MySQL using Squirrel-SQL?
> >
> >
> >
> > I have a valid stored procedure that I can create in the db using a mysql
> > <filename.sql
> >
> >
> >
> > Every attempt to run this query through squirrel results in syntax errors.
> >
> > I've tried a DELIMTER // command and changing the session delimiter, but
> > that didn't work.
>
>
> Support needs to be added in the MySQL plugin for parsing stored
> procedures and other constructs.  We'll see if we can get that in soon
> - we have an outstanding request for it here:
>
> http://sourceforge.net/tracker/index.php?func=detail&aid=1466324&group_id=28383&atid=393417
>
>  It would be helpful if you would provide some sample script for
> creating stored procedures that would be similar to ones that you
> would expect SQuirreL to handle.  If you decide to provide any sample
> script(s) you can attach them to the feature request above.

Support for handling stored procedure create statements has been added
to the MySQL plugin.  Please try out the snapshot build available at
the link below, and let us know how it goes (The default
"end-of-procedure" character is "|" but can be changed in the MySQL
tab of the Global Preferences dialog.  If there is a better default to
be using, let us know that too)

http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=522159

Rob

Re: [Squirrel-sql-users] Creating Stored procedure on DB2/400 (System i5, OS400 etc )

[Robert M. <rob...@gm...>]

On 7/4/07, Forder, Nick <Nic...@su...> wrote:
> Robert,
>
> Bang on the nail!
> "New Session Properties" statement separator to "~" (I do a little
> concatenating of fields) new session and a slight tweak to the syntax
> (DB2/400 has always got to be a little bit more pedantic than the rest!)
> And hey presto a nice new stored proc; tried it on my original proc and
> that works as well.
>

Very good.  I have a fix in CVS, which will be available in this
weekends snapshot if you want to try it out.  It should allow you to
change statement separator temporarily for the current session without
having to restart (just as it worked in versions prior to 2.5)

Rob

Re: [Squirrel-sql-users] Creating Stored procedure on DB2/400 (System i5, OS400 etc )

[Forder, N. <Nic...@su...>]

Robert,

Bang on the nail!
"New Session Properties" statement separator to "~" (I do a little
concatenating of fields) new session and a slight tweak to the syntax
(DB2/400 has always got to be a little bit more pedantic than the rest!)
And hey presto a nice new stored proc; tried it on my original proc and
that works as well.

Thanks
Nick

p.s. There is a 2nd edition of "DB2 SQL Procedure Language for Linux,
UNIX, Windows, i5/OS, and z/OS" couldn't have survived without it. You
don't get  
DB2 Control Center with i5/OS, we have iSeries Navigator and very little
help!

drop table employee
|
create table employee ( midinit CHAR, empno CHAR(6) )
|
create procedure simple_error ( IN p_midinit CHAR
				,IN p_empno CHAR(6) )
LANGUAGE SQL
specific simple_error
se: BEGIN
	DECLARE SQLSTATE CHAR(5) DEFAULT '00000';
	DECLARE X CHAR(1);
	DECLARE SQLCODE INT DEFAULT 0;
	UPDATE employee
		SET midinit = p_midinit
		WHERE empno = p_empno;
	IF SUBSTR(SQLSTATE, 2) NOT in ('00', '01', '02') THEN
		SET X = 'x';
	END IF;
END se
|

-----Original Message-----
From: Robert Manning [mailto:rob...@gm...] 
Sent: Wednesday, July 04, 2007 2:41 AM
To: Forder, Nick
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] Creating Stored procedure on DB2/400
(System i5, OS400 etc )

On 7/3/07, Robert Manning <rob...@gm...> wrote:
> On 7/3/07, Robert Manning <rob...@gm...> wrote:
> > framework.  Until then, you should still be able to use SQuirreL in
> > the manner that you did previously - at least that was our intent.
>
> Well now it appears we have a bug from the addition of the custom
> query tokenizer framework.  We are now caching the original query
> tokenizer and not updating it's properties each time it is requested.
> What this means is that you cannot set the session properties for
> query tokenizer (statement sep, comment, multi-line comment) and
> expect that to apply to the current session.  You need to set the "New
> Session Properties" and restart the session to have them take effect.
> Not so convenient now is it?  We'll get that fixed up quickly.
> However, I can see that the stored procedure that you sent is still
> rejected by my DB2 V9 on Linux.  The error message seems to point to
> the DECLARE statement:

Yes, indeed there is something wrong with the procedure definition you
sent.  I can set the statement separator to "|", restart the DB2
session then execute the following just fine (in the DB2 Control
Center as well as in SQuirreL):

create table employee ( midinit CHAR, empno CHAR(6) )
|

create procedure simple_error ( IN p_midinit CHAR
				,IN p_empno CHAR(6) )
specific simple_error
LANGUAGE SQL
se: BEGIN
	DECLARE SQLSTATE CHAR(5) DEFAULT '00000';
	DECLARE SQLCODE INT DEFAULT 0;
	UPDATE employee
		SET midinit = p_midinit
		WHERE empno = p_empno;
	IF SUBSTR(SQLSTATE, 2) NOT in ('00', '01', '02') THEN
	END IF;
END se
|

I obtained this sample procedure def from the sample chapter (no. 5)
of the book "DB2 SQL Procedure Language for Linux, UNIX, and Windows"
by Drew Bradstock, et. al., which is available on IBM's website
(http://www.tinyurl.com/ys66u3)

Try setting your File -> "New Session Properties" statement separator
to "|" (pipe) and then reconnect to DB2 and execute the above.  Let me
know how it goes.  Oh, and we'll have a fix for the bug in a jiffy
(snapshot release and 2.6 - we are not planning on a 2.5.2 release at
this point)

Rob


CONFIDENTIALITY NOTICE
The information in this email may be confidential and/or privileged. 
This email is intended to be reviewed by only the addressee(s) named 
above. If you are not the intended recipient, you are hereby notified 
that any review, dissemination, copying, use or storage of this email 
and its attachments, if any, or the information contained herein is 
prohibited. If you have received this email in error, please 
immediately notify the sender by return email and delete this email 
from your system. Thank you.

Re: [Squirrel-sql-users] Creating Stored procedure on DB2/400 (System i5, OS400 etc )

[Robert M. <rob...@gm...>]

On 7/3/07, Robert Manning <rob...@gm...> wrote:
> On 7/3/07, Robert Manning <rob...@gm...> wrote:
> > framework.  Until then, you should still be able to use SQuirreL in
> > the manner that you did previously - at least that was our intent.
>
> Well now it appears we have a bug from the addition of the custom
> query tokenizer framework.  We are now caching the original query
> tokenizer and not updating it's properties each time it is requested.
> What this means is that you cannot set the session properties for
> query tokenizer (statement sep, comment, multi-line comment) and
> expect that to apply to the current session.  You need to set the "New
> Session Properties" and restart the session to have them take effect.
> Not so convenient now is it?  We'll get that fixed up quickly.
> However, I can see that the stored procedure that you sent is still
> rejected by my DB2 V9 on Linux.  The error message seems to point to
> the DECLARE statement:

Yes, indeed there is something wrong with the procedure definition you
sent.  I can set the statement separator to "|", restart the DB2
session then execute the following just fine (in the DB2 Control
Center as well as in SQuirreL):

create table employee ( midinit CHAR, empno CHAR(6) )
|

create procedure simple_error ( IN p_midinit CHAR
				,IN p_empno CHAR(6) )
specific simple_error
LANGUAGE SQL
se: BEGIN
	DECLARE SQLSTATE CHAR(5) DEFAULT '00000';
	DECLARE SQLCODE INT DEFAULT 0;
	UPDATE employee
		SET midinit = p_midinit
		WHERE empno = p_empno;
	IF SUBSTR(SQLSTATE, 2) NOT in ('00', '01', '02') THEN
	END IF;
END se
|

I obtained this sample procedure def from the sample chapter (no. 5)
of the book "DB2 SQL Procedure Language for Linux, UNIX, and Windows"
by Drew Bradstock, et. al., which is available on IBM's website
(http://www.tinyurl.com/ys66u3)

Try setting your File -> "New Session Properties" statement separator
to "|" (pipe) and then reconnect to DB2 and execute the above.  Let me
know how it goes.  Oh, and we'll have a fix for the bug in a jiffy
(snapshot release and 2.6 - we are not planning on a 2.5.2 release at
this point)

Rob

Re: [Squirrel-sql-users] Creating Stored procedure on DB2/400 (System i5, OS400 etc )

[Robert M. <rob...@gm...>]

On 7/3/07, Robert Manning <rob...@gm...> wrote:
> > After upgrading to V2.5 I can no longer create a stored procedure in
> > DB2/400.
>
> Nick,
>
> In 2.5 we introduced a framework to allow plugins to install a custom
> QueryTokenizer (the class responsible for chopping up a selection in a
> script into individual statements).  This has been used in the Oracle
> plugin and the SQLServer plugins (MS and Sybase) to enable them to
> handle tokenizing procedural blocks into complete statements without
> forcing the user to manipulate the statement separator.  The DB2
> plugin has not yet been updated to use this new framework, so I am at
> a loss as to why there would be a change in behavior (the old behavior
> was kept as the default when not overridden by a session plugin).
> There are plans to update each of the plugins that don't yet use this
> framework.  Until then, you should still be able to use SQuirreL in
> the manner that you did previously - at least that was our intent.

Well now it appears we have a bug from the addition of the custom
query tokenizer framework.  We are now caching the original query
tokenizer and not updating it's properties each time it is requested.
What this means is that you cannot set the session properties for
query tokenizer (statement sep, comment, multi-line comment) and
expect that to apply to the current session.  You need to set the "New
Session Properties" and restart the session to have them take effect.
Not so convenient now is it?  We'll get that fixed up quickly.
However, I can see that the stored procedure that you sent is still
rejected by my DB2 V9 on Linux.  The error message seems to point to
the DECLARE statement:

An unexpected token "END" was found following "nter INT Default 1".
Expected tokens may include:  "
". SQL Code: -104, SQL State: 42601

In the debugger I see both semi-colons in one long string being sent
to the server.  I tested this in the DB2 control center and got the
same result (I used "|" as the statement separator instead of ";").
How can I verify that this stored procedure is valid?

Rob

Re: [Squirrel-sql-users] Creating Stored procedure on DB2/400 (System i5, OS400 etc )

[Robert M. <rob...@gm...>]

On 7/3/07, Forder, Nick <Nic...@su...> wrote:
>
>
>
>
> After upgrading to V2.5 I can no longer create a stored procedure in
> DB2/400.
>
>
>
> I used to change the statement separator in the session properties to
> something other than ; and I could get by, by highlighting the text and
> running it.
>
> But sadly no longer.  I get this sql exception suggesting malformed sql
> syntax when I terminate a stored procedure statement line with ;
>
> I guess this is result from fixing a bug in the DB2 LUW or Z/OS
> environments.
>
>
>
> Any suggestions from the OS/400 guys would be great I have made SQuirrel my
> shop standard and have loved it up to now.

Nick,

In 2.5 we introduced a framework to allow plugins to install a custom
QueryTokenizer (the class responsible for chopping up a selection in a
script into individual statements).  This has been used in the Oracle
plugin and the SQLServer plugins (MS and Sybase) to enable them to
handle tokenizing procedural blocks into complete statements without
forcing the user to manipulate the statement separator.  The DB2
plugin has not yet been updated to use this new framework, so I am at
a loss as to why there would be a change in behavior (the old behavior
was kept as the default when not overridden by a session plugin).
There are plans to update each of the plugins that don't yet use this
framework.  Until then, you should still be able to use SQuirreL in
the manner that you did previously - at least that was our intent.
I'll run your sample procedure through the debugger and see if I can't
figure out why it isn't working, and get back to you if I find
anything.  In the meantime, if you have any of the above plugins
installed, could you check there configuration panel in Global
Preferences and try turning off the custom tokenizer (should have no
effect but just in case a bug is causing a plugin to think that your
DB2 session is one that it should modify).  Also, I suppose you are
not using ";" as the statement separator in session properties,
correct? ( if you are, then that would be a problem you can fix by
picking a different sequence of character(s) beside ";" that aren't
found in your procedure)

Rob

[Squirrel-sql-users] Creating Stored procedure on DB2/400 (System i5, OS400 etc )

[Forder, N. <Nic...@su...>]

After upgrading to V2.5 I can no longer create a stored procedure in
DB2/400.

 

I used to change the statement separator in the session properties to
something other than ; and I could get by, by highlighting the text and
running it.

But sadly no longer.  I get this sql exception suggesting malformed sql
syntax when I terminate a stored procedure statement line with ;

I guess this is result from fixing a bug in the DB2 LUW or Z/OS
environments. 

 

Any suggestions from the OS/400 guys would be great I have made SQuirrel
my shop standard and have loved it up to now.

 

 

CREATE PROCEDURE NICKLIB.SP_GETWODET_FROM_POITMN ( 

    IN P_PO CHARACTER ( 6 ) , 

    IN P_ITMN CHARACTER ( 4 ) ,

    OUT P_STATUS INTEGER ,

    OUT P_STATUS_TEXT VARCHAR ( 100 ) ,

    OUT P_JOB CHARACTER ( 8 ) ,

    OUT P_RLWO CHARACTER ( 14 ) ,

    OUT P_DESC CHARACTER ( 40 ) ,

    OUT P_QTYT DECIMAL ( 11,3 ) ,

    OUT P_LC CHARACTER ( 2 ) ,

    OUT P_IND CHARACTER ( 2 ) ,

    OUT P_CMPL CHARACTER ( 2 ) ,

    OUT P_BIN CHARACTER ( 10 ) , 

    OUT P_NOTE VARCHAR ( 1000 ) 

    ) 

    LANGUAGE SQL 

    SPECIFIC NICKLIB.SP_GETWODET_FROM_POITMN

    DETERMINISTIC 

    MODIFIES SQL DATA 

    CALLED ON NULL INPUT

 

    BEGIN   

    DECLARE v_counter INT Default 1 ;

    END ;

 

Error: java.sql.SQLException: [SQL0104] Token <END-OF-STATEMENT> was not
valid. Valid tokens: ;. Cause . . . . . :   A syntax error was detected
at token <END-OF-STATEMENT>.  Token <END-OF-STATEMENT> is not a valid
token.  A partial list of valid tokens is ;.  This list assumes that the
statement is correct up to the token.  The error may be earlier in the
statement, but the syntax of the statement appears to be valid up to
this point. Recovery  . . . :   Do one or more of the following and try
the request again: -- Verify the SQL statement in the area of the token
<END-OF-STATEMENT>. Correct the statement.  The error could be a missing
comma or quotation mark, it could be a misspelled word, or it could be
related to the order of clauses. -- If the error token is
<END-OF-STATEMENT>, correct the SQL statement because it does not end
with a valid clause., SQL State: 42601, Error Code: -104

Error occured in:

CREATE PROCEDURE NICKLIB.SP_GETWODET_FROM_POITMN ( 

    IN P_PO CHARACTER ( 6 ) , 

    IN P_ITMN CHARACTER ( 4 ) ,

    OUT P_STATUS INTEGER ,

    OUT P_STATUS_TEXT VARCHAR ( 100 ) ,

    OUT P_JOB CHARACTER ( 8 ) ,

    OUT P_RLWO CHARACTER ( 14 ) ,

    OUT P_DESC CHARACTER ( 40 ) ,

    OUT P_QTYT DECIMAL ( 11,3 ) ,

    OUT P_LC CHARACTER ( 2 ) ,

    OUT P_IND CHARACTER ( 2 ) ,

    OUT P_CMPL CHARACTER ( 2 ) ,

    OUT P_BIN CHARACTER ( 10 ) , 

    OUT P_NOTE VARCHAR ( 1000 ) 

    ) 

    LANGUAGE SQL 

    SPECIFIC NICKLIB.SP_GETWODET_FROM_POITMN

    DETERMINISTIC 

    MODIFIES SQL DATA 

    CALLED ON NULL INPUT

 

    BEGIN   

    DECLARE v_counter INT Default 1



CONFIDENTIALITY NOTICE
The information in this email may be confidential and/or privileged. 
This email is intended to be reviewed by only the addressee(s) named 
above. If you are not the intended recipient, you are hereby notified 
that any review, dissemination, copying, use or storage of this email 
and its attachments, if any, or the information contained herein is 
prohibited. If you have received this email in error, please 
immediately notify the sender by return email and delete this email 
from your system. Thank you.

Re: [Squirrel-sql-users] Hide Oracle BIN$ objects

[Robert M. <rob...@gm...>]

On 7/3/07, Erwan DUROSELLE <erw...@ho...> wrote:
>
>
> Hi,
>
> Is there a way to configure SQuirreL (or the Oracle plugin) hide Oracle's
> Recycle bin's objects, whose name are like BIN$.
> They have a limited use, but are always visible and a bit polluting the tree
> view, IMHO.

Not at the moment.  But you can periodically execute:

purge recyclebin;

The sessions scripts plugin will allow you to execute this once
automatically each time you connect.

Additionally, if your tables all have the same prefix or suffix, you
can setup an object filter by right-clicking the root node in the
object tree and choosing "Edit Object Filter".  Unfortunately, it
doesn't support negation so you can't say NOT(BIN$) or some such
equivalent construct.

Rob

[Squirrel-sql-users] Hide Oracle BIN$ objects

[Erwan D. <erw...@ho...>]

Hi,
=20
Is there a way to configure SQuirreL (or the Oracle plugin) hide Oracle's R=
ecycle bin's objects, whose name are like BIN$.
They have a limited use, but are always visible and a bit polluting the tre=
e view, IMHO.
=20
Erwan
=20
_________________________________________________________________
Windows Live Messenger vous offre 30 nouvelles =E9motic=F4nes gratuites, in=
stall=E9es directement dans votre Messenger !
http://www.emoticones-messenger.fr/=

Re: [Squirrel-sql-users] creating a mysql stored procedure

[Robert M. <rob...@gm...>]

On 6/29/07, Dan Climan <dc...@my...> wrote:
>
>
>
>
> Is there a way to creat a stored procedure in MySQL using Squirrel-SQL?
>
>
>
> I have a valid stored procedure that I can create in the db using a mysql
> <filename.sql
>
>
>
> Every attempt to run this query through squirrel results in syntax errors.
>
> I've tried a DELIMTER // command and changing the session delimiter, but
> that didn't work.


Support needs to be added in the MySQL plugin for parsing stored
procedures and other constructs.  We'll see if we can get that in soon
- we have an outstanding request for it here:

http://sourceforge.net/tracker/index.php?func=detail&aid=1466324&group_id=28383&atid=393417

 It would be helpful if you would provide some sample script for
creating stored procedures that would be similar to ones that you
would expect SQuirreL to handle.  If you decide to provide any sample
script(s) you can attach them to the feature request above.

Rob