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

[Squirrel-sql-users] Where to get the source code for 2.0rc1?

[<jm...@jo...>]

Hello everybody,

I didn't find the source code for 2.0rc1. Is it possible to get it as zip or tar or should I checkout the CVS repository?


Thanks,

Johannes

[Squirrel-sql-users] Communication error with DB2

[Ashraf F. <ash...@gm...>]

Dears,
I connect using squirrel sql 2.0 rc1 to DB2 server, hosted on UNIX machine,=
=20
I open session & excute statments and everything works fine, untill I leave=
=20
the squirrel without executing any statments for around 4 - 6 mins, then I=
=20
try to execute any valid statment, I got this error:
 Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL30081N A=
=20
communication error has been detected. Communication protocol being used:=
=20
"TCP/IP". Communication API being used: "SOCKETS". Location where the error=
=20
was detected: "". Communication function detecting the error: "recv".=20
Protocol specific error code(s): "*", "*", "0". SQLSTATE=3D08001
  I thought a timeout is set by DB2 admin or something, but I connect using=
=20
IBM DB2 command line processor and such problem occurs.
 I tried also setting the following in Squirrel
"File" menu -> "Global preferences" -> "SQL" tab -> Login timeout (secs) an=
d=20
set this to zero & sometimes with 20 mins but the same problem persists.
 Can anyone help?

--=20
Thanks, best regards,
Ashraf Fouad

Re: [Squirrel-sql-users] Configuring Squirrel for Derby

[Susan C. <hom...@ya...>]

Hi Alan,
 
When you create the alias for Derby, just specify the full path to the database if you have already created it.  Otherwise, you can always use the create=true attribute to create a new database wherever you like.
 
For instance, when I created an alias for the embedded Derby driver here was the URL I gave:
 
jdbc:derby:C:\temp\embedDB;create=true;
 
likewise, if you already had an 'embedDB' database under the temp directory you could
use this URL:
 
jdbc:derby:C:\temp\embedDB;
 
If you just give this URL:
 
jdbc:derby:embedDB;create=true;
 
The database will be created under the SQuirrel SQL Client directory where SQuirreL is started from.
 
I hope this helps.
 
Susan

Alan Halley <ala...@id...> wrote:
Hi

I'm a newbie to squirrel and would like to access enbedded Derby. I've 
added the driver and setup and alias but Squirrel doesn't seem able to 
find my database.
I suspect that it doesn't know where the database files are stored.

TIA

Alan

-- 
This E-Mail and the information contained in it and in any attachments
are confidential and may be privileged. The email is intended for the 
person or entity to which it is addressed only.
If you have received this E-Mail in error please notify us immediately 
either by email to the sender or by telephone (+44 (0)870 351 1150) to the company. 
If you are not the intended recipient, you are not authorised to, and must not use,
disclose, copy, distribute, retain or rely on this E-Mail or any part
of it.




-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Configuring Squirrel for Derby

[Alan H. <ala...@id...>]

Hi

I'm a newbie to squirrel and would like to access enbedded Derby. I've 
added the driver and setup and alias but Squirrel doesn't seem able to 
find my database.
I suspect that it doesn't know where the database files are stored.

TIA

Alan

-- 
This E-Mail and the information contained in it and in any attachments
are confidential and may be privileged. The email is intended for the 
person or entity to which it is addressed only.
If you have received this E-Mail in error please notify us immediately 
either by email to the sender or by telephone (+44 (0)870 351 1150) to the company.  
If you are not the intended recipient, you are not authorised to, and must not use,
disclose, copy, distribute, retain or rely on this E-Mail or any part
of it.

Re: [Squirrel-sql-users] Can't update column with type char(1)

[Rob M. <Rob...@co...>]

Gerd Wagner wrote:

> Hi David,
>
> if the field already contains a char you can't append another one 
> because of the length of 1.
>
> I tried out SQL Server, SQuirreL 2.0 rc1 running on Suse Linux and JDK 
> 1.5 except from the limitation mentioned above I could not find any 
> problem. I can delete the character and I can change it.
>
> Has anybody else seen the problem?

I don't see the behavior when using the MS jdbc driver against SQL 
Server 2005 (beta)

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] Can't update column with type char(1)

