geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michal Borowiecki (JIRA)" <j...@apache.org>
Subject [jira] Commented: (GERONIMO-3875) Enabling authentication for Derby renders DB Viewer portlet unusable for all db's except SystemDatabase
Date Mon, 04 Aug 2008 13:20:44 GMT

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


Mime
View raw message