squirrel-sql-develop Mailing List for SQuirreL SQL Client (Page 2)
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
You can subscribe to this list here.
2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(48) |
Dec
(4) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2002 |
Jan
(13) |
Feb
(17) |
Mar
(30) |
Apr
(7) |
May
(3) |
Jun
|
Jul
(3) |
Aug
(10) |
Sep
(8) |
Oct
(28) |
Nov
(24) |
Dec
(6) |
2003 |
Jan
(2) |
Feb
(6) |
Mar
(3) |
Apr
(7) |
May
(11) |
Jun
(14) |
Jul
(39) |
Aug
(9) |
Sep
(4) |
Oct
(21) |
Nov
(6) |
Dec
(26) |
2004 |
Jan
(3) |
Feb
(18) |
Mar
(9) |
Apr
(19) |
May
(8) |
Jun
(14) |
Jul
(11) |
Aug
(22) |
Sep
(11) |
Oct
(6) |
Nov
|
Dec
(3) |
2005 |
Jan
(8) |
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
(8) |
Jul
(4) |
Aug
(8) |
Sep
(3) |
Oct
(19) |
Nov
(12) |
Dec
|
2006 |
Jan
(3) |
Feb
(5) |
Mar
(4) |
Apr
(5) |
May
|
Jun
|
Jul
(2) |
Aug
(6) |
Sep
(36) |
Oct
(10) |
Nov
(40) |
Dec
(17) |
2007 |
Jan
(5) |
Feb
(2) |
Mar
(10) |
Apr
(7) |
May
(26) |
Jun
(31) |
Jul
(14) |
Aug
(12) |
Sep
(14) |
Oct
(8) |
Nov
(1) |
Dec
(9) |
2008 |
Jan
(2) |
Feb
(13) |
Mar
(3) |
Apr
(8) |
May
(1) |
Jun
(3) |
Jul
(6) |
Aug
(16) |
Sep
(2) |
Oct
|
Nov
(8) |
Dec
(3) |
2009 |
Jan
(2) |
Feb
(2) |
Mar
(4) |
Apr
(8) |
May
(5) |
Jun
(7) |
Jul
(1) |
Aug
(6) |
Sep
(5) |
Oct
(2) |
Nov
(3) |
Dec
(3) |
2010 |
Jan
(11) |
Feb
(7) |
Mar
(2) |
Apr
(4) |
May
|
Jun
(2) |
Jul
(2) |
Aug
(5) |
Sep
|
Oct
(5) |
Nov
(6) |
Dec
(4) |
2011 |
Jan
(7) |
Feb
(4) |
Mar
(26) |
Apr
(3) |
May
|
Jun
|
Jul
(10) |
Aug
(11) |
Sep
(11) |
Oct
(3) |
Nov
(3) |
Dec
|
2012 |
Jan
(5) |
Feb
(4) |
Mar
(4) |
Apr
(2) |
May
(7) |
Jun
(1) |
Jul
(2) |
Aug
(1) |
Sep
(2) |
Oct
(10) |
Nov
(2) |
Dec
(4) |
2013 |
Jan
(3) |
Feb
(3) |
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
(2) |
Aug
(1) |
Sep
(5) |
Oct
(1) |
Nov
(5) |
Dec
(11) |
2014 |
Jan
|
Feb
(5) |
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
(4) |
Aug
(2) |
Sep
(2) |
Oct
|
Nov
(2) |
Dec
(1) |
2015 |
Jan
(2) |
Feb
(6) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
(1) |
Oct
|
Nov
|
Dec
|
2016 |
Jan
|
Feb
(7) |
Mar
(3) |
Apr
(2) |
May
|
Jun
(5) |
Jul
(5) |
Aug
(1) |
Sep
(1) |
Oct
|
Nov
(3) |
Dec
|
2017 |
Jan
|
Feb
|
Mar
|
Apr
(2) |
May
|
Jun
(3) |
Jul
(4) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
2018 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
(6) |
Aug
(1) |
Sep
|
Oct
|
Nov
(6) |
Dec
|
2019 |
Jan
(1) |
Feb
(5) |
Mar
(3) |
Apr
|
May
(2) |
Jun
(2) |
Jul
|
Aug
|
Sep
(1) |
Oct
(2) |
Nov
(1) |
Dec
|
2020 |
Jan
(1) |
Feb
|
Mar
|
Apr
(4) |
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
(4) |
Dec
(2) |
2021 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2023 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Joseph N. <jo...@na...> - 2019-11-21 17:03:06
|
Hello, Firstly, my thanks for creating SquirrelSQL! Our environment is very heterogenous, so it's nice to have a single tool that can work with all of the different types of databases we have. I'm currently using SquirrelSQL to connect to a number of PostgreSQL databases. With the Oracle driver, when viewing the plan you see it in a nice tree form with columns for each aspect of a step. However, with PostgreSQL, you just see text output that's difficult to read for a plan that has more than a few joins. Fortunately, it seems like the EXPLAIN command in PostgreSQL supports multiple formats including XML, JSON, and YAML which should be easier to parse and then display in a logical manner. So, is this a feature request that you would be willing to work on? I'd certainly be happy to test and give feedback. If not, would you be able to at least point me to the correct place in the code? I'm not a great Java programmer, but would be willing to give it a shot if you'd agree to review and commit it when done. Thanks, --Joe |
From: Gerd W. <ger...@t-...> - 2019-10-08 18:31:38
|
Sorry, I can't reproduce your problem. One reason may be that I have only access to Oracle database version 12.1.0.2.0 while you are using 10.2.0.1.0. Another guess is that there are very many objects in your object tree. But that's not very probable either because the Session start up time in your video seems reasonably short. Could you have give any more details? Gerd Am 23.09.19 um 10:11 schrieb jose luis fernandez diaz: > Hi, > > When you try to search fot a non existing table in Oracle DB the client keeps stalled. Se attached viedo. > > Regards, > Jose Luis. > > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
From: jose l. f. d. <jos...@ho...> - 2019-10-08 11:31:37
|
Hi, Please, see attached video. Regards, Jose Luis. |
From: jose l. f. d. <jos...@ho...> - 2019-09-23 09:45:05
|
Hi, When you try to search fot a non existing table in Oracle DB the client keeps stalled. Se attached viedo. Regards, Jose Luis. |
From: Gerd W. <ger...@t-...> - 2019-06-09 20:06:34
|
Am 05.06.19 um 19:17 schrieb Sigiswald Madou: > plainZipScripts/squirrel-sql.bat still contains the same bug that was fixed > in launcher/squirrel-sql.bat with commit 3b577a > <https://sourceforge.net/p/squirrel-sql/git/ci/3b577a667268597758103b10791948385b5a2e29/> > Without > this fix JAVA_HOME basically is ignored (actually that "if exist" statement > fails and LOCAL_JAVA is being set twice so it ends up being javaw.exe). > > Off topic: both versions of the bat file also treat the quoting of variable > CP differently, but both do it correctly. The differences between the installer and the plain zip scripts are now removed. Gerd |
From: Sigiswald M. <sig...@gm...> - 2019-06-05 17:17:28
|
plainZipScripts/squirrel-sql.bat still contains the same bug that was fixed in launcher/squirrel-sql.bat with commit 3b577a <https://sourceforge.net/p/squirrel-sql/git/ci/3b577a667268597758103b10791948385b5a2e29/> Without this fix JAVA_HOME basically is ignored (actually that "if exist" statement fails and LOCAL_JAVA is being set twice so it ends up being javaw.exe). Off topic: both versions of the bat file also treat the quoting of variable CP differently, but both do it correctly. Kind regards, /Sigiswald |
From: Gerd W. <ger...@t-...> - 2019-05-15 17:16:45
|
Your video, which unfortunately can't be uploaded to the mailing list, shows that you are using ojdbc6.jar which according to https://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html is for Java 1.6. With SQuirreL 3.9.1 you run Java 1.8. So you should use ojdbc7.jar instead. Gerd Am 13.05.19 um 21:37 schrieb jose luis fernandez diaz: > Hi, > > I have created an alias in Squirrel 3.9.1 running on W10, but when I > open then windows Properties, it is empty, although I can connect to > the new alias. > > In the attached files are the log and a video (the video can be > viewed with "VLC Media Player") > > If you need more info, only ask it. > > Best regards, Jose Luis. > > > _______________________________________________ Squirrel-sql-develop > mailing list Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
From: jose l. f. d. <jos...@ho...> - 2019-05-13 20:09:57
|
Hi, I have created an alias in Squirrel 3.9.1 running on W10, but when I open then windows Properties, it is empty, although I can connect to the new alias. In the attached files are the log and a video (the video can be viewed with "VLC Media Player") If you need more info, only ask it. Best regards, Jose Luis. |
From: Gerd W. <ger...@t-...> - 2019-03-20 19:33:53
|
Go to menu Windows --> View SQuirreL Logs. This should give you more details. Gerd Am 19.03.19 um 22:28 schrieb pchambre: > Hello, > > We are working on a JDBC driver for a proprietary database. > >>From a Java test app, I can connect and run executeQuery to pass a native > (not SQL) query to the database and get an iterable ResultSet. > >>From SQL Squirrel, I was initially not able to connect. After implementing a > number of metadata methods that we weren't originally supporting, I can now > connect, and I can submit a query, but the result is: > > Error: No current result > SQLState: null > ErrorCode: 0 > > The result set is pretty simple - one String and two double columns with ten > rows. String (12) and double (8) are both data types that are returned from > the JDBC driver's getTypeInfo() call. > > I see no details in STDOUT, .squirell-sql logs, or the logs generated by my > JDBC driver or database. The database end of things has very detailed logs, > and the query appears to have executed successfully. I am thinking that SQL > Squirrel is not finding something that it expects when attempting to > retrieve or render the ResultSet, but I do not know how to get more detail > about what's happening behind the scenes. > > Any suggestions on how to log more detail about what SQL Squirrel is doing > here? > > Thanks, > Paul > > > > -- > Sent from: http://squirrel-sql-client.10976.n7.nabble.com/Developer-f2439.html > > > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
From: pchambre <pau...@il...> - 2019-03-19 21:48:25
|
Hello, We are working on a JDBC driver for a proprietary database. >From a Java test app, I can connect and run executeQuery to pass a native (not SQL) query to the database and get an iterable ResultSet. >From SQL Squirrel, I was initially not able to connect. After implementing a number of metadata methods that we weren't originally supporting, I can now connect, and I can submit a query, but the result is: Error: No current result SQLState: null ErrorCode: 0 The result set is pretty simple - one String and two double columns with ten rows. String (12) and double (8) are both data types that are returned from the JDBC driver's getTypeInfo() call. I see no details in STDOUT, .squirell-sql logs, or the logs generated by my JDBC driver or database. The database end of things has very detailed logs, and the query appears to have executed successfully. I am thinking that SQL Squirrel is not finding something that it expects when attempting to retrieve or render the ResultSet, but I do not know how to get more detail about what's happening behind the scenes. Any suggestions on how to log more detail about what SQL Squirrel is doing here? Thanks, Paul -- Sent from: http://squirrel-sql-client.10976.n7.nabble.com/Developer-f2439.html |
From: Alarcón V. <vla...@ya...> - 2019-03-08 16:20:27
|
Well, I'll have some time next week to work on this. It seems I can code it myself. Shouldn't be a great amount of work. But first: is there any interest on this? Second, if there's interest, can someone: * Give me access to the source code repository. * Point me into the right direction where to intervene the code (which package or classes should I touch). * Tell me how to build Squirrel, so I can test it? Thank you, Vlad f there's interest on it, can you -------------------------------------------- On Thu, 2/21/19, Alarcón Vladimir via Squirrel-sql-develop <squ...@li...> wrote: Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab To: "Mateus Stock" <ms...@sp...>, squ...@li... Date: Thursday, February 21, 2019, 4:31 PM I was thinking about what features of the library can be of use for Squirrel SQL Client. The features I clearly see can help are: * Automatic width of the cells: no need to compute cell sizes; just add them to the table. Can also be set to min/max width range (with cropping styles). * Column separation: by default we can use one or two spaces, but could be any other char(s). * Column title underlining: uses dashes by default but can use any other char, even Unicode if supported by GUI. * Left, center, and right cell alignment. Maybe by default VARCHARs should be left aligned, NUMBERs right aligned, DATEs centered? Just a thought. Other library features that I don't see as very useful for Squirrel, but worth mentioning: * Custom and predefined styles for top, left, right, bottom borders. Probably Squirrel prefers minimalistic display without borders. * Implements colspan, so a cell can span few columns. Don't see any use case for this in Squirrel. * Streaming tables for large number of rows. Not sure Squirrel would ever display massive number of rows. Well, that's what I think of off the top of my head. Vlad -------------------------------------------- On Thu, 2/21/19, Mateus Stock <ms...@sp...> wrote: Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab To: "Alarcón Vladimir" <vla...@ya...> Cc: squ...@li... Date: Thursday, February 21, 2019, 2:42 PM Yeah it stripped all the formatting. Not sure if my picture was sent either. Mateus Stock "With great power comes great responsibility." - Voltaire Mateus Stock IT Manager +1 813 649 2140 Speedling Incorporated On Thu, Feb 21, 2019 at 2:33 PM Alarcón Vladimir <vla...@ya...> wrote: Yes, I was thinking in monospace font (as in the tab). My email client must have removed the formatting. -------------------------------------------- On Thu, 2/21/19, Mateus Stock <ms...@sp...> wrote: Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab To: "Alarcón Vladimir" <vla...@ya...> Cc: squ...@li... Date: Thursday, February 21, 2019, 2:23 PM I would send that as a screenshot or with monospace font. Your suggestion does look better, but just looking at the email it seems to be worse: Original message: I would prefer the first option. Your suggestion: I would prefer your suggestion. Mateus Stock "With great power comes great responsibility." - Voltaire Mateus Stock IT Manager +1 813 649 2140 Speedling Incorporated On Thu, Feb 21, 2019 at 1:44 PM Alarcón Vladimir via Squirrel-sql-develop <squ...@li...> wrote: Hi, I wanted to explore the possibility of improving the "Result as Text" tab. IMHO as it is now its format is lacking quite a bit. A few years back I developed a library here at source forge called "Java Text Table Formatter" (https://sourceforge.net/projects/texttablefmt/) that could be put to good use. For example, the query: select id, name, type from account; Nowadays shows something like: id name type ----------------------------------------------------------------------------- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK With the new library, it could show something like: id name type ------- ------- ---- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK I don't know how to articulate this change or how to find out if there's interest for it. Is this the right email subscription? Thanks, Vlad _______________________________________________ Squirrel-sql-develop mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof. Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof. _______________________________________________ Squirrel-sql-develop mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop |
From: Alarcón V. <vla...@ya...> - 2019-02-21 21:31:23
|
I was thinking about what features of the library can be of use for Squirrel SQL Client. The features I clearly see can help are: * Automatic width of the cells: no need to compute cell sizes; just add them to the table. Can also be set to min/max width range (with cropping styles). * Column separation: by default we can use one or two spaces, but could be any other char(s). * Column title underlining: uses dashes by default but can use any other char, even Unicode if supported by GUI. * Left, center, and right cell alignment. Maybe by default VARCHARs should be left aligned, NUMBERs right aligned, DATEs centered? Just a thought. Other library features that I don't see as very useful for Squirrel, but worth mentioning: * Custom and predefined styles for top, left, right, bottom borders. Probably Squirrel prefers minimalistic display without borders. * Implements colspan, so a cell can span few columns. Don't see any use case for this in Squirrel. * Streaming tables for large number of rows. Not sure Squirrel would ever display massive number of rows. Well, that's what I think of off the top of my head. Vlad -------------------------------------------- On Thu, 2/21/19, Mateus Stock <ms...@sp...> wrote: Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab To: "Alarcón Vladimir" <vla...@ya...> Cc: squ...@li... Date: Thursday, February 21, 2019, 2:42 PM Yeah it stripped all the formatting. Not sure if my picture was sent either. Mateus Stock "With great power comes great responsibility." - Voltaire Mateus Stock IT Manager +1 813 649 2140 Speedling Incorporated On Thu, Feb 21, 2019 at 2:33 PM Alarcón Vladimir <vla...@ya...> wrote: Yes, I was thinking in monospace font (as in the tab). My email client must have removed the formatting. -------------------------------------------- On Thu, 2/21/19, Mateus Stock <ms...@sp...> wrote: Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab To: "Alarcón Vladimir" <vla...@ya...> Cc: squ...@li... Date: Thursday, February 21, 2019, 2:23 PM I would send that as a screenshot or with monospace font. Your suggestion does look better, but just looking at the email it seems to be worse: Original message: I would prefer the first option. Your suggestion: I would prefer your suggestion. Mateus Stock "With great power comes great responsibility." - Voltaire Mateus Stock IT Manager +1 813 649 2140 Speedling Incorporated On Thu, Feb 21, 2019 at 1:44 PM Alarcón Vladimir via Squirrel-sql-develop <squ...@li...> wrote: Hi, I wanted to explore the possibility of improving the "Result as Text" tab. IMHO as it is now its format is lacking quite a bit. A few years back I developed a library here at source forge called "Java Text Table Formatter" (https://sourceforge.net/projects/texttablefmt/) that could be put to good use. For example, the query: select id, name, type from account; Nowadays shows something like: id name type ----------------------------------------------------------------------------- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK With the new library, it could show something like: id name type ------- ------- ---- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK I don't know how to articulate this change or how to find out if there's interest for it. Is this the right email subscription? Thanks, Vlad _______________________________________________ Squirrel-sql-develop mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof. Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof. |
From: Mateus S. <ms...@sp...> - 2019-02-21 19:42:54
|
Yeah it stripped all the formatting. Not sure if my picture was sent either. Mateus Stock *"With great power comes great responsibility." - Voltaire* ------------------------------ *Mateus Stock* *IT Manager* *+1 813 649 2140* *Speedling Incorporated <http://http://www.speedling.com/> [image: Speedling Incorporated 50th]* ------------------------------ On Thu, Feb 21, 2019 at 2:33 PM Alarcón Vladimir <vla...@ya...> wrote: > Yes, I was thinking in monospace font (as in the tab). My email client > must have removed the formatting. > > -------------------------------------------- > On Thu, 2/21/19, Mateus Stock <ms...@sp...> wrote: > > Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab > To: "Alarcón Vladimir" <vla...@ya...> > Cc: squ...@li... > Date: Thursday, February 21, 2019, 2:23 PM > > I would > send that as a screenshot or with monospace font. Your > suggestion does look better, but just looking at the email > it seems to be worse: > > Original message: > I > would prefer the first option. > > > Your > suggestion: > I would prefer your > suggestion. > > > > > > Mateus > Stock > > "With > great power comes > great responsibility." > - Voltaire > > > Mateus Stock > > IT Manager > +1 813 649 2140 > > Speedling > Incorporated > > > > > > > > On Thu, Feb 21, > 2019 at 1:44 PM Alarcón Vladimir via Squirrel-sql-develop > <squ...@li...> > wrote: > Hi, I wanted to explore > the possibility of improving the "Result as Text" > tab. IMHO as it is now its format is lacking quite a bit. A > few years back I developed a library here at source forge > called "Java Text Table Formatter" ( > https://sourceforge.net/projects/texttablefmt/) > that could be put to good use. > > > > For example, the query: > > > > select id, name, type from account; > > > > Nowadays shows something like: > > > > id name > type > > > ----------------------------------------------------------------------------- > > 1234001 CHK1004 > CHK > > 1234004 SAV7018 > SAV > > 1234005 CHK2301 > CHK > > > > With the new library, it could show something like: > > > > id name type > > ------- ------- ---- > > 1234001 CHK1004 CHK > > 1234004 SAV7018 SAV > > 1234005 CHK2301 CHK > > > > I don't know how to articulate this change or how to > find out if there's interest for it. Is this the right > email subscription? > > > > Thanks, > > Vlad > > > > > > _______________________________________________ > > Squirrel-sql-develop mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > > > > > > Confidentiality > Caution: This email, including any attachment, is > confidential and may contain privileged information, that is > intended solely for the use of the individual to whom it is > addressed. If you are not the intended recipient, be advised > that you have received this email in error and that any use, > dissemination, forwarding, printing, or copying of this > email is strictly prohibited. Please notify us immediately > by reply email and then delete this message from your > system. Any views or opinions presented are solely those of > the author and do not necessarily represent those of > Speedling Incorporated. Although this email and any > attachments are believed to be free of any virus or other > defects which might affect any computer or IT system into > which they are received, no responsibility is accepted by > Speedling Incorporated or any of its associated companies > for any loss or damage arising in any way from the receipt > or use > thereof. > -- *Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof.* |
From: Alarcón V. <vla...@ya...> - 2019-02-21 19:33:32
|
Yes, I was thinking in monospace font (as in the tab). My email client must have removed the formatting. -------------------------------------------- On Thu, 2/21/19, Mateus Stock <ms...@sp...> wrote: Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab To: "Alarcón Vladimir" <vla...@ya...> Cc: squ...@li... Date: Thursday, February 21, 2019, 2:23 PM I would send that as a screenshot or with monospace font. Your suggestion does look better, but just looking at the email it seems to be worse: Original message: I would prefer the first option. Your suggestion: I would prefer your suggestion. Mateus Stock "With great power comes great responsibility." - Voltaire Mateus Stock IT Manager +1 813 649 2140 Speedling Incorporated On Thu, Feb 21, 2019 at 1:44 PM Alarcón Vladimir via Squirrel-sql-develop <squ...@li...> wrote: Hi, I wanted to explore the possibility of improving the "Result as Text" tab. IMHO as it is now its format is lacking quite a bit. A few years back I developed a library here at source forge called "Java Text Table Formatter" (https://sourceforge.net/projects/texttablefmt/) that could be put to good use. For example, the query: select id, name, type from account; Nowadays shows something like: id name type ----------------------------------------------------------------------------- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK With the new library, it could show something like: id name type ------- ------- ---- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK I don't know how to articulate this change or how to find out if there's interest for it. Is this the right email subscription? Thanks, Vlad _______________________________________________ Squirrel-sql-develop mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof. |
From: Alarcón V. <vla...@ya...> - 2019-02-21 18:44:12
|
Hi, I wanted to explore the possibility of improving the "Result as Text" tab. IMHO as it is now its format is lacking quite a bit. A few years back I developed a library here at source forge called "Java Text Table Formatter" (https://sourceforge.net/projects/texttablefmt/) that could be put to good use. For example, the query: select id, name, type from account; Nowadays shows something like: id name type ----------------------------------------------------------------------------- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK With the new library, it could show something like: id name type ------- ------- ---- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK I don't know how to articulate this change or how to find out if there's interest for it. Is this the right email subscription? Thanks, Vlad |
From: Mateus S. <ms...@sp...> - 2019-02-13 14:44:44
|
Anybody? Mateus Stock *"With great power comes great responsibility." - Voltaire* ------------------------------ *Mateus Stock* *IT Manager* *+1 813 649 2140* *Speedling Incorporated <http://http://www.speedling.com/> [image: Speedling Incorporated 50th]* ------------------------------ On Thu, Jan 24, 2019 at 11:02 AM Mateus Stock <ms...@sp...> wrote: > Hello all! > Not sure exactly where to ask this so I apologize. > > Does anyone know who created the splash image for SQuirreL SQL? Also, in > which program they made it? > > [image: image.png] > > Mateus Stock > > *"With great power comes great responsibility." - Voltaire* > ------------------------------ > *Mateus Stock* > *IT Manager* > *+1 813 649 2140* > > *Speedling Incorporated <http://http://www.speedling.com/> [image: > Speedling Incorporated 50th]* > ------------------------------ > -- *Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof.* |
From: Mateus S. <ms...@sp...> - 2019-01-24 16:32:33
|
Hello all! Not sure exactly where to ask this so I apologize. Does anyone know who created the splash image for SQuirreL SQL? Also, in which program they made it? [image: image.png] Mateus Stock *"With great power comes great responsibility." - Voltaire* ------------------------------ *Mateus Stock* *IT Manager* *+1 813 649 2140* *Speedling Incorporated <http://http://www.speedling.com/> [image: Speedling Incorporated 50th]* ------------------------------ -- *Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof.* |
From: Jürgen W. <ju...@jw...> - 2018-11-02 17:55:20
|
Ok. I never explored a corresponding function in SQLServer (or Oracle or DB2...). I remember (but never get really in touch with it) corresponding (mostly java) stuff in frameworks where classes like Dialect (e.g: org.hibernate.dialect.Oracle10gDialect, https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src/main/java/org/hibernate/dialect/Oracle10gDialect.java) captures implementation specific instruction sets. Here is a another example: https://github.com/JetBrains/Exposed/blob/master/src/main/kotlin/org/jetbrains/exposed/sql/vendors/Keywords.kt As you see, there has to be a kind of pattern implemented, which handles the different ANSI SQL approaches and vendor specific stuff. bye jürgen Am 02.11.18 um 18:44 schrieb Wendell Nichols: > I guess I could have been more clear. I don't work a whole lot with > SQL databases, but the sorts of functions we need metadata for are > APPROX_COUNT_DISTINCT > AVG > CHECKSUM_AGG > COUNT > COUNT_BIG > GROUPING > GROUPING_ID > MAX > MIN > ... > > The queries I do on sys.all_objects return > > sp_MSalreadyhavegeneration > sp_MSwritemergeperfcounter > sp_drop_trusted_assembly > TABLE_PRIVILEGES > sp_replsetsyncstatus > sp_replshowcmds > sp_publishdb > sp_addqueued_artinfo > sp_replcounters > sp_MSget_subscription_dts_info > > ... > > > I've been trying to figure out if the jdbc driver has code that would > give me a hint but nothing so far. > > Thanks for your time. > > wcn > > On 11/2/18 8:28 AM, Jürgen Weltner wrote: >> select * from sys.all_objects |
From: Wendell N. <wen...@gm...> - 2018-11-02 17:44:31
|
I guess I could have been more clear. I don't work a whole lot with SQL databases, but the sorts of functions we need metadata for are APPROX_COUNT_DISTINCT AVG CHECKSUM_AGG COUNT COUNT_BIG GROUPING GROUPING_ID MAX MIN ... The queries I do on sys.all_objects return sp_MSalreadyhavegeneration sp_MSwritemergeperfcounter sp_drop_trusted_assembly TABLE_PRIVILEGES sp_replsetsyncstatus sp_replshowcmds sp_publishdb sp_addqueued_artinfo sp_replcounters sp_MSget_subscription_dts_info ... I've been trying to figure out if the jdbc driver has code that would give me a hint but nothing so far. Thanks for your time. wcn On 11/2/18 8:28 AM, Jürgen Weltner wrote: > select * from sys.all_objects |
From: Jürgen W. <ju...@jw...> - 2018-11-02 14:29:02
|
Hi Wendell, still not sure what you exactly need. ADD seems to be a DDL statement, while the values of your example postgres statement retrieves (as far as i understand) DML callables. In SQLServer select * from sys.all_objects seems to retrieve all (not only user defined in the meaning of non-builtin users) functions and procedures. But still not that set of built-in instructions like "Create", "Drop" or "group by" or "AVG", "DateAdd" and so on. Is it that, what you're looking for? All SQLServer DDL /DML instructions? bye Jürgen Am 02.11.18 um 13:19 schrieb Wendell Nichols: > Thanks Jurgen. This works for user defined functions and stored > procedures but not builtin's like ADD. > > I hate to do it but we're going to have to hard code the metadata for > those. > > wcn > > On 11/2/18 12:12 AM, Jürgen Weltner wrote: >> Sounds to me that you're looking for something like this: >> https://www.mssqltips.com/sqlservertip/1669/generate-a-parameter-list-for-all-sql-server-stored-procedures-and-functions/ >> >> ? >> >> bye Jürgen >> >> Am 01.11.18 um 21:01 schrieb Wendell Nichols: >>> Other databases have tables and functions for deriving the names, >>> args and returntypes for builtin functions but I can't find this for >>> sqlserver. Does anyone on this list have any experience with that? >>> >>> For example a query for postgres that we use is: >>> >>> SELECT proname as name, >>> pg_catalog.pg_get_function_arguments(pg_proc.oid) as input, >>> format_type(pg_proc.prorettype, null) as returntype, prosrc as >>> definition FROM pg_proc ; >>> >>> Thanks in advance.. >>> >>> wcn >>> >>> >>> >>> _______________________________________________ >>> Squirrel-sql-develop mailing list >>> Squ...@li... >>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop >> > > > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop |
From: Wendell N. <wen...@gm...> - 2018-11-02 12:19:28
|
Thanks Jurgen. This works for user defined functions and stored procedures but not builtin's like ADD. I hate to do it but we're going to have to hard code the metadata for those. wcn On 11/2/18 12:12 AM, Jürgen Weltner wrote: > Sounds to me that you're looking for something like this: > https://www.mssqltips.com/sqlservertip/1669/generate-a-parameter-list-for-all-sql-server-stored-procedures-and-functions/ > > ? > > bye Jürgen > > Am 01.11.18 um 21:01 schrieb Wendell Nichols: >> Other databases have tables and functions for deriving the names, >> args and returntypes for builtin functions but I can't find this for >> sqlserver. Does anyone on this list have any experience with that? >> >> For example a query for postgres that we use is: >> >> SELECT proname as name, >> pg_catalog.pg_get_function_arguments(pg_proc.oid) as input, >> format_type(pg_proc.prorettype, null) as returntype, prosrc as >> definition FROM pg_proc ; >> >> Thanks in advance.. >> >> wcn >> >> >> >> _______________________________________________ >> Squirrel-sql-develop mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
From: Jürgen W. <ju...@jw...> - 2018-11-02 06:26:03
|
Sounds to me that you're looking for something like this: https://www.mssqltips.com/sqlservertip/1669/generate-a-parameter-list-for-all-sql-server-stored-procedures-and-functions/ ? bye Jürgen Am 01.11.18 um 21:01 schrieb Wendell Nichols: > Other databases have tables and functions for deriving the names, args > and returntypes for builtin functions but I can't find this for > sqlserver. Does anyone on this list have any experience with that? > > For example a query for postgres that we use is: > > SELECT proname as name, > pg_catalog.pg_get_function_arguments(pg_proc.oid) as input, > format_type(pg_proc.prorettype, null) as returntype, prosrc as > definition FROM pg_proc ; > > Thanks in advance.. > > wcn > > > > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop -- Jürgen Weltner Uhlengrund 18 b D-21244 Buchholz 04181 -137 118 0176 49 000 349 |
From: Wendell N. <wen...@gm...> - 2018-11-01 20:01:38
|
Other databases have tables and functions for deriving the names, args and returntypes for builtin functions but I can't find this for sqlserver. Does anyone on this list have any experience with that? For example a query for postgres that we use is: SELECT proname as name, pg_catalog.pg_get_function_arguments(pg_proc.oid) as input, format_type(pg_proc.prorettype, null) as returntype, prosrc as definition FROM pg_proc ; Thanks in advance.. wcn |
From: Shikhar M. <sma...@ya...> - 2018-08-09 14:56:59
|
Hi, Squirrel sql has an open issue where is does not handle decfloat values well. I am trying to create a patch for it. Is there a db2 database i can test it against? Shikhar Sent from Yahoo Mail on Android |
From: Rony R. <ron...@gm...> - 2018-07-29 20:13:24
|
Thanks, I'll check it out. Le dim. 29 juil. 2018 à 22:11, Gerd Wagner <ger...@t-...> a écrit : > > > Am 24.07.2018 um 13:59 schrieb Rony Rauzduel: > > Hi everybody, > > > > I am a french Java developer. My aim is to improve my Java skills on an > > open-source project. > > SQuirrel SQL FX based on JavaFX and JDK 9 is already started or in > stand-by > > ? > I have to admit it lost a bit of momentum with Oracles decision to > decouple JavaFX from JDK, see > > https://blogs.oracle.com/java-platform-group/the-future-of-javafx-and-other-java-client-roadmap-updates > > > > I would integrate this project. How do I proceed ? > > Just create a clone of our GIT repository and start implementing > features. You are invited to drop merge requests here > https://sourceforge.net/p/squirrel-sql/git/merge-requests/ > > or patches here > https://sourceforge.net/p/squirrel-sql/patches/ > > Some introduction can be found here: > http://www.squirrelsql.org/index.php?page=squirrelFx > > Thanks for your interest in SQuirreL > > Gerd > |