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. <fed...@gm...> - 2014-09-26 17:09:53
|
Il 26/set/2014 18:29 "Federico Bruni" <fed...@gm...> ha scritto: > > 2014-07-28 10:59 GMT+02:00 Federico Bruni <fed...@gm...>: >> >> Hi all >> >> I've started using Squirrel to learn a bit of SQL. >> I have a simple question that I can't figure out by myself. I'm connecting to a DB2 database which has several schemas, but I'm interested in querying only one. Currently I must specify the schema or I get an error. For example: >> >> SELECT column FROM schema.table >> >> works, while: >> >> SELECT column FROM table >> >> doesn't. >> >> I'd like to set a certain schema to be the default to reduce the length of my SQL instructions. >> IIUC I should change the properties of the alias. But I can load or not load _all_ the schemas; I cannot say "load only this schema and don't load the others". I'm missing something? >> >> Thanks a lot in advance >> Federico >> > > I'm making a second try. > My understanding in the last paragraph above was wrong. Now I've learned how to filter a schema: I choose the alias to connect to, then click on "New Session Properties", open the tab Object tree and I enter my schema name in *Schema include*. > > It works, but my problem now is that there are two identical schemas in this database. Same name, but the second is empty. Unfortunately Squirrel is loading only the empty one, as far as I can see. > How can I work around this problem? > > I'm using snapshot 20140911_2017 on debian. > Oops, I miss a letter, the names are different. And now the filtering is working fine. Back to the original question, I think should _load_ only this schema if I want to shorten the SQL commands |
|
From: Alex M. <ale...@wo...> - 2014-09-26 16:54:33
|
You should be able to modify your alias to specify the schema (I work with iSeries): jdbc:as400://host.domain.corp/schema; See if that helps. Works for me. Thank you Alex From: Federico Bruni [mailto:fed...@gm...] Sent: Friday, September 26, 2014 12:29 PM To: squ...@li... Subject: Re: [Squirrel-sql-users] load only one schema in a DB2 database 2014-07-28 10:59 GMT+02:00 Federico Bruni <fed...@gm...<mailto:fed...@gm...>>: Hi all I've started using Squirrel to learn a bit of SQL. I have a simple question that I can't figure out by myself. I'm connecting to a DB2 database which has several schemas, but I'm interested in querying only one. Currently I must specify the schema or I get an error. For example: SELECT column FROM schema.table works, while: SELECT column FROM table doesn't. I'd like to set a certain schema to be the default to reduce the length of my SQL instructions. IIUC I should change the properties of the alias. But I can load or not load _all_ the schemas; I cannot say "load only this schema and don't load the others". I'm missing something? Thanks a lot in advance Federico I'm making a second try. My understanding in the last paragraph above was wrong. Now I've learned how to filter a schema: I choose the alias to connect to, then click on "New Session Properties", open the tab Object tree and I enter my schema name in *Schema include*. It works, but my problem now is that there are two identical schemas in this database. Same name, but the second is empty. Unfortunately Squirrel is loading only the empty one, as far as I can see. How can I work around this problem? I'm using snapshot 20140911_2017 on debian. Thanks Federico |
|
From: Federico B. <fed...@gm...> - 2014-09-26 16:29:09
|
2014-07-28 10:59 GMT+02:00 Federico Bruni <fed...@gm...>: > Hi all > > I've started using Squirrel to learn a bit of SQL. > I have a simple question that I can't figure out by myself. I'm connecting > to a DB2 database which has several schemas, but I'm interested in querying > only one. Currently I must specify the schema or I get an error. For > example: > > SELECT column FROM schema.table > > works, while: > > SELECT column FROM table > > doesn't. > > I'd like to set a certain schema to be the default to reduce the length of > my SQL instructions. > IIUC I should change the properties of the alias. But I can load or not > load _all_ the schemas; I cannot say "load only this schema and don't load > the others". I'm missing something? > > Thanks a lot in advance > Federico > > I'm making a second try. My understanding in the last paragraph above was wrong. Now I've learned how to filter a schema: I choose the alias to connect to, then click on "New Session Properties", open the tab Object tree and I enter my schema name in *Schema include*. It works, but my problem now is that there are two identical schemas in this database. Same name, but the second is empty. Unfortunately Squirrel is loading only the empty one, as far as I can see. How can I work around this problem? I'm using snapshot 20140911_2017 on debian. Thanks Federico |
|
From: Alex M. <ale...@wo...> - 2014-09-26 13:47:53
|
I am getting the same in 3.5.0:
The selected SQL is not a SELECT statement.
java.lang.reflect.InvocationTargetException
Could not create the Progress Monitor.
Removing the variable declaration fixes the error.
10k result rows is not too much, so the workaround would be to output to the grid and export from there. That seems to work for me.
Thank you
Alex
From: Stefan Grewe [mailto:new...@sg...]
Sent: Friday, September 26, 2014 5:32 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Export Resultset
Hi
using Squirrel 3.5.3 I connect to a MS-SQL 2008R2 DB.
I´ve got a select Script using Variables.
Unfortunately I cannot export the resultset directly to file.
A minimal example Script looks like this:
declare @A varchar(4);
set @A = 2014;
select
*
from Table
I expect some 10,000 rows so I want to directly export results but Squirrel tells me:
The selected SQL is not a SELECT statement.
I can see the export window but exporting results throws a NullPointerException.
Any hints on how to export a script like this or is this a bug?
Cheers Stefan
2014-09-26 11:30:29,068 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.MessagePanel - privateShowMessage: Exception was null
java.lang.reflect.InvocationTargetException
at java.awt.EventQueue.invokeAndWait(Unknown Source)
at java.awt.EventQueue.invokeAndWait(Unknown Source)
at javax.swing.SwingUtilities.invokeAndWait(Unknown Source)
at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand.createProgressAbortDialog(CreateFileOfCurrentSQLCommand.java:229)
at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand$2.create(CreateFileOfCurrentSQLCommand.java:124)
at net.sourceforge.squirrel_sql.fw.gui.action.ResultSetExportCommand.createProgressController(ResultSetExportCommand.java:143)
at net.sourceforge.squirrel_sql.fw.gui.action.AbstractExportCommand.execute(AbstractExportCommand.java:257)
at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand.doCreateFileOfCurrentSQL(CreateFileOfCurrentSQLCommand.java:136)
at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand.access$000(CreateFileOfCurrentSQLCommand.java:58)
at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand$1.run(CreateFileOfCurrentSQLCommand.java:93)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at net.sourceforge.squirrel_sql.client.util.codereformat.CodeReformatorKernel.getStatesOfPosition(CodeReformatorKernel.java:188)
at net.sourceforge.squirrel_sql.client.util.codereformat.CodeReformator.flatenWhiteSpaces(CodeReformator.java:597)
at net.sourceforge.squirrel_sql.client.util.codereformat.CodeReformator.reformat(CodeReformator.java:56)
at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand$4.run(CreateFileOfCurrentSQLCommand.java:240)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
|
|
From: Stefan G. <new...@sg...> - 2014-09-26 09:52:32
|
Hi
using Squirrel 3.5.3 I connect to a MS-SQL 2008R2 DB.
I´ve got a select Script using Variables.
Unfortunately I cannot export the resultset directly to file.
A minimal example Script looks like this:
declare @A varchar(4);
set @A = 2014;
select
*
from Table
I expect some 10,000 rows so I want to directly export results but
Squirrel tells me:
The selected SQL is not a SELECT statement.
I can see the export window but exporting results throws a
NullPointerException.
Any hints on how to export a script like this or is this a bug?
Cheers Stefan
2014-09-26 11:30:29,068 [Thread-2] ERROR
net.sourceforge.squirrel_sql.client.session.MessagePanel -
privateShowMessage: Exception was null
java.lang.reflect.InvocationTargetException
at java.awt.EventQueue.invokeAndWait(Unknown Source)
at java.awt.EventQueue.invokeAndWait(Unknown Source)
at javax.swing.SwingUtilities.invokeAndWait(Unknown Source)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand.createProgressAbortDialog(CreateFileOfCurrentSQLCommand.java:229)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand$2.create(CreateFileOfCurrentSQLCommand.java:124)
at
net.sourceforge.squirrel_sql.fw.gui.action.ResultSetExportCommand.createProgressController(ResultSetExportCommand.java:143)
at
net.sourceforge.squirrel_sql.fw.gui.action.AbstractExportCommand.execute(AbstractExportCommand.java:257)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand.doCreateFileOfCurrentSQL(CreateFileOfCurrentSQLCommand.java:136)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand.access$000(CreateFileOfCurrentSQLCommand.java:58)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand$1.run(CreateFileOfCurrentSQLCommand.java:93)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at
net.sourceforge.squirrel_sql.client.util.codereformat.CodeReformatorKernel.getStatesOfPosition(CodeReformatorKernel.java:188)
at
net.sourceforge.squirrel_sql.client.util.codereformat.CodeReformator.flatenWhiteSpaces(CodeReformator.java:597)
at
net.sourceforge.squirrel_sql.client.util.codereformat.CodeReformator.reformat(CodeReformator.java:56)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand$4.run(CreateFileOfCurrentSQLCommand.java:240)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at
net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
|
|
From: John H. <jh...@im...> - 2014-09-23 14:33:12
|
On Tue, 23 Sep 2014, Amit Dor-Shifer wrote: > #John, > (screenshot taken from > http://squirrel-sql.sourceforge.net/screenshots/1_desktop.png) Yep. 74MB allocated to heap from OS; of that, 27MB is allocated to things like result sets. There *is* an indirect clue - IIRC if you hover over the trash can that's in the same group on the status bar you get a tooltip that suggests something about running the garbage collector. > On Tue, Sep 23, 2014 at 12:37 AM, John Hardin <jh...@im...> wrote: > >> On Mon, 22 Sep 2014, Amit Dor-Shifer wrote: >> >>> Hmm. I probably misinterpreted this widget. Is it actually a mem usage >>> bar? >> >> Absent a screenshot, yes, that's the allocated-vs-used memory. >> >> On Mon, Sep 22, 2014 at 10:47 AM, Amit Dor-Shifer < >>> ami...@gm... >>> >>>> wrote: >>> >>>> I'm new to squirrel. I notice there's a download progress bar at the >>>> bottom of the page, where it's showing the client pretty busily >>>> downloading something. hundreds of MBs. No tool tip is available. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Windows Vista: Windows ME for the XP generation. ----------------------------------------------------------------------- 845 days since the first successful private support mission to ISS (SpaceX) |
|
From: John H. <jh...@im...> - 2014-09-22 14:37:34
|
On Mon, 22 Sep 2014, Amit Dor-Shifer wrote: > Hmm. I probably misinterpreted this widget. Is it actually a mem usage bar? Absent a screenshot, yes, that's the allocated-vs-used memory. > On Mon, Sep 22, 2014 at 10:47 AM, Amit Dor-Shifer <ami...@gm... >> wrote: > >> I'm new to squirrel. I notice there's a download progress bar at the >> bottom of the page, where it's showing the client pretty busily downloading >> something. hundreds of MBs. No tool tip is available. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- ...in the 2nd amendment the right to arms clause means you have the right to choose how many arms you want, and the militia clause means that Congress can punish you if the answer is "none." -- David Hardy, 2nd Amendment scholar ----------------------------------------------------------------------- 844 days since the first successful private support mission to ISS (SpaceX) |
|
From: Alexandre P. <Ale...@ei...> - 2014-09-22 13:54:00
|
Yes, it is memory usage bar. Sent from my iPhone On Sep 21, 2014, at 9:38 PM, "Amit Dor-Shifer" <ami...@gm...<mailto:ami...@gm...>> wrote: Hmm. I probably misinterpreted this widget. Is it actually a mem usage bar? On Mon, Sep 22, 2014 at 10:47 AM, Amit Dor-Shifer <ami...@gm...<mailto:ami...@gm...>> wrote: Hi. I'm new to squirrel. I notice there's a download progress bar at the bottom of the page, where it's showing the client pretty busily downloading something. hundreds of MBs. No tool tip is available. What is it that squirrel is downloading, and how do I turn it off? Thanks, ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk _______________________________________________ Squirrel-sql-users mailing list Squ...@li...<mailto:Squ...@li...> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Amit Dor-S. <ami...@gm...> - 2014-09-22 03:38:42
|
Hmm. I probably misinterpreted this widget. Is it actually a mem usage bar? On Mon, Sep 22, 2014 at 10:47 AM, Amit Dor-Shifer <ami...@gm... > wrote: > Hi. > I'm new to squirrel. I notice there's a download progress bar at the > bottom of the page, where it's showing the client pretty busily downloading > something. hundreds of MBs. No tool tip is available. > > What is it that squirrel is downloading, and how do I turn it off? > Thanks, > |
|
From: Amit Dor-S. <ami...@gm...> - 2014-09-22 00:47:33
|
Hi. I'm new to squirrel. I notice there's a download progress bar at the bottom of the page, where it's showing the client pretty busily downloading something. hundreds of MBs. No tool tip is available. What is it that squirrel is downloading, and how do I turn it off? Thanks, |
|
From: Stepan R. <xr...@se...> - 2014-09-15 08:43:21
|
Good morning, is there any way, how can I set the default size of Result's "Value of column ..." pop-up window? Using GUI or XML configuration? Especially in the case of CLOB or large varchar columns I do not want always drag&drop this window to see the content of the cell. Also the button for "Reformat XML" beside buttons Export and Browse would be highly appreciated to speed up reformatting as XML comparing the current right mouse click, selection... Thank You, Stepan |
|
From: Gerd W. <ger...@t-...> - 2014-09-10 19:49:20
|
Hi Stepan and Jef, please have a look at the snapshot here: https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20140910_2140/ and let me know if the bug is fixed. Thanks Gerd Am 10.09.2014 um 09:06 schrieb Stepan RYBAR: > Hello, Jef, > > I have the same problem for years. But I have a workaround. > > Try to run sql select again, then NOT TO LEFT MOUSE CLICK ANYWHERE INTO RESULT SET TABLE and right mouse click for export procedure. You simply get info, if the export is successful, if You get popup window that "Export of ... rows to file ... is complete." I > > Regarding the error: Once You click into ResultSet table, and then export to MS Excel, You can see the error in SQuirreL event log pasted below. I think, that the problem occurs, if the ResultSet table contains (C)LOB column with nulls and before export You click into null cell of (C)LOB column. At least this is the way, how can I reproduce the error anytime. > > Stepan > > 2014-09-10 08:55:35,121 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occured dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(70,188),absolute(939,865),button=1,modifiers=Button1,clickCount=1] on win0 > java.lang.NullPointerException > at net.sourceforge.squirrel_sql.fw.gui.action.TableExportCsvCommand.checkMissingData(TableExportCsvCommand.java:58) > at net.sourceforge.squirrel_sql.fw.gui.action.AbstractExportCommand.execute(AbstractExportCommand.java:190) > at net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ExportCsvAction.actionPerformed(TablePopupMenu.java:397) > at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) > at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) > at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) > at javax.swing.DefaultButtonModel.setPressed(Unknown Source) > at javax.swing.AbstractButton.doClick(Unknown Source) > at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) > at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) > at java.awt.Component.processMouseEvent(Unknown Source) > at javax.swing.JComponent.processMouseEvent(Unknown Source) > at java.awt.Component.processEvent(Unknown Source) > at java.awt.Container.processEvent(Unknown Source) > at java.awt.Component.dispatchEventImpl(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) > at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) > at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Window.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.EventQueue.dispatchEventImpl(Unknown Source) > at java.awt.EventQueue.access$400(Unknown Source) > at java.awt.EventQueue$3.run(Unknown Source) > at java.awt.EventQueue$3.run(Unknown Source) > at java.security.AccessController.doPrivileged(Native Method) > at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) > at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) > at java.awt.EventQueue$4.run(Unknown Source) > at java.awt.EventQueue$4.run(Unknown Source) > at java.security.AccessController.doPrivileged(Native Method) > at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) > at java.awt.EventQueue.dispatchEvent(Unknown Source) > at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) > at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) > at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) > at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) > at java.awt.EventDispatchThread.pumpEvents(Unknown Source) > at java.awt.EventDispatchThread.pumpEvents(Unknown Source) > at java.awt.EventDispatchThread.run(Unknown Source) > > ---------- Původní zpráva ---------- > Od: Seyen, Jef > Komu: squ...@li... > Datum: 10. 9. 2014 3:54:32 > Předmět: [Squirrel-sql-users] problem with export of result of squirrel > > I have a problem with export of a small result > > I am using version 3.5.3 > > Only 74 rows are in result (so not big file) > > > > When i export with paramaters like shown , i dont get any result > > > > Jef Seyen > > Applicatiebeheerder > ESF-Agentschap Vlaanderen vzw > Gasthuisstraat 31 > 1000 Brussel > Tel: 02/5462247 Fax:02/546 22 40 > > > > ------------------------------------------------------------------------------ > Want excitement? > Manually upgrade your production database. > When you want reliability, choose Perforce > Perforce version control. Predictably reliable. > http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk_______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users= > > > > ------------------------------------------------------------------------------ > Want excitement? > Manually upgrade your production database. > When you want reliability, choose Perforce > Perforce version control. Predictably reliable. > http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
|
From: Seyen, J. <jef...@es...> - 2014-09-10 09:18:09
|
Great , I thought it was needed to select all rows and to export then. I did like that always and in 95% of cases it works. When I click in the result table, and export I don’t get an error message There are indeed clob fields in the result. I adapted the query so clob fields are not in the result anymore. SO when I select all , then export is working fine. So I know the reason for the issue. MANY THANKS Jef Seyen Applicatiebeheerder ESF-Agentschap Vlaanderen vzw Gasthuisstraat 31 1000 Brussel Tel: 02/5462247 Fax:02/546 22 40 -----Oorspronkelijk bericht----- Van: Stepan RYBAR [mailto:xr...@se...] Verzonden: woensdag 10 september 2014 9:06 Aan: squ...@li... CC: Seyen, Jef Onderwerp: Re: [Squirrel-sql-users] problem with export of result of squirrel Hello, Jef, I have the same problem for years. But I have a workaround. Try to run sql select again, then NOT TO LEFT MOUSE CLICK ANYWHERE INTO RESULT SET TABLE and right mouse click for export procedure. You simply get info, if the export is successful, if You get popup window that "Export of ... rows to file ... is complete." I Regarding the error: Once You click into ResultSet table, and then export to MS Excel, You can see the error in SQuirreL event log pasted below. I think, that the problem occurs, if the ResultSet table contains (C)LOB column with nulls and before export You click into null cell of (C)LOB column. At least this is the way, how can I reproduce the error anytime. Stepan 2014-09-10 08:55:35,121 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occured dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(70,188),absolute(939,865),button=1,modifiers=Button1,clickCount=1] on win0 java.lang.NullPointerException at net.sourceforge.squirrel_sql.fw.gui.action.TableExportCsvCommand.checkMissingData(TableExportCsvCommand.java:58) at net.sourceforge.squirrel_sql.fw.gui.action.AbstractExportCommand.execute(AbstractExportCommand.java:190) at net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ExportCsvAction.actionPerformed(TablePopupMenu.java:397) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$400(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) ---------- Původní zpráva ---------- Od: Seyen, Jef Komu: squ...@li... Datum: 10. 9. 2014 3:54:32 Předmět: [Squirrel-sql-users] problem with export of result of squirrel I have a problem with export of a small result I am using version 3.5.3 Only 74 rows are in result (so not big file) When i export with paramaters like shown , i dont get any result Jef Seyen Applicatiebeheerder ESF-Agentschap Vlaanderen vzw Gasthuisstraat 31 1000 Brussel Tel: 02/5462247 Fax:02/546 22 40 ------------------------------------------------------------------------------ Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk_______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Stepan R. <xr...@se...> - 2014-09-10 07:19:01
|
Hello, Jef, I have the same problem for years. But I have a workaround. Try to run sql select again, then NOT TO LEFT MOUSE CLICK ANYWHERE INTO RESULT SET TABLE and right mouse click for export procedure. You simply get info, if the export is successful, if You get popup window that "Export of ... rows to file ... is complete." I Regarding the error: Once You click into ResultSet table, and then export to MS Excel, You can see the error in SQuirreL event log pasted below. I think, that the problem occurs, if the ResultSet table contains (C)LOB column with nulls and before export You click into null cell of (C)LOB column. At least this is the way, how can I reproduce the error anytime. Stepan 2014-09-10 08:55:35,121 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occured dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(70,188),absolute(939,865),button=1,modifiers=Button1,clickCount=1] on win0 java.lang.NullPointerException at net.sourceforge.squirrel_sql.fw.gui.action.TableExportCsvCommand.checkMissingData(TableExportCsvCommand.java:58) at net.sourceforge.squirrel_sql.fw.gui.action.AbstractExportCommand.execute(AbstractExportCommand.java:190) at net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ExportCsvAction.actionPerformed(TablePopupMenu.java:397) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$400(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) ---------- Původní zpráva ---------- Od: Seyen, Jef Komu: squ...@li... Datum: 10. 9. 2014 3:54:32 Předmět: [Squirrel-sql-users] problem with export of result of squirrel I have a problem with export of a small result I am using version 3.5.3 Only 74 rows are in result (so not big file) When i export with paramaters like shown , i dont get any result Jef Seyen Applicatiebeheerder ESF-Agentschap Vlaanderen vzw Gasthuisstraat 31 1000 Brussel Tel: 02/5462247 Fax:02/546 22 40 ------------------------------------------------------------------------------ Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk_______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Vince R. <vin...@ho...> - 2014-09-10 02:05:10
|
Hi all, I managed to install Squirrel and to connect to my Sybase ASE servers. I can see tables, procedures but I cannot see User-Defined Functions (UDFs introduced in ASE15).Is that normal? Is that a limitation of JDBC or the Squirrel plugin? Let me know if it exists or if I can help to implement this part. Thanks,Vince |
|
From: John H. <jh...@im...> - 2014-09-08 23:35:37
|
On Mon, 8 Sep 2014, Willie Calove wrote: > I know the standard is a free license but there are 2 more groups that I > could not find anymore (2 licenses that we have to buy). I'm interested > in finding out what are the capabilities of the other 2 licenses that > are not free. What exactly are you referring to? Commercial JDBC drivers? > Also, can squirrel, import/export from accessdb? Please > advise. Squirrel uses JDBC for database access. Google "JDBC Access" to get lots of information about JDBC drivers for MS Access. You can also set up an ODBC data source for the Access database, and then use the JDBC/ODBC bridge to read it. I *think* that capability is provided with Squirrel out-of-the-box. Note: I haven't actually *done* any of this as I stopped using MS Access nearly fifteen years ago, but I know these tools exist. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- 9 days until the 227th anniversary of the signing of the U.S. Constitution |
|
From: Willie C. <Wil...@Mo...> - 2014-09-08 22:37:40
|
I know the standard is a free license but there are 2 more groups that I could not find anymore (2 licenses that we have to buy). I'm interested in finding out what are the capabilities of the other 2 licenses that are not free. Also, can squirrel, import/export from accessdb? Please advise. Thank you. IMPORTANT NOTICE TO RECIPIENT: This email is meant only for the intended recipient of the transmission. In addition, this email may be a communication that is privileged by law. If you received this email in error, any review, use, disclosure, distribution, or copying of this email is strictly prohibited. Please notify us immediately of the error by return email, and please delete this email from your system. Thank you for your cooperation. |
|
From: Brian M. <bd...@bu...> - 2014-09-06 00:47:54
|
On Fri, Sep 05, 2014 at 05:17:41PM +0000, Alexandre Peshansky wrote: > There's no default setting, AFAIK - CSV file will reproduce the format you set up in Excel (if you started with Excel and save as CSV). I usually use mm/dd/yyyy format, so this is what I change it to. But you can format column (select column, then "Format Cell") with dates to yyyy-mm-dd hh:mm:ss (custom formats, enter manually) and avoid changing format on the DataImport. I would also look at strings. The best idea there is to make sure that they are all quoted. Some CSV file "generators" don't do that, and some file readers don't like that. Brian |
|
From: Alexandre P. <Ale...@ei...> - 2014-09-05 17:17:56
|
There's no default setting, AFAIK - CSV file will reproduce the format you set up in Excel (if you started with Excel and save as CSV). I usually use mm/dd/yyyy format, so this is what I change it to. But you can format column (select column, then "Format Cell") with dates to yyyy-mm-dd hh:mm:ss (custom formats, enter manually) and avoid changing format on the DataImport. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore Albert Einstein College of Medicine 1300 Morris Park Ave, Bronx, NY 10461 (718) 430-2440 (Mo, Tu, Th, Fr) (718) 920-4885 (We) -----Original Message----- From: cassandracyril [mailto:cas...@gm...] Sent: Friday, September 05, 2014 1:13 PM To: squ...@li... Subject: Re: [Squirrel-sql-users] Data Import plugin - database error loading CSV file Thanks - sorry if this is a silly follow-up, but what do you modify it to? What is the default date setting in Excel CSV? Given that I don't even have any dates in this sample dataset, it's hard to see what it wants to be reading. -- View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Data-Import-plugin-database-error-loading-CSV-file-tp3403p3407.html Sent from the Users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: cassandracyril <cas...@gm...> - 2014-09-05 17:12:50
|
Thanks - sorry if this is a silly follow-up, but what do you modify it to? What is the default date setting in Excel CSV? Given that I don't even have any dates in this sample dataset, it's hard to see what it wants to be reading. -- View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Data-Import-plugin-database-error-loading-CSV-file-tp3403p3407.html Sent from the Users mailing list archive at Nabble.com. |
|
From: Alexandre P. <Ale...@ei...> - 2014-09-05 17:03:16
|
I modify format in the DataImport plugin settings screen, and also have to always modify default ";" separator to ",". Sorry - never had issues with anything except dates. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore Albert Einstein College of Medicine 1300 Morris Park Ave, Bronx, NY 10461 (718) 430-2440 (Mo, Tu, Th, Fr) (718) 920-4885 (We) -----Original Message----- From: cassandracyril [mailto:cas...@gm...] Sent: Friday, September 05, 2014 12:55 PM To: squ...@li... Subject: Re: [Squirrel-sql-users] Data Import plugin - database error loading CSV file Would that be the case even if there are no dates in my data? Do you modify the CSV formatting within Excel, or in the DataImport plugin? -- View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Data-Import-plugin-database-error-loading-CSV-file-tp3403p3405.html Sent from the Users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: cassandracyril <cas...@gm...> - 2014-09-05 16:55:05
|
Would that be the case even if there are no dates in my data? Do you modify the CSV formatting within Excel, or in the DataImport plugin? -- View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Data-Import-plugin-database-error-loading-CSV-file-tp3403p3405.html Sent from the Users mailing list archive at Nabble.com. |
|
From: Alexandre P. <Ale...@ei...> - 2014-09-05 16:49:52
|
I usually see that when I forget to modify the CSV defaults, especially date format. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore Albert Einstein College of Medicine 1300 Morris Park Ave, Bronx, NY 10461 (718) 430-2440 (Mo, Tu, Th, Fr) (718) 920-4885 (We) -----Original Message----- From: cassandracyril [mailto:cas...@gm...] Sent: Friday, September 05, 2014 12:20 AM To: squ...@li... Subject: [Squirrel-sql-users] Data Import plugin - database error loading CSV file I've got the Data Import plugin loaded and supposedly working, but when I try and fill a table with a CSV file I get "A database error occurred while inserting data" During the data insert process, I see the full preview of my CSV data correctly, and it reads the column names and rows and everything just fine. It's only when I say "go ahead and create it" that it crashes. This question's been asked before, but not since ~2008 and it was never answered fully then, so hopefully we can figure it out this time. I'm a new user to SQuirreL SQL, and trying to get it set up to load in a fairly large data set (currently in .dat format). |
|
From: cassandracyril <cas...@gm...> - 2014-09-05 04:20:02
|
I've got the Data Import plugin loaded and supposedly working, but when I try and fill a table with a CSV file I get "A database error occurred while inserting data" During the data insert process, I see the full preview of my CSV data correctly, and it reads the column names and rows and everything just fine. It's only when I say "go ahead and create it" that it crashes. This question's been asked before, but not since ~2008 and it was never answered fully then, so hopefully we can figure it out this time. I'm a new user to SQuirreL SQL, and trying to get it set up to load in a fairly large data set (currently in .dat format). -- View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Data-Import-plugin-database-error-loading-CSV-file-tp3403.html Sent from the Users mailing list archive at Nabble.com. |
|
From: John H. <jh...@im...> - 2014-09-03 19:58:25
|
On Wed, 3 Sep 2014, Shull, Daniel wrote: > In SQuirreL any way to run a query, then email the results to a specified distribution list? > Any way to automate this using scripting, pugins etc? > Any way to run a SQuirreL query from a cmd line, then redirect to sendmail? Squirrel is an *enormously* heavy-weight tool to do this. There are simple command-line query clients provided by most database vendors that would probably be a better solution. Is there some reason that only Squirrel would fit the bill? > Use of sendmail assumes UNIX not sure the same can be done in Windows (I > read someone built a Windows sendmail binary...)? Sendmail's available on Windows. At the very least, check out Cygwin. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Insofar as the police deter by their presence, they are very, very good. Criminals take great pains not to commit a crime in front of them. -- Jeffrey Snyder ----------------------------------------------------------------------- 14 days until the 227th anniversary of the signing of the U.S. Constitution |
){kind=link}