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

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

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

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

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

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

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] Db2 test env

[Shikhar M. <sma...@ya...>]

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

[Squirrel-sql-develop] SQuirreL SQL FX based on JavaFX and JDK 9

[Rony R. <ron...@gm...>]

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
>

Re: [Squirrel-sql-develop] SQuirreL SQL FX based on JavaFX and JDK 9

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

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

[Squirrel-sql-develop] SQuirrel SQL FX Project

[Rony R. <ron...@gm...>]

Ok, thanks.

Le dim. 29 juil. 2018 à 22:05, Gerd Wagner <ger...@t-...> a
écrit :

>
>
> Am 24.07.2018 um 00:02 schrieb Rony Rauzduel:
> > Hi everybody,
> >
> > In the installer documentation of SQuirrel SQL FX Project, I read that :
> > There is a small Ant script right inside the sqfx/ directory. To execute
> > the script you need to download Ant version 1.9.3 or higher from here
> > <http://ant.apache.org/bindownload.cgi>.
> >
> > Question : It's possible to build SQuirrel SQL FX with Apache Maven
> instead
> > of Ant ?
> No, there is only an Ant script.
>
> Gerd
>

Re: [Squirrel-sql-develop] SQuirrel SQL FX Project

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

Am 24.07.2018 um 00:02 schrieb Rony Rauzduel:
> Hi everybody,
> 
> In the installer documentation of SQuirrel SQL FX Project, I read that :
> There is a small Ant script right inside the sqfx/ directory. To execute
> the script you need to download Ant version 1.9.3 or higher from here
> <http://ant.apache.org/bindownload.cgi>.
> 
> Question : It's possible to build SQuirrel SQL FX with Apache Maven instead
> of Ant ?
No, there is only an Ant script.

Gerd

[Squirrel-sql-develop] SQuirreL SQL FX based on JavaFX and JDK 9

[Rony R. <ron...@gm...>]

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 would integrate this project. How do I proceed ?

Best regards.
Sophonie.

[Squirrel-sql-develop] SQuirrel SQL FX Project

[Rony R. <ron...@gm...>]

Hi everybody,

In the installer documentation of SQuirrel SQL FX Project, I read that :
There is a small Ant script right inside the sqfx/ directory. To execute
the script you need to download Ant version 1.9.3 or higher from here
<http://ant.apache.org/bindownload.cgi>.

Question : It's possible to build SQuirrel SQL FX with Apache Maven instead
of Ant ?

Best regards.
Sophonie.

[Squirrel-sql-develop] need help to create a plugin

[<che...@wi...>]

Hi,
I am new to the tool SQuirreL. I want to write a plugin for masking the query results.
Can anyone help.

Regards,
Chetan C S
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

[Squirrel-sql-develop] Problems with Mac-installation of 3.8.0

[Martin L. <la...@ru...>]

After installing the 3.8.0-version on my Mac, it fails to start with a 
message:

     Error: Could not find or load main class JavaVersionChecker

This is caused by the squirrel-sql.sh script attempting to set 
SQUIRREL_SQL_HOME to `dirname "$0"`/Contents/Resources/Java. Since the 
script is located in /Applications/SQuirreLSQL.app/Contents/MacOS/, this 
will produce the invalid path 
/Applications/SQuirreLSQL.app/Contents/MacOS/Contents/Resources/Java. 
The rest of the code ends up trying to locate versioncheck.jar in 
/Applications/SQuirreLSQL.app/Contents/MacOS/lib/

The simple solution is to use ln in /Applications/SQuirreLSQL.app:

     /Applications/SQuirreLSQL.app$ ln -s Contents/MacOS/squirrel-sql.sh

But I guess a better solution is to fix the script so it actually finds 
the lib-folder.



Regards,

Martin Larsson

Re: [Squirrel-sql-develop] Build Subqueries using Query Builder

[Pavan K. <pav...@gm...>]

Oh alright. Thanks for a speedy reply!

Regards,
Pavan Kumar K N

Re: [Squirrel-sql-develop] Build Subqueries using Query Builder

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

Am 06.07.2017 um 12:36 schrieb Pavan Kumar:
> Hi Guys,
> 
> Is there a way to build queries containing subqueries in the Query Builder
> Plug-in in SQuirreL?

Sorry, but there isn't.

Gerd

[Squirrel-sql-develop] Build Subqueries using Query Builder

[Pavan K. <pav...@gm...>]

Hi Guys,

Is there a way to build queries containing subqueries in the Query Builder
Plug-in in SQuirreL?

Regards,
Pavan Kumar K. N.

[Squirrel-sql-develop] Teradata and/or Hive Support

[Pavan K. <pav...@gm...>]

Hi All,

I am using the SQuirreL 3.7.1 and I notice that there aren't any plugins
available for Teradata or Hive.

I am able to add the JDBC driver for Teradata and connect to the database.
But sometimes, the tool does not behave normally. For example, when I drag
and drop tables into the query builder tab, the relationships between
tables are not shown. Also, the database name and schema name prefixes are
not added to table names when I build queries.

I am assuming these issues stem from the fact that there is no plugin
support for Teradata. Is anyone currently working on plugins for Teradata
and/or Hive? It would be of great use.

Thanks and Regards,
Pavan

Re: [Squirrel-sql-develop] Need help for a new database plugin development

[Choong H. K. <ze...@gm...>]

Thanks a lot :)

Bests,

Choong Hun Kim

On Tue, Jun 27, 2017 at 5:16 AM, Gerd Wagner <ger...@t-...>
wrote:

>
>
> Am 19.06.2017 um 11:51 schrieb Choong Hun Kim:
>
>> Hello,
>>
>> I am working for Altibase (www.altibase.com), a hybrid (in-memory & disk)
>> relational DBMS. My manager asked me to develop an Altibase plugin for
>> SQuirreL SQL as the first step to make Altibase more open source friendly
>> DBMS.
>>
>> As I am a newbie to open source and SQuirreL SQL, I'd like to check three
>> issues before starting it.
>>
>> 1. Plugin development process
>> According to this mailing list, my guess for the plugin developement
>> process may be, 1. fork from master, 2. develop Altibase plugin, 3. pull
>> request for the plugin. Is it correct?
>>
> Yes, that's right.
>
>
>> 2. Use other DBMS's source code and images
>> Is it okay to borrow some images (icons) from other DBMS plugins? GPLv2
>> license says it may be okay, but I'd like to confirm it. I am clumsy at
>> graphic stuff :(
>>
> That's OK.
>
>
>> 3. Regression test
>> Though I have browsed several SQuirreL API documents, I have not found any
>> clue for testing. Is there any automated (regression) test for DBMS
>> plugin?
>>
> There was once. But they got lost some time ago.
>
>
> Gerd
>

Re: [Squirrel-sql-develop] Need help for a new database plugin development

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

Am 19.06.2017 um 11:51 schrieb Choong Hun Kim:
> Hello,
> 
> I am working for Altibase (www.altibase.com), a hybrid (in-memory & disk)
> relational DBMS. My manager asked me to develop an Altibase plugin for
> SQuirreL SQL as the first step to make Altibase more open source friendly
> DBMS.
> 
> As I am a newbie to open source and SQuirreL SQL, I'd like to check three
> issues before starting it.
> 
> 1. Plugin development process
> According to this mailing list, my guess for the plugin developement
> process may be, 1. fork from master, 2. develop Altibase plugin, 3. pull
> request for the plugin. Is it correct?
Yes, that's right.

> 
> 2. Use other DBMS's source code and images
> Is it okay to borrow some images (icons) from other DBMS plugins? GPLv2
> license says it may be okay, but I'd like to confirm it. I am clumsy at
> graphic stuff :(
That's OK.

> 
> 3. Regression test
> Though I have browsed several SQuirreL API documents, I have not found any
> clue for testing. Is there any automated (regression) test for DBMS plugin?
There was once. But they got lost some time ago.


Gerd

[Squirrel-sql-develop] Need help for a new database plugin development

[Choong H. K. <ze...@gm...>]

Hello,

I am working for Altibase (www.altibase.com), a hybrid (in-memory & disk)
relational DBMS. My manager asked me to develop an Altibase plugin for
SQuirreL SQL as the first step to make Altibase more open source friendly
DBMS.

As I am a newbie to open source and SQuirreL SQL, I'd like to check three
issues before starting it.

1. Plugin development process
According to this mailing list, my guess for the plugin developement
process may be, 1. fork from master, 2. develop Altibase plugin, 3. pull
request for the plugin. Is it correct?

2. Use other DBMS's source code and images
Is it okay to borrow some images (icons) from other DBMS plugins? GPLv2
license says it may be okay, but I'd like to confirm it. I am clumsy at
graphic stuff :(

3. Regression test
Though I have browsed several SQuirreL API documents, I have not found any
clue for testing. Is there any automated (regression) test for DBMS plugin?

Any feedback will be very appreciated and many thinks in advance.

Best regards,


Choong Hun Kim

Re: [Squirrel-sql-develop] Need help for early EOF issue

[Neville R. <row...@ho...>]

I’ve just tried exactly that git clone command and it worked for me, however stack-overflow appears to suggest setting the git post-buffer size will help

http://stackoverflow.com/questions/17683295/git-bash-error-rpc-failed-result-18-htp-code-200b-1kib-s/36595823

There are several suggestions on that link but specifically

git config http.postBuffer 24288000

Before doing the clone looks like it is most recommended.

Neville

On 17 Apr 2017, at 03:38, Kevin Xu <xu...@gm...<mailto:xu...@gm...>> wrote:

Hi all,



This is my first time to clone the project. Could you help? I got an error
as follows. I was trying to set git compression to -1 as someone mentioned
on the website, but doesn’t work for me. Really appreciated if anyone can
help.



$ git clone http://git.code.sf.net/p/squirrel-sql/git squirrel-sql

Cloning into 'squirrel-sql'...

remote: Counting objects: 126804, done.

remote: Compressing objects: 100% (32442/32442), done.

error: RPC failed; result=18, HTTP code = 200 MiB | 204.00 KiB/s

fatal: The remote end hung up unexpectedly

fatal: early EOF

fatal: index-pack failed





$ git config -l

core.symlinks=false

core.autocrlf=true

color.diff=auto

color.status=auto

color.branch=auto

color.interactive=true

pack.packsizelimit=2g

help.format=html

http.sslcainfo=d:/Program Files/Git/mingw64/ssl/certs/ca-bundle.crt

diff.astextplain.textconv=astextplain

rebase.autosquash=true

credential.helper=store

core.compression=-1


--


*Kevin *
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org<http://Slashdot.org>! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-develop mailing list
Squ...@li...<mailto:Squ...@li...>
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

[Squirrel-sql-develop] Need help for early EOF issue

[Kevin Xu <xu...@gm...>]

Hi all,



This is my first time to clone the project. Could you help? I got an error
as follows. I was trying to set git compression to -1 as someone mentioned
on the website, but doesn’t work for me. Really appreciated if anyone can
help.



$ git clone http://git.code.sf.net/p/squirrel-sql/git squirrel-sql

Cloning into 'squirrel-sql'...

remote: Counting objects: 126804, done.

remote: Compressing objects: 100% (32442/32442), done.

error: RPC failed; result=18, HTTP code = 200 MiB | 204.00 KiB/s

fatal: The remote end hung up unexpectedly

fatal: early EOF

fatal: index-pack failed





$ git config -l

core.symlinks=false

core.autocrlf=true

color.diff=auto

color.status=auto

color.branch=auto

color.interactive=true

pack.packsizelimit=2g

help.format=html

http.sslcainfo=d:/Program Files/Git/mingw64/ssl/certs/ca-bundle.crt

diff.astextplain.textconv=astextplain

rebase.autosquash=true

credential.helper=store

core.compression=-1


-- 


*Kevin *

Re: [Squirrel-sql-develop] JDBC Cancel request

[<Ste...@ha...>]

Hello Gerd,

thank you for the info.
I forwarded it to the support of Progress, they managed to reproduce the issue and will discuss it with their development.


Stefan


-----Original Message-----
From: Gerd Wagner [mailto:ger...@t-...] 
Sent: Samstag, 5. November 2016 11:42
To: Marquardt Stefan; squ...@li...
Subject: Re: [Squirrel-sql-develop] JDBC Cancel request

SQuirreL uses the mechanism you mention. Here is what it does in a bit of detail:
1. Queries are executed in separate threads which prevents SQuirreL from freezing and is needed to make the cancel button actually accessible.
2. When the cancel button is clicked another thread is started. In this thread statement.cancel() is called. If this thread does not finish within 1500 milli seconds a time out message is written to the message panel. But even if after the time out statement.cancel() succeed or fails an according message is written to the message panel.

The core of the implementation can bee seen here:
https://sourceforge.net/p/squirrel-sql/git/ci/master/tree/sql12/core/src/net/sourceforge/squirrel_sql/client/session/CancelStatementThread.java

So your problem I think should be different one. Could you please have a look at the logs after the problem appeared an see if there is more information. If so please post it.

Gerd



==================================
Hannover Rück SE, Handelsregister (Commercial Register) Hannover HRB 6778 / E+S Rückversicherung AG, Handelsregister (Commercial Register) Hannover HRB 6117; für beide Gesellschaften gilt (applicable to both companies): Karl-Wiechert-Allee 50, 30625 Hannover, Germany; Sitz (registered office) der Gesellschaften: Hannover; Aufsichtsrat (Supervisory Board): Herbert K. Haas (Vorsitzender/Chairman); Vorstand (Executive Board): Ulrich Wallin (Vorsitzender/Chairman), Sven Althoff*, Claude Chèvre*, Jürgen Gräber*, Dr. Klaus Miller, Dr. Michael Pickel, Roland Vogel (*nur Mitglied des Vorstands der Hannover Rück SE/member of the Hannover Rück SE Executive Board only)

Re: [Squirrel-sql-develop] JDBC Cancel request

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

SQuirreL uses the mechanism you mention. Here is what it does in a bit 
of detail:
1. Queries are executed in separate threads which prevents SQuirreL from 
freezing and is needed to make the cancel button actually accessible.
2. When the cancel button is clicked another thread is started. In this 
thread statement.cancel() is called. If this thread does not finish 
within 1500 milli seconds a time out message is written to the message 
panel. But even if after the time out statement.cancel() succeed or 
fails an according message is written to the message panel.

The core of the implementation can bee seen here:
https://sourceforge.net/p/squirrel-sql/git/ci/master/tree/sql12/core/src/net/sourceforge/squirrel_sql/client/session/CancelStatementThread.java

So your problem I think should be different one. Could you please have a 
look at the logs after the problem appeared an see if there is more 
information. If so please post it.

Gerd


Am 01.11.2016 um 07:37 schrieb Ste...@ha...:
> Hello,
>
> When I run a long query with aggregation cancel isn’t possible.
> The message is: not supported.
>
> It seems to be that it has to be called on another way because the manufacturer (Progress/OpenEdge) provided a KB:
>
> ----------------------------------------------------------------------------
>
> The client code is written in Java.
> The Connection object's abort() method is not supported.
>
> Assume an SQL query is initiated from Java.
> The Java code might look like the following:
>
> Assume a Connection object, connected to the database, exists. The instantiated Connection object is called myConnection.
> Assume the query is against the sports2000 database and the Customer table within the sports2000 database.
>
> Statement myStatement = null;
> String myQuery = "select * from PUB.Customer";
>
> try {
>         myStatement =   myConnection.createStatement().
>         ResultSet myRs = myStatement.executeQuery(myQuery );
>         /* The remainder of the try block processes what is returned by the SQL query. */
>       } CATCH {SQLException e) {
>         /* exception handling code */
>       } finally {
>           if (myStatement  != null) { myStatement.close();}
>       }
>
> ​
>
>
>
> Error Message
>
>
> Defect/Enhancement Number
>
> Cause
>
>
>
> Resolution
> In a separate thread, call the Statement object's cancel() method. The Statement object created in the thread that initiated the query must be passed to the separate thread that cancels the query. Assume myStatement is the Statement object. The separate thread should have a timeout associated with it to ensure it exits should the attempt to cancel the SQL query fail.
>
> A call to the Statement object's cancel method looks like the following:
>
> if (myStatement != null && !myStatement.isClosed())
> {
>     myStatement.cancel();
> }
>
> -------------------------------------------------------------------------------------------------
>
>
>
> Kind regards
>
> Stefan Marquardt, Information Technology, IT Domain Direct | Hannover Re, Karl-Wiechert-Allee 50, 30625 Hannover, Germany | phone +49 511 5604 2799, mob +49 172 7292066, fax +49 511 5604 4799, ste...@ha... |  www.hannover-re.com
>
>
> ==================================
> Hannover Rück SE, Handelsregister (Commercial Register) Hannover HRB 6778 / E+S Rückversicherung AG, Handelsregister (Commercial Register) Hannover HRB 6117; für beide Gesellschaften gilt (applicable to both companies): Karl-Wiechert-Allee 50, 30625 Hannover, Germany; Sitz (registered office) der Gesellschaften: Hannover; Aufsichtsrat (Supervisory Board): Herbert K. Haas (Vorsitzender/Chairman); Vorstand (Executive Board): Ulrich Wallin (Vorsitzender/Chairman), Sven Althoff*, Claude Chèvre*, Jürgen Gräber*, Dr. Klaus Miller, Dr. Michael Pickel, Roland Vogel (*nur Mitglied des Vorstands der Hannover Rück SE/member of the Hannover Rück SE Executive Board only)
>
>
>
> ------------------------------------------------------------------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
>
>
>
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

[Squirrel-sql-develop] JDBC Cancel request

[<Ste...@ha...>]

Hello,

When I run a long query with aggregation cancel isn’t possible.
The message is: not supported.

It seems to be that it has to be called on another way because the manufacturer (Progress/OpenEdge) provided a KB:

----------------------------------------------------------------------------

The client code is written in Java.
The Connection object's abort() method is not supported.

Assume an SQL query is initiated from Java. 
The Java code might look like the following:

Assume a Connection object, connected to the database, exists. The instantiated Connection object is called myConnection.
Assume the query is against the sports2000 database and the Customer table within the sports2000 database.

Statement myStatement = null;
String myQuery = "select * from PUB.Customer";

try {
        myStatement =   myConnection.createStatement().
        ResultSet myRs = myStatement.executeQuery(myQuery );
        /* The remainder of the try block processes what is returned by the SQL query. */
      } CATCH {SQLException e) {
        /* exception handling code */
      } finally {
          if (myStatement  != null) { myStatement.close();}
      }

​

 

Error Message


Defect/Enhancement Number

Cause



Resolution
In a separate thread, call the Statement object's cancel() method. The Statement object created in the thread that initiated the query must be passed to the separate thread that cancels the query. Assume myStatement is the Statement object. The separate thread should have a timeout associated with it to ensure it exits should the attempt to cancel the SQL query fail.

A call to the Statement object's cancel method looks like the following:

if (myStatement != null && !myStatement.isClosed())
{  
    myStatement.cancel();
}

-------------------------------------------------------------------------------------------------



Kind regards

Stefan Marquardt, Information Technology, IT Domain Direct | Hannover Re, Karl-Wiechert-Allee 50, 30625 Hannover, Germany | phone +49 511 5604 2799, mob +49 172 7292066, fax +49 511 5604 4799, ste...@ha... |  www.hannover-re.com


==================================
Hannover Rück SE, Handelsregister (Commercial Register) Hannover HRB 6778 / E+S Rückversicherung AG, Handelsregister (Commercial Register) Hannover HRB 6117; für beide Gesellschaften gilt (applicable to both companies): Karl-Wiechert-Allee 50, 30625 Hannover, Germany; Sitz (registered office) der Gesellschaften: Hannover; Aufsichtsrat (Supervisory Board): Herbert K. Haas (Vorsitzender/Chairman); Vorstand (Executive Board): Ulrich Wallin (Vorsitzender/Chairman), Sven Althoff*, Claude Chèvre*, Jürgen Gräber*, Dr. Klaus Miller, Dr. Michael Pickel, Roland Vogel (*nur Mitglied des Vorstands der Hannover Rück SE/member of the Hannover Rück SE Executive Board only)

[Squirrel-sql-develop] load testing using SQuirreL

[Ray M. <Ray...@si...>]

Hi!

I need to be able to open a large number of connections, and submit queries (selects at the moment), on all these connections, very quickly. What would be perfect is a script interface that would allow me to do these two steps many times.

Is there anything available now? If no, what is the closest we have now that I could build on?

Thanks!

Ray Malecki | Software Engineer | SirsiDynix
Phone 801.223.5296 | Ray...@Si...<mailto:Ray...@Si...>

[Squirrel-sql-develop] some PROCEDURE issues and one request regarding the Objects tree/panel

[martin v. d. <mar...@mo...>]

Dear SQuirreL developers,

I have found some PROCEDURE issues and one request regarding the Objects
tree/panel:

Issue-1:
Based on the boolean return value of call
DatabaseMetaData.supportsStoredProcedures() SQuirreL decides whether the
node PROCEDURE should be shown in the Objects tree pane.
See:
https://sourceforge.net/p/squirrel-sql/git/ci/4864dc6f625ac1d0fb3cd25f0d689d9d4070f945/tree/sql12/core/src/net/sourceforge/squirrel_sql/fw/sql/SQLDatabaseMetaData.java
and its ISQLDatabaseMetaData.java

However the JDBC method DatabaseMetaData.supportsStoredProcedures()
retrieves and returns whether this database supports stored procedure
calls THAT USE THE stored procedure ESCAPE SYNTAX. Not whether it
supports creation and calling of stored procedures!
See:
https://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#supportsStoredProcedures()

So a JDBC driver (and RDBMS) could support stored procedures but NOT
support the stored procedure escape syntax. It will return false for the
method DatabaseMetaData.supportsStoredProcedures().
In that case you should still show the PROCEDURE node in the Objects
tree pane.
Could you please improve this in SQuirreL, by removing the test on
squirrel_sql.fw.sql.SQLDatabaseMetaData.supportsStoredProcedures() value
when deciding whether the PROCEDURE node needs to be shown in the
Objects tree or not?

Also correct the incorrect text in interface
net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData for boolean
supportsStoredProcedures():
     * Retrieves whether this DBMS supports stored procedures. Cached on
first
     * call.
     *
     * @return  <TT>true</TT> if DBMS supports stored procedures.
and improve class
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData by not
overriding the values of Postgress and Netezza. They both probably
support stored procedures, but not the stored procedure escape syntax,
hence they correctly return false.


Issue-2:
Currently the procedures shown in the PROCEDURE node in the Objects tree
pane do not show the overloaded procedures, i.e. which have the same
name but different arguments. Only one entry is shown in the tree for an
overloaded procedure name. This should be corrected by showing all (as
returned by getProcedures()) procedure names. This will lead to
duplicate name entries in the tree-view. You can and should make this
unique by appending the value of the column SPECIFIC_NAME to the entry
name in the tree view or show a subtree of the overloaded variants
(using SPECIFIC_NAME values as entry name) for each procedure if it has
more than one overloaded procedure.
>From JDBC doc: SPECIFIC_NAME String => The name which uniquely
identifies this procedure within its schema.
See:
https://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getProcedures(java.lang.String,%20java.lang.String,%20java.lang.String)

Issue-3:
To view (in the Columns tab) the arguments of a selected procedure, you
will currently get all arguments of all overloaded procedures with the
same procedure name. This is the case in MonetDB which allows and stores
overloaded procedures (and functions) separately in the data dictiornary.
To show only the arguments/columns of a specific selected overloaded
procedure you will need to also filter the rows returned by
getProcedureColumns() to match the value of column SPECIFIC_NAME with
that of the value of SPECIFIC_NAME returned by getProcedures(), besides
filtering on the same catalog, schema, procedure name.
>From JDBC doc: SPECIFIC_NAME String => the name which uniquely
identifies this procedure within its schema.
See:
https://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getProcedureColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String)

FYI: In Latest MonetDB JDBC driver monetdb-jdbc-2.23.jar
(https://www.monetdb.org/downloads/Java/Jun2016-SP1/) this has been
implemented. The SPECIFIC_NAME columns now return the internal id of the
procedure such that any generic JDBC client programs can match the
correct arguments to a specific overloaded procedure as described by
JDBC API.
Note that in MonetDB the SPECIFIC_NAME contains only a unique id number,
not the name of the procedure or its complete signature. So it is wise
to show in the Objects tree both the PROCEDURE_NAME and the
SPECIFIC_NAME in the tree view entries. Structurally the SPECIFIC_NAME
is a subtree of the PROCEDURE_NAME entry, so if that could be
implemented it would be even better (more user friendly) for overloaded
procedures.


Request:
Besides SQL stored procedures, RDBMS also support SQL stored functions,
also called User Defined Functions (UDF).
These can be retrieved via methods DatabaseMetaData.getFunctions() and
DatabaseMetaData.getFunctionColumns() which have been introduced in Java
1.6.
See:
https://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getFunctions(java.lang.String,%20java.lang.String,%20java.lang.String)

For drivers which comply to JDBC 3.0 or higher (so getJDBCMajorVersion()
>= 3), could you add a FUNCTION node in the Objects tree pane and call
these methods, similar as done for Procedures and ProcedureColumns?
When implementing this new functionality please make sure overloaded
functions are correctly shown and accessable by including the value of
the SPECIFIC_NAME to avoid similar issues as explained above in issue-2
and issue-3.
>From JDBC doc: SPECIFIC_NAME String => the name which uniquely
identifies this function within its schema. This is a user specified, or
DBMS generated, name that may be different then the FUNCTION_NAME for
example with overload functions.


Note: as of Java 1.6 there is a new method
DatabaseMetaData.supportsStoredFunctionsUsingCallSyntax().
This returns whether this database supports invoking user-defined or
vendor functions using the stored procedure escape syntax.
See:
https://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#supportsStoredFunctionsUsingCallSyntax()
Similar to DatabaseMetaData.supportsStoredProcedures() this should NOT
be used to determine whether a JDBC driver and RDBMS supports Stored
Functions or UDFs at all, only to retrieve whether the escape syntax {fn
<function call> } is supported.


Hope this helps in improving SQuirreL.

Kind Regards,
Martin van Dinther