squirrel-sql-develop — A subscriber-only list for those interested in developing SQuirreL and Plugins.

Re: [Squirrel-sql-develop] Squirrel question

[Gerd W. <ger...@t-...>]

This may depend on your Oracle DB version or perhaps even on your JDBC 
driver. From your error I see you are not using the same JDBC driver as 
I do. Mine can be found here:
https://www.oracle.com/database/technologies/jdbc-drivers-12c-downloads.html

Gerd

Am 13.04.20 um 13:51 schrieb Marcos Javier Dvoskin:
> Thanks Gred for your answer.
> 
> The code you suggested raises an error. It doesn't accept the declare
>  statememt, something strange.
> 
> I will try with simple statements, not using dynamic sql
> 
> Regards,
> 
> Marcos
> 
> -----Mensaje original----- De: Gerd Wagner <ger...@t-...> 
> Enviado el: sábado, 4 de abril de 2020 18:19 Para: Marcos Javier
> Dvoskin <mdv...@pr...obal>; 
> squ...@li... CC: Natalia Romero Bicego
> <nar...@pr...obal> Asunto: Re: [Squirrel-sql-develop] Squirrel
> question
> 
> Yes it does if your database does support it. A crucial point is to
> use a statement separator that doesn't interfere with the one used by
> the database. To adjust the statement separator see menu File -> New
> Session Properties -> Tab SQL -> lower part of panel
> 
> For Oracle, if you have the Oracle Plugin installed, the statement 
> separator is taken care of automatically.
> 
> By the way, your example code didn't work on my Oracle DB (version 
> 12.1.0.2.0). Here's the code that works for me:
> 
> DECLARE
> 
> v_cant_reg integer;
> 
> v_table varchar(300);
> 
> BEGIN
> 
> v_table := 'Activity_history';
> 
> EXECUTE immediate 'select count(*) from ' || v_table into v_cant_reg;
>  DBMS_OUTPUT.PUT_LINE('v_cant_reg = ' || v_cant_reg); END;
> 
> Note: When the Oracle PLugin is installed there is a tool bar button
>  "View Oracle Database Output" which allows to see outputs of
> 
> DBMS_OUTPUT.PUT_LINE(...)
> 
> Gerd
> 
> Am 02.04.20 um 21:58 schrieb Marcos Javier Dvoskin:
> 
>> Hi,
> 
>> I'm using squirrel sql. I would like to know if it supports dynamic
>> 
> sql, that is, to create "On the fly" queys instead of writing direct
> sql sentences. As an example, below is an extract of an Oracle
> dynamic sql sentence "Execute inmediate".
> 
>> Regards,
> 
>> Marcos
> 
>> == DYAMIC SQL EXAMPLE===
> 
>> declare v_cant_reg integer;
> 
>> v_table = "Activity_history" -please note that the table name for
>> the
> 
>> next statement is this variable EXECUTE INMEDIATE "select count(*)
> 
>> from " || v_table into v_cant_reg;
> 
>> 
> 
>> 
> 
>> _______________________________________________
> 
>> Squirrel-sql-develop mailing list
> 
>> Squ...@li...
> <mailto:Squ...@li...>
> 
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
>> 
> 

Re: [Squirrel-sql-develop] Squirrel question

[Gerd W. <ger...@t-...>]

Yes it does if your database does support it. A crucial point is to use 
a statement separator that doesn't interfere with the one used by the 
database. To adjust the statement separator see menu File -> New Session 
Properties -> Tab SQL -> lower part of panel

For Oracle, if you have the Oracle Plugin installed, the statement 
separator is taken care of automatically.

By the way, your example code didn't work on my Oracle DB (version 
12.1.0.2.0). Here's the code that works for me:
DECLARE
v_cant_reg integer;
v_table varchar(300);
BEGIN
v_table := 'Activity_history';
EXECUTE immediate 'select count(*) from ' || v_table into v_cant_reg;
DBMS_OUTPUT.PUT_LINE('v_cant_reg = ' || v_cant_reg);
END;

Note: When the Oracle PLugin is installed there is a tool bar button 
"View Oracle Database Output" which allows to see outputs of 
DBMS_OUTPUT.PUT_LINE(...)

Gerd

Am 02.04.20 um 21:58 schrieb Marcos Javier Dvoskin:
> Hi,
> I'm using squirrel sql. I would like to know if it supports dynamic sql, that is, to create "On the fly" queys instead of writing direct sql sentences. As an example, below is an extract of an Oracle dynamic sql sentence "Execute inmediate".
> Regards,
> Marcos
> == DYAMIC SQL EXAMPLE===
> declare v_cant_reg integer;
> v_table = "Activity_history" -please note that the table name for the next statement is this variable
> EXECUTE INMEDIATE "select count(*) from " || v_table into v_cant_reg;
> 
> 
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 

[Squirrel-sql-develop] Squirrel question

[Marcos J. D. <mdv...@pr...>]

Hi,
I'm using squirrel sql. I would like to know if it supports dynamic sql, that is, to create "On the fly" queys instead of writing direct sql sentences. As an example, below is an extract of an Oracle dynamic sql sentence "Execute inmediate".
Regards,
Marcos
== DYAMIC SQL EXAMPLE===
declare v_cant_reg integer;
v_table = "Activity_history" -please note that the table name for the next statement is this variable
EXECUTE INMEDIATE "select count(*) from " || v_table into v_cant_reg;

Re: [Squirrel-sql-develop] Feature request: nicer execution plans from PostgreSQL

[Gerd W. <ger...@t-...>]

Joe,

sorry for my late response. I've been a bit busy lately. Thank you for 
using SQuirreL.

Here are some pointers to the code:
Look at
net.sourceforge.squirrel_sql.plugins.postgres.explain.ExplainExecuterPanel
for the current implementation of the Postgres Plugin's execution plan.

The Oracle Plugin's implementation is in
net.sourceforge.squirrel_sql.plugins.oracle.explainplan.ExplainPlanExecuter.
The createTreeTable() method of this class should be good to look at.

Two general suggestions:
1. Just try to write the simplest code you can. Besides this you should 
only try to avoid to duplicate code.
2. If you believe you know a better UI component than JTreeTable feel 
free to implement it in both, Oracle's and PostgreSQL's execution plans.

Hope this gets you started. If you have any more questions feel free to ask.

Thanks
Gerd


Am 21.11.19 um 16:33 schrieb Joseph Nahmias:
> 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
> 
> 
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 

[Squirrel-sql-develop] Feature request: nicer execution plans from PostgreSQL

[Joseph N. <jo...@na...>]

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

Re: [Squirrel-sql-develop] Client 4.0 stalled where search fot a non existing table in Oracle DB

[Gerd W. <ger...@t-...>]

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
> 

[Squirrel-sql-develop] [Client 4.0] Squirrel doesn't paint data when connectect to Oracle 9i with ojdbc7

[jose l. f. d. <jos...@ho...>]

Hi,

Please, see attached video.

Regards,
Jose Luis.

[Squirrel-sql-develop] Client 4.0 stalled where search fot a non existing table in Oracle DB

[jose l. f. d. <jos...@ho...>]

Hi,

When you try to search fot a non existing table in Oracle DB the client keeps stalled. Se attached viedo.

Regards,
Jose Luis.

Re: [Squirrel-sql-develop] bug @ plainZipScripts/squirrel-sql.bat

[Gerd W. <ger...@t-...>]

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

[Squirrel-sql-develop] bug @ plainZipScripts/squirrel-sql.bat

[Sigiswald M. <sig...@gm...>]

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

Re: [Squirrel-sql-develop] Empty properties windows for a new alias in Windows 10.

[Gerd W. <ger...@t-...>]

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
> 

[Squirrel-sql-develop] Empty properties windows for a new alias in Windows 10.

[jose l. f. d. <jos...@ho...>]

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.

Re: [Squirrel-sql-develop] How to get more detail on query execution errors

[Gerd W. <ger...@t-...>]

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
> 

[Squirrel-sql-develop] How to get more detail on query execution errors

[pchambre <pau...@il...>]

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

Re: [Squirrel-sql-develop] Improving Result as Text tab

[Alarcón V. <vla...@ya...>]

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
 

Re: [Squirrel-sql-develop] Improving Result as Text tab

[Alarcón V. <vla...@ya...>]

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.

Re: [Squirrel-sql-develop] Improving Result as Text tab

[Mateus S. <ms...@sp...>]

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.*

Re: [Squirrel-sql-develop] Improving Result as Text tab

[Alarcón V. <vla...@ya...>]

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.

[Squirrel-sql-develop] Improving Result as Text tab

[Alarcón V. <vla...@ya...>]

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

Re: [Squirrel-sql-develop] Splash Image

[Mateus S. <ms...@sp...>]

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.*

[Squirrel-sql-develop] Splash Image

[Mateus S. <ms...@sp...>]

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.*

Re: [Squirrel-sql-develop] How do I get metadata about builtin functions from MS SqlServer?

[Jürgen W. <ju...@jw...>]

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 

Re: [Squirrel-sql-develop] How do I get metadata about builtin functions from MS SqlServer?

[Wendell N. <wen...@gm...>]

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 

Re: [Squirrel-sql-develop] How do I get metadata about builtin functions from MS SqlServer?

[Jürgen W. <ju...@jw...>]

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

Re: [Squirrel-sql-develop] How do I get metadata about builtin functions from MS SqlServer?

[Wendell N. <wen...@gm...>]

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
>