db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David W. Van Couvering" <David.Vancouver...@Sun.COM>
Subject Re: Cause of Can't start Databases/JPetStoreDB?
Date Tue, 22 Nov 2005 22:18:45 GMT
What we are seeing here is the fact that the database couldn't be 
started, but not *why*.  I think you're getting it 30+ times because you 
have a connection pool with 30 connections?

Anyway, often there is more information in the derby.log file, which is 
normally placed in the directory where Derby is started, or as specified 
by the system property derby.system.home.

Check that out.  It could be something as simple as a file permission 
problem.

David

Martin Streicher wrote:
> Anyone know what the root cause of this error is? I am trying to run the 
> JPetStore demo under Derby and Geronimo. 
> 
> Help! Quick! 
> 
> Martin
> 
> 
> 
> *Error!*
> 
> *com.ibatis.struts.BeanActionException*
> Error dispatching bean action via URL pattern ('viewCategory'). Cause: 
> java.lang.reflect.InvocationTargetException
> 
> *Stack*
> 
> /com.ibatis.struts.BeanActionException: Error dispatching bean action 
> via URL pattern ('viewCategory').//  //Cause: 
> java.lang.reflect.InvocationTargetException/
> /Caused by: java.lang.reflect.InvocationTargetException/
> /at com.ibatis.struts.BeanAction.execute(BeanAction.java:140)/
> /at 
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)/
> /at 
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)/
> /at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)/
> /at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)/
> /at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)/
> /at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)/
> /at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)/
> /at 
> org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolder.java:92)/
> /at 
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:832)/
> /at org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:171)/
> /at 
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)/
> /at 
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)/
> /at 
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)/
> /at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)/
> /at 
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:635)/
> /at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)/
> /at org.mortbay.http.HttpServer.service(HttpServer.java:954)/
> /at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)/
> /at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)/
> /at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)/
> /at 
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)/
> /at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)/
> /at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)/
> /Caused by: java.lang.reflect.InvocationTargetException/
> /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:324)/
> /at com.ibatis.struts.BeanAction.execute(BeanAction.java:138)/
> /... 23 more/
> /Caused by: com.ibatis.dao.client.DaoException: Error starting SQL Map 
> transaction.//  //Cause: SQL Exception: Failed to start database 
> 'Databases/JPetstoreDB', see the next exception for details./
> /Caused by: SQL Exception: Failed to start database 
> 'Databases/JPetstoreDB', see the next exception for details./
> /at 
> com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransaction.(SqlMapDaoTransaction.java:25)/
> /at 
> com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransactionManager.startTransaction(SqlMapDaoTransactionManager.java:48)/
> /at 
> com.ibatis.dao.engine.impl.DaoContext.startTransaction(DaoContext.java:82)/
> /at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:60)/
> /at $Proxy5.getProductListByCategory(Unknown Source)/
> /at 
> com.ibatis.jpetstore.service.CatalogService.getProductListByCategory(CatalogService.java:60)/
> /at 
> com.ibatis.jpetstore.presentation.CatalogBean.viewCategory(CatalogBean.java:134)/
> /... 28 more/
> /Caused by: SQL Exception: Failed to start database 
> 'Databases/JPetstoreDB', 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.(EmbedConnection.java)/
> /at org.apache.derby.impl.jdbc.EmbedConnection20.(EmbedConnection20.java)/
> /at org.apache.derby.impl.jdbc.EmbedConnection30.(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.EmbeddedDriver.connect(EmbeddedDriver.java)/
> /at 
> org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDriverMCF.java:90)/
> /at 
> org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDriverMCF.java:70)/
> /at 
> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:41)/
> /at 
> org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)/
> /at 
> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:60)/
> /at 
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:70)/
> /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:60)/
> /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(ConnectorMethodInterceptor.java:53)/
> /at $javax.sql.DataSource$$EnhancerByCGLIB$$5faece95.getConnection()/
> /at 
> com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.(JdbcTransaction.java:26)/
> /at 
> com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransactionConfig.newTransaction(JdbcTransactionConfig.java:32)/
> /at 
> com.ibatis.sqlmap.engine.transaction.TransactionManager.begin(TransactionManager.java:35)/
> /at 
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.startTransaction(SqlMapExecutorDelegate.java:408)/
> /at 
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.startTransaction(SqlMapSessionImpl.java:113)/
> /at 
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.startTransaction(SqlMapClientImpl.java:87)/
> /at 
> com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransaction.(SqlMapDaoTransaction.java:22)/
> /... 34 more/
> 
> /Caused by:// /
> /java.lang.reflect.InvocationTargetException/
> /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:324)/
> /at com.ibatis.struts.BeanAction.execute(BeanAction.java:138)/
> /at 
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)/
> /at 
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)/
> /at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)/
> /at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)/
> /at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)/
> /at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)/
> /at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)/
> /at 
> org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolder.java:92)/
> /at 
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:832)/
> /at org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:171)/
> /at 
> org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)/
> /at 
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)/
> /at 
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)/
> /at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)/
> /at 
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:635)/
> /at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)/
> /at org.mortbay.http.HttpServer.service(HttpServer.java:954)/
> /at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)/
> /at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)/
> /at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)/
> /at 
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)/
> /at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)/
> /at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)/
> /Caused by: com.ibatis.dao.client.DaoException: Error starting SQL Map 
> transaction.//  //Cause: SQL Exception: Failed to start database 
> 'Databases/JPetstoreDB', see the next exception for details./
> /Caused by: SQL Exception: Failed to start database 
> 'Databases/JPetstoreDB', see the next exception for details./
> /at 
> com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransaction.(SqlMapDaoTransaction.java:25)/
> /at 
> com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransactionManager.startTransaction(SqlMapDaoTransactionManager.java:48)/
> /at 
> com.ibatis.dao.engine.impl.DaoContext.startTransaction(DaoContext.java:82)/
> /at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:60)/
> /at $Proxy5.getProductListByCategory(Unknown Source)/
> /at 
> com.ibatis.jpetstore.service.CatalogService.getProductListByCategory(CatalogService.java:60)/
> /at 
> com.ibatis.jpetstore.presentation.CatalogBean.viewCategory(CatalogBean.java:134)/
> /... 28 more/
> /Caused by: SQL Exception: Failed to start database 
> 'Databases/JPetstoreDB', 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.(EmbedConnection.java)/
> /at org.apache.derby.impl.jdbc.EmbedConnection20.(EmbedConnection20.java)/
> /at org.apache.derby.impl.jdbc.EmbedConnection30.(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.EmbeddedDriver.connect(EmbeddedDriver.java)/
> /at 
> org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDriverMCF.java:90)/
> /at 
> org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDriverMCF.java:70)/
> /at 
> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:41)/
> /at 
> org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)/
> /at 
> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:60)/
> /at 
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:70)/
> /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:60)/
> /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(ConnectorMethodInterceptor.java:53)/
> /at $javax.sql.DataSource$$EnhancerByCGLIB$$5faece95.getConnection()/
> /at 
> com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.(JdbcTransaction.java:26)/
> /at 
> com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransactionConfig.newTransaction(JdbcTransactionConfig.java:32)/
> /at 
> com.ibatis.sqlmap.engine.transaction.TransactionManager.begin(TransactionManager.java:35)/
> /at 
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.startTransaction(SqlMapExecutorDelegate.java:408)/
> /at 
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.startTransaction(SqlMapSessionImpl.java:113)/
> /at 
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.startTransaction(SqlMapClientImpl.java:87)/
> /at 
> com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransaction.(SqlMapDaoTransaction.java:22)/

Mime
View raw message