Return-Path: Delivered-To: apmail-geronimo-dev-archive@www.apache.org Received: (qmail 11195 invoked from network); 26 Apr 2007 22:00:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Apr 2007 22:00:40 -0000 Received: (qmail 68974 invoked by uid 500); 26 Apr 2007 22:00:45 -0000 Delivered-To: apmail-geronimo-dev-archive@geronimo.apache.org Received: (qmail 68933 invoked by uid 500); 26 Apr 2007 22:00:44 -0000 Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: dev@geronimo.apache.org List-Id: Delivered-To: mailing list dev@geronimo.apache.org Received: (qmail 68922 invoked by uid 99); 26 Apr 2007 22:00:44 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Apr 2007 15:00:44 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Apr 2007 15:00:37 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 97CCF714049 for ; Thu, 26 Apr 2007 15:00:15 -0700 (PDT) Message-ID: <7709364.1177624815344.JavaMail.jira@brutus> Date: Thu, 26 Apr 2007 15:00:15 -0700 (PDT) From: "Joe Bohn (JIRA)" To: dev@geronimo.apache.org Subject: [jira] Commented: (GERONIMO-3051) DB Viewer portlet error In-Reply-To: <28399985.1175282425143.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/GERONIMO-3051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492126 ] Joe Bohn commented on GERONIMO-3051: ------------------------------------ I had mixed results. One test that I thought was failing earlier did work after I applied the patch (sans the tld code). However when I attempted to run all of the jstl tests I had several failures like that below. I also didn't get to change the URLs for the console yet to see if it would work properly with the new driver. I'll try that later tonight. Here's the error on the other jstl tests: 04-26-2007 17:44:23: ERROR: [WebValidatorBase] Unexpected '500' received from target server! Error response recieved from server: ------------------------------------------------ Apache Tomcat/6.0-snapshot - Error report

HTTP Status 500 -

type Except ion report

message

description The server encountered an internal error () that prevented i t from fulfilling this request.

exception 

javax.servlet.ServletException: Unable to get connection, DataSo
urce invalid: "java.sql.SQLException: Could not look up datasource"
        org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
        org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
        org.apache.jsp.positiveDateParamQueryTimestampTest_jsp._jspService(positiveDateParamQueryTimestampTest_jsp.java:268)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:379)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
        com.sun.ts.tests.jstl.common.filters.JstlDbFilter.doFilter(JstlDbFilter.java:109)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0-snapshot logs.

< HR size="1" noshade="noshade">

Apache Tomcat/6.0-snapshot

04-26-2007 17:44:23: ERROR: Exception at: 04-26-2007 17:44:23: ERROR: com.sun.ts.tests.common.webclient.TestFailureException: Test FAILED! at com.sun.ts.tests.common.webclient.WebTestCase.execute(WebTestCase.java:164) at com.sun.ts.tests.common.webclient.BaseUrlClient.invoke(BaseUrlClient.java:389) at com.sun.ts.tests.jstl.compat.onedotzero.JSTLClient.positiveDateParamQueryTimestampTest(JSTLClient.java:117) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sun.ts.lib.harness.EETest.run(EETest.java:495) at com.sun.ts.lib.harness.EETest.getPropsReady(EETest.java:392) at com.sun.ts.lib.harness.EETest.run(EETest.java:252) at com.sun.ts.tests.jstl.compat.onedotzero.JSTLClient.run(JSTLClient.java:54) at com.sun.ts.tests.jstl.compat.onedotzero.JSTLClient.main(JSTLClient.java:40) 04-26-2007 17:44:23: [BaseUrlClient] Test cleanup OK > DB Viewer portlet error > ----------------------- > > Key: GERONIMO-3051 > URL: https://issues.apache.org/jira/browse/GERONIMO-3051 > Project: Geronimo > Issue Type: Bug > Security Level: public(Regular issues) > Components: console, databases > Affects Versions: 2.0-M4 > Environment: embedded Derby databases > Reporter: Hernan Cunico > Assigned To: Joe Bohn > Attachments: GERONIMO-3051-jdbc.patch, GERONIMO-3051-new.patch, GERONIMO-3051.patch > > > There is a problem when trying to view an embedded Derby database. > I am able to successfully create a new DB with the DB manager and a new entry appears in the DB Viewer but when I try to view that DB from the DB Viewer I get a portlet error. > When I check the logs I get this: > 09:57:02,421 ERROR [listTables_jsp]] Servlet.service() for servlet jsp.WEB_002dINF.view.internaldb.listTables_jsp threw exception > javax.servlet.ServletException: javax.servlet.jsp.JspTagException: Error getting connection: "java.sql.SQLException: No suitable driver" > ... > 09:57:02,421 ERROR [[DBViewer]] Servlet.service() for servlet DBViewer threw exception > javax.servlet.ServletException > ... > 09:57:02,453 ERROR [PortletInvokerImpl] PortletInvokerImpl.render() - Error while dispatching portlet. > javax.portlet.PortletException > ... > With the exception of the "SystemDatabase" all the other databases created on the embedded Derby are also unaccessible from other applications. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.