Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 28696 invoked from network); 5 Jul 2006 11:47:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Jul 2006 11:47:29 -0000 Received: (qmail 94636 invoked by uid 500); 5 Jul 2006 11:47:27 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 94315 invoked by uid 500); 5 Jul 2006 11:47:26 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 94304 invoked by uid 99); 5 Jul 2006 11:47:25 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Jul 2006 04:47:25 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [209.68.5.17] (HELO relay03.pair.com) (209.68.5.17) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 05 Jul 2006 04:47:24 -0700 Received: (qmail 57780 invoked from network); 5 Jul 2006 11:47:02 -0000 Received: from unknown (HELO ?10.0.0.7?) (unknown) by unknown with SMTP; 5 Jul 2006 11:47:02 -0000 X-pair-Authenticated: 220.247.251.171 Message-ID: <44ABA6B3.4030506@opensource.lk> Date: Wed, 05 Jul 2006 17:16:59 +0530 From: Lasantha Ranaweera User-Agent: Thunderbird 1.5.0.2 (X11/20060522) MIME-Version: 1.0 To: user@geronimo.apache.org Subject: Re: Is this due to a problem in Derby Embedded DB? References: <44AB9B62.9030909@opensource.lk> <74e15baa0607050401w4f8b410dl6bf9146551a7fb62@mail.gmail.com> In-Reply-To: <74e15baa0607050401w4f8b410dl6bf9146551a7fb62@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Aron, I changed the URL in the deployment plan of the DB Pool as you suggested. Then deploy it using a command prompt. Error still appears in the same scenario until it restarts. Thanks, Lasantha Aaron Mulder wrote: > If you haven't manually created the Derby DB before these tests, can > you try changing your URL to "jdbc:derby:InventoryDB;create=true" and > let us know if that fixes the problem on Windows? > > Also, the security realm issue was not a Derby problem, it was a > problem with how the admin console tries to create the new security > realm service. > > Thanks, > Aaron > > On 7/5/06, Lasantha Ranaweera wrote: >> >> >> >> >> >> >> Hi All, >> >> An interesting observation made when I was writing a sample >> application to >> the Geronimo v1.1. The sample application just a small web >> application which >> refers to the embedded Derby DB from a DataSource. I carried out some >> investigation regarding the observation. Following are my >> observations in a >> list of test scenarios. >> >> Scenario => Deploying a database pool in Geronimo v1.1 and accessing it >> without restarting the server >> >> Scenario 1:- >> OS :- Windows XP >> Server :- Geronimo v1.1/ Tomcat >> Database :- Embedded Derby DB. >> Condition :- Access Without Restarting. >> Result :- Attached Error Occurs. >> >> Scenario 2:- >> OS :- Windows XP >> Server :- Geronimo v1.1/ Tomcat >> Database :- Embedded Derby DB. >> Condition :- Access DB Pool After Restarting the Server. >> Result :- Application works without an error. >> >> Scenario 3:- >> OS :- Linux >> Server :- Geronimo v1.1/ Tomcat >> Database :- Embedded Derby DB. >> Condition :- Access Without Restarting. >> Result :- Application works without an error. >> >> Scenario 4:- >> OS :- Windows XP >> Server :- Geronimo v1.1/ Tomcat >> Database :- MySQL >> Condition :- Access Without Restarting. >> Result :- Application works without an error. >> >> >> >> >> Due to above results I suspect there is a problem in Derby database of >> Geronimo 1.1 in Windows environment. Also I think error reported by >> Markus >> as "creating security realm in 1.1 fails" same due to a problem Derby >> Database. Please correct me if I am wrong. >> >> >> Herewith I attached necessary files to test the application too. >> >> With Kind Regards, >> Lasantha >> >> Lasantha Ranaweera >> Senior Software Engineer, >> Lanka Software Foundation, >> Sri Lanka. >> SQL Exception: Failed to start database 'InventoryDB', see the next >> exception fo >> r details. >> at >> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown >> Source) >> at >> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown >> Source) >> at >> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown >> Source >> ) >> at >> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown >> So >> urce) >> at >> org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown >> Sourc >> e) >> at >> org.apache.derby.impl.jdbc.EmbedConnection.(Unknown >> Source) >> at >> org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown >> Source) >> at >> org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown >> Source) >> at >> org.apache.derby.jdbc.InternalDriver.connect(Unknown >> Source) >> at >> org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown >> Source) >> at >> org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDri >> verMCF.java:96) >> at >> org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCD >> riverMCF.java:73) >> at >> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getCo >> nnection(MCFConnectionInterceptor.java:41) >> at >> org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterc >> eptor.getConnection(LocalXAResourceInsertionInterceptor.java:41) >> at >> org.apache.geronimo.connector.outbound.SinglePoolConnectionIntercepto >> r.internalGetConnection(SinglePoolConnectionInterceptor.java:63) >> at >> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionIn >> terceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:73) >> at >> org.apache.geronimo.connector.outbound.TransactionEnlistingIntercepto >> r.getConnection(TransactionEnlistingInterceptor.java:47) >> at >> org.apache.geronimo.connector.outbound.TransactionCachingInterceptor. >> getConnection(TransactionCachingInterceptor.java:86) >> at >> org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.ge >> tConnection(ConnectionHandleInterceptor.java:43) >> at >> org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection( >> TCCLInterceptor.java:39) >> at >> org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor. >> getConnection(ConnectionTrackingInterceptor.java:66) >> at >> org.apache.geronimo.connector.outbound.AbstractConnectionManager.allo >> cateConnection(AbstractConnectionManager.java:61) >> at >> org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56 >> ) >> at >> $javax.sql.DataSource$$FastClassByCGLIB$$6525cafd.invoke() >> >> at >> net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) >> at >> org.apache.geronimo.connector.ConnectorMethodInterceptor.intercept(Co >> nnectorMethodInterceptor.java:54) >> at >> $javax.sql.DataSource$$EnhancerByCGLIB$$a80fed92.getConnection(> ated>) >> at >> org.apache.geronimo.samples.inventory.util.DBManager.getConnection(Un >> known Source) >> at >> org.apache.geronimo.samples.inventory.dao.ItemDAO.getItems(Unknown >> So >> urce) >> at >> org.apache.geronimo.samples.inventory.services.InventoryManager.getIt >> ems(Unknown Source) >> at >> org.apache.jsp.welcome_jsp._jspService(org.apache.jsp.welcome_jsp:65) >> >> at >> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) >> at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:688) >> at >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper >> .java:332) >> at >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3 >> 14) >> at >> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) >> at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:688) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl >> icationFilterChain.java:252) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF >> ilterChain.java:173) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV >> alve.java:213) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV >> alve.java:178) >> at >> org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu >> bjectValve.java:46) >> at >> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve. >> invoke(GeronimoStandardContext.java:342) >> at >> org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(Gero >> nimoBeforeAfterValve.java:31) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j >> ava:126) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j >> ava:105) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal >> ve.java:107) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: >> 541) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav >> a:148) >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java >> :869) >> at >> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p >> rocessConnection(Http11BaseProtocol.java:667) >> at >> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo >> int.java:527) >> at >> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol >> lowerWorkerThread.java:80) >> at >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP >> ool.java:684) >> at java.lang.Thread.run(Thread.java:534) >> 15:08:17,171 ERROR [[jsp]] Servlet.service() for servlet jsp threw >> exception >> java.lang.NullPointerException >> at >> org.apache.geronimo.samples.inventory.dao.ItemDAO.getItems(Unknown >> So >> urce) >> at >> org.apache.geronimo.samples.inventory.services.InventoryManager.getIt >> ems(Unknown Source) >> at >> org.apache.jsp.welcome_jsp._jspService(org.apache.jsp.welcome_jsp:65) >> >> at >> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) >> at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:688) >> at >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper >> .java:332) >> at >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3 >> 14) >> at >> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) >> at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:688) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl >> icationFilterChain.java:252) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF >> ilterChain.java:173) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV >> alve.java:213) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV >> alve.java:178) >> at >> org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu >> bjectValve.java:46) >> at >> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve. >> invoke(GeronimoStandardContext.java:342) >> at >> org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(Gero >> nimoBeforeAfterValve.java:31) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j >> ava:126) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j >> ava:105) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal >> ve.java:107) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: >> 541) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav >> a:148) >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java >> :869) >> at >> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p >> rocessConnection(Http11BaseProtocol.java:667) >> at >> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo >> int.java:527) >> at >> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol >> lowerWorkerThread.java:80) >> at >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP >> ool.java:684) >> at java.lang.Thread.run(Thread.java:534) >> >> >> CREATE TABLE item( >> item_id VARCHAR(10) PRIMARY KEY, >> item_name VARCHAR(25), >> description VARCHAR(100) >> ); >> >> CREATE TABLE item_master( >> item_id VARCHAR(10) PRIMARY KEY, >> quantity INTEGER >> ); >> >> INSERT INTO item VALUES('001', 'Item 1', 'Test Item 1'); >> INSERT INTO item VALUES('002', 'Item 2', 'Test Item 2'); >> INSERT INTO item VALUES('003', 'Item 3', 'Test Item 3'); >> INSERT INTO item VALUES('004', 'Item 4', 'Test Item 4'); >> >> >> INSERT INTO item_master VALUES('001', 12); >> INSERT INTO item_master VALUES('002', 8); >> INSERT INTO item_master VALUES('003', 49); >> INSERT INTO item_master VALUES('004', 34); >> >> >> >