You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(9) |
Feb
(4) |
Mar
(20) |
Apr
(10) |
May
(5) |
Jun
(2) |
Jul
(10) |
Aug
(4) |
Sep
(15) |
Oct
(5) |
Nov
(8) |
Dec
(2) |
| 2003 |
Jan
(11) |
Feb
(5) |
Mar
(10) |
Apr
(20) |
May
(24) |
Jun
(13) |
Jul
(6) |
Aug
(5) |
Sep
(10) |
Oct
(10) |
Nov
(9) |
Dec
(7) |
| 2004 |
Jan
(4) |
Feb
(10) |
Mar
(5) |
Apr
(18) |
May
(18) |
Jun
(14) |
Jul
(24) |
Aug
(14) |
Sep
(6) |
Oct
(18) |
Nov
(5) |
Dec
(3) |
| 2005 |
Jan
(5) |
Feb
(1) |
Mar
(5) |
Apr
(10) |
May
(10) |
Jun
(16) |
Jul
(46) |
Aug
(36) |
Sep
(16) |
Oct
(11) |
Nov
(12) |
Dec
(29) |
| 2006 |
Jan
(33) |
Feb
(45) |
Mar
(42) |
Apr
(23) |
May
(23) |
Jun
(21) |
Jul
(19) |
Aug
(23) |
Sep
(17) |
Oct
(50) |
Nov
(74) |
Dec
(44) |
| 2007 |
Jan
(35) |
Feb
(18) |
Mar
(46) |
Apr
(25) |
May
(26) |
Jun
(24) |
Jul
(33) |
Aug
(4) |
Sep
(41) |
Oct
(43) |
Nov
(23) |
Dec
(42) |
| 2008 |
Jan
(26) |
Feb
(20) |
Mar
(21) |
Apr
(18) |
May
(28) |
Jun
(32) |
Jul
(25) |
Aug
(28) |
Sep
(27) |
Oct
(34) |
Nov
(16) |
Dec
(42) |
| 2009 |
Jan
(21) |
Feb
(36) |
Mar
(40) |
Apr
(51) |
May
(27) |
Jun
(13) |
Jul
(38) |
Aug
(40) |
Sep
(5) |
Oct
(14) |
Nov
(4) |
Dec
(7) |
| 2010 |
Jan
(16) |
Feb
(10) |
Mar
(38) |
Apr
(83) |
May
(27) |
Jun
(41) |
Jul
(57) |
Aug
(24) |
Sep
(14) |
Oct
(22) |
Nov
(28) |
Dec
(42) |
| 2011 |
Jan
(52) |
Feb
(13) |
Mar
(41) |
Apr
(14) |
May
(24) |
Jun
(14) |
Jul
(16) |
Aug
(15) |
Sep
(19) |
Oct
(20) |
Nov
(35) |
Dec
(48) |
| 2012 |
Jan
(30) |
Feb
(9) |
Mar
(33) |
Apr
(15) |
May
(13) |
Jun
(13) |
Jul
(57) |
Aug
(20) |
Sep
(18) |
Oct
(29) |
Nov
(28) |
Dec
(9) |
| 2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
| 2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
| 2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
| 2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
| 2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
| 2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
| 2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
| 2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
| 2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
(3) |
Nov
(3) |
Dec
|
| 2025 |
Jan
|
Feb
(5) |
Mar
(33) |
Apr
(8) |
May
(10) |
Jun
(7) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Jim I. <ji...@ho...> - 2004-04-08 20:42:43
|
<html><div style='background-color:'><DIV class=RTE>Colin,</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>I use Squirrel every day to access AS/400 data. It works perfectly, except for a few little issues.</DIV>
<DIV class=RTE>(Occasionally, Copy & Paste doesn't work.)</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>To access multiple member AS/400 files, you must use CREATE ALIAS command to create a file alias over that member. </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Ex. <STRONG>Create Alias Library.NewFile For LIB.FILE (MBR)</STRONG></DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Also you can call OS/400 commands directly from the Squirrel SQL edit window.</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Ex. <STRONG>CALL QSYS.QCMDEXC('WRKACTJOB SEQ(*CPUPCT) CPUPCTLMT(0.1)', 0000000037.00000)</STRONG></DIV>
<DIV class=RTE><FONT face=Arial></FONT> </DIV>
<DIV class=RTE><FONT face=Arial>Where 0000000037.00000 is a fixed decimal field with a length of 10 and 5 decimal places. The value 37 in the sample above must be the length of the string (the number of characters including spaces between the single quotes).</FONT></DIV>
<P><FONT face=Arial>Jim</FONT></P>
<DIV class=RTE><BR></DIV>
<DIV class=RTE> </DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMAENUS/2755??PS=">Is your PC infected? Get a FREE online computer virus scan from McAfee® Security.</a> </html>
|
|
From: Glenn G. <gw...@co...> - 2004-04-06 20:51:32
|
If you have string fields (VARCHAR, etc) that contain NEWLINE characters
within the strings:
DO NOT EDIT THOSE STRINGS USING THE ContentsTab IN-CELL EDITOR -
USE THE POPUP EDITOR ONLY! THE IN-CELL EDITOR REMOVES THE NEWLINES.
What happens:
If you bring up the ContentsTab view of your data, and
- one of the fields in the table is a VARCHAR-type field, and
- the data in one of the entries contains newlines within the string,
you will see the data displayed in that cell without any newlines. In
other words, you will see all of the lines of the mult-line text
displayed in a single line within the cell. If you click on that cell
(or tab into it) and the table is editable, the current release of
SQuirreL will let you edit that data, and when you leave the cell it
will replace the value in the DB with the value you just editing, which
does not contain the newlines.
To edit multi-line data, double-click on the cell to get the Popup
editing window, which shows the text correctly on multiple lines.
Since most VARCHAR-type fields are not usually used to contain
multi-line data, you probably have not seen this problem, but I wanted
to warn you about it just in case.
Example:
If a table contains a VARCHAR field named ADDRESS, and one of the
entries is:
"20 Elm St.\n
P. O. Box 123"
the ContentsTab will display:
"20 Elm St.P. O. Box 123"
If you edit the entry to say "Box 124" in the cell (without
double-clicking to get the popup window), the DB willbe changed to:
"20 Elm St.P. O. Box 124"
This problem has been fixed in the dev version by blocking in-cell
editing of data containing newlines in the cell. Note that the data is
still displayed as before (ie. all the text on one line) so you can see
it, but you can't edit it without using the Popup window.
Glenn
|
|
From: Colin B. <col...@bi...> - 2004-04-02 06:26:11
|
On Thu, Apr 01, 2004 at 03:05:42PM +0200, Pierre Didelon wrote: > Hi, > All my pbs begin by trying to download the jar file of squirrel-sql. > I can't download squirrel 1.1 jar file from whatever european > site available. > On WinXP, it answer me that source file could not be read, > by using the download facilties or using "save link target as" > it does nothing. > On Sun it answer me, > SmartUpdate failed: JAR archive failes security check. Corrupt JAR file. > > Previously on sun I got the possibility to use "save link target as" > (but the downloaded file was of no use as stressed above) > but actually this functionality is no more active/ available! > > I don't know how to solve this, > and from where I can download the jar files > > SY, Pierre > > Please reply to the list, not to me personally. What link are you trying to download from? -- Colin Bell http://squirrel-sql.sf.net |
|
From: Colin B. <Col...@as...> - 2004-04-01 22:08:25
|
There you go. If I kept up with my email I'd know that. :-)
Col
-----Original Message-----
From: Glenn Griffin [mailto:gw...@co...]
Sent: Friday, 2 April 2004 5:57
To: squ...@li...
Subject: Re: [Squirrel-sql-users] how to insert or delete records with put a
sql statment ?
Actually, the development version currently has both delete and insert on
the ContentsTab. For delete, select one or more rows and right-click, then
select "delete rows". To insert, go anywhere in the table, right-click, and
select "Insert Row". Of course, the table must be editable for either of
these to work.
As far as the released product is concerned, there are two data types that
I'ld like to get working (CLOB and BLOB) before we make this a real release,
and for timing on that I'll have to go along with Colin's "sometime this
year".
Glenn
Colin Bell wrote:
Sorry Jorge, I managed to miss this email. All I can really say is
sometime this year.
On Wed, Feb 04, 2004 at 12:25:42AM -0300, Jorge Valenzuela wrote:
ok thanks, any estimated date ?
Jorge V.S.'040204
Colin Bell wrote:
Hi Jorg,
-----Original Message-----
From: Jorge Valenzuela [mailto:jv...@po...]
Sent: Monday, 2 February 2004 1:49
To: squ...@li...
Subject: [Squirrel-sql-users] how to insert or delete records
with put a
sql statment ?
Hello:
There is any way to insert and delete records without using
sql statmentes ?
like the edit mode.
Not at the moment. This will be looked at in the future.
Col
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
|
From: Glenn G. <gw...@co...> - 2004-04-01 19:51:30
|
Actually, the development version currently has both delete and insert on the ContentsTab. For delete, select one or more rows and right-click, then select "delete rows". To insert, go anywhere in the table, right-click, and select "Insert Row". Of course, the table must be editable for either of these to work. As far as the released product is concerned, there are two data types that I'ld like to get working (CLOB and BLOB) before we make this a real release, and for timing on that I'll have to go along with Colin's "sometime this year". Glenn Colin Bell wrote: >Sorry Jorge, I managed to miss this email. All I can really say is >sometime this year. > >On Wed, Feb 04, 2004 at 12:25:42AM -0300, Jorge Valenzuela wrote: > > >>ok thanks, any estimated date ? >> >> >>Jorge V.S.'040204 >> >>Colin Bell wrote: >> >> >>>Hi Jorg, >>> >>> >>> >>> >>>>-----Original Message----- >>>>From: Jorge Valenzuela [mailto:jv...@po...] >>>>Sent: Monday, 2 February 2004 1:49 >>>>To: squ...@li... >>>>Subject: [Squirrel-sql-users] how to insert or delete records >>>>with put a >>>>sql statment ? >>>> >>>> >>>>Hello: >>>> >>>>There is any way to insert and delete records without using >>>>sql statmentes ? >>>> >>>>like the edit mode. >>>> >>>> >>>> >>>Not at the moment. This will be looked at in the future. >>> >>>Col >>> >>> >>> >>> > > >------------------------------------------------------- >This SF.Net email is sponsored by: IBM Linux Tutorials >Free Linux tutorial presented by Daniel Robbins, President and CEO of >GenToo technologies. Learn everything from fundamentals to system >administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click >_______________________________________________ >Squirrel-sql-users mailing list >Squ...@li... >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > |
|
From: Colin B. <col...@bi...> - 2004-04-01 11:26:17
|
On Thu, Mar 18, 2004 at 04:24:30PM -0700, John David Lilly wrote: > I had Squirrel 1.1 working perfectly against my Oracle 8.1.7, using the > system user. Today I am getting an "ORA-00942: table or view does not > exist" error upon login. > > The left pane is blank except for the top level node, and if I try to > refresh I get the error again. I can still run SQL statements against > the tables without a problem (so the connection works), I just can't see > the view in the left pane. > > I ran catalog.sql and my first export of the DB yesterday, I can't think > how that would mess things up. I'm guessing whatever commands Squirrel > runs to populate that left pane must have been affected by my changes. > > I googled the ORA error but found nothing pointing to a solution. > Any insights or suggestions on how to fix would be greatly appreciated. > -John > Sounds like you are missing metadata tables from the database. SQuirreL uses standard JDBC calls to retrieve the list of tables. The driver maps this to the appropriate action for the DBMS, usually queries over metadata tables of some form. I don't know how this is done in Oracle. I don't know what the catalog.sql script that you ran does does but it may have either removed the metadata tables or removed your authority to access them. -- Colin Bell http://squirrel-sql.sf.net |
|
From: Colin B. <col...@bi...> - 2004-04-01 11:19:44
|
On Fri, Mar 19, 2004 at 03:35:16PM +0100, Pierre Didelon wrote: > Hi squirrel users, > I download squirrel-sql-1.1 jar file, > then java -jar on this file gives an error, > PB of zip openning, both on unix (sun) and WinXP, > see below. > What can I do? > -- > Pierre > ------------------------------------------------------------------------------- > DIDELON e-mail : pdidelon_at_cea.fr > CEA SACLAY - Service d'Astrophysique W3 : http://www-dapnia.cea.fr/Sap/ > 91191 Gif-Sur-Yvette Cedex Phone : 33 (0)1 69 08 58 89 > ------------------------------------------------------------------------------- > UNIX CASE : > skylab:dide ~/squirrel >java -version > java version "1.4.2_01" > Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_01-b06) > Java HotSpot(TM) Client VM (build 1.4.2_01-b06, mixed mode) > skylab:dide ~/squirrel >java -jar squirrel-sql-1.1final1-install.jar > Exception in thread "main" java.util.zip.ZipException: error in opening zip > file > at java.util.zip.ZipFile.open(Native Method) > at java.util.zip.ZipFile.<init>(ZipFile.java:112) > at java.util.jar.JarFile.<init>(JarFile.java:127) > at java.util.jar.JarFile.<init>(JarFile.java:65) > That error indicates that the file was corrupted during the download. Try to download it again. -- Colin Bell http://squirrel-sql.sf.net |
|
From: Colin B. <col...@bi...> - 2004-04-01 11:17:18
|
On Mon, Mar 08, 2004 at 01:10:41PM -0500, Gang Cheng wrote: > Hi: > > I am a first time user. When configuring it to point an Informix SE (standard engine), I do not get the object tree, > although I can issue sql statements from the sql editor. I tried to use both the JDBC driver from Informix and the JDBC-ODBC bridge > from Sun, both have the same problem. Does anyone experience the same problem for Informix database ? I tried the same driver on another > tool DB Visualizer (http://www.minq.se/products/dbvis) with the same JDBC driver, I can see the object tree there. May be a bug in > the object tree rendering code of Squirrel ? > > I am using SQuirreL SQL Client Version 1.1final1. My JVM version is SUN JDK 1.4.2_03-b02. > > I do not get error message in the JDBC driver case. For the JDBC-ODBC driver, I am getting > this error: > > 123393 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.client.session.SessionSheet - Unable to retrieve catalog info > java.sql.SQLException: [Informix][Informix ODBC Driver]Driver does not support this function. > at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) > at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) > at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5519) > at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcDatabaseMetaData.java:2395) > at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getCatalogs(JdbcOdbcDatabaseMetaData.java:2471) > at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDatabaseMetaData.java:353) > at net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox.setConnection(SQLCatalogsComboBox.java:70) > at net.sourceforge.squirrel_sql.client.session.SessionSheet$MyToolBar.<init>(SessionSheet.java:367) > at net.sourceforge.squirrel_sql.client.session.SessionSheet.createUserInterface(SessionSheet.java:304) > at net.sourceforge.squirrel_sql.client.session.SessionSheet.<init>(SessionSheet.java:90) > at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:419) > at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178) > at java.awt.EventQueue.dispatchEvent(EventQueue.java:454) > at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) > at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) > at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) > at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) > at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) > 123549 [Thread-1] ERROR net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree - Error: SE ODBC > java.sql.SQLException: [Informix][Informix ODBC Driver]Driver does not support this function. > at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) > at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) > at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5519) > at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcDatabaseMetaData.java:2395) > at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getCatalogs(JdbcOdbcDatabaseMetaData.java:2471) > at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDatabaseMetaData.java:353) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander.createCatalogNodes(DatabaseExpander.java:159) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander.createChildren(DatabaseExpander.java:122) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.loadChildren(ObjectTree.java:668) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.execute(ObjectTree.java:619) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.expandNode(ObjectTree.java:355) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.access$600(ObjectTree.java:63) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$ExpansionController.run(ObjectTree.java:576) > at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:65) > at java.lang.Thread.run(Thread.java:534) > > > This error says that the ODBC driver doesn't support the function required to list the database tables. What error do you get with the native JDBC driver? -- Colin Bell http://squirrel-sql.sf.net |
|
From: Colin B. <col...@bi...> - 2004-04-01 11:14:42
|
Sorry Jorge, I managed to miss this email. All I can really say is sometime this year. On Wed, Feb 04, 2004 at 12:25:42AM -0300, Jorge Valenzuela wrote: > ok thanks, any estimated date ? > > > Jorge V.S.'040204 > > Colin Bell wrote: > >Hi Jorg, > > > > > >>-----Original Message----- > >>From: Jorge Valenzuela [mailto:jv...@po...] > >>Sent: Monday, 2 February 2004 1:49 > >>To: squ...@li... > >>Subject: [Squirrel-sql-users] how to insert or delete records > >>with put a > >>sql statment ? > >> > >> > >>Hello: > >> > >>There is any way to insert and delete records without using > >>sql statmentes ? > >> > >>like the edit mode. > >> > > > > > >Not at the moment. This will be looked at in the future. > > > >Col > > > > |
|
From: Colin B. <col...@bi...> - 2004-04-01 11:14:22
|
On Fri, Feb 13, 2004 at 12:52:02PM -0500, rkn...@st... wrote: > > Has anyone gotten Squirrel to work with AS/400 Tables correctly? Its been reported to work but I don't know to what detail. I've added an entry to the bug tracker to cover this and will look at it for the 1.2 series. http://sourceforge.net/tracker/index.php?func=detail&aid=927417&group_id=28383&atid=393414 -- Colin Bell http://squirrel-sql.sf.net |
|
From: Pierre D. <pdi...@ce...> - 2004-03-19 14:35:29
|
Hi squirrel users, I download squirrel-sql-1.1 jar file, then java -jar on this file gives an error, PB of zip openning, both on unix (sun) and WinXP, see below. What can I do? -- Pierre ------------------------------------------------------------------------------- DIDELON e-mail : pdidelon_at_cea.fr CEA SACLAY - Service d'Astrophysique W3 : http://www-dapnia.cea.fr/Sap/ 91191 Gif-Sur-Yvette Cedex Phone : 33 (0)1 69 08 58 89 ------------------------------------------------------------------------------- UNIX CASE : skylab:dide ~/squirrel >java -version java version "1.4.2_01" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_01-b06) Java HotSpot(TM) Client VM (build 1.4.2_01-b06, mixed mode) skylab:dide ~/squirrel >java -jar squirrel-sql-1.1final1-install.jar Exception in thread "main" java.util.zip.ZipException: error in opening zip file at java.util.zip.ZipFile.open(Native Method) at java.util.zip.ZipFile.<init>(ZipFile.java:112) at java.util.jar.JarFile.<init>(JarFile.java:127) at java.util.jar.JarFile.<init>(JarFile.java:65) WinXP case C:\Squirrel>java -version java version "1.4.1_02" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_02-b06) Java HotSpot(TM) Client VM (build 1.4.1_02-b06, mixed mode) C:\Squirrel>java -jar squirrel-sql-1.1final1-install.jar Exception in thread "main" java.util.zip.ZipException: error in opening zip file at java.util.zip.ZipFile.open(Native Method) at java.util.zip.ZipFile.<init>(ZipFile.java:112) at java.util.jar.JarFile.<init>(JarFile.java:117) at java.util.jar.JarFile.<init>(JarFile.java:55) |
|
From: John D. L. <jl...@id...> - 2004-03-18 23:24:45
|
I had Squirrel 1.1 working perfectly against my Oracle 8.1.7, using the system user. Today I am getting an "ORA-00942: table or view does not exist" error upon login. The left pane is blank except for the top level node, and if I try to refresh I get the error again. I can still run SQL statements against the tables without a problem (so the connection works), I just can't see the view in the left pane. I ran catalog.sql and my first export of the DB yesterday, I can't think how that would mess things up. I'm guessing whatever commands Squirrel runs to populate that left pane must have been affected by my changes. I googled the ORA error but found nothing pointing to a solution. Any insights or suggestions on how to fix would be greatly appreciated. -John |
|
From: Gang C. <gan...@sp...> - 2004-03-08 18:28:03
|
Hi: I am a first time user. When configuring it to point an Informix SE = (standard engine), I do not get the object tree, although I can issue sql statements from the sql editor. I tried to use = both the JDBC driver from Informix and the JDBC-ODBC bridge from Sun, both have the same problem. Does anyone experience the same = problem for Informix database ? I tried the same driver on another tool DB Visualizer (http://www.minq.se/products/dbvis) with the same = JDBC driver, I can see the object tree there. May be a bug in the object tree rendering code of Squirrel ?=20 I am using SQuirreL SQL Client Version 1.1final1. My JVM version is SUN = JDK 1.4.2_03-b02. I do not get error message in the JDBC driver case. For the JDBC-ODBC = driver, I am getting this error: 123393 [AWT-EventQueue-0] ERROR = net.sourceforge.squirrel_sql.client.session.SessionSheet - Unable to = retrieve catalog info java.sql.SQLException: [Informix][Informix ODBC Driver]Driver does not = support this function. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5519) at = sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcDatabaseMetaData= .java:2395) at = sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getCatalogs(JdbcOdbcDatabaseMetaDa= ta.java:2471) at = net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDa= tabaseMetaData.java:353) at = net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox.setConnection(SQL= CatalogsComboBox.java:70) at = net.sourceforge.squirrel_sql.client.session.SessionSheet$MyToolBar.<init>= (SessionSheet.java:367) at = net.sourceforge.squirrel_sql.client.session.SessionSheet.createUserInterf= ace(SessionSheet.java:304) at = net.sourceforge.squirrel_sql.client.session.SessionSheet.<init>(SessionSh= eet.java:90) at = net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasComman= d$Runner.run(ConnectToAliasCommand.java:419) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178) at java.awt.EventQueue.dispatchEvent(EventQueue.java:454) at = java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread= .java:201) at = java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.j= ava:151) at = java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at = java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) 123549 [Thread-1] ERROR = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr= ee - Error: SE ODBC java.sql.SQLException: [Informix][Informix ODBC Driver]Driver does not = support this function. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5519) at = sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcDatabaseMetaData= .java:2395) at = sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getCatalogs(JdbcOdbcDatabaseMetaDa= ta.java:2471) at = net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDa= tabaseMetaData.java:353) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expander= s.DatabaseExpander.createCatalogNodes(DatabaseExpander.java:159) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expander= s.DatabaseExpander.createChildren(DatabaseExpander.java:122) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr= ee$TreeLoader.loadChildren(ObjectTree.java:668) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr= ee$TreeLoader.execute(ObjectTree.java:619) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr= ee.expandNode(ObjectTree.java:355) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr= ee.access$600(ObjectTree.java:63) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr= ee$ExpansionController.run(ObjectTree.java:576) at = net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:6= 5) at java.lang.Thread.run(Thread.java:534) |
|
From: Knepp, E. <eK...@c-...> - 2004-03-03 13:57:00
|
Sorry Philipp, Check this page out for how to utilize the POI API for spreadsheets. http://jakarta.apache.org/poi/hssf/quick-guide.html -Ethan -----Original Message----- From: Knepp, Ethan Sent: Wednesday, March 03, 2004 8:35 AM To: squ...@li... Subject: RE: [Squirrel-sql-users] Redirect output to file? Philipp, I encountered the same situation some months back. I solved my problem by writing some JAVA code that utilized Apache's POI API (allows you to create MS documents, spreadsheets, etc) to export the Result Set into an excel spreadsheet. I also modified the same code to allow the same Result Set to be exported as a csv file. Here is an quick example of how to use the POI API: http://jakarta.apache.org/poi/hssf/how-to.html Best Regards, Ethan -- Ethan Knepp -----Original Message----- From: Philipp K. Janert, Ph.D. [mailto:ja...@ie...] Sent: Friday, February 27, 2004 7:08 PM To: squ...@li... Cc: ja...@ie... Subject: [Squirrel-sql-users] Redirect output to file? Often, I use SQuirrel to interactively build up a query, which I then would like to run with the results being dumped into a file. I know that I can copy/paste the results out of the results window, but this is rather unpleasant if the resulting set is big. Best regards, Ph. -- Philipp K. Janert, Ph.D. http://www.beyondCode.org ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id56&alloc_id438&op=click _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Knepp, E. <eK...@c-...> - 2004-03-03 13:53:35
|
Philipp, I encountered the same situation some months back. I solved my problem by writing some JAVA code that utilized Apache's POI API (allows you to create MS documents, spreadsheets, etc) to export the Result Set into an excel spreadsheet. I also modified the same code to allow the same Result Set to be exported as a csv file. Here is an quick example of how to use the POI API: http://jakarta.apache.org/poi/hssf/how-to.html Best Regards, Ethan -- Ethan Knepp -----Original Message----- From: Philipp K. Janert, Ph.D. [mailto:ja...@ie...] Sent: Friday, February 27, 2004 7:08 PM To: squ...@li... Cc: ja...@ie... Subject: [Squirrel-sql-users] Redirect output to file? Often, I use SQuirrel to interactively build up a query, which I then would like to run with the results being dumped into a file. I know that I can copy/paste the results out of the results window, but this is rather unpleasant if the resulting set is big. Best regards, Ph. -- Philipp K. Janert, Ph.D. http://www.beyondCode.org ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id56&alloc_id438&op=click _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Philipp K. J. Ph.D. <ja...@ie...> - 2004-02-28 00:18:30
|
Often, I use SQuirrel to interactively build up a query, which I then would like to run with the results being=20 dumped into a file. I know that I can copy/paste the results out of the results window, but this is rather unpleasant if the resulting set is big.=20 Best regards, =09=09Ph. --=20 Philipp K. Janert, Ph.D. =20 http://www.beyondCode.org |
|
From: Colin B. <Col...@as...> - 2004-02-10 05:21:58
|
Hi Richard, I've moved this back to the users list in case anybody has some ideas. I can't give any real advice about this as I've never had the problem. Its possible that your Java fonts aren't been mapped correctly to your X fonts. This link has some more info about it http://java.sun.com/j2se/1.4.2/docs/guide/intl/fontprop.html. Theres some info here on Fonts and Blackdown that may or may not be relevant for you http://www.blackdown.org/java-linux/docs/support/faq-release/FAQ-java-linux- 5.html Good luck. Col > -----Original Message----- > From: Richard Martin [mailto:Ric...@ae...] > Sent: Monday, 9 February 2004 23:11 > To: Colin Bell > Subject: RE: [Squirrel-sql-users] Install problem > > > Hi Colin, > > Just did a quick test with netbeans (another swing app) and the same > thing happens with it. Any ideas whats wrong with my setup? > > Cheers > Richard > > On Fri, 2004-02-06 at 22:22, Colin Bell wrote: > > > -----Original Message----- > > > From: Richard Martin [mailto:Ric...@ae...] > > > Sent: Friday, 6 February 2004 22:20 > > > To: Colin Bell > > > Cc: squirrel-sql-users > > > Subject: RE: [Squirrel-sql-users] Install problem > > > > > > > > > Hi Colin > > > > > > Thanks for the reply. I have tried it on GNOME, KDE and > Enlightenment > > > with no luck - same screen appears. Is it possible to run > it just from > > > the downloaded source code? > > > > > > > Hi Richard, > > > > You'll need to build the application using the Ant build > file in the /build > > directory from the source disrribution. If you're not > familiar with Java and > > Ant this would be a bit difficult. As well if the IzPack > installer doesn't > > work then probably SQuirreL will have similar problems when > trying to run. > > Do you have any other Java Swing applications installed > (such as JEdit) that > > run correctly? > > > > If you give me a couple of hours I'll tar up an installed version of > > SQuirreL and put it up on an FTP site for you. Just untar > it into somewhere > > like /usr/local/. You'll probably need to fiddle with the > shell script > > before it runs in your environment. Just let me know > whether you want 1.1 > > final or the 1.2 beta. > > > > Col > > > > > > ------------------------------------------------------- > > The SF.Net email is sponsored by EclipseCon 2004 > > Premiere Conference on Open Tools Development and Integration > > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > > http://www.eclipsecon.org/osdn > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > -- > Richard Martin <Ric...@ae...> > AePONA Ltd > |
|
From: Colin B. <Col...@as...> - 2004-02-07 01:34:44
|
Hi Richard, Theres a tarred up version of 1.2beta4 at http://users.bigpond.com/colbelloz/sqsc1.2beta4.tar.gz Let me know what happens when you try running this one. Col |
|
From: Colin B. <Col...@as...> - 2004-02-06 23:11:40
|
> -----Original Message----- > From: Richard Martin [mailto:Ric...@ae...] > Sent: Friday, 6 February 2004 22:20 > To: Colin Bell > Cc: squirrel-sql-users > Subject: RE: [Squirrel-sql-users] Install problem > > > Hi Colin > > Thanks for the reply. I have tried it on GNOME, KDE and Enlightenment > with no luck - same screen appears. Is it possible to run it just from > the downloaded source code? > Hi Richard, You'll need to build the application using the Ant build file in the /build directory from the source disrribution. If you're not familiar with Java and Ant this would be a bit difficult. As well if the IzPack installer doesn't work then probably SQuirreL will have similar problems when trying to run. Do you have any other Java Swing applications installed (such as JEdit) that run correctly? If you give me a couple of hours I'll tar up an installed version of SQuirreL and put it up on an FTP site for you. Just untar it into somewhere like /usr/local/. You'll probably need to fiddle with the shell script before it runs in your environment. Just let me know whether you want 1.1 final or the 1.2 beta. Col |
|
From: Richard M. <Ric...@ae...> - 2004-02-06 11:20:29
|
Hi Colin Thanks for the reply. I have tried it on GNOME, KDE and Enlightenment with no luck - same screen appears. Is it possible to run it just from the downloaded source code? Cheers Richard On Thu, 2004-02-05 at 21:56, Colin Bell wrote: > Hi Richard, > > It works for me on Debian KDE. Some Windowmanagers have problems with Java - > BlackBox and FluxBox come to mind. To a lesser extent MetaCity (the GNome > WindowManager) has some problems. Try using a different Windowmanager. > > Col > > > -----Original Message----- > > From: Richard Martin [mailto:Ric...@ae...] > > Sent: Friday, 6 February 2004 3:36 > > To: squirrel-sql-users > > Subject: [Squirrel-sql-users] Install problem > > > > > > Hi > > > > I have just download both the stable > > squirrel-sql-1.1final1-install.jar > > and the beta > > squirrel-sql-1.2beta4-install.jar > > > > When i run java -jar squirrel-sql-<version>-install.jar on either jar > > file i get a IZPack window pops up which is empty apart from > > 1 extremely > > long button which doesn't do anything. Any ideas? I am > > running jdk 1.4.2 > > on RH9 linux. > > > > Thanks > > Richard > > > > > > > > ------------------------------------------------------- > > The SF.Net email is sponsored by EclipseCon 2004 > > Premiere Conference on Open Tools Development and Integration > > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > > http://www.eclipsecon.org/osdn > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > > > ------------------------------------------------------- > The SF.Net email is sponsored by EclipseCon 2004 > Premiere Conference on Open Tools Development and Integration > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Colin B. <Col...@as...> - 2004-02-05 21:56:48
|
Hi Richard, It works for me on Debian KDE. Some Windowmanagers have problems with Java - BlackBox and FluxBox come to mind. To a lesser extent MetaCity (the GNome WindowManager) has some problems. Try using a different Windowmanager. Col > -----Original Message----- > From: Richard Martin [mailto:Ric...@ae...] > Sent: Friday, 6 February 2004 3:36 > To: squirrel-sql-users > Subject: [Squirrel-sql-users] Install problem > > > Hi > > I have just download both the stable > squirrel-sql-1.1final1-install.jar > and the beta > squirrel-sql-1.2beta4-install.jar > > When i run java -jar squirrel-sql-<version>-install.jar on either jar > file i get a IZPack window pops up which is empty apart from > 1 extremely > long button which doesn't do anything. Any ideas? I am > running jdk 1.4.2 > on RH9 linux. > > Thanks > Richard > > > > ------------------------------------------------------- > The SF.Net email is sponsored by EclipseCon 2004 > Premiere Conference on Open Tools Development and Integration > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Richard M. <Ric...@ae...> - 2004-02-05 16:36:33
|
Hi I have just download both the stable squirrel-sql-1.1final1-install.jar and the beta squirrel-sql-1.2beta4-install.jar When i run java -jar squirrel-sql-<version>-install.jar on either jar file i get a IZPack window pops up which is empty apart from 1 extremely long button which doesn't do anything. Any ideas? I am running jdk 1.4.2 on RH9 linux. Thanks Richard |
|
From: Jorge V. <jv...@po...> - 2004-02-04 03:17:54
|
ok thanks, any estimated date ? Jorge V.S.'040204 Colin Bell wrote: > Hi Jorg, > > >>-----Original Message----- >>From: Jorge Valenzuela [mailto:jv...@po...] >>Sent: Monday, 2 February 2004 1:49 >>To: squ...@li... >>Subject: [Squirrel-sql-users] how to insert or delete records >>with put a >>sql statment ? >> >> >>Hello: >> >>There is any way to insert and delete records without using >>sql statmentes ? >> >>like the edit mode. >> > > > Not at the moment. This will be looked at in the future. > > Col > > > ------------------------------------------------------- > The SF.Net email is sponsored by EclipseCon 2004 > Premiere Conference on Open Tools Development and Integration > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > -- //\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\ \\// Jorge Valenzuela S.; Santiago, Chile. <|>. \\// e-mail > jv...@po... /| |X| \\// ICQ > 107367495 \\// http://www.poliedros.net //\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\ |
|
From: Colin B. <Col...@as...> - 2004-02-03 21:04:38
|
Hi Jorg, > -----Original Message----- > From: Jorge Valenzuela [mailto:jv...@po...] > Sent: Monday, 2 February 2004 1:49 > To: squ...@li... > Subject: [Squirrel-sql-users] how to insert or delete records > with put a > sql statment ? > > > Hello: > > There is any way to insert and delete records without using > sql statmentes ? > > like the edit mode. > Not at the moment. This will be looked at in the future. Col |
|
From: Jorge V. <jv...@po...> - 2004-02-01 14:41:15
|
Hello:
There is any way to insert and delete records without using sql statmentes ?
like the edit mode.
thanks
Jorge V.S.'040201
--
//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\
\\// Jorge Valenzuela S.; Santiago, Chile.
<|>. \\// e-mail > jv...@po...
/| |X| \\// ICQ > 107367495
\\// http://www.poliedros.net
//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\
|
