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: Federico B. <fe...@in...> - 2018-05-03 16:52:14
|
Ciao Luca
I've not tested it, but perhaps you can simply copy the file
~/.squirrel-sql/SQLDrivers.xml from your working installation to a new
installation.
For example, in that file I found the driver I manually installed:
<Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
<driverClassName>com.ibm.db2.jcc.DB2Driver</driverClassName>
<identifier
Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
<string>-ac8177c:159219c8c71:-7f81</string>
</identifier>
<jarFileName/>
<jarFileNames Indexed="true">
<Bean
Class="net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper">
<string>/home/fede/Documenti/query/jdbc-driver/db2jcc.jar</string>
</Bean>
<Bean
Class="net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper">
<string>/home/fede/Documenti/query/jdbc-driver/db2jcc_license_cu.jar</string>
</Bean>
</jarFileNames>
<name>DB2 Driver</name>
<url>jdbc:db2://10.0.20.1:50000/DB_020</url>
<websiteUrl/>
</Bean>
Il giorno gio 3 mag 2018 alle 9:33, Luca Vercelli
<"luca.vercelli.to"@gmail.com> ha scritto:
> Maybe, there is some function in the program that allows importing
> all drivers for some given folder?
>
>
>
> Il 02/05/2018 09:27, Luca Vercelli ha scritto:
>> Hello everybody,
>>
>> this is the first time I try to use SQuirreL SQL Client.
>>
>> My first issue is: what is the intended way to download and install
>> all JDBC drivers? Do I really need to download them manually one by
>> one?
>>
>> The suggested link
>> http://industry.java.sun.com/products/jdbc/drivers does not work.
>>
>> If so, this is really a great limitation, as compared to other free
>> products as DbVisualizer.
>>
>> I imagine it shouldn't be difficult to develop a plugin that
>> downloads the drivers.
>>
>>
>> Thank you
>>
>> Luca
>>
>>
>>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
|
From: Alex M. <ale...@bl...> - 2018-05-03 16:01:52
|
There is very little traffic here as of lately, almost none from the dev side. Realistically, how many drivers and how often do you install? If you work with 2-3 DB backends simultaneously like I do, that's probably tops. Most only ever work with one. Once you installed Squirrel, downloading drivers from the respective project sites should not be such a hassle. Much less than for the SQ dev team to keep track of all the JDBC driver web sites out there. -----Original Message----- From: Luca Vercelli <luc...@gm...> Sent: Thursday, May 03, 2018 3:34 AM To: squ...@li... Subject: Re: [Squirrel-sql-users] [newbie] about downloading drivers Maybe, there is some function in the program that allows importing all drivers for some given folder? Il 02/05/2018 09:27, Luca Vercelli ha scritto: > Hello everybody, > > this is the first time I try to use SQuirreL SQL Client. > > My first issue is: what is the intended way to download and install > all JDBC drivers? Do I really need to download them manually one by one? > > The suggested link http://industry.java.sun.com/products/jdbc/drivers > does not work. > > If so, this is really a great limitation, as compared to other free > products as DbVisualizer. > > I imagine it shouldn't be difficult to develop a plugin that downloads > the drivers. > > > Thank you > > Luca > > > ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Luca V. <luc...@gm...> - 2018-05-03 07:34:07
|
Maybe, there is some function in the program that allows importing all drivers for some given folder? Il 02/05/2018 09:27, Luca Vercelli ha scritto: > Hello everybody, > > this is the first time I try to use SQuirreL SQL Client. > > My first issue is: what is the intended way to download and install > all JDBC drivers? Do I really need to download them manually one by one? > > The suggested link http://industry.java.sun.com/products/jdbc/drivers > does not work. > > If so, this is really a great limitation, as compared to other free > products as DbVisualizer. > > I imagine it shouldn't be difficult to develop a plugin that downloads > the drivers. > > > Thank you > > Luca > > > |
|
From: Luca V. <luc...@gm...> - 2018-05-02 07:27:28
|
Hello everybody, this is the first time I try to use SQuirreL SQL Client. My first issue is: what is the intended way to download and install all JDBC drivers? Do I really need to download them manually one by one? The suggested link http://industry.java.sun.com/products/jdbc/drivers does not work. If so, this is really a great limitation, as compared to other free products as DbVisualizer. I imagine it shouldn't be difficult to develop a plugin that downloads the drivers. Thank you Luca |
|
From: Alex M. <ale...@bl...> - 2018-04-25 18:54:59
|
When looking at Objects tab/Content tab (a table data view), columns are pretty wide for the most part. At least looks like varchar columns are. Would developers please consider iterating column objects and performing the column separator double-click action for each, after the table is displayed, as if a user double-clicked each to resize manually? I am on 3.7.1 if it matters. Apologies if this is not the right place - I could not remember if feature requests had to be filed elsewhere! This approach may benefit many other tables around Squirrel, so maybe add this to the base table class? Thank you Alex |
|
From: <w4...@on...> - 2018-04-24 18:07:03
|
Hi everyone, I am connecting to a postgresql database (version 10) over the network using the new jdbc driver (42.2.2). The DB's character set is LATIN1, my system is UTF8, both machines run debian stable. I don't manage to display the characters correctly when running a select on the database (squirrelsql result shows "für" instead of "für" for example). I did not find any option to specify the character set, moreover, the driver specification says that it's not necessary anymore. For years all worked fine with an oracle database (latin1) and the oracle driver, but lately we switched to postgres and now I cannot use squirrelsql anymore (pg4admin and psql-client display the characters correctly). Does anyone has an idea what I am missing? Thanks, Peter |
|
From: George H. <hu...@us...> - 2018-04-10 11:15:14
|
Alex - The Java version is 1.8.0_162
George Hudson in lovely BTV
E-Mail : hu...@us...
Phone : 769-2640
Technology Software Engineering
From: Alex Malmyguine <ale...@bl...>
To: George Hudson <hu...@us...>,
"squ...@li..."
<squ...@li...>
Date: 04/09/2018 04:01 PM
Subject: RE: [Squirrel-sql-users] Unsupported DH key size
What is your JDK version?
From: George Hudson <hu...@us...>
Sent: Monday, April 09, 2018 1:08 PM
To: squ...@li...
Subject: [Squirrel-sql-users] Unsupported DH key size
Folks - I have been having issues connecting to certain server/DB2 data
bases. After looking in this group I found an entry that suggested to add
the following to the URL entry:
:securityMechanism=13;
I now get the following error. Has someone else seen this?
Error:
Unexpected Error occurred attempting to open an SQL connection.
class java.security.InvalidAlgorithmParameterException: DH key size must
be multiple of 64, and can only range from 512 to 8192 (inclusive). The
specific key size 256 is not supported
Stack Trace:
java.security.InvalidAlgorithmParameterException: DH key size must be
multiple of 64, and can only range from 512 to 8192 (inclusive). The
specific key size 256 is not supported
at
com.sun.crypto.provider.DHKeyPairGenerator.initialize(DHKeyPairGenerator.java:139)
at java.security.KeyPairGenerator$Delegate.initialize(Unknown
Source)
at java.security.KeyPairGenerator.initialize(Unknown Source)
at com.ibm.db2.jcc.am.uc.a(uc.java:141)
at com.ibm.db2.jcc.t4.b.ud(b.java:2741)
at com.ibm.db2.jcc.t4.b.b(b.java:818)
at com.ibm.db2.jcc.t4.b.c(b.java:758)
at com.ibm.db2.jcc.t4.b.a(b.java:421)
at com.ibm.db2.jcc.t4.b.a(b.java:396)
at com.ibm.db2.jcc.t4.b.<init>(b.java:334)
at
com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:231)
at
com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:197)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:472)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:113)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.lang.Thread.run(Unknown Source)
George Hudson in lovely BTV
E-Mail : hu...@us...
Phone : 769-2640
Technology Software Engineering
|
|
From: George H. <hu...@us...> - 2018-04-09 17:08:06
|
Folks - I have been having issues connecting to certain server/DB2 data
bases. After looking in this group I found an entry that suggested to add
the following to the URL entry:
:securityMechanism=13;
I now get the following error. Has someone else seen this?
Error:
Unexpected Error occurred attempting to open an SQL connection.
class java.security.InvalidAlgorithmParameterException: DH key size must
be multiple of 64, and can only range from 512 to 8192 (inclusive). The
specific key size 256 is not supported
Stack Trace:
java.security.InvalidAlgorithmParameterException: DH key size must be
multiple of 64, and can only range from 512 to 8192 (inclusive). The
specific key size 256 is not supported
at
com.sun.crypto.provider.DHKeyPairGenerator.initialize(DHKeyPairGenerator.java:139)
at java.security.KeyPairGenerator$Delegate.initialize(Unknown
Source)
at java.security.KeyPairGenerator.initialize(Unknown Source)
at com.ibm.db2.jcc.am.uc.a(uc.java:141)
at com.ibm.db2.jcc.t4.b.ud(b.java:2741)
at com.ibm.db2.jcc.t4.b.b(b.java:818)
at com.ibm.db2.jcc.t4.b.c(b.java:758)
at com.ibm.db2.jcc.t4.b.a(b.java:421)
at com.ibm.db2.jcc.t4.b.a(b.java:396)
at com.ibm.db2.jcc.t4.b.<init>(b.java:334)
at
com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:231)
at
com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:197)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:472)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:113)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.lang.Thread.run(Unknown Source)
George Hudson in lovely BTV
E-Mail : hu...@us...
Phone : 769-2640
Technology Software Engineering
|
|
From: Roger H. <rh...@hi...> - 2018-04-06 06:44:10
|
Hi guys.
On Lubuntu 17.10.
Installing latest snapshot, the installation falls over when I try to
tick the selection box for any optional plugin. I think this has been
reported before, but not sure about which release it was.
Regards
Roger
rhill@lime4:~/Downloads$ java -jar
squirrel-sql-snapshot-20180404_2309-standard.jar
** (java:20725): WARNING **: Couldn't connect to accessibility bus:
Failed to connect to socket /tmp/dbus-jRukgNct4J: Connection refused
Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException
at
com.izforge.izpack.panels.PacksPanelBase$CheckBoxRenderer.getTableCellRendererComponent(Unknown
Source)
at
javax.swing.JTable$AccessibleJTable.getAccessibleChild(JTable.java:7031)
at
javax.swing.JTable$AccessibleJTable.getAccessibleAt(JTable.java:7418)
at
javax.swing.JTable$AccessibleJTable.valueChanged(JTable.java:6933)
at
javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:184)
at
javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:164)
at
javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:211)
at
javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:405)
at
javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:415)
at
javax.swing.DefaultListSelectionModel.setSelectionInterval(DefaultListSelectionModel.java:459)
at javax.swing.JTable.changeSelectionModel(JTable.java:2389)
at javax.swing.JTable.changeSelection(JTable.java:2456)
at
javax.swing.plaf.basic.BasicTableUI$Handler.adjustSelection(BasicTableUI.java:1115)
at
javax.swing.plaf.basic.BasicTableUI$Handler.mousePressed(BasicTableUI.java:1038)
at
java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:280)
at
java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:279)
at java.awt.Component.processMouseEvent(Component.java:6530)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2237)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2295)
at java.awt.Component.dispatchEvent(Component.java:4711)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4889)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:4523)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4467)
at java.awt.Container.dispatchEventImpl(Container.java:2281)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
at
org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
---
***************************
Roger Hill
*************************** |
|
From: Laura M. <lj...@nt...> - 2018-04-03 15:27:02
|
NTAC:3NS-20
My apologies for the formatting of my original posts.
Here's the details from the error log:
2018-04-03 09:41:23,385 [AWT-EventQueue-1] DEBUG net.sourceforge.squirrel_sql.plugins.sqlreplace.SQLReplacePlugin - statementExecuting: original SQL = call ntsdb.db2sp2('DSNDB06');
2018-04-03 09:41:23,385 [AWT-EventQueue-1] DEBUG net.sourceforge.squirrel_sql.plugins.sqlreplace.SQLReplacePlugin - statementExecuting: replacedStmnt = call ntsdb.db2sp2('DSNDB06');
2018-04-03 09:41:23,385 [AWT-EventQueue-1] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Reusing existing thread
2018-04-03 09:41:23,385 [Thread-3] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Using a thread. 2 threads available
2018-04-03 09:41:23,431 [Thread-3] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Returning thread. 3 threads available
|
|
From: Laura M. <lj...@nt...> - 2018-04-03 14:51:55
|
When calling the following DB2 z/OS stored procedure: call ntsdb.db2sp2('DSNDB06');
I receive the following error message: ExampleExceptionFormatter: exception message was: [jcc][10413][10940][3.71.22] Literal replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text call ntsdb.db2sp2('DSNDB06'). ERRORCODE=-4463, SQLSTATE=42601
Error occurred in:
call ntsdb.db2sp2('DSNDB06')
I am able to successfully call a stored procedure which does not require parameters.
I am also able to successfully execute the call the ntsdb.db2sp2('DSNDB06') using IBM Data Studio.
Thanks for any help you can provide.
I am out of the office on Friday.
[cid:image002.png@01D156AA.2CA49E30]<https://www.northerntrust.com/>
Laura J. Moravek, Vice President, Global Database Platforms (GDP) - DB2/IMS
50 S. LaSalle Street, LQ 11, Chicago , Illinois 60603 USA
312 444-3990 | lj...@nt...<mailto:lj...@nt...>
_______________________________________________________________________________
CONFIDENTIALITY NOTICE: This communication is confidential, may be privileged and is meant only for the intended recipient. If you are not the intended recipient, please notify the sender ASAP and delete this message from your system. NTAC:3NS-20
P Please consider the environment before printing this email.
|
|
From: Laura M. <lj...@nt...> - 2018-04-03 14:44:51
|
I changed the log4j.rootlogger to debug and see the following in the log: [cid:image002.png@01D3CB30.5B382030] I am out of the office on Friday. [cid:image002.png@01D156AA.2CA49E30]<https://www.northerntrust.com/> Laura J. Moravek, Vice President, Global Database Platforms (GDP) - DB2/IMS 50 S. LaSalle Street, LQ 11, Chicago , Illinois 60603 USA 312 444-3990 | lj...@nt...<mailto:lj...@nt...> _______________________________________________________________________________ CONFIDENTIALITY NOTICE: This communication is confidential, may be privileged and is meant only for the intended recipient. If you are not the intended recipient, please notify the sender ASAP and delete this message from your system. NTAC:3NS-20 P Please consider the environment before printing this email. From: Laura Moravek Sent: Tuesday, April 03, 2018 9:25 AM To: 'squ...@li...' Subject: DB2 z/OS stored procedure - error when calling using parameters When calling the following DB2 z/OS stored procedure: call ntsdb.db2sp2('DSNDB06'); I receive the following error message: ExampleExceptionFormatter: exception message was: [jcc][10413][10940][3.71.22] Literal replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text call ntsdb.db2sp2('DSNDB06'). ERRORCODE=-4463, SQLSTATE=42601 Error occurred in: call ntsdb.db2sp2('DSNDB06') I am able to successfully call a stored procedure which does not require parameters. I am also able to successfully execute the call the ntsdb.db2sp2('DSNDB06') using IBM Data Studio. Thanks for any help you can provide. I am out of the office on Friday. [cid:image002.png@01D156AA.2CA49E30]<https://www.northerntrust.com/> Laura J. Moravek, Vice President, Global Database Platforms (GDP) - DB2/IMS 50 S. LaSalle Street, LQ 11, Chicago , Illinois 60603 USA 312 444-3990 | lj...@nt...<mailto:lj...@nt...> _______________________________________________________________________________ CONFIDENTIALITY NOTICE: This communication is confidential, may be privileged and is meant only for the intended recipient. If you are not the intended recipient, please notify the sender ASAP and delete this message from your system. NTAC:3NS-20 P Please consider the environment before printing this email. |
|
From: Rasmus W. <ras...@gm...> - 2018-03-12 14:08:56
|
Hi No, it doesn't really explain. While I do understand that any client can create locks, I don't understand his claim that Squirrel creates far more locks than AQT does, and that it's a JDBC vs ODBC thing. I use Squirrel in exactly the same way as the AQT users use AQT. 2018-03-12 14:22 GMT+01:00 Tsuei, Jack C. <jt...@dt...>: > Squirrel and AQT or any client tools are using dynamic SQL (rather than > COBOL on the mainframe that uses static SQL). SPUFI on the mainframe is > using dynamic SQL too. > > > > Your DBA is 100% right. These tools will lock database catalog and > directory. You should not leave your desk and go take coffee for 20 minutes > after you received your SQL result set since it will still hold up locks. > > > > Even you have share lock it will still impact process that needs exclusive > locks. > > > > Hope this helps to explain. > > > > > > > > DTCC Public (White) > > *From:* Rasmus Wiman [mailto:ras...@gm...] > *Sent:* Monday, March 12, 2018 7:17 AM > *To:* squ...@li... > *Subject:* [Squirrel-sql-users] Squirrel locks DB2? > > > > ATTENTION! This email originated outside of DTCC; exercise caution. > > Hi, everyone. > > Our DBA dislikes that I use Squirrel-SQL. He says that it creates locks in > the db. I don't understand this, it's extremely rare that I forget to > commit (we are not allowed to use autocommit, regardless of what client we > use) a transaction. We use DB2 and I connect to the databases using the IBM > DB2 Net driver. I don't do anything people using other clients (AQT is > popular here) don't do. > > How can I stop these locks from occurring? According to the DBA it's a > generic JDBC issue that has no solution, is he right? > > Thanks, > > Rasmus > > DTCC DISCLAIMER: This email and any files transmitted with it are > confidential and intended solely for the use of the individual or entity to > whom they are addressed. If you have received this email in error, please > notify us immediately and delete the email and any attachments from your > system. The recipient should check this email and any attachments for the > presence of viruses. The company accepts no liability for any damage > caused by any virus transmitted by this email. > |
|
From: Tsuei, J. C. <jt...@dt...> - 2018-03-12 13:22:33
|
Squirrel and AQT or any client tools are using dynamic SQL (rather than COBOL on the mainframe that uses static SQL). SPUFI on the mainframe is using dynamic SQL too. Your DBA is 100% right. These tools will lock database catalog and directory. You should not leave your desk and go take coffee for 20 minutes after you received your SQL result set since it will still hold up locks. Even you have share lock it will still impact process that needs exclusive locks. Hope this helps to explain. DTCC Public (White) From: Rasmus Wiman [mailto:ras...@gm...] Sent: Monday, March 12, 2018 7:17 AM To: squ...@li... Subject: [Squirrel-sql-users] Squirrel locks DB2? ATTENTION! This email originated outside of DTCC; exercise caution. Hi, everyone. Our DBA dislikes that I use Squirrel-SQL. He says that it creates locks in the db. I don't understand this, it's extremely rare that I forget to commit (we are not allowed to use autocommit, regardless of what client we use) a transaction. We use DB2 and I connect to the databases using the IBM DB2 Net driver. I don't do anything people using other clients (AQT is popular here) don't do. How can I stop these locks from occurring? According to the DBA it's a generic JDBC issue that has no solution, is he right? Thanks, Rasmus DTCC DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify us immediately and delete the email and any attachments from your system. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. |
|
From: Rasmus W. <ras...@gm...> - 2018-03-12 11:16:51
|
Hi, everyone. Our DBA dislikes that I use Squirrel-SQL. He says that it creates locks in the db. I don't understand this, it's extremely rare that I forget to commit (we are not allowed to use autocommit, regardless of what client we use) a transaction. We use DB2 and I connect to the databases using the IBM DB2 Net driver. I don't do anything people using other clients (AQT is popular here) don't do. How can I stop these locks from occurring? According to the DBA it's a generic JDBC issue that has no solution, is he right? Thanks, Rasmus |
|
From: <squ...@ne...> - 2018-02-19 19:13:39
|
Hello, I have a small Oracle XE Database. When I connect to it, it takes a very long time, until the metadata is loaded. When I open a schema in the Objects-Tree it takes at least a minute, until it opens. In the Alias Properties I already set most of the schemas to "Don't load and only two schemas to "load and cache". Caching doesn't seam to improve anything, though. Is this a know issue? Because Squirrel is barely usable this way. Other tool don't take this long to load. Greetings, Malte |
|
From: Roger H. <rh...@hi...> - 2018-01-21 14:39:37
|
Hi Matt: Just found this: it's not only me! https://sourceforge.net/p/squirrel-sql/bugs/1328/ Roger --- *************************** Roger Hill *************************** On 2018-01-21 14:29, Roger Hill wrote: > Hi Matt. > > I'm using Lubuntu 17.10 > > I think it may be specific to me. I 've tried the 3.8.1 standard jar, the current snapshot jar, and also the 3.7 standard jar from my last install (which worked ok last time, but on a different machine - see below). > > I sort of feel that I am missing one of the Ubuntu packages, but my problem is which one! > > Some more background - my home dir (which included the 3.7 jar) was copied from another disk when I moved machines to the NUC recently. The system was a fresh install on this machine though...so that reinforces my suspicion that I'm missing a package. > > And the fact that not one of the three jars I've tried has worked points me to a machine specific problem, not the software. > > Roger > > --- > *************************** > Roger Hill > *************************** > > On 2018-01-21 13:39, Matt F wrote: > >> Sounds like either a corrupt download or incorrect download. >> >> What OS Are you running on the NUC? >> What download did you grab? >> >> ============================================== >> Matt Ferreira >> de...@ya... >> >> On Sunday, January 21, 2018, 3:10:43 AM EST, Roger Hill <rh...@hi...> wrote: >> >> Hi. >> >> I'm trying to install 3.8.1. When I run the command java -jar >> squirrel....jar, it starts up ok, but when it displays the list of >> plugins to be selected, each time I try to click a plugin to select it, >> I get this error trace: >> >> Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException >> at >> com.izforge.izpack.panels.PacksPanelBase$CheckBoxRenderer.getTableCellRendererComponent(Unknown >> Source) >> at >> javax.swing.JTable$AccessibleJTable.getAccessibleChild(JTable.java:7031) >> at >> javax.swing.JTable$AccessibleJTable.getAccessibleAt(JTable.java:7418) >> at javax.swing.JTable$AccessibleJTable.valueChanged(JTable.java:6933) >> at >> javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:184) >> at >> javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:164) >> at >> javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:211) >> at >> javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:405) >> at >> javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:415) >> at >> javax.swing.DefaultListSelectionModel.removeSelectionIntervalImpl(DefaultListSelectionModel.java:576) >> at >> javax.swing.DefaultListSelectionModel.clearSelection(DefaultListSelectionModel.java:420) >> at javax.swing.JTable.clearSelection(JTable.java:2117) >> at javax.swing.JTable.clearSelectionAndLeadAnchor(JTable.java:2125) >> at javax.swing.JTable.tableChanged(JTable.java:4445) >> at >> javax.swing.table.AbstractTableModel.fireTableChanged(AbstractTableModel.java:296) >> at >> javax.swing.table.AbstractTableModel.fireTableDataChanged(AbstractTableModel.java:198) >> at com.izforge.izpack.panels.PacksModel.setValueAt(Unknown Source) >> at com.izforge.izpack.panels.PacksPanelBase$1.mouseClicked(Unknown >> Source) >> at >> java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:270) >> at java.awt.Component.processMouseEvent(Component.java:6536) >> at javax.swing.JComponent.processMouseEvent(JComponent.java:3324) >> at java.awt.Component.processEvent(Component.java:6298) >> at java.awt.Container.processEvent(Container.java:2236) >> at java.awt.Component.dispatchEventImpl(Component.java:4889) >> at java.awt.Container.dispatchEventImpl(Container.java:2294) >> at java.awt.Component.dispatchEvent(Component.java:4711) >> at >> java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888) >> at >> java.awt.LightweightDispatcher.processMouseEvent(Container.java:4534) >> at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466) >> at java.awt.Container.dispatchEventImpl(Container.java:2280) >> at java.awt.Window.dispatchEventImpl(Window.java:2746) >> at java.awt.Component.dispatchEvent(Component.java:4711) >> at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758) >> at java.awt.EventQueue.access$500(EventQueue.java:97) >> at java.awt.EventQueue$3.run(EventQueue.java:709) >> at java.awt.EventQueue$3.run(EventQueue.java:703) >> at java.security.AccessController.doPrivileged(Native Method) >> at >> java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) >> at >> java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90) >> at java.awt.EventQueue$4.run(EventQueue.java:731) >> at java.awt.EventQueue$4.run(EventQueue.java:729) >> at java.security.AccessController.doPrivileged(Native Method) >> at >> java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) >> at java.awt.EventQueue.dispatchEvent(EventQueue.java:728) >> at >> org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700) >> at >> java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) >> at >> java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) >> at >> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) >> at >> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) >> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) >> at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) >> >> java -version gives me: >> rhill@lime4:~$ java -version >> openjdk version "1.8.0_151" >> OpenJDK Runtime Environment (build >> 1.8.0_151-8u151-b12-0ubuntu0.17.10.2-b12) >> OpenJDK 64-Bit Server >> >> I have en installing Squirrel for years: this is the first time I've had >> a problem (on a new Intel NUC, if that matters). >> >> Thanks >> Roger >> --- >> *************************** >> Roger Hill >> *************************** >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Roger H. <rh...@hi...> - 2018-01-21 14:29:18
|
Hi Matt. I'm using Lubuntu 17.10 I think it may be specific to me. I 've tried the 3.8.1 standard jar, the current snapshot jar, and also the 3.7 standard jar from my last install (which worked ok last time, but on a different machine - see below). I sort of feel that I am missing one of the Ubuntu packages, but my problem is which one! Some more background - my home dir (which included the 3.7 jar) was copied from another disk when I moved machines to the NUC recently. The system was a fresh install on this machine though...so that reinforces my suspicion that I'm missing a package. And the fact that not one of the three jars I've tried has worked points me to a machine specific problem, not the software. Roger --- *************************** Roger Hill *************************** On 2018-01-21 13:39, Matt F wrote: > Sounds like either a corrupt download or incorrect download. > > What OS Are you running on the NUC? > What download did you grab? > > ============================================== > Matt Ferreira > de...@ya... > > On Sunday, January 21, 2018, 3:10:43 AM EST, Roger Hill <rh...@hi...> wrote: > > Hi. > > I'm trying to install 3.8.1. When I run the command java -jar > squirrel....jar, it starts up ok, but when it displays the list of > plugins to be selected, each time I try to click a plugin to select it, > I get this error trace: > > Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException > at > com.izforge.izpack.panels.PacksPanelBase$CheckBoxRenderer.getTableCellRendererComponent(Unknown > Source) > at > javax.swing.JTable$AccessibleJTable.getAccessibleChild(JTable.java:7031) > at > javax.swing.JTable$AccessibleJTable.getAccessibleAt(JTable.java:7418) > at javax.swing.JTable$AccessibleJTable.valueChanged(JTable.java:6933) > at > javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:184) > at > javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:164) > at > javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:211) > at > javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:405) > at > javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:415) > at > javax.swing.DefaultListSelectionModel.removeSelectionIntervalImpl(DefaultListSelectionModel.java:576) > at > javax.swing.DefaultListSelectionModel.clearSelection(DefaultListSelectionModel.java:420) > at javax.swing.JTable.clearSelection(JTable.java:2117) > at javax.swing.JTable.clearSelectionAndLeadAnchor(JTable.java:2125) > at javax.swing.JTable.tableChanged(JTable.java:4445) > at > javax.swing.table.AbstractTableModel.fireTableChanged(AbstractTableModel.java:296) > at > javax.swing.table.AbstractTableModel.fireTableDataChanged(AbstractTableModel.java:198) > at com.izforge.izpack.panels.PacksModel.setValueAt(Unknown Source) > at com.izforge.izpack.panels.PacksPanelBase$1.mouseClicked(Unknown > Source) > at > java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:270) > at java.awt.Component.processMouseEvent(Component.java:6536) > at javax.swing.JComponent.processMouseEvent(JComponent.java:3324) > at java.awt.Component.processEvent(Component.java:6298) > at java.awt.Container.processEvent(Container.java:2236) > at java.awt.Component.dispatchEventImpl(Component.java:4889) > at java.awt.Container.dispatchEventImpl(Container.java:2294) > at java.awt.Component.dispatchEvent(Component.java:4711) > at > java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888) > at > java.awt.LightweightDispatcher.processMouseEvent(Container.java:4534) > at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466) > at java.awt.Container.dispatchEventImpl(Container.java:2280) > at java.awt.Window.dispatchEventImpl(Window.java:2746) > at java.awt.Component.dispatchEvent(Component.java:4711) > at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758) > at java.awt.EventQueue.access$500(EventQueue.java:97) > at java.awt.EventQueue$3.run(EventQueue.java:709) > at java.awt.EventQueue$3.run(EventQueue.java:703) > at java.security.AccessController.doPrivileged(Native Method) > at > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) > at > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90) > at java.awt.EventQueue$4.run(EventQueue.java:731) > at java.awt.EventQueue$4.run(EventQueue.java:729) > at java.security.AccessController.doPrivileged(Native Method) > at > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) > at java.awt.EventQueue.dispatchEvent(EventQueue.java:728) > at > org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700) > at > java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) > at > java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) > at > java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) > at > java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) > at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) > at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) > > java -version gives me: > rhill@lime4:~$ java -version > openjdk version "1.8.0_151" > OpenJDK Runtime Environment (build > 1.8.0_151-8u151-b12-0ubuntu0.17.10.2-b12) > OpenJDK 64-Bit Server > > I have en installing Squirrel for years: this is the first time I've had > a problem (on a new Intel NUC, if that matters). > > Thanks > Roger > --- > *************************** > Roger Hill > *************************** > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Matt F <de...@ya...> - 2018-01-21 13:45:47
|
Sounds like either a corrupt download or incorrect download.
What OS Are you running on the NUC?What download did you grab?
==============================================Matt Ferreira
de...@ya...
On Sunday, January 21, 2018, 3:10:43 AM EST, Roger Hill <rh...@hi...> wrote:
Hi.
I'm trying to install 3.8.1. When I run the command java -jar
squirrel....jar, it starts up ok, but when it displays the list of
plugins to be selected, each time I try to click a plugin to select it,
I get this error trace:
Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException
at
com.izforge.izpack.panels.PacksPanelBase$CheckBoxRenderer.getTableCellRendererComponent(Unknown
Source)
at
javax.swing.JTable$AccessibleJTable.getAccessibleChild(JTable.java:7031)
at
javax.swing.JTable$AccessibleJTable.getAccessibleAt(JTable.java:7418)
at javax.swing.JTable$AccessibleJTable.valueChanged(JTable.java:6933)
at
javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:184)
at
javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:164)
at
javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:211)
at
javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:405)
at
javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:415)
at
javax.swing.DefaultListSelectionModel.removeSelectionIntervalImpl(DefaultListSelectionModel.java:576)
at
javax.swing.DefaultListSelectionModel.clearSelection(DefaultListSelectionModel.java:420)
at javax.swing.JTable.clearSelection(JTable.java:2117)
at javax.swing.JTable.clearSelectionAndLeadAnchor(JTable.java:2125)
at javax.swing.JTable.tableChanged(JTable.java:4445)
at
javax.swing.table.AbstractTableModel.fireTableChanged(AbstractTableModel.java:296)
at
javax.swing.table.AbstractTableModel.fireTableDataChanged(AbstractTableModel.java:198)
at com.izforge.izpack.panels.PacksModel.setValueAt(Unknown Source)
at com.izforge.izpack.panels.PacksPanelBase$1.mouseClicked(Unknown
Source)
at
java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:270)
at java.awt.Component.processMouseEvent(Component.java:6536)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:4534)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at
org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
java -version gives me:
rhill@lime4:~$ java -version
openjdk version "1.8.0_151"
OpenJDK Runtime Environment (build
1.8.0_151-8u151-b12-0ubuntu0.17.10.2-b12)
OpenJDK 64-Bit Server
I have en installing Squirrel for years: this is the first time I've had
a problem (on a new Intel NUC, if that matters).
Thanks
Roger
---
***************************
Roger Hill
***************************
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
|
From: Roger H. <rh...@hi...> - 2018-01-21 08:09:45
|
Hi. I'm trying to install 3.8.1. When I run the command java -jar squirrel....jar, it starts up ok, but when it displays the list of plugins to be selected, each time I try to click a plugin to select it, I get this error trace: Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException at com.izforge.izpack.panels.PacksPanelBase$CheckBoxRenderer.getTableCellRendererComponent(Unknown Source) at javax.swing.JTable$AccessibleJTable.getAccessibleChild(JTable.java:7031) at javax.swing.JTable$AccessibleJTable.getAccessibleAt(JTable.java:7418) at javax.swing.JTable$AccessibleJTable.valueChanged(JTable.java:6933) at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:184) at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:164) at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:211) at javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:405) at javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:415) at javax.swing.DefaultListSelectionModel.removeSelectionIntervalImpl(DefaultListSelectionModel.java:576) at javax.swing.DefaultListSelectionModel.clearSelection(DefaultListSelectionModel.java:420) at javax.swing.JTable.clearSelection(JTable.java:2117) at javax.swing.JTable.clearSelectionAndLeadAnchor(JTable.java:2125) at javax.swing.JTable.tableChanged(JTable.java:4445) at javax.swing.table.AbstractTableModel.fireTableChanged(AbstractTableModel.java:296) at javax.swing.table.AbstractTableModel.fireTableDataChanged(AbstractTableModel.java:198) at com.izforge.izpack.panels.PacksModel.setValueAt(Unknown Source) at com.izforge.izpack.panels.PacksPanelBase$1.mouseClicked(Unknown Source) at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:270) at java.awt.Component.processMouseEvent(Component.java:6536) at javax.swing.JComponent.processMouseEvent(JComponent.java:3324) at java.awt.Component.processEvent(Component.java:6298) at java.awt.Container.processEvent(Container.java:2236) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2294) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4534) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466) at java.awt.Container.dispatchEventImpl(Container.java:2280) at java.awt.Window.dispatchEventImpl(Window.java:2746) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.awt.EventQueue$4.run(EventQueue.java:729) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) at java.awt.EventQueue.dispatchEvent(EventQueue.java:728) at org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) java -version gives me: rhill@lime4:~$ java -version openjdk version "1.8.0_151" OpenJDK Runtime Environment (build 1.8.0_151-8u151-b12-0ubuntu0.17.10.2-b12) OpenJDK 64-Bit Server I have en installing Squirrel for years: this is the first time I've had a problem (on a new Intel NUC, if that matters). Thanks Roger --- *************************** Roger Hill *************************** |
|
From: Michael <mjc...@ao...> - 2017-11-30 16:59:50
|
On Thu, 30 Nov 2017 14:59:19 +0000 "Huberts, Bert" <ber...@en...> wrote: > Hello support, > > > I used Squirrel to import data in an SQL srv database table and that > worked allright, but is there an option that existing data in a table > will NOT be deleted ? > > Best regards, > > Bert Huberts > Data management - Security / Datalake team > > ENEXIS HOLDING N.V. Ict / Marsweg 5 8013 PD Zwolle > enexisgroep.nl<http://www.enexisgroep.nl/> > [Enexis Groep] > I have used the importer and I do not think that option is available. I use a temporary table and then insert the data into the final destination. It would be nice if that option was available. Mike |
|
From: Huberts, B. <ber...@en...> - 2017-11-30 16:33:05
|
Hello support, I used Squirrel to import data in an SQL srv database table and that worked allright, but is there an option that existing data in a table will NOT be deleted ? Best regards, Bert Huberts Data management - Security / Datalake team ENEXIS HOLDING N.V. Ict / Marsweg 5 8013 PD Zwolle enexisgroep.nl<http://www.enexisgroep.nl/> [Enexis Groep] |
|
From: harish g. <rh_...@ya...> - 2017-11-30 00:00:45
|
Global Preferences option is missing under File menu. I'm using snapshot-20171106_2206 version in MacOS Sierra. Can anyone help? Thanks,Harry |
|
From: Akom, L. <lyn...@op...> - 2017-11-07 22:26:07
|
I am trying to create a new driver for Hive. I am using Java 1.6 with Squirrel 3.3.0. I cannot create a new driver. When I check the log files, I see this error message: "2017-11-07 15:16:53,503 [Thread-6] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$AsyncClient$get_table_column_statistics_call in C:\Users\xxxxxxx\squirrel-sql-3.3.0\JDBC\hive-metastore-2.1.1-mapr-1703.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.UnsupportedClassVersionError: org/apache/hadoop/hive/metastore/api/ThriftHiveMetastore$AsyncClient$get_table_column_statistics_call : Unsupported major.minor version 51.0" Unsupported major.minor version 51.0 refers to Java 1.7 I believe. I can't get hold of Java 1.7. I tried using Java 1.8 in the beginning, but got another compatibility error, which made me switch to Java 1.6. I am in a predicament. Can anyone help? Thanks, Lynne Akom This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. |
|
From: Sangamesh B M <san...@gm...> - 2017-10-26 12:55:42
|
Hi All, To have your *syntax colored* based on the keywords, table names, column names etc, you need to have *SYNTAX* plugin. The way you need to check if you already have the *SYNTAX* plugin, goto *PLUGINS>>SUMMARY>> *you should be able to look at all the available plugin. For all the plugin to work *"Load at Startup"* should be checked/enabled. Possible error is, that your software would be pointing to wrong folder to look into the plugin, if that is the case run the *squirrel-sql.bat *available during your initial software download(generally available next to *"squirrel-sql.jar" *) -- *Regards,* *Sangamesh B M.* ----------------------------------------------- Phone : 031687899629 email : san...@gm... ----------------------------------------------- |
