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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1, 2.1.1, 2.1.3, 2.1.4, 2.2
• Fix Version/s: 2.2
• Component/s: console
• Security Level: public (Regular issues)

Environment

Win XP, G 2.1 Tomcat

• Assignee: Unassigned
• Reporter: Vamsavardhana Reddy
• Created: 24/Feb/08 17:46
• Updated: 28/May/09 20:27
• Resolved: 28/May/09 20:27

Description

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:

<%-- 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>

Issue Links

• relates to: GERONIMO-4225 Allow Run SQL portlet run sql against any configured data source