You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@geronimo.apache.org by "Michal Borowiecki (JIRA)" <ji...@apache.org> on 2008/08/04 15:00:44 UTC
[jira] Created: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Allow Run SQL portlet run sql against any configured data source
----------------------------------------------------------------
Key: GERONIMO-4225
URL: https://issues.apache.org/jira/browse/GERONIMO-4225
Project: Geronimo
Issue Type: Improvement
Security Level: public (Regular issues)
Components: databases
Affects Versions: 2.1.1
Reporter: Michal Borowiecki
Priority: Minor
Currently Run SQL portlet allows only running queries against internal Derby databases.
It would be very useful if it allowed to run SQL against any of the datasources configured.
Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Michal Borowiecki (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12636052#action_12636052 ]
Michal Borowiecki commented on GERONIMO-4225:
---------------------------------------------
Sounds reasonable :)
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Assignee: Donald Woods
> Priority: Minor
> Fix For: 2.1.4, 2.2
>
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods closed GERONIMO-4225.
----------------------------------
Resolution: Fixed
Updated Run SQL portlet code so it can be used on both the DB Manager page for databases and the DB Pool page for datasources by using a portlet init-param. Also updated the DBManagerTest and DatabasePoolTest with some explicit tests for the RunSQL portlet.
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Assignee: Donald Woods
> Priority: Minor
> Fix For: 2.1.4, 2.2
>
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Michal Borowiecki (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12620909#action_12620909 ]
Michal Borowiecki commented on GERONIMO-4225:
---------------------------------------------
The trunk patch (sysdb-portlets-trunk.patch) can also be used to patch the recent 2.1.2 release.
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Priority: Minor
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods reopened GERONIMO-4225:
------------------------------------
After thinking about this for awhile (and trying to fix a testsuite failure) it doesn't make sense to update the Run SQL support in the DB Manager portlet to use DataSources, as this portlet is only to be used with the embedded Derby system db.
The Run SQL support for datasources should really be added to the Database Pools portlet, which is adding/deleting/configuring DataSources....
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Assignee: Donald Woods
> Priority: Minor
> Fix For: 2.1.4, 2.2
>
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Michal Borowiecki (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12619498#action_12619498 ]
Michal Borowiecki commented on GERONIMO-4225:
---------------------------------------------
The patch also makes Run SQL portlet keep the selected db and query text across "Run SQL" invocations to make it easier to run a query multiple times (possibly correcting the query text). Previously the query text and database selection were discarded making it difficult to test a query.
Also the patch fixes a bug in Run SQL and DB Viewer which prevented the portlets from working in maximized mode.
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Priority: Minor
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated GERONIMO-4225:
-----------------------------------
Fix Version/s: 2.2
2.1.4
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Assignee: Joe Bohn
> Priority: Minor
> Fix For: 2.1.4, 2.2
>
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods reassigned GERONIMO-4225:
--------------------------------------
Assignee: Donald Woods (was: Joe Bohn)
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Assignee: Donald Woods
> Priority: Minor
> Fix For: 2.1.4, 2.2
>
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Michal Borowiecki (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michal Borowiecki updated GERONIMO-4225:
----------------------------------------
Attachment: sysdb-portlets-2.1.1.patch
sysdb-portlets-trunk.patch
patches for trunk and for the latest released version (2.1.1)
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Priority: Minor
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods closed GERONIMO-4225.
----------------------------------
Resolution: Fixed
patch applied to branches/2.1 and trunk
Michal, thanks for the patch.
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Assignee: Donald Woods
> Priority: Minor
> Fix For: 2.1.4, 2.2
>
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (GERONIMO-4225) Allow Run SQL portlet run sql
against any configured data source
Posted by "Joe Bohn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GERONIMO-4225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Joe Bohn reassigned GERONIMO-4225:
----------------------------------
Assignee: Joe Bohn
> Allow Run SQL portlet run sql against any configured data source
> ----------------------------------------------------------------
>
> Key: GERONIMO-4225
> URL: https://issues.apache.org/jira/browse/GERONIMO-4225
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: databases
> Affects Versions: 2.1.1
> Reporter: Michal Borowiecki
> Assignee: Joe Bohn
> Priority: Minor
> Attachments: sysdb-portlets-2.1.1.patch, sysdb-portlets-trunk.patch
>
>
> Currently Run SQL portlet allows only running queries against internal Derby databases.
> It would be very useful if it allowed to run SQL against any of the datasources configured.
> Create DB and Delete DB features are Derby specific, Use DB on the other hand can be easily generalized to use any data source.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.