[ http://issues.apache.org/jira/browse/GERONIMO-1613?page=comments#action_12366253 ]
Joe Bohn commented on GERONIMO-1613: ------------------------------------ Hmmmm perhaps we should wait to apply this patch. My initial tests with a simple application worked just fine on all assemblies. However, when I attempt to populate the daytrader DB for either the tomcat or jetty assembly I get the following set of errors. Anybody have any ideas how changes in the config dependencies could cause these types of error? There doesn't seem to be any more information in the log. SQL Exception: Failed to start database 'DaytraderDatabase', see the next exception for details. SQL Exception: Failed to start database 'DaytraderDatabase', see the next exception for details. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java) at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java) at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java) at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java) at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java) at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java) at org.apache.derby.jdbc.Driver169.connect(Driver169.java) at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java) at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java) at org.apache.derby.jdbc.EmbeddedXADataSource.setupResourceAdapter(EmbeddedXADataSource.java) at org.apache.derby.jdbc.EmbeddedXADataSource.getXAConnection(EmbeddedXADataSource.java) at org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:74) at org.tranql.connector.derby.EmbeddedXAMCF.createManagedConnection(EmbeddedXAMCF.java:52) at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:41) at org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java:41) at org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:63) at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:73) at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:47) at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:86) at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(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.allocateConnection(AbstractConnectionManager.java:57) 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(ConnectorMethodInterceptor.java:53) at $javax.sql.DataSource$$EnhancerByCGLIB$$4d687449.getConnection(<generated>) at org.apache.geronimo.samples.daytrader.direct.TradeDirect.getConn(TradeDirect.java:2035) at org.apache.geronimo.samples.daytrader.direct.TradeDirect.resetTrade(TradeDirect.java:1799) at org.apache.geronimo.samples.daytrader.TradeAction.resetTrade(TradeAction.java:490) at org.apache.geronimo.samples.daytrader.web.TradeBuildDB.<init>(TradeBuildDB.java:62) at org.apache.geronimo.samples.daytrader.web.TradeConfigServlet.service(TradeConfigServlet.java:353) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:46) at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:273) at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:31) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) ... <@JAB Same exception as above appears again > ... 16:30:03,243 ERROR [Log] Error: TradeBuildDB: Unable to delete Trade users (uid:0, uid:1, ...) and Trade Quotes (s:0, s:1, ...) SQL Exception: Failed to start database 'DaytraderDatabase', see the next exception for details. SQL Exception: Failed to start database 'DaytraderDatabase', see the next exception for details. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java) at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java) at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java) at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java) at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java) at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java) at org.apache.derby.jdbc.Driver169.connect(Driver169.java) at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java) at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java) at org.apache.derby.jdbc.EmbeddedXADataSource.setupResourceAdapter(EmbeddedXADataSource.java) at org.apache.derby.jdbc.EmbeddedXADataSource.getXAConnection(EmbeddedXADataSource.java) at org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:74) at org.tranql.connector.derby.EmbeddedXAMCF.createManagedConnection(EmbeddedXAMCF.java:52) at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:41) at org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java:41) at org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:63) at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:73) at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:47) at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:86) at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(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.allocateConnection(AbstractConnectionManager.java:57) 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(ConnectorMethodInterceptor.java:53) at $javax.sql.DataSource$$EnhancerByCGLIB$$4d687449.getConnection(<generated>) at org.apache.geronimo.samples.daytrader.direct.TradeDirect.getConn(TradeDirect.java:2035) at org.apache.geronimo.samples.daytrader.direct.TradeDirect.resetTrade(TradeDirect.java:1799) at org.apache.geronimo.samples.daytrader.TradeAction.resetTrade(TradeAction.java:490) at org.apache.geronimo.samples.daytrader.web.TradeBuildDB.<init>(TradeBuildDB.java:62) at org.apache.geronimo.samples.daytrader.web.TradeConfigServlet.service(TradeConfigServlet.java:353) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:46) at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:273) at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:31) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) ... <@JAB same exception as above follows next > ... 16:30:03,514 ERROR [Log] Error: TradeDirect:createQuote -- error creating quote SQL Exception: Failed to start database 'DaytraderDatabase', see the next exception for details. SQL Exception: Failed to start database 'DaytraderDatabase', see the next exception for details. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java) at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java) at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java) at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java) at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java) at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java) at org.apache.derby.jdbc.Driver169.connect(Driver169.java) at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java) at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java) at org.apache.derby.jdbc.EmbeddedXADataSource.setupResourceAdapter(EmbeddedXADataSource.java) at org.apache.derby.jdbc.EmbeddedXADataSource.getXAConnection(EmbeddedXADataSource.java) at org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:74) at org.tranql.connector.derby.EmbeddedXAMCF.createManagedConnection(EmbeddedXAMCF.java:52) at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:41) at org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java:41) at org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:63) at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:73) at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:47) at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:86) at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(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.allocateConnection(AbstractConnectionManager.java:57) 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(ConnectorMethodInterceptor.java:53) at $javax.sql.DataSource$$EnhancerByCGLIB$$4d687449.getConnection(<generated>) at org.apache.geronimo.samples.daytrader.direct.TradeDirect.getConn(TradeDirect.java:2035) at org.apache.geronimo.samples.daytrader.direct.TradeDirect.createQuote(TradeDirect.java:804) at org.apache.geronimo.samples.daytrader.TradeAction.createQuote(TradeAction.java:274) at org.apache.geronimo.samples.daytrader.web.TradeBuildDB.<init>(TradeBuildDB.java:72) at org.apache.geronimo.samples.daytrader.web.TradeConfigServlet.service(TradeConfigServlet.java:353) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:46) at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:273) at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:31) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) ... <@JAB same exception as above appears 9 times below > ... 16:30:14,970 ERROR [Log] Error: TradeDirect:register -- error registering new user java.sql.SQLException java.sql.SQLException at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:61) 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(ConnectorMethodInterceptor.java:53) at $javax.sql.DataSource$$EnhancerByCGLIB$$4d687449.getConnection(<generated>) at org.apache.geronimo.samples.daytrader.direct.TradeDirect.getConn(TradeDirect.java:2035) at org.apache.geronimo.samples.daytrader.direct.TradeDirect.register(TradeDirect.java:1642) at org.apache.geronimo.samples.daytrader.TradeAction.register(TradeAction.java:472) at org.apache.geronimo.samples.daytrader.web.TradeBuildDB.<init>(TradeBuildDB.java:108) at org.apache.geronimo.samples.daytrader.web.TradeConfigServlet.service(TradeConfigServlet.java:353) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:46) at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:273) at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:31) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Caused by: No ManagedConnections available within configured blocking timeout ( 5000 [ms] ) at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:75) at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:47) at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:86) at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(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.allocateConnection(AbstractConnectionManager.java:57) at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56) ... 28 more ... <@JAB same exception as above appears 4 more times below > ... > Eliminate unncessary dependencies to reduce assemnbly footprint size > -------------------------------------------------------------------- > > Key: GERONIMO-1613 > URL: http://issues.apache.org/jira/browse/GERONIMO-1613 > Project: Geronimo > Type: Improvement > Components: general > Versions: 1.1 > Environment: all > Reporter: Joe Bohn > Fix For: 1.1 > Attachments: RemoveDeps.patch > > Clean up assembly project.xml and eliminate some unnecessary dependencies in > various modules and configs. This will reduce the footprint size (with > special attention to the minimal-tomcat-assembly. > The patch contains the following: > - clean up minimal-tomcat-server\project.xml to remove commented out sections > - clean up web-jms-tomcat-server\project.xml to remove commented out sections > - remove dependencies from config\j2ee_server on xstream, jaxr-api, and > geronimo-derby > - remove dependencies from config\j2ee_deployer on geronimo-client-builder > - remove dependencies from module\tomcat on activecluster, wadi-core, and > wadi-tomcat55 > There are still more dependencies that should be removed but this is a start. > These changes reduce the disk footprint of minimal-tomcat-server from 27 meg > to about 21 meg. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira