squirrel-sql-develop Mailing List for SQuirreL SQL Client (Page 3)
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: Gerd W. <ger...@t-...> - 2018-07-29 20:11:11
|
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 |
From: Rony R. <ron...@gm...> - 2018-07-29 20:06:53
|
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 > |
From: Gerd W. <ger...@t-...> - 2018-07-29 20:05:20
|
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 |
From: Rony R. <ron...@gm...> - 2018-07-24 11:59:57
|
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. |
From: Rony R. <ron...@gm...> - 2018-07-23 22:02:45
|
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. |
From: <che...@wi...> - 2018-02-01 07:46:55
|
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 ______________________________________________________________________ |
From: Martin L. <la...@ru...> - 2017-09-19 13:16:20
|
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 |
From: Pavan K. <pav...@gm...> - 2017-07-07 08:45:20
|
Oh alright. Thanks for a speedy reply! Regards, Pavan Kumar K N |
From: Gerd W. <ger...@t-...> - 2017-07-06 18:55:03
|
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 |
From: Pavan K. <pav...@gm...> - 2017-07-06 10:37:08
|
Hi Guys, Is there a way to build queries containing subqueries in the Query Builder Plug-in in SQuirreL? Regards, Pavan Kumar K. N. |
From: Pavan K. <pav...@gm...> - 2017-07-03 15:24:17
|
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 |
From: Choong H. K. <ze...@gm...> - 2017-06-27 04:19:51
|
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 > |
From: Gerd W. <ger...@t-...> - 2017-06-26 20:16:38
|
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 |
From: Choong H. K. <ze...@gm...> - 2017-06-19 09:51:41
|
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 |
From: Neville R. <row...@ho...> - 2017-04-23 13:13:17
|
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 |
From: Kevin Xu <xu...@gm...> - 2017-04-17 02:39:08
|
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 * |
From: <Ste...@ha...> - 2016-11-10 13:24:05
|
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) |
From: Gerd W. <ger...@t-...> - 2016-11-05 10:41:41
|
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 > |
From: <Ste...@ha...> - 2016-11-01 07:04:38
|
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) |
From: Ray M. <Ray...@si...> - 2016-09-20 22:13:36
|
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.Malecki@SirsiDynix.com<mailto:Ray.Malecki@SirsiDynix.com> |
From: martin v. d. <mar...@mo...> - 2016-08-04 10:55:09
|
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 |
From: Gerd W. <ger...@t-...> - 2016-07-31 21:43:16
|
Am 29.07.2016 um 12:10 schrieb Ste...@ha...: > Hello, > > the session script plugin isn't really working. > https://sourceforge.net/p/squirrel-sql/bugs/1260/ > > I got the same error, it's copied to the sql editor but then I get an error message. > Are there any plans to integrate this to the main source? > > It would be helpful to set some connection settings first, like "set schema" or other things by default. Fix is available in current snapshot 20160731_2321. Gerd |
From: <Ste...@ha...> - 2016-07-29 10:36:23
|
Hello, the session script plugin isn't really working. https://sourceforge.net/p/squirrel-sql/bugs/1260/ I got the same error, it's copied to the sql editor but then I get an error message. Are there any plans to integrate this to the main source? It would be helpful to set some connection settings first, like "set schema" or other things by default. Stefan ================================== 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) |
From: Ralph <dwi...@em...> - 2016-07-12 12:55:58
|
-- We offer all types of Loan |
From: Narendra R. <nar...@gm...> - 2016-07-08 16:23:44
|
Hi, I have been using DB Squirrel for connecting to Oracle and now that I want to create a procedure with a parameter and call that , i have no problem with the compilation but getting error while calling the same procedure with the parameter. Please help me in using that, or is that not possible to call a procedure suing db squirrel. Thanks & Regards Narendra Reddy |