Thread: [Squirrel-sql-develop] Procedure execution plugin
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Subhabrata B. <sub...@gm...> - 2011-08-05 10:44:01
|
Hi, I needed a plugin for executing stored procedures in our Oracle database. I have developed the same and wish to contribute it back to the community. I had access to an Oracle database only - I have not tested this on any other database. However, I stuck to standard JDBC calls only in order to maximize its chances of working with other databases too. Is this plugin interesting to the community? If yes, how do I contribute it? In the process I have found a bug in core Squirrel SQL too (problems when a custom IMainPanelTab is closed - entry is removed from _tabPnl and not from _tabs in MainPanel::removeMainpanelTab()). Where do I report this bug? Best regards, -- Subhabrata Biswas |
From: Robert M. <rob...@gm...> - 2011-08-05 11:14:16
|
Hello, The Oracle plugin that ships with SQuirreL today allows you to execute stored procedures from the SQL editor. Can you give it a try and tell us how your plugin is different or does a better job of it ? For bug reports you can file them here: http://sourceforge.net/tracker/?group_id=28383&atid=393414 Rob On Fri, Aug 5, 2011 at 6:43 AM, Subhabrata Biswas < sub...@gm...> wrote: > Hi, > > I needed a plugin for executing stored procedures in our Oracle > database. I have developed the same and wish to contribute it back to > the community. > > I had access to an Oracle database only - I have not tested this on > any other database. However, I stuck to standard JDBC calls only in > order to maximize its chances of working with other databases too. > > Is this plugin interesting to the community? If yes, how do I contribute > it? > > In the process I have found a bug in core Squirrel SQL too (problems > when a custom IMainPanelTab is closed - entry is removed from _tabPnl > and not from _tabs in MainPanel::removeMainpanelTab()). Where do I > report this bug? > > Best regards, > > -- Subhabrata Biswas > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1 > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
From: Subhabrata B. <sub...@gm...> - 2011-08-05 16:03:27
|
Hi Rob, I guess the Oracle plugin let's you execute procedures that don't have OUT parameters? Or did I get that wrong? I could not find a way to do that and hence wrote this plugin. This plugin shows the parameters in a table - let's you enter the values for input arguments and when you execute the SP, it shows the values of the OUT variables in the same table. Regards, -- Subhabrata On Fri, Aug 5, 2011 at 4:44 PM, Robert Manning <rob...@gm...> wrote: > Hello, > > The Oracle plugin that ships with SQuirreL today allows you to execute > stored procedures from the SQL editor. Can you give it a try and tell us > how your plugin is different or does a better job of it ? > > For bug reports you can file them here: > > http://sourceforge.net/tracker/?group_id=28383&atid=393414 > > Rob > > On Fri, Aug 5, 2011 at 6:43 AM, Subhabrata Biswas > <sub...@gm...> wrote: >> >> Hi, >> >> I needed a plugin for executing stored procedures in our Oracle >> database. I have developed the same and wish to contribute it back to >> the community. >> >> I had access to an Oracle database only - I have not tested this on >> any other database. However, I stuck to standard JDBC calls only in >> order to maximize its chances of working with other databases too. >> >> Is this plugin interesting to the community? If yes, how do I contribute >> it? >> >> In the process I have found a bug in core Squirrel SQL too (problems >> when a custom IMainPanelTab is closed - entry is removed from _tabPnl >> and not from _tabs in MainPanel::removeMainpanelTab()). Where do I >> report this bug? >> >> Best regards, >> >> -- Subhabrata Biswas >> >> >> ------------------------------------------------------------------------------ >> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA >> The must-attend event for mobile developers. Connect with experts. >> Get tools for creating Super Apps. See the latest technologies. >> Sessions, hands-on labs, demos & much more. Register early & save! >> http://p.sf.net/sfu/rim-blackberry-1 >> _______________________________________________ >> Squirrel-sql-develop mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > > |
From: Robert M. <rob...@gm...> - 2011-08-05 18:52:34
|
You are correct - the current Oracle plugin doesn't have the functionality that you've described. Please submit a patch for your plugin here: http://sourceforge.net/tracker/?group_id=28383&atid=393416 You can attach the files that you want to contribute there in an archive file. We can then take a look at how to integrate it into the existing Oracle plugin or add it to the distro as a separate plugin. Rob On Fri, Aug 5, 2011 at 12:03 PM, Subhabrata Biswas < sub...@gm...> wrote: > Hi Rob, > > I guess the Oracle plugin let's you execute procedures that don't have > OUT parameters? Or did I get that wrong? I could not find a way to do > that and hence wrote this plugin. This plugin shows the parameters in > a table - let's you enter the values for input arguments and when you > execute the SP, it shows the values of the OUT variables in the same > table. > > Regards, > > -- Subhabrata > > > On Fri, Aug 5, 2011 at 4:44 PM, Robert Manning > <rob...@gm...> wrote: > > Hello, > > > > The Oracle plugin that ships with SQuirreL today allows you to execute > > stored procedures from the SQL editor. Can you give it a try and tell us > > how your plugin is different or does a better job of it ? > > > > For bug reports you can file them here: > > > > http://sourceforge.net/tracker/?group_id=28383&atid=393414 > > > > Rob > > > > On Fri, Aug 5, 2011 at 6:43 AM, Subhabrata Biswas > > <sub...@gm...> wrote: > >> > >> Hi, > >> > >> I needed a plugin for executing stored procedures in our Oracle > >> database. I have developed the same and wish to contribute it back to > >> the community. > >> > >> I had access to an Oracle database only - I have not tested this on > >> any other database. However, I stuck to standard JDBC calls only in > >> order to maximize its chances of working with other databases too. > >> > >> Is this plugin interesting to the community? If yes, how do I contribute > >> it? > >> > >> In the process I have found a bug in core Squirrel SQL too (problems > >> when a custom IMainPanelTab is closed - entry is removed from _tabPnl > >> and not from _tabs in MainPanel::removeMainpanelTab()). Where do I > >> report this bug? > >> > >> Best regards, > >> > >> -- Subhabrata Biswas > >> > >> > >> > ------------------------------------------------------------------------------ > >> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > >> The must-attend event for mobile developers. Connect with experts. > >> Get tools for creating Super Apps. See the latest technologies. > >> Sessions, hands-on labs, demos & much more. Register early & save! > >> http://p.sf.net/sfu/rim-blackberry-1 > >> _______________________________________________ > >> Squirrel-sql-develop mailing list > >> Squ...@li... > >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > > > > > |
From: John H. <jh...@im...> - 2011-08-05 21:14:37
|
On Fri, 5 Aug 2011, Robert Manning wrote: >> This plugin shows the parameters in a table - let's you enter the >> values for input arguments and when you execute the SP, it shows the >> values of the OUT variables in the same table. > You are correct - the current Oracle plugin doesn't have the functionality > that you've described. That sounds to me like a very attractive way to run SPs/functions with _any_ backend. I would hope that it's generalizable. Does it also display the return code of the SP/function? That's useful to know, too... -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Gun Control: The theory that a woman found dead in an alley, raped and strangled with her panty hose, is somehow morally superior to a woman explaining to police how her attacker got that fatal bullet wound. -- L. Neil Smith ----------------------------------------------------------------------- Today: the 276th anniversary of John Peter Zenger's acquittal |
From: Dennis D. <zin...@ya...> - 2011-08-06 19:35:11
|
I'm wondering if Subhabrata's code would work with Teradata stored procedures since only standard jdbc calls were used. Does anyone use Squirrel with Teradata? There doesn't seem to be a Teradata plugin. Is anyone working on one? -Dennis ________________________________ From: Robert Manning <rob...@gm...> To: Subhabrata Biswas <sub...@gm...> Cc: squ...@li... Sent: Friday, August 5, 2011 2:52 PM Subject: Re: [Squirrel-sql-develop] Procedure execution plugin You are correct - the current Oracle plugin doesn't have the functionality that you've described. Please submit a patch for your plugin here: http://sourceforge.net/tracker/?group_id=28383&atid=393416 You can attach the files that you want to contribute there in an archive file. We can then take a look at how to integrate it into the existing Oracle plugin or add it to the distro as a separate plugin. Rob On Fri, Aug 5, 2011 at 12:03 PM, Subhabrata Biswas < sub...@gm...> wrote: > Hi Rob, > > I guess the Oracle plugin let's you execute procedures that don't have > OUT parameters? Or did I get that wrong? I could not find a way to do > that and hence wrote this plugin. This plugin shows the parameters in > a table - let's you enter the values for input arguments and when you > execute the SP, it shows the values of the OUT variables in the same > table. > > Regards, > > -- Subhabrata > > > On Fri, Aug 5, 2011 at 4:44 PM, Robert Manning > <rob...@gm...> wrote: > > Hello, > > > > The Oracle plugin that ships with SQuirreL today allows you to execute > > stored procedures from the SQL editor. Can you give it a try and tell us > > how your plugin is different or does a better job of it ? > > > > For bug reports you can file them here: > > > > http://sourceforge.net/tracker/?group_id=28383&atid=393414 > > > > Rob > > > > On Fri, Aug 5, 2011 at 6:43 AM, Subhabrata Biswas > > <sub...@gm...> wrote: > >> > >> Hi, > >> > >> I needed a plugin for executing stored procedures in our Oracle > >> database. I have developed the same and wish to contribute it back to > >> the community. > >> > >> I had access to an Oracle database only - I have not tested this on > >> any other database. However, I stuck to standard JDBC calls only in > >> order to maximize its chances of working with other databases too. > >> > >> Is this plugin interesting to the community? If yes, how do I contribute > >> it? > >> > >> In the process I have found a bug in core Squirrel SQL too (problems > >> when a custom IMainPanelTab is closed - entry is removed from _tabPnl > >> and not from _tabs in MainPanel::removeMainpanelTab()). Where do I > >> report this bug? > >> > >> Best regards, > >> > >> -- Subhabrata Biswas > >> > >> > >> > ------------------------------------------------------------------------------ > >> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > >> The must-attend event for mobile developers. Connect with experts. > >> Get tools for creating Super Apps. See the latest technologies. > >> Sessions, hands-on labs, demos & much more. Register early & save! > >> http://p.sf.net/sfu/rim-blackberry-1 > >> _______________________________________________ > >> Squirrel-sql-develop mailing list > >> Squ...@li... > >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > > > > > ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ Squirrel-sql-develop mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop |
From: Vladimir K. <vla...@ko...> - 2011-08-08 07:34:15
|
Hi, > Does anyone use Squirrel with Teradata? > There doesn't seem to be a Teradata plugin. Is anyone working on one? I use Squirrel with Teradata quite often, and yes, it would be great to have Teradata plugin available. I have also noticed Squirrel does not display Teradata macros (used more often than stored procedures in td, imo) in object tree view. Other td specific functionality I miss in Squirel concerns displaying object references and space summary or by amp. On Sat, Aug 6, 2011 at 10:35 PM, Dennis DiMaria <zin...@ya...> wrote: > I'm wondering if Subhabrata's code would work with Teradata stored procedures since only standard jdbc calls were used. > > Does anyone use Squirrel with Teradata? There doesn't seem to be a Teradata plugin. Is anyone working on one? > > -Dennis > > > > ________________________________ > From: Robert Manning <rob...@gm...> > To: Subhabrata Biswas <sub...@gm...> > Cc: squ...@li... > Sent: Friday, August 5, 2011 2:52 PM > Subject: Re: [Squirrel-sql-develop] Procedure execution plugin > > You are correct - the current Oracle plugin doesn't have the functionality > that you've described. Please submit a patch for your plugin here: > > http://sourceforge.net/tracker/?group_id=28383&atid=393416 > > You can attach the files that you want to contribute there in an archive > file. We can then take a look at how to integrate it into the existing > Oracle plugin or add it to the distro as a separate plugin. > > Rob > > On Fri, Aug 5, 2011 at 12:03 PM, Subhabrata Biswas < > sub...@gm...> wrote: > >> Hi Rob, >> >> I guess the Oracle plugin let's you execute procedures that don't have >> OUT parameters? Or did I get that wrong? I could not find a way to do >> that and hence wrote this plugin. This plugin shows the parameters in >> a table - let's you enter the values for input arguments and when you >> execute the SP, it shows the values of the OUT variables in the same >> table. >> >> Regards, >> >> -- Subhabrata >> >> >> On Fri, Aug 5, 2011 at 4:44 PM, Robert Manning >> <rob...@gm...> wrote: >> > Hello, >> > >> > The Oracle plugin that ships with SQuirreL today allows you to execute >> > stored procedures from the SQL editor. Can you give it a try and tell us >> > how your plugin is different or does a better job of it ? >> > >> > For bug reports you can file them here: >> > >> > http://sourceforge.net/tracker/?group_id=28383&atid=393414 >> > >> > Rob >> > >> > On Fri, Aug 5, 2011 at 6:43 AM, Subhabrata Biswas >> > <sub...@gm...> wrote: >> >> >> >> Hi, >> >> >> >> I needed a plugin for executing stored procedures in our Oracle >> >> database. I have developed the same and wish to contribute it back to >> >> the community. >> >> >> >> I had access to an Oracle database only - I have not tested this on >> >> any other database. However, I stuck to standard JDBC calls only in >> >> order to maximize its chances of working with other databases too. >> >> >> >> Is this plugin interesting to the community? If yes, how do I contribute >> >> it? >> >> >> >> In the process I have found a bug in core Squirrel SQL too (problems >> >> when a custom IMainPanelTab is closed - entry is removed from _tabPnl >> >> and not from _tabs in MainPanel::removeMainpanelTab()). Where do I >> >> report this bug? >> >> >> >> Best regards, >> >> >> >> -- Subhabrata Biswas >> >> >> >> >> >> >> ------------------------------------------------------------------------------ >> >> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA >> >> The must-attend event for mobile developers. Connect with experts. >> >> Get tools for creating Super Apps. See the latest technologies. >> >> Sessions, hands-on labs, demos & much more. Register early & save! >> >> http://p.sf.net/sfu/rim-blackberry-1 >> >> _______________________________________________ >> >> Squirrel-sql-develop mailing list >> >> Squ...@li... >> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop >> > >> > >> > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1 > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1 > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
From: Subhabrata B. <sub...@gm...> - 2011-08-07 20:12:04
|
Thank you John, Dennis and Rob for taking the time to respond to my mails. I believe the code is generic and should work with many databases - it will be great if you can test and verify - I can't do that since I don't have access to any database other than Oracle at the moment. I'll be, of course, willing to fix any issues that you may find. I'll post a screenshot tomorrow. It'll take me a day to package things properly and submit the code. Rob: I believe it should be a separate plugin since it can work with many databases. John: the CallableStatement::execute() method returns a boolean and no other code. Are you referring to some other API? Please let me know and I'll look into it. This plugin does not show any resultset returned by an SP that some databases allow. Regards, -- Subhabrata On Sat, Aug 6, 2011 at 2:44 AM, John Hardin <jh...@im...> wrote: > On Fri, 5 Aug 2011, Robert Manning wrote: > >>> This plugin shows the parameters in a table - let's you enter the >>> values for input arguments and when you execute the SP, it shows the >>> values of the OUT variables in the same table. > >> You are correct - the current Oracle plugin doesn't have the functionality >> that you've described. > > That sounds to me like a very attractive way to run SPs/functions with > _any_ backend. I would hope that it's generalizable. > > Does it also display the return code of the SP/function? That's useful to > know, too... > > -- > John Hardin KA7OHZ http://www.impsec.org/~jhardin/ > jh...@im... FALaholic #11174 pgpk -a jh...@im... > key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 > ----------------------------------------------------------------------- > Gun Control: The theory that a woman found dead in an alley, raped > and strangled with her panty hose, is somehow morally superior to > a woman explaining to police how her attacker got that fatal bullet > wound. -- L. Neil Smith > ----------------------------------------------------------------------- > Today: the 276th anniversary of John Peter Zenger's acquittal > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1 > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
From: John H. <jh...@im...> - 2011-08-07 20:24:28
|
On Mon, 8 Aug 2011, Subhabrata Biswas wrote: > John: the CallableStatement::execute() method returns a boolean and no > other code. Are you referring to some other API? Please let me know > and I'll look into it. Sadly, I'm not familiar with JDBC, but the documentation for CallableStatement::execute() says: This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. ...so it may be that with Oracle (where SPs do not return anything) it's only returning a boolean. Have you tried using your plugin to call an Oracle function that returns (say) a string of characters? > This plugin does not show any resultset returned by an SP that some > databases allow. _That_ I wouldn't expect support for. If you're going to call an SP that returns result set(s), do it in the regular query window. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Ignorance is no excuse for a law. ----------------------------------------------------------------------- 8 days until the 66th anniversary of the end of World War II |