[jira] Commented: (GERONIMO-3875) Enabling authentication for Derby renders DB Viewer portlet unusable for all db's except SystemDatabase

["Michal Borowiecki (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GERONIMO-3875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12619502#action_12619502 ] 

Michal Borowiecki commented on GERONIMO-3875:
---------------------------------------------

I created a patch allowing Run SQL portlet to execute queries against any datasource (including non-derby): GERONIMO-4225

Making DB Viewer work with non-derby databases will be much trickier, because it would require a portable way to list database tables (currently a Derby-specific approach of querying sys.systables is used)


> Enabling authentication for Derby renders DB Viewer portlet unusable for all db's except SystemDatabase
> -------------------------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-3875
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-3875
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: console
>    Affects Versions: 2.1, 2.1.1, 2.2
>         Environment: Win XP, G 2.1 Tomcat
>            Reporter: Vamsavardhana Reddy
>             Fix For: 2.1.3, 2.2
>
>         Attachments: GERONIMO-3875.patch
>
>
> After enabling  authentication for Derby, I am noticing that DB Viewer portlet is unable to work with any database other that SystemDatabase.
> listTables.jsp has the following code:
> {code}
> <%-- Datasource --%>
> <c:if test="${ds == null}">
>     <%-- Create the connection manually --%>
>     <sql:setDataSource
>       var="ds"
>       driver="org.apache.derby.jdbc.EmbeddedDriver"
>       url="jdbc:derby:${db};create=true"
>       user=""
>       password=""
>     />
> </c:if>
> {code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.