[Gerd W. <bir...@t-...>]

Hi David,

if the field already contains a char you can't append another one 
because of the length of 1.

I tried out SQL Server, SQuirreL 2.0 rc1 running on Suse Linux and JDK 
1.5 except from the limitation mentioned above I could not find any 
problem. I can delete the character and I can change it.

Has anybody else seen the problem?

Gerd


dgu...@re... wrote:
> Hi Gerd,
> 
> You're right, I mean updating data in a contents tab. I just select 'Make
> editable' in a cell of type char(1) and try to modify its value, but I
> can't append any char or delete.
> 
> I"m using Ubuntu Linux, Squirrel Sql 2.0 RC 1 with Java 1.5 and a
> connection to SQL Server.
> 
> Thanks a lot.
> 
> David.
> 

Re: [Squirrel-sql-users] Can't update column with type char(1)

[<dgu...@re...>]

Hi Gerd,

You're right, I mean updating data in a contents tab. I just select 'Make
editable' in a cell of type char(1) and try to modify its value, but I
can't append any char or delete.

I"m using Ubuntu Linux, Squirrel Sql 2.0 RC 1 with Java 1.5 and a
connection to SQL Server.

Thanks a lot.

David.


> Hi David,
>
> I guess you're not talking about a SQL Update statement. This would be
> like
> update MYTABLE set mychar = 'z'
>
> You probably mean updating data in the contents tab or in a SQL result.
> I tried out both on SQL Server and char(1) field and it just worked fine.
>
> Could you give some more details? What OS do you use.
>
> Gerd
>
> dgu...@re... wrote:
>> Hello,
>>
>> I"m using squirrel sql 2.0 RC 1 with Java 1.5 and an alias for connect
>> to
>> SQL Server.
>>
>> Does anyone know how to modify the value of a column with type char(1)?
>>
>> I can update any column but columns with this type of data.
>>
>> Thanks.
>>
>> David.
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by the 'Do More With Dual!' webinar
>> happening
>> July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
>> core and dual graphics technology at this free one hour event hosted by
>> HP,
>> AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>
>

Re: [Squirrel-sql-users] Can't update column with type char(1)

[Gerd W. <bir...@t-...>]

Hi David,

I guess you're not talking about a SQL Update statement. This would be like
update MYTABLE set mychar = 'z'

You probably mean updating data in the contents tab or in a SQL result. 
I tried out both on SQL Server and char(1) field and it just worked fine.

Could you give some more details? What OS do you use.

Gerd

dgu...@re... wrote:
> Hello,
> 
> I"m using squirrel sql 2.0 RC 1 with Java 1.5 and an alias for connect to
> SQL Server.
> 
> Does anyone know how to modify the value of a column with type char(1)?
> 
> I can update any column but columns with this type of data.
> 
> Thanks.
> 
> David.
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening
> July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
> core and dual graphics technology at this free one hour event hosted by HP,
> AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] Can't update column with type char(1)

[<dgu...@re...>]

Hello,

I"m using squirrel sql 2.0 RC 1 with Java 1.5 and an alias for connect to
SQL Server.

Does anyone know how to modify the value of a column with type char(1)?

I can update any column but columns with this type of data.

Thanks.

David.

Re: [Squirrel-sql-users] derby access (was cloudscape)

[Susan C. <hom...@ya...>]

Hi Rob,
 
Thanks a lot I appreciate it.
 
Susan

Rob Manning <Rob...@co...> wrote:
Susan Cline wrote:

> Hi Gerd,
> 
> Could you send me the new squirrel-sql.jar as well? I'd like to use 
> it with Derby too.
> 

Susan,

I'm working with Gerd to provide periodic (at least weekly) builds of 
SQuirreL from the CVS trunk.
For now, I've built a version - we'll call it the July 4th build - which 
is accessible from this URL:

http://dbcopyplugin.sourceforge.net/squirrel-sql.jar

We'll make an announcement regarding where to get the periodic builds 
from the trunk
in the future. These builds will include the installer, which will 
contain updates to any standard
plugins as well.

Rob Manning




CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83




-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] derby access (was cloudscape)

[Rob M. <Rob...@co...>]

