Return-Path: Delivered-To: apmail-geronimo-dev-archive@www.apache.org Received: (qmail 27032 invoked from network); 18 Nov 2010 16:03:11 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 18 Nov 2010 16:03:11 -0000 Received: (qmail 91398 invoked by uid 500); 18 Nov 2010 16:03:42 -0000 Delivered-To: apmail-geronimo-dev-archive@geronimo.apache.org Received: (qmail 91296 invoked by uid 500); 18 Nov 2010 16:03:40 -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 91288 invoked by uid 99); 18 Nov 2010 16:03:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Nov 2010 16:03:39 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Nov 2010 16:03:36 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id oAIG3DT3023800 for ; Thu, 18 Nov 2010 16:03:14 GMT Message-ID: <31052095.176731290096193740.JavaMail.jira@thor> Date: Thu, 18 Nov 2010 11:03:13 -0500 (EST) From: "viola.lu (JIRA)" To: dev@geronimo.apache.org Subject: [jira] Updated: (GERONIMO-5706) When derby authentication is disabled, DB manager portlet run SQL error: Caused by: java.sql.SQLException: Schema 'DBADMIN' does not exist In-Reply-To: <9899960.171311290070214245.JavaMail.jira@thor> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/GERONIMO-5706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] viola.lu updated GERONIMO-5706: ------------------------------- Attachment: G5706.patch Apply it to 21/22, thanks. > When derby authentication is disabled, DB manager portlet run SQL error: Caused by: java.sql.SQLException: Schema 'DBADMIN' does not exist > ------------------------------------------------------------------------------------------------------------------------------------------ > > Key: GERONIMO-5706 > URL: https://issues.apache.org/jira/browse/GERONIMO-5706 > Project: Geronimo > Issue Type: Bug > Security Level: public(Regular issues) > Components: databases > Affects Versions: 2.1.7, 2.2.1 > Environment: windows x86 > sun java 1.5.0_22 > Reporter: Forrest Xia > Assignee: viola.lu > Attachments: G5706.patch > > > Steps: > 1. Get the latest 2.1.7 snapshot build > 2. set env variable to disable derby authentication > C:\> set GERONIMO_OPTS=-Dderby.connection.requireAuthentication=false > 3. start server > 4. login admin console, go to DB Manager portlet to create a database > 5. Execute these SQLs on the created derby db > create table name (name varchar(10)); > insert into name values ('Tom'); > 6. Issue a select statement with DB manager portlet > select * from name > Then an exception like as below throws out: > javax.portlet.PortletException > at org.apache.pluto.internal.impl.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:113) > at org.apache.geronimo.console.internaldb.RunSQLPortlet.doView(RunSQLPortlet.java:146) > at javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:247) > at javax.portlet.GenericPortlet.render(GenericPortlet.java:175) > at org.apache.geronimo.console.BasePortlet.render(BasePortlet.java:144) > at org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:208) > at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:139) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:693) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:806) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) > at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) > at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) > at org.apache.pluto.core.DefaultPortletInvokerService.invoke(DefaultPortletInvokerService.java:167) > at org.apache.pluto.core.DefaultPortletInvokerService.render(DefaultPortletInvokerService.java:101) > at org.apache.pluto.core.PortletContainerImpl.doRender(PortletContainerImpl.java:173) > at org.apache.pluto.driver.tags.PortletTag.doStartTag(PortletTag.java:152) > at jsp.WEB_002dINF.themes.portlet_002dskin_jsp._jspService(portlet_002dskin_jsp.java:102) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:806) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) > at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) > at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) > at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:968) > at jsp.WEB_002dINF.themes.default_002dtheme_jsp._jspx_meth_c_005fforEach_005f0(default_002dtheme_jsp.java:215) > at jsp.WEB_002dINF.themes.default_002dtheme_jsp._jspService(default_002dtheme_jsp.java:120) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:806) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) > at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) > at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) > at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) > at org.apache.pluto.driver.PortalDriverServlet.doGet(PortalDriverServlet.java:151) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:693) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:806) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.apache.geronimo.console.filter.PlutoURLRebuildFilter.doFilter(PlutoURLRebuildFilter.java:48) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.apache.geronimo.console.filter.XSSXSRFFilter.doFilter(XSSXSRFFilter.java:130) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56) > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) > at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:406) > at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:47) > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555) > at org.apache.geronimo.tomcat.valve.ThreadCleanerValve.invoke(ThreadCleanerValve.java:40) > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > at java.lang.Thread.run(Unknown Source) > Caused by: java.sql.SQLException: Schema 'DBADMIN' does not exist > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(Unknown Source) > at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) > at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:222) > at jsp.WEB_002dINF.view.internaldb.runSQLNormal_jsp._jspService(runSQLNormal_jsp.java:268) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:806) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) > at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) > at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) > at org.apache.pluto.internal.impl.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:106) > ... 63 more > Caused by: ERROR 42Y07: Schema 'DBADMIN' does not exist > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source) > at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source) > at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source) > at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source) > at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source) > at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source) > at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source) > at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source) > at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) > at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) > at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) > at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) > at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) > ... 79 more -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.