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

David Jencks commented on GERONIMO-3875:
----------------------------------------

I've never understood the thinking behind the DB viewer portlet.  I've always 
wanted it to use the database pools running in the server rather than 
connecting to the database directly.  So I would prefer it if the only way to 
look at a database was through a running database pool.  In any case perhaps if 
we keep the current option  of direct connection we could have a  choice 
between direct connection or selecting from an existing pool?  I haven't looked 
at your patch..... I would think that selecting the connection manager or MCF 
name would avoid ambiguity.

with  this approach would we be able to  work with non-derby databases?

> 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
>            Assignee: Vamsavardhana Reddy
>             Fix For: 2.1.1, 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.

Reply via email to