Susan Cline wrote:

> Hi Gerd,
>  
> Could you send me the new squirrel-sql.jar as well?  I'd like to use 
> it with Derby too.
>  

Susan,

I'm working with Gerd to provide periodic (at least weekly) builds of 
SQuirreL from the CVS trunk.
For now, I've built a version - we'll call it the July 4th build - which 
is accessible from this URL:

http://dbcopyplugin.sourceforge.net/squirrel-sql.jar

We'll make an announcement regarding where to get the periodic builds 
from the trunk
in the future. These builds will include the installer, which will 
contain updates to any standard
plugins as well.

Rob Manning




CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] derby access (was cloudscape)

[Susan C. <hom...@ya...>]

Hi Gerd,
 
Could you send me the new squirrel-sql.jar as well?  I'd like to use it with Derby too.
 
Regards,
 
Susan

Gerd Wagner <bir...@t-...> wrote:
Hi Xavier,

it looks like your driver closes a ResultSet when it was completely 
iterated through. SQuirreL tried to access the ResultSetMetaData after 
iterating. I was able to fix this. The fix is in CVS. If you want me to 
I could mail you a new version of squirrel-sql.jar (2.1 MB).

Still the exception will persist (as in 1.2beta6) because SQuirreL tries 
to read SQL warnings from the ResultSet after iterating. This will 
fail when the ResultSet is closed.

Gerd


Xavier Vigouroux wrote:
> Hi,
> 
> Here is the log I get:
> 
> 
> ------------------------------------------------------------------------
> 
> org.apache.derby.client.am.SqlException: Invalid operation: result set closed
> at org.apache.derby.client.am.ResultSet.checkForClosedResultSet(ResultSet.java:2900)
> at org.apache.derby.client.am.ResultSet.getMetaDataX(ResultSet.java:1240)
> at org.apache.derby.client.am.ResultSet.getMetaData(ResultSet.java:1232)
> at net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetMetaDataDataSet.getMetaDataFromResultSet(ResultSetMetaDataDataSet.java:238)
> at net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetMetaDataDataSet.(ResultSetMetaDataDataSet.java:92)
> at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel$SQLExecutionHandler.sqlResultSetAvailable(SQLResultExecuterPanel.java:733)
> at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processResultSet(SQLExecuterTask.java:450)
> at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:359)
> at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:252)
> at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
> at java.lang.Thread.run(Thread.java:536)
> 
> 
> ------------------------------------------------------------------------
> 
> 
> 
> What is strange is that I disable "show SQL Result metadata" in the 
> connecteciot nproperties but it doesn't help.
> 
> ps: note that I also send a mail concerning this problem to derby DB ML.
> 
> thanks
> 
> Le 28 juin 05, à 20:35, Gerd Wagner a écrit :
> 
>> Hi Xavier,
>>
>> could you have look at the SQuirreL logs (Menu Windows -->View 
>> SQuirreL logs). There you should find a stacktrace of your exception. 
>> Could you please post the stacktrace together with your request.
>>
>> Thanks
>>
>> Gerd
>>
>> Xavier Vigouroux wrote:
>>
>>> Hi,
>>> I try to connect to a derby database, I have a different behavior 
>>> SQL requests withfrom 1.2beta6 to 2.0rc1:
>>> o in 1.2beta6: I can execute select, get an exception 
>>> (org.apache.derby.client.am.SqlException: invalid operation: result 
>>> set closed) but can see the result of the request
>>> o in 2.0rc1: I have the same exception but with no result.
>>> what must I investigate to get better insight.
>>> XFV
>>
>>
>>



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Never finishing queries

[Rob M. <Rob...@co...>]

Jack Eidsness wrote:

> Hello
>
> I'm using squirrel sql 2.0 RC 1 with Java 1.5 and an Oracle thin 
> driver for oracle 9i;
>
> I have found that when I do a simple select query in the SQL window 
> (e.g. "select sysdate from dual"), it will work and show me a result 
> set, but my send query will always hang indefinitely.  I haven't seen 
> one finish yet.  I know I'm not giving a lot to go on, but I'm not 
> sure what other information needs to be collected.
>
> If I close that window & connection, and reconnect, I can do another 
> query.
>
> Does anyone have any advice for troubleshooting this problem?

