[jira] Reopened: (GERONIMO-4225) Allow Run SQL portlet run sql against any configured data source

["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.