Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (asf.osuosl.org: domain of ammulder@gmail.com designates
 64.233.162.205 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=FzjQuzz/jtq+Iv5l6oX5ay3Rm/MzSKxzT82cVxxxqA6ryE54DoB6b8wP3sO0LQEanE/2BZEjRnvWS3dpLlgfhxzaUoqyGvi0SEdpR8ag6n7yOb1KRrcINvUbrVzbI5B/N/Q/iE6x6T3xrOiYp2patOYGMD0ifSO3hgQ4s1R0PZo=
Message-ID: <74e15baa0607050401w4f8b410dl6bf9146551a7fb62@mail.gmail.com>
Date: Wed, 5 Jul 2006 07:01:54 -0400
From: "Aaron Mulder" <ammulder@alumni.princeton.edu>
Sender: ammulder@gmail.com
To: user@geronimo.apache.org
Subject: Re: Is this due to a problem in Derby Embedded DB?
In-Reply-To: <44AB9B62.9030909@opensource.lk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <44AB9B62.9030909@opensource.lk>

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 <lasantha@opensource.lk> 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.<init>(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.EmbedConnection30.<init>(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(<generated>)
>
>         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(<gener
> 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);
>
>
>