Jack,

I don't have jdk 1.5 installed (I have 1.4.2_08-b03/WinXP).  However, I 
do have Oracle 9i installed and I am
using the type 4 driver (<ORACLE_HOME>/jdbc/lib/classes12.zip) I am able 
to issue the query
"select sysdate from dual" and it successfully completes giving me a 
single column in the results tab with the
current date (according to Oracle).  Are you using the same driver? Do 
you have access to a 1.4 JVM that you
could try running SQuirreL with?  Are you seeing any exceptions at the 
very end of your
<user.home>/.squirrel-sql/logs/squirrel-sql.log file ?

Rob



CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

[Squirrel-sql-users] Never finishing queries

[Jack E. <ja...@hh...>]

Hello

I'm using squirrel sql 2.0 RC 1 with Java 1.5 and an Oracle thin driver 
for oracle 9i;

I have found that when I do a simple select query in the SQL window 
(e.g. "select sysdate from dual"), it will work and show me a result 
set, but my send query will always hang indefinitely.  I haven't seen 
one finish yet.  I know I'm not giving a lot to go on, but I'm not sure 
what other information needs to be collected.

If I close that window & connection, and reconnect, I can do another query.

Does anyone have any advice for troubleshooting this problem?

-Jack

Re: [Squirrel-sql-users] [ENHANCEMENT] SQL HISTORY

[Gerd W. <bir...@t-...>]

Hi Xavier,

Xavier Vigouroux wrote:
> hi,
> 
> I fell regularly in the situation where an erroneous SQL command is not 
> stored in the history. I understand the goal of this for real erroneous 
> command.
> 
> However, for error relative to the loss of the connection, this couls be 
> stored in the SQL history. This way, I can reopen a new window to 
> reconnect to the DB and get the whole history.

First of all I see your point.

A little help for the connection loss situation might be

1. You might use Menu Session --> Reconnect

2. Add the SQL to the bookmarks. See tools popup (ctrl +t) --> add bookmark

3. Save the SQL to a file.


The problem I see is to distinguish an SQLException that comes from an 
erroneous SQL command from one that for example results from a loss of 
the connection.

In SQLException's API doc it say the SQLState string might tell if the 
database supports the XOPEN SQLstate conventions or the SQL 99 
conventions. But if for example you look at PostgerSQL the 
getSQLStateType() method is unsupported.

I can't really think of a way to find out of what category an 
SQLException. If you or anyone else has an idea I'd be grateful to get 
to know it.

Gerd

[Squirrel-sql-users] [ENHANCEMENT] SQL HISTORY

[Xavier V. <Xav...@Su...>]

hi,

I fell regularly in the situation where an erroneous SQL command is not 
stored in the history. I understand the goal of this for real erroneous 
command.

However, for error relative to the loss of the connection, this couls 
be stored in the SQL history. This way, I can reopen a new window to 
reconnect to the DB and get the whole history.

obviously, this is a "priority 21 / severity 45" problem.

my two cents

-- 
Xavier VIGOUROUX - sun microsystems

Re: [Squirrel-sql-users] SQL and meta-data

[Xavier V. <Xav...@Su...>]

Le 4 juil. 05, =E0 14:15, Rob Manning a =E9crit :

> Xavier Vigouroux wrote:
>
>> Hi,
>>
>> It seems that the checkbox (Properties -> SQL -> Show SQL Result =
=20
>> MetaData) is not working. When I uncheck it, I still have the meta=
 =20
>> data fetched.
>>
>> Am I understanding correctly the role of this box.
>>
> Xavier,
>
> Yes, that appears to me to be a bug. I filed a bug (1232170) for th=
is.
>
> Gerd,
>
> Would you like to have a look at the attached patch to address this=
 =20
> issue?
>

Hi, thanks

It's hard for me to test the patch (even if it seems to be short) as =
I =20
use the jar files. furthermore, I use a modified version solving my =
=20
"derby closed resultset" problem.

If I find time to test it, I'll do it, but do not wait for me.

Congratulations for the reactivity.

XFV

>
> Rob
>
>
>
>
>
>
> CollabraSpace - Revolutionary Collaboration
> Visit us at http://www.collabraspace.com
> This message has been scanned for viruses by
> ClamAV v0.83
>
>
> Index: SQLResultExecuterPanel.java
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
> RCS file: =20
> /cvsroot/squirrel-sql/sql12/app/src/net/sourceforge/squirrel_sql/=
=20
> client/session/mainpanel/SQLResultExecuterPanel.java,v
> retrieving revision 1.10
> diff -u -r1.10 SQLResultExecuterPanel.java
> --- SQLResultExecuterPanel.java=093 Jul 2005 21:39:40 -0000=091.10
> +++ SQLResultExecuterPanel.java=094 Jul 2005 12:07:12 -0000
> @@ -913,7 +913,9 @@
>  =09=09=09try
>  =09=09=09{
>  //=09=09=09=09rsds.setResultSet(rs, props.getLargeResultSetObjectI=
nfo());
> -            rsmdds =3D new ResultSetMetaDataDataSet(rs);
> +                if (props.getShowResultsMetaData()) {
> +                    rsmdds =3D new ResultSetMetaDataDataSet(rs);
> +                }
>  =09=09=09=09rsds.setResultSet(rs);
>  =09=09=09}
>  =09=09=09catch (DataSetException ex)
>
--=20
Xavier VIGOUROUX - sun microsystems

Re: [Squirrel-sql-users] SQL and meta-data

[Rob M. <Rob...@co...>]

Xavier Vigouroux wrote:

> Hi,
>
> It seems that the checkbox (Properties -> SQL -> Show SQL Result 
> MetaData) is not working. When I uncheck it, I still have the meta 
> data fetched.
>
> Am I understanding correctly the role of this box.
>
Xavier,

Yes, that appears to me to be a bug. I filed a bug (1232170) for this.

Gerd,

Would you like to have a look at the attached patch to address this issue?


Rob






CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

[Squirrel-sql-users] SQL and meta-data

[Xavier V. <Xav...@Su...>]

Hi,

It seems that the checkbox (Properties -> SQL -> Show SQL Result 
MetaData) is not working. When I uncheck it, I still have the meta data 
fetched.

Am I understanding correctly the role of this box.

-- 
Xavier VIGOUROUX - sun microsystems

Re: [Squirrel-sql-users] derby access (was cloudscape)

[Gerd W. <bir...@t-...>]

Hi Xavier,

it looks like your driver closes a ResultSet when it was completely 
iterated through. SQuirreL tried to access the ResultSetMetaData after 
iterating. I was able to fix this. The fix is in CVS. If you want me to 
I could mail you a new version of squirrel-sql.jar (2.1 MB).

Still the exception will persist (as in 1.2beta6) because SQuirreL tries 
  to read SQL warnings from the ResultSet after iterating. This will 
fail when the ResultSet is closed.

Gerd


Xavier Vigouroux wrote:
> Hi,
> 
> Here is the log I get:
> 
> 
> ------------------------------------------------------------------------
> 
> org.apache.derby.client.am.SqlException: Invalid operation: result set closed
> 	at org.apache.derby.client.am.ResultSet.checkForClosedResultSet(ResultSet.java:2900)
> 	at org.apache.derby.client.am.ResultSet.getMetaDataX(ResultSet.java:1240)
> 	at org.apache.derby.client.am.ResultSet.getMetaData(ResultSet.java:1232)
> 	at net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetMetaDataDataSet.getMetaDataFromResultSet(ResultSetMetaDataDataSet.java:238)
> 	at net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetMetaDataDataSet.<init>(ResultSetMetaDataDataSet.java:92)
> 	at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel$SQLExecutionHandler.sqlResultSetAvailable(SQLResultExecuterPanel.java:733)
> 	at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processResultSet(SQLExecuterTask.java:450)
> 	at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:359)
> 	at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:252)
> 	at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
> 	at java.lang.Thread.run(Thread.java:536)
> 
> 
> ------------------------------------------------------------------------
> 
> 
> 
> What is strange is that I disable "show SQL Result metadata" in the 
> connecteciot nproperties but it doesn't help.
> 
> ps: note that I also send a mail concerning this problem to derby DB ML.
> 
> thanks
> 
> Le 28 juin 05, à 20:35, Gerd Wagner a écrit :
> 
>> Hi Xavier,
>>
>> could you have look at the SQuirreL logs (Menu Windows -->View 
>> SQuirreL logs). There you should find a stacktrace of your exception. 
>> Could you please post the stacktrace together with your request.
>>
>> Thanks
>>
>> Gerd
>>
>> Xavier Vigouroux wrote:
>>
>>> Hi,
>>> I try to connect to a derby database, I have a different behavior  
>>> SQL requests withfrom 1.2beta6 to 2.0rc1:
>>> o in 1.2beta6: I can execute select, get an exception 
>>> (org.apache.derby.client.am.SqlException: invalid operation: result 
>>> set closed) but can see the result of the request
>>> o in 2.0rc1: I have the same exception but with no result.
>>> what must I investigate to get better insight.
>>> XFV
>>
>>
>>

Re: [Squirrel-sql-users] derby access (was cloudscape)

[Xavier V. <Xav...@Su...>]

Hi,

Here is the log I get:

Re: [Squirrel-sql-users] derby access (was cloudscape)

[Gerd W. <bir...@t-...>]

Hi Xavier,

could you have look at the SQuirreL logs (Menu Windows -->View SQuirreL 
logs). There you should find a stacktrace of your exception. Could you 
please post the stacktrace together with your request.

Thanks

Gerd

Xavier Vigouroux wrote:
> Hi,
> 
> I try to connect to a derby database, I have a different behavior  SQL 
> requests withfrom 1.2beta6 to 2.0rc1:
> 
> o in 1.2beta6: I can execute select, get an exception 
> (org.apache.derby.client.am.SqlException: invalid operation: result set 
> closed) but can see the result of the request
> 
> o in 2.0rc1: I have the same exception but with no result.
> 
> what must I investigate to get better insight.
> 
> XFV
> 

[Squirrel-sql-users] derby access (was cloudscape)

[Xavier V. <Xav...@Su...>]

Hi,

I try to connect to a derby database, I have a different behavior  SQL 
requests withfrom 1.2beta6 to 2.0rc1:

o in 1.2beta6: I can execute select, get an exception 
(org.apache.derby.client.am.SqlException: invalid operation: result set 
closed) but can see the result of the request

o in 2.0rc1: I have the same exception but with no result.

what must I investigate to get better insight.

XFV

-- 
Xavier VIGOUROUX - sun microsystems

RE: [Squirrel-sql-users] Mac OS X Problems

[Rowe, N. <Nev...@dr...>]

I'm going through the checkout process and I'll see if I can get anywhere
looking at some of the issues.

First fix, in the mac package I did various of us have been finding problems
with the JavaApplicationStub binary. It turns out the package doesn't need
to distribute it - instead what is currently a dir MacOS in the package
should be a link pointing to
/System/Library/Frameworks/JavaVM.framework/Resources/MacOS
which will pick up the current version as installed on the local machine.

I'll make the appropriate changes in CVS when I can get to a machine with
appropriate rights.

Neville

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of Gerd
Wagner
Sent: 26 June 2005 21:11
To: Thomas Risberg; squ...@li...
Subject: Re: [Squirrel-sql-users] Mac OS X Problems


Thomas,

we are aware of several issues concerning the Mac. We are actually 
looking for a Mac specialist who could CVS check out and debug SQuirreL 
on the Mac.

The check out command would be
cvs -z3 -d:pserver:ano...@cv...:/cvsroot/squirrel-sql 
co -P sql12

Gerd


