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: David C. <dl...@wi...> - 2025-06-23 13:12:16
|
Well, I've found that I can run a custom query for it. Seems this could be
built in. But, I do understand that the system table names may change
depending upon the connected DBMS.
Select trim(con.tabschema) || '.' || trim(con.tabname) as table
, con.constname as constraint_name
, case tab.enforced
when 'N' then 'Disabled'
when 'Y' then 'Active'
end as status
, col.colname as column_name
, cast(con.text as varchar(255)) as text
from syscat.checks as con
Join syscat.colchecks as col
on col.constname = con.constname
and col.tabschema = con.tabschema
and col.tabname = con.tabname
Join syscat.tabconst as tab
on tab.constname = con.constname
and tab.tabschema = con.tabschema
and tab.tabname = con.tabname
order by con.tabschema, con.tabname, col.colname;
Thanks,
Dave Clark
--
Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331
On Sun, Jun 22, 2025 at 4:37 PM Gerd Wagner <ger...@t-...> wrote:
>
>
> On 11.06.25 16:26, David Clark wrote:
> > I have found where to view indexes and foreign key constraints, but not
> > where to view check constraints. Is this available in SQuirrel 4.8?
> >
>
> No it's not.
>
> To my knowledge the JDBC-API does not offer access to check constraints
> and there isn't any other SQL standard way to access check constraints,
> either.
>
> Gerd
>
|
|
From: Gerd W. <ger...@t-...> - 2025-06-22 20:37:22
|
On 11.06.25 16:26, David Clark wrote: > I have found where to view indexes and foreign key constraints, but not > where to view check constraints. Is this available in SQuirrel 4.8? > No it's not. To my knowledge the JDBC-API does not offer access to check constraints and there isn't any other SQL standard way to access check constraints, either. Gerd |
|
From: Stanimir S. <s7...@ne...> - 2025-06-11 17:10:26
|
Wed, 11 Jun 2025 14:58:26 +0000, /Kevin Beard/: > To: "squ...@li..." > <squ...@li...> > List-Unsubscribe: <https://lists.sourceforge.net/lists/options/squirrel-sql-users>, > <mailto:squ...@li...?subject=unsubscribe> > > Unsubscribe I guess you need to send this to <squ...@li...>, instead. -- Stanimir |
|
From: Kevin B. <Kev...@ph...> - 2025-06-11 15:14:32
|
Unsubscribe This message and any attachments are confidential, may contain privileged information, and are intended solely for the recipient named above. If you are not the intended recipient, or a person responsible for delivery to the named recipient, you are notified that any review, distribution, dissemination or copying is prohibited. If you have received this message in error, you should notify the sender by return email and delete the message from your computer system. |
|
From: David C. <dl...@wi...> - 2025-06-11 14:27:41
|
I have found where to view indexes and foreign key constraints, but not where to view check constraints. Is this available in SQuirrel 4.8? Sincerely, Dave Clark -- Winsupply Group Services 3110 Kettering Boulevard Dayton, Ohio 45439 USA (937) 294-5331 |
|
From: Gerd W. <ger...@t-...> - 2025-06-07 01:36:05
|
On 30.05.25 21:14, David Clark wrote:
> This is my first time using the Squirrel SQL Client (v8.4). I'm trying
> to create a DB2 stored procedure and getting the following error
> message. I'm not completely sure what it is trying to tell me. I know
> that the state indicates a syntax error, and I'm guessing that the
> SQLERRMC indicates the failing statement. Does the string after that
> indicate the previous characters in my source? ...leading up to that
> statement? And why does it say "TRUNCATE"? I know the ALTER statement
> is good, though; because I can execute it by itself elsewhere. So, I'm
> confused. Help?!?
>
> Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=ALTER;OP'
> Then Begin
> ;TRUNCATE, DRIVER=4.33.31
>
As SQuirreL's default statement separator is ; (semicolon) and DB2 uses
; as an internal separator you might first want to adjust SQuirreL's
statement separator at menu File --> New Session Properties --> tab SQL
--> section "Statement" separator.
As stored procedures often contain empty lines, make sure the complete
procedure is selected in SQUirreL's editor before you click the run
button or hit Ctrl+Enter.
Below you find an example of a stored procedure that I could create and
execute from within SQuirreL.
To call the procedure from within SQuirreL you must use the JDBC format
{call READ_MYTABLE(42)}
although I noticed that for me
call READ_MYTABLE(42)
works as well.
Gerd
-- Example Stored Procedure for DB2/LINUXX8664 version SQL110550
--
CREATE OR REPLACE PROCEDURE READ_MYTABLE(IN MYTABLEIDVAR INTEGER)
LANGUAGE SQL
DYNAMIC RESULT SETS 1
BEGIN
DECLARE cursor1 CURSOR WITH RETURN TO CALLER
FOR (SELECT * FROM MYTABLE WHERE MYTABLEID = MYTABLEIDVAR);
OPEN cursor1;
END
|
|
From: David C. <dl...@wi...> - 2025-06-04 15:13:08
|
Note that I have successfully compiled my Linux DB2 stored procedure through SQuirrel. Yes, it is difficult having only the DB2 error messages to go by (i.e., no interactive debugger is possible), but once I got used to them I was able to figure things out. I also had to do a lot of reading of the IBM online documentation. It was helpful that I have had a lot of experience with writing stored procedures on other platforms--particularly, DB2 for iSeries. Thanks, Dave Clark -- Winsupply Group Services 3110 Kettering Boulevard Dayton, Ohio 45439 USA (937) 294-5331 On Fri, May 30, 2025 at 7:47 PM info <in...@dr...> wrote: > I had little luck compiling DB2 SPs through Squirrel. Usually they compile > successfully through IBM Data Studio or command line processor. > > On 2025-05-30 07:20 PM, David Clark wrote: > > Sorry, I should have mentioned that this is for DB2 for Linux. But, by > CLP, are you referring to Command Line Processing? I don't think I have > access to that. I'm just using SQuirrel v4.8 from the Windows Desktop. > I'm saving my source in a separate TXT file and copying it into SQuirrel > when I'm ready to test it. > > Sincerely, > > Dave Clark > -- > Winsupply Group Services > 3110 Kettering Boulevard > Dayton, Ohio 45439 USA > (937) 294-5331 > > > On Fri, May 30, 2025 at 6:29 PM info <in...@dr...> wrote: > >> David, >> >> Does your SP compile in CLP? >> >> Regards >> >> On 2025-05-30 03:14 PM, David Clark wrote: >> >> This is my first time using the Squirrel SQL Client (v8.4). I'm trying >> to create a DB2 stored procedure and getting the following error message. >> I'm not completely sure what it is trying to tell me. I know that the >> state indicates a syntax error, and I'm guessing that the SQLERRMC >> indicates the failing statement. Does the string after that indicate the >> previous characters in my source? ...leading up to that statement? And why >> does it say "TRUNCATE"? I know the ALTER statement is good, though; >> because I can execute it by itself elsewhere. So, I'm confused. Help?!? >> >> Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=ALTER;OP' >> Then Begin >> ;TRUNCATE, DRIVER=4.33.31 >> >> Sincerely, >> >> Dave Clark >> -- >> Winsupply Group Services >> 3110 Kettering Boulevard >> Dayton, Ohio 45439 USA >> (937) 294-5331 >> >> >> >> >> _______________________________________________ >> Squirrel-sql-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > > |
|
From: info <in...@dr...> - 2025-05-31 13:45:29
|
https://www.ibm.com/docs/en/db2/11.1.0?topic=clp-db2-invocation https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=commands-db2-command-line-processor On 2025-05-31 09:28 AM, David Clark wrote: > How is the command line processor accessed? > |
|
From: David C. <dl...@wi...> - 2025-05-31 13:29:22
|
How is the command line processor accessed? Thanks, Dave Clark -- Winsupply Group Services 3110 Kettering Boulevard Dayton, Ohio 45439 USA (937) 294-5331 On Fri, May 30, 2025 at 7:47 PM info <in...@dr...> wrote: > I had little luck compiling DB2 SPs through Squirrel. Usually they compile > successfully through IBM Data Studio or command line processor. > > On 2025-05-30 07:20 PM, David Clark wrote: > > Sorry, I should have mentioned that this is for DB2 for Linux. But, by > CLP, are you referring to Command Line Processing? I don't think I have > access to that. I'm just using SQuirrel v4.8 from the Windows Desktop. > I'm saving my source in a separate TXT file and copying it into SQuirrel > when I'm ready to test it. > > Sincerely, > > Dave Clark > -- > Winsupply Group Services > 3110 Kettering Boulevard > Dayton, Ohio 45439 USA > (937) 294-5331 > > > On Fri, May 30, 2025 at 6:29 PM info <in...@dr...> wrote: > >> David, >> >> Does your SP compile in CLP? >> >> Regards >> >> On 2025-05-30 03:14 PM, David Clark wrote: >> >> This is my first time using the Squirrel SQL Client (v8.4). I'm trying >> to create a DB2 stored procedure and getting the following error message. >> I'm not completely sure what it is trying to tell me. I know that the >> state indicates a syntax error, and I'm guessing that the SQLERRMC >> indicates the failing statement. Does the string after that indicate the >> previous characters in my source? ...leading up to that statement? And why >> does it say "TRUNCATE"? I know the ALTER statement is good, though; >> because I can execute it by itself elsewhere. So, I'm confused. Help?!? >> >> Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=ALTER;OP' >> Then Begin >> ;TRUNCATE, DRIVER=4.33.31 >> >> Sincerely, >> >> Dave Clark >> -- >> Winsupply Group Services >> 3110 Kettering Boulevard >> Dayton, Ohio 45439 USA >> (937) 294-5331 >> >> >> >> >> _______________________________________________ >> Squirrel-sql-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > > |
|
From: info <in...@dr...> - 2025-05-30 23:47:12
|
I had little luck compiling DB2 SPs through Squirrel. Usually they compile successfully through IBM Data Studio or command line processor. On 2025-05-30 07:20 PM, David Clark wrote: > Sorry, I should have mentioned that this is for DB2 for Linux. But, > by CLP, are you referring to Command Line Processing? I don't think I > have access to that. I'm just using SQuirrel v4.8 from the Windows > Desktop. I'm saving my source in a separate TXT file and copying it > into SQuirrel when I'm ready to test it. > > Sincerely, > > Dave Clark > -- > Winsupply Group Services > 3110 Kettering Boulevard > Dayton, Ohio 45439 USA > (937) 294-5331 > > > On Fri, May 30, 2025 at 6:29 PM info <in...@dr... > <mailto:in...@dr...>> wrote: > > David, > > Does your SP compile in CLP? > > Regards > > On 2025-05-30 03:14 PM, David Clark wrote: >> This is my first time using the Squirrel SQL Client (v8.4). I'm >> trying to create a DB2 stored procedure and getting the following >> error message. I'm not completely sure what it is trying to tell >> me. I know that the state indicates a syntax error, and I'm >> guessing that the SQLERRMC indicates the failing statement. Does >> the string after that indicate the previous characters in my >> source? ...leading up to that statement? And why does it say >> "TRUNCATE"? I know the ALTER statement is good, though; because >> I can execute it by itself elsewhere. So, I'm confused. Help?!? >> >> Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, >> SQLERRMC=ALTER;OP' Then Begin >> ;TRUNCATE, DRIVER=4.33.31 >> >> Sincerely, >> >> Dave Clark >> -- >> Winsupply Group Services >> 3110 Kettering Boulevard >> Dayton, Ohio 45439 USA >> (937) 294-5331 >> >> >> >> >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> <mailto:Squ...@li...> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > <mailto:Squ...@li...> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: David C. <dl...@wi...> - 2025-05-30 23:21:47
|
Sorry, I should have mentioned that this is for DB2 for Linux. But, by CLP, are you referring to Command Line Processing? I don't think I have access to that. I'm just using SQuirrel v4.8 from the Windows Desktop. I'm saving my source in a separate TXT file and copying it into SQuirrel when I'm ready to test it. Sincerely, Dave Clark -- Winsupply Group Services 3110 Kettering Boulevard Dayton, Ohio 45439 USA (937) 294-5331 On Fri, May 30, 2025 at 6:29 PM info <in...@dr...> wrote: > David, > > Does your SP compile in CLP? > > Regards > > On 2025-05-30 03:14 PM, David Clark wrote: > > This is my first time using the Squirrel SQL Client (v8.4). I'm trying to > create a DB2 stored procedure and getting the following error message. I'm > not completely sure what it is trying to tell me. I know that the state > indicates a syntax error, and I'm guessing that the SQLERRMC indicates the > failing statement. Does the string after that indicate the previous > characters in my source? ...leading up to that statement? And why does it > say "TRUNCATE"? I know the ALTER statement is good, though; because I can > execute it by itself elsewhere. So, I'm confused. Help?!? > > Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=ALTER;OP' > Then Begin > ;TRUNCATE, DRIVER=4.33.31 > > Sincerely, > > Dave Clark > -- > Winsupply Group Services > 3110 Kettering Boulevard > Dayton, Ohio 45439 USA > (937) 294-5331 > > > > > _______________________________________________ > Squirrel-sql-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: info <in...@dr...> - 2025-05-30 22:29:00
|
David, Does your SP compile in CLP? Regards On 2025-05-30 03:14 PM, David Clark wrote: > This is my first time using the Squirrel SQL Client (v8.4). I'm > trying to create a DB2 stored procedure and getting the following > error message. I'm not completely sure what it is trying to tell me. > I know that the state indicates a syntax error, and I'm guessing that > the SQLERRMC indicates the failing statement. Does the string after > that indicate the previous characters in my source? ...leading up to > that statement? And why does it say "TRUNCATE"? I know the > ALTER statement is good, though; because I can execute it by itself > elsewhere. So, I'm confused. Help?!? > > Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=ALTER;OP' > Then Begin > ;TRUNCATE, DRIVER=4.33.31 > > Sincerely, > > Dave Clark > -- > Winsupply Group Services > 3110 Kettering Boulevard > Dayton, Ohio 45439 USA > (937) 294-5331 > > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: David C. <dl...@wi...> - 2025-05-30 21:07:49
|
This is my first time using the Squirrel SQL Client (v8.4). I'm trying to create a DB2 stored procedure and getting the following error message. I'm not completely sure what it is trying to tell me. I know that the state indicates a syntax error, and I'm guessing that the SQLERRMC indicates the failing statement. Does the string after that indicate the previous characters in my source? ...leading up to that statement? And why does it say "TRUNCATE"? I know the ALTER statement is good, though; because I can execute it by itself elsewhere. So, I'm confused. Help?!? Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=ALTER;OP' Then Begin ;TRUNCATE, DRIVER=4.33.31 Sincerely, Dave Clark -- Winsupply Group Services 3110 Kettering Boulevard Dayton, Ohio 45439 USA (937) 294-5331 |
|
From: Hector f. <hec...@gm...> - 2025-05-26 10:40:43
|
Hi gerd . I fixed it deleting props.properties and prefs files. The issue Was when i tried to open export menu El sáb, 24 de may de 2025, 16:20, Gerd Wagner <ger...@t-...> escribió: > Sorry, I cannot reproduce your problem. But your stacktrace allowed me > to guess what went wrong and I implemented a fix. The fix will be > available in future snapshots and versions. > > Gerd > > > > On 20.05.25 11:53, Hector fernandez wrote: > > Hi team in 4.8 on WindowsRegistrado por > > net.sourceforge.squirrel_sql.client.Main el 20/5/25, 6:50: > > > > Exception occurred dispatching Event > > java.awt.event.MouseEvent[MOUSE_RELEASED, > > (32,442),absolute(607,571),button=1,modifiers=Button1,clickCount=1] on > win2 > > > > java.lang.NullPointerException: Cannot invoke "String.equals(Object)" > > because "newItem" is null > > at > > > net.sourceforge.squirrel_sql.fw.gui.EditableComboBoxHandler.addOrReplaceCurrentItem(EditableComboBoxHandler.java:73) > > at > > > net.sourceforge.squirrel_sql.fw.gui.action.fileexport.ExportController.initData(ExportController.java:492) > > at > > > net.sourceforge.squirrel_sql.fw.gui.action.fileexport.ExportController.<init>(ExportController.java:50) > > at > > > net.sourceforge.squirrel_sql.fw.gui.action.fileexport.TableExport.<init>(TableExport.java:20) > > at > > > net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ExportAction.actionPerformed(TablePopupMenu.java:490) > > at java.desktop/ > > javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) > > at java.desktop/ > > > javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2314) > > at java.desktop/ > > > javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:407) > > at java.desktop/ > > javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) > > at > java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374) > > at java.desktop/ > > javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1029) > > at java.desktop/ > > > javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1073) > > at java.desktop/java.awt.Component.processMouseEvent(Component.java:6621) > > at java.desktop/ > > javax.swing.JComponent.processMouseEvent(JComponent.java:3398) > > at java.desktop/java.awt.Component.processEvent(Component.java:6386) > > at java.desktop/java.awt.Container.processEvent(Container.java:2266) > > at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4996) > > at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) > > at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828) > > at java.desktop/ > > java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) > > at java.desktop/ > > java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) > > at java.desktop/ > > java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) > > at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) > > at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) > > at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828) > > at > java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:775) > > at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:720) > > at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:714) > > at java.base/ > > java.security.AccessController.doPrivileged(AccessController.java:400) > > at java.base/ > > > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:87) > > at java.base/ > > > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:98) > > at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:747) > > at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745) > > at java.base/ > > java.security.AccessController.doPrivileged(AccessController.java:400) > > at java.base/ > > > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:87) > > at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:744) > > at > net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:101) > > at java.desktop/ > > > java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) > > at java.desktop/ > > > java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) > > at java.desktop/ > > > java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) > > at java.desktop/ > > java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) > > at java.desktop/ > > java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) > > at java.desktop/ > > java.awt.EventDispatchThread.run(EventDispatchThread.java:90) 11 in get > > this trying to export > > > > > > > > > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
|
From: Gerd W. <ger...@t-...> - 2025-05-24 19:20:13
|
Sorry, I cannot reproduce your problem. But your stacktrace allowed me to guess what went wrong and I implemented a fix. The fix will be available in future snapshots and versions. Gerd On 20.05.25 11:53, Hector fernandez wrote: > Hi team in 4.8 on WindowsRegistrado por > net.sourceforge.squirrel_sql.client.Main el 20/5/25, 6:50: > > Exception occurred dispatching Event > java.awt.event.MouseEvent[MOUSE_RELEASED, > (32,442),absolute(607,571),button=1,modifiers=Button1,clickCount=1] on win2 > > java.lang.NullPointerException: Cannot invoke "String.equals(Object)" > because "newItem" is null > at > net.sourceforge.squirrel_sql.fw.gui.EditableComboBoxHandler.addOrReplaceCurrentItem(EditableComboBoxHandler.java:73) > at > net.sourceforge.squirrel_sql.fw.gui.action.fileexport.ExportController.initData(ExportController.java:492) > at > net.sourceforge.squirrel_sql.fw.gui.action.fileexport.ExportController.<init>(ExportController.java:50) > at > net.sourceforge.squirrel_sql.fw.gui.action.fileexport.TableExport.<init>(TableExport.java:20) > at > net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ExportAction.actionPerformed(TablePopupMenu.java:490) > at java.desktop/ > javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) > at java.desktop/ > javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2314) > at java.desktop/ > javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:407) > at java.desktop/ > javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) > at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374) > at java.desktop/ > javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1029) > at java.desktop/ > javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1073) > at java.desktop/java.awt.Component.processMouseEvent(Component.java:6621) > at java.desktop/ > javax.swing.JComponent.processMouseEvent(JComponent.java:3398) > at java.desktop/java.awt.Component.processEvent(Component.java:6386) > at java.desktop/java.awt.Container.processEvent(Container.java:2266) > at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4996) > at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) > at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828) > at java.desktop/ > java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) > at java.desktop/ > java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) > at java.desktop/ > java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) > at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) > at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) > at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828) > at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:775) > at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:720) > at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:714) > at java.base/ > java.security.AccessController.doPrivileged(AccessController.java:400) > at java.base/ > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:87) > at java.base/ > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:98) > at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:747) > at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745) > at java.base/ > java.security.AccessController.doPrivileged(AccessController.java:400) > at java.base/ > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:87) > at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:744) > at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:101) > at java.desktop/ > java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) > at java.desktop/ > java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) > at java.desktop/ > java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) > at java.desktop/ > java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) > at java.desktop/ > java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) > at java.desktop/ > java.awt.EventDispatchThread.run(EventDispatchThread.java:90) 11 in get > this trying to export > > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Hector f. <hec...@gm...> - 2025-05-20 09:53:37
|
Hi team in 4.8 on WindowsRegistrado por net.sourceforge.squirrel_sql.client.Main el 20/5/25, 6:50: Exception occurred dispatching Event java.awt.event.MouseEvent[ MOUSE_RELEASED,(32,442),absolute(607,571),button=1, modifiers=Button1,clickCount=1] on win2 java.lang.NullPointerException: Cannot invoke "String.equals(Object)" because "newItem" is null at net.sourceforge.squirrel_sql.fw.gui.EditableComboBoxHandler. addOrReplaceCurrentItem(EditableComboBoxHandler.java:73) at net.sourceforge.squirrel_sql.fw.gui.action.fileexport. ExportController.initData(ExportController.java:492) at net.sourceforge.squirrel_sql.fw.gui.action.fileexport. ExportController.<init>(ExportController.java:50) at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.TableExport.<init>( TableExport.java:20) at net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ ExportAction.actionPerformed(TablePopupMenu.java:490) at java.desktop/javax.swing.AbstractButton.fireActionPerformed( AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed( AbstractButton.java:2314) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed( DefaultButtonModel.java:407) at java.desktop/javax.swing.DefaultButtonModel.setPressed( DefaultButtonModel.java:262) at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374) at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI.doClick( BasicMenuItemUI.java:1029) at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Handler. mouseReleased(BasicMenuItemUI.java:1073) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6621) at java.desktop/javax.swing.JComponent.processMouseEvent( JComponent.java:3398) at java.desktop/java.awt.Component.processEvent(Component.java:6386) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4996) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container. java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container. java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java: 4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:775) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:720) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:714) at java.base/java.security.AccessController.doPrivileged( AccessController.java:400) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl. doIntersectionPrivilege(ProtectionDomain.java:87) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl. doIntersectionPrivilege(ProtectionDomain.java:98) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:747) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745) at java.base/java.security.AccessController.doPrivileged( AccessController.java:400) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl. doIntersectionPrivilege(ProtectionDomain.java:87) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:744) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:101) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters( EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter( EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy( EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents( EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents( EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run( EventDispatchThread.java:90) 11 in get this trying to export |
|
From: Gerd W. <ger...@t-...> - 2025-05-04 18:38:07
|
On 11.03.25 02:53, info wrote: > Is there a possibility this toolbar could be wrapped around the purple > line, in future releases? > Now, it is practically useless, beyond the line, because seldom there is > space on the monitor to expand the panel enough. > The following was implemented and will be available in future snapshots and versions: Excerpt from change log: Option to warp the Aliases' toolbar to two lines: A new toggle button (or checked menu item) in the Aliases toolbar, Aliases menu, or Aliases right-click menu allows users to switch the Aliases toolbar between one or two lines. Gerd |
|
From: Roger H. <rh...@hi...> - 2025-04-08 22:04:41
|
Hi Gerd I solved this by reverting to openjdk-17. openjdk-21 and -24 both had the array issue. Regards Roger On 16/03/2025 16:56, Roger Hill wrote: > Hi Gerd > > > Attaching as a gzipped file now. > > > Roger > > On 16/03/2025 16:10, Gerd Wagner wrote: >> >> >> On 06.03.25 20:04, Roger Hill wrote: >>> Hi >>> >>> >>> I am getting the following error: >>> >>> >>> hillr@pineapple:~/Downloads$ java --version >>> openjdk 21.0.6 2025-01-21 >>> OpenJDK Runtime Environment (build 21.0.6+7-Ubuntu-124.10.1) >>> OpenJDK 64-Bit Server VM (build 21.0.6+7-Ubuntu-124.10.1, mixed >>> mode, sharing) >>> hillr@pineapple:~/Downloads$ whereis java >>> java: /usr/bin/java /etc/java /usr/share/java >>> /usr/share/man/man1/java.1.gz >>> hillr@pineapple:~/Downloads$ */usr/bin/java -jar squirrel-sql-4.8.0- >>> standard.jar >>> Command line arguments: >>> SEVERE: java.lang.ArrayIndexOutOfBoundsException: Index 70131 out of >>> bounds for length 22674* >>> hillr@pineapple:~/Downloads$ >>> >> >> Sorry, I can't reproduce your problem. Does your error message >> contain a stack trace? >> >> Gerd > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Gerd W. <ger...@t-...> - 2025-04-06 19:09:10
|
On 02.04.25 19:50, info wrote: > There is now one more driver that does not list its classes: SAP ASE > jconn42.jar: > If you could post a link where I could download the driver or send me the driver I'd try to reproduce and fix the problem. Gerd |
|
From: Roger H. <rh...@hi...> - 2025-04-06 19:00:07
|
Ok thanks Gerd. Roger Get BlueMail for Android On 6 Apr 2025, 14:23, at 14:23, Gerd Wagner <ger...@t-...> wrote: > > >On 16.03.25 21:56, Roger Hill wrote: >> Hi Gerd >> >> >> Attaching as a gzipped file now. >> >> >The last lines of your gzipped file are: > > > >> [0.339s][info][class,load] >jdk.internal.module.SystemModuleFinders$SystemModuleReader$$Lambda/0x00007794880d1220 >source: jdk.internal.module.SystemModuleFinders >> SEVERE: java.lang.ArrayIndexOutOfBoundsException: Index 70131 out of >bounds for length 22674 >> [0.340s][info][class,load] >java.util.IdentityHashMap$IdentityHashMapIterator source: shared >objects file >> [0.340s][info][class,load] java.util.IdentityHashMap$KeyIterator >source: shared objects file >> > >These point to an internal problem of your Java version. You might try >to reinstall Java or use a JDK from here: >https://adoptium.net/temurin/releases/ > >Gerd |
|
From: Gerd W. <ger...@t-...> - 2025-04-06 18:43:14
|
On 17.03.25 02:42, Fergus, Chris wrote: > Hi Gerd, > > Thank you for your reply. > > You stated " The help file was update and adjusted to the new Driver > dialog. " and then qualify it with "The change will be available in > future snapshots and versions." > > In what snapshot/version will the updated Help file be available? > It's available in the latest snapshot. Here are the download links: https://github.com/squirrel-sql-client/squirrel-sql-snapshot-releases/releases/tag/snapshot-20250316_2114 or https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20250316_2114/ > Regarding the location of the driver that I am trying to add, I > first tried it by adding it from its default location: > > C:\connx32\connxjdbc\java\jar\connxjdbc.jar > > But the result was the exact same error that I received in the my > last screen shot (Could not find class com.connx.jdbc.driver in > neither the Java class path nor the Extra class path of the > connx_jdbc driver definition: java.lang.ClassNotFoundException: > com.connx.jdbc.driver" > Sorry, I'd have tried to reproduce your problem but I couldn't find a place to download it. If you know a download link or can send me the driver jar I'd take a look at it. Another thing you could try is using the driver class name com.Connx.jdbc.TCJdbc.TCJdbcDriver as documented here: https://www.connx.com/products/connx/CONNX%2014.6%20InstallGuide/connxinstall/connecting_to_connx_jdbc_server.htm If you know a bit of Java you may also try to reproduce your problem using the line of Java code given in the this link. Gerd |
|
From: Gerd W. <ger...@t-...> - 2025-04-06 18:24:12
|
On 16.03.25 21:56, Roger Hill wrote: > Hi Gerd > > > Attaching as a gzipped file now. > > The last lines of your gzipped file are: > > [0.339s][info][class,load] jdk.internal.module.SystemModuleFinders$SystemModuleReader$$Lambda/0x00007794880d1220 source: jdk.internal.module.SystemModuleFinders > SEVERE: java.lang.ArrayIndexOutOfBoundsException: Index 70131 out of bounds for length 22674 > [0.340s][info][class,load] java.util.IdentityHashMap$IdentityHashMapIterator source: shared objects file > [0.340s][info][class,load] java.util.IdentityHashMap$KeyIterator source: shared objects file > These point to an internal problem of your Java version. You might try to reinstall Java or use a JDK from here: https://adoptium.net/temurin/releases/ Gerd |
|
From: info <in...@dr...> - 2025-04-04 12:27:41
|
Sorry, it did not occur to me that db2admin might not have select permissions on tables in the SAMPLE DB but still see that they exist. Once the permission was granted, everything worked. On 2025-04-03 11:01 AM, info wrote: > Not able to see contents of DB2 tables. > > In Windows SQuirreL SQL Client Version 4.6.0 with DB2 plugin 0.05: > > > > In Linux SQuirreL SQL Client Version 3.9.1 with DB2 plugin 0.05: > > > > |
|
From: info <in...@dr...> - 2025-04-03 15:02:15
|
Not able to see contents of DB2 tables. In Windows SQuirreL SQL Client Version 4.6.0 with DB2 plugin 0.05: In Linux SQuirreL SQL Client Version 3.9.1 with DB2 plugin 0.05: |
|
From: info <in...@dr...> - 2025-04-02 17:51:30
|
There is now one more driver that does not list its classes: SAP ASE jconn42.jar: On 2025-03-02 06:36 PM, info wrote: > Interestingly, Intercient JAR does not have this issue: > > But it does not allow me to connect either. Regardless of [relaxed] > server settings, > > > > On 2025-03-02 05:56 PM, info wrote: >> That was 3.9.1 under Linux. I built a Windows machine and tried 4.6.0 >> on it, but it is doing the same thing: >> >> Meanwhile, MySQL driver does not exhibit the same issue: >> >> >> On 2025-03-02 02:47 PM, info wrote: >>> Trying to connect to Firebird, I downloaded one after another all of >>> these drivers, but none of them lists: >>> >>> Other JDBC drivers such as MySQL, Oracle Thin, SQLite, etc have no >>> problem listing the class. Why is Firebird different? >>> >>> Regards >>> Al >> >> > |