Thomas Risberg wrote:
> Not having much luck running on Mac OS X (10.4.1)
> 
> Tried the OS X packages - nothing happens when I click on
> "SquirrelSQL.app".  I never see the splash screen or an error  message.  
> Is there a log generated somehwere?
> 
> Moved on ti the  "2.0rc1 plain zip" download
> 
> The jgoodies laf throws a NPE as soon as I click on a menu item:
> 
> java.lang.NullPointerException
>         at apple.laf.ScreenPopupFactory.getPopup
> (ScreenPopupFactory.java:38)
>         at com.jgoodies.looks.common.ShadowPopupFactory.getPopup 
> (ShadowPopupFactory.java:135)
>         at javax.swing.plaf.PopupMenuUI.getPopup(PopupMenuUI.java:44)
>         at javax.swing.JPopupMenu.getPopup(JPopupMenu.java:817)
>         at javax.swing.JPopupMenu.setVisible(JPopupMenu.java:758)
>         at javax.swing.JPopupMenu.show(JPopupMenu.java:950)
>         at javax.swing.JMenu.setPopupMenuVisible(JMenu.java:326)
>         at javax.swing.JPopupMenu.menuSelectionChanged 
> (JPopupMenu.java:1288)
>         at javax.swing.MenuSelectionManager.setSelectedPath 
> (MenuSelectionManager.java:83)
>         at javax.swing.plaf.basic.BasicMenuUI.appendPath 
> (BasicMenuUI.java:207)
>         at javax.swing.plaf.basic.BasicMenuUI.access$400 
> (BasicMenuUI.java:30)
>         at javax.swing.plaf.basic.BasicMenuUI 
> $MouseInputHandler.mousePressed(BasicMenuUI.java:341)
>         at java.awt.AWTEventMulticaster.mousePressed 
> (AWTEventMulticaster.java:221)
>         at java.awt.Component.processMouseEvent(Component.java:5163)
>         at java.awt.Component.processEvent(Component.java:4963)
>         at java.awt.Container.processEvent(Container.java:1613)
>         at java.awt.Component.dispatchEventImpl(Component.java:3681)
>         at java.awt.Container.dispatchEventImpl(Container.java:1671)
>         at java.awt.Component.dispatchEvent(Component.java:3543)
>         at java.awt.LightweightDispatcher.retargetMouseEvent 
> (Container.java:3527)
>         at java.awt.LightweightDispatcher.processMouseEvent 
> (Container.java:3239)
>         at java.awt.LightweightDispatcher.dispatchEvent 
> (Container.java:3172)
>         at java.awt.Container.dispatchEventImpl(Container.java:1657)
>         at java.awt.Window.dispatchEventImpl(Window.java:1606)
>         at java.awt.Component.dispatchEvent(Component.java:3543)
>         at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
>         at java.awt.EventDispatchThread.pumpOneEventForHierarchy 
> (EventDispatchThread.java:234)
>         at java.awt.EventDispatchThread.pumpEventsForHierarchy 
> (EventDispatchThread.java:184)
>         at java.awt.EventDispatchThread.pumpEvents 
> (EventDispatchThread.java:178)
>         at java.awt.EventDispatchThread.pumpEvents 
> (EventDispatchThread.java:170)
>         at java.awt.EventDispatchThread.run(EventDispatchThread.java: 100)
> 
> Removing looks-1.3.1.jar from the lafs directory seems to work - is  
> the
> jgoodies set as the default?  Now I can start the app and pick  the "Mac 
> OS X" laf.
> 
> Additionally, in squirrel-sql.sh - had to change the  
> SQUIRREL_SQL_HOME
> setting :)
> 
> # Squirrel home.
> SQUIRREL_SQL_HOME='/home/gerd/tmp/SQuirreL SQL Client'
> 
> Other than that, looking forward to testing the new features.
> 
> Thomas
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies 
> from IBM. Find simple to follow Roadmaps, straightforward articles, 
> informative Webcasts and more! Get everything you need to get up to 
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Squirrel-sql-users mailing list 
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from
IBM. Find simple to follow Roadmaps, straightforward articles, informative
Webcasts and more! Get everything you need to get up to speed, fast.
http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Squirrel-sql-users mailing list Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
 ------


--------------------------------------------------------------------------------
The information contained herein is confidential and is intended solely for the
addressee. Access by any other party is unauthorised without the express 
written permission of the sender. If you are not the intended recipient, please 
contact the sender either via the company switchboard on +44 (0)20 7623 8000, or
via e-mail return. If you have received this e-mail in error or wish to read our
e-mail disclaimer statement and monitoring policy, please refer to 
http://www.drkw.com/disc/email/ or contact the sender. 3166
--------------------------------------------------------------------------------

Re: [Squirrel-sql-users] Mac OS X Problems

[Gerd W. <bir...@t-...>]

Thomas,

we are aware of several issues concerning the Mac. We are actually 
looking for a Mac specialist who could CVS check out and debug SQuirreL 
on the Mac.

The check out command would be
cvs -z3 -d:pserver:ano...@cv...:/cvsroot/squirrel-sql 
co -P sql12

Gerd


Thomas Risberg wrote:
> Not having much luck running on Mac OS X (10.4.1)
> 
> Tried the OS X packages - nothing happens when I click on  
> "SquirrelSQL.app".  I never see the splash screen or an error  message.  
> Is there a log generated somehwere?
> 
> Moved on ti the  "2.0rc1 plain zip" download
> 
> The jgoodies laf throws a NPE as soon as I click on a menu item:
> 
> java.lang.NullPointerException
>         at apple.laf.ScreenPopupFactory.getPopup 
> (ScreenPopupFactory.java:38)
>         at com.jgoodies.looks.common.ShadowPopupFactory.getPopup 
> (ShadowPopupFactory.java:135)
>         at javax.swing.plaf.PopupMenuUI.getPopup(PopupMenuUI.java:44)
>         at javax.swing.JPopupMenu.getPopup(JPopupMenu.java:817)
>         at javax.swing.JPopupMenu.setVisible(JPopupMenu.java:758)
>         at javax.swing.JPopupMenu.show(JPopupMenu.java:950)
>         at javax.swing.JMenu.setPopupMenuVisible(JMenu.java:326)
>         at javax.swing.JPopupMenu.menuSelectionChanged 
> (JPopupMenu.java:1288)
>         at javax.swing.MenuSelectionManager.setSelectedPath 
> (MenuSelectionManager.java:83)
>         at javax.swing.plaf.basic.BasicMenuUI.appendPath 
> (BasicMenuUI.java:207)
>         at javax.swing.plaf.basic.BasicMenuUI.access$400 
> (BasicMenuUI.java:30)
>         at javax.swing.plaf.basic.BasicMenuUI 
> $MouseInputHandler.mousePressed(BasicMenuUI.java:341)
>         at java.awt.AWTEventMulticaster.mousePressed 
> (AWTEventMulticaster.java:221)
>         at java.awt.Component.processMouseEvent(Component.java:5163)
>         at java.awt.Component.processEvent(Component.java:4963)
>         at java.awt.Container.processEvent(Container.java:1613)
>         at java.awt.Component.dispatchEventImpl(Component.java:3681)
>         at java.awt.Container.dispatchEventImpl(Container.java:1671)
>         at java.awt.Component.dispatchEvent(Component.java:3543)
>         at java.awt.LightweightDispatcher.retargetMouseEvent 
> (Container.java:3527)
>         at java.awt.LightweightDispatcher.processMouseEvent 
> (Container.java:3239)
>         at java.awt.LightweightDispatcher.dispatchEvent 
> (Container.java:3172)
>         at java.awt.Container.dispatchEventImpl(Container.java:1657)
>         at java.awt.Window.dispatchEventImpl(Window.java:1606)
>         at java.awt.Component.dispatchEvent(Component.java:3543)
>         at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
>         at java.awt.EventDispatchThread.pumpOneEventForHierarchy 
> (EventDispatchThread.java:234)
>         at java.awt.EventDispatchThread.pumpEventsForHierarchy 
> (EventDispatchThread.java:184)
>         at java.awt.EventDispatchThread.pumpEvents 
> (EventDispatchThread.java:178)
>         at java.awt.EventDispatchThread.pumpEvents 
> (EventDispatchThread.java:170)
>         at java.awt.EventDispatchThread.run(EventDispatchThread.java: 100)
> 
> Removing looks-1.3.1.jar from the lafs directory seems to work - is  the 
> jgoodies set as the default?  Now I can start the app and pick  the "Mac 
> OS X" laf.
> 
> Additionally, in squirrel-sql.sh - had to change the  SQUIRREL_SQL_HOME 
> setting :)
> 
> # Squirrel home.
> SQUIRREL_SQL_HOME='/home/gerd/tmp/SQuirreL SQL Client'
> 
> Other than that, looking forward to testing the new features.
> 
> Thomas
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>