geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ivan <xhh...@gmail.com>
Subject Re: Derby problems(Created tables/schemas not seen)
Date Wed, 27 Jun 2012 01:56:35 GMT
>From the exception below, seems that you are using resource adapter to
connect the derby, and it shows the tables were not created.
I am wondering how do you create those tables, with ij script and where did
you try those connect string ?

2012/6/26 Dok Sander <doksander@yahoo.com>

> Hi,
>
>  I have big problems with
> Geronimo(2.2.1) and Derby. I've been on this almost for a week now.
> First I thought the problem was with XWiki, the first web application I
> was going to set up, but I have now come to a conclusion that the actual
> problem lies withing Geronimo/Derby.
>
> I have only tested this with XWiki and Apache Jackrabbit, with similar
> results:
>
>
> For some reason the database tables are not created by the applications.
> This could be on the application side but when I create the tables
> manually I still get the same errors. I have set the username to "APP"
> which is Derby default user/schema(Creating a test -user didn't work
> because Derby defaults to the current user's schema unless you
> explicitly set it and the tables weren't found) and created the tables
> using ij(Derby shell)
>
> I have tried different drivers(ClientDriver & Embedded both Derby and
> Tranquil) to no avail. I have also tried setting the connection url in
> different styles:
>
> connect
> 'jdbc:derby://localhost:1527/opt/apache-geronimo/2.2.1_tomcat/var/jcr-test/repo/version/db;user=app;password=app';
>
> and
>
>
> connect
> 'jdbc:derby:/opt/apache-geronimo/2.2.1_tomcat/var/jcr-test/repo/version/db;user=app;password=app';
>
>
>
> Please advice what would be the next thing to try to get Geronimo working
> for me.
>
> --vdox
>
> 2012-06-26 03:43:36,748 INFO  [SupportedModesServiceImpl] Portlet mode
> 'edit' not
> found for portletId: '/system-database.DBViewer!-514983590|0'
> 2012-06-26 03:43:36,762 INFO  [SupportedModesServiceImpl]
>  Portlet mode 'edit' not found for portletId:
> '/system-database.RunSQL!-514983590|1'
> 2012-06-26
>  03:43:37,702 INFO  [SupportedModesServiceImpl] Portlet mode 'edit' not
> found for portletId: '/system-database.InternalDB!-138236768|0'
> 2012-06-26
>  03:44:25,002 INFO  [SupportedModesServiceImpl] Portlet mode 'edit' not
> found for portletId: '/system-database.InternalDB!-138236768|0'
> 2012-06-26 03:56:18,088 INFO  [RepositoryImpl] Starting repository...
> 2012-06-26
>  03:56:18,088 INFO  [LocalFileSystem] LocalFileSystem initialized at
> path /opt/apache-geronimo/2.2.1_tomcat/var/jcr-test/repo/repository
> 2012-06-26 03:56:18,103 INFO  [NodeTypeRegistry] no custom node type
> definitions found
> 2012-06-26
>  03:56:18,103 INFO  [LocalFileSystem] LocalFileSystem initialized at
> path /opt/apache-geronimo/2.2.1_tomcat/var/jcr-test/repo/version
> 2012-06-26 03:56:18,227 ERROR [ConnectionHelper] Failed to execute SQL
> (stacktrace on DEBUG
>  log level)
> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from
> pool failed
>         at
> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:113)
>         at
> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
>         at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:386)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:370)
>         at
>
>  org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:366)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:493)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:366)
>
>  at
>
> org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:827)
>
>  at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundleCacheMiss(AbstractBundlePersistenceManager.java:737)
>
>  at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundle(AbstractBundlePersistenceManager.java:720)
>
>  at
>
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.exists(AbstractBundlePersistenceManager.java:534)
>         at
> org.apache.jackrabbit.core.version.InternalVersionManagerImpl.<init>(InternalVersionManagerImpl.java:162)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:492)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:311)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:589)
>         at
> org.apache.jackrabbit.jca.JCARepositoryManager.createNonTransientRepository(JCARepositoryManager.java:124)
>         at
>
>  org.apache.jackrabbit.jca.JCARepositoryManager.createRepository(JCARepositoryManager.java:79)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.getRepository(JCAManagedConnectionFactory.java:205)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnection.openSession(JCAManagedConnection.java:100)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnection.<init>(JCAManagedConnection.java:85)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createManagedConnection(JCAManagedConnectionFactory.java:174)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createManagedConnection(JCAManagedConnectionFactory.java:166)
>         at
>
>  org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
>
>  at
>
> org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java:41)
>
>  at
>
> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:69)
>
>  at
>
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80)
>
>  at
>
> org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:49)
>         at
>
>  org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:109)
>         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:77)
>         at
> org.apache.jackrabbit.jca.JCARepositoryHandle.login(JCARepositoryHandle.java:75)
>         at
>
>  org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:111)
>         at com.clsts.test.Test5.doGet(Test5.java:31)
>         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.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>         at
>
>  org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>         at
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:420)
>         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.valves.AccessLogValve.invoke(AccessLogValve.java:555)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>         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$SocketProcessor.run(JIoEndpoint.java:396)
>         at org.apache.geronimo.pool.ThreadPool$1.run(ThreadPool.java:214)
>         at
> org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run(ThreadPool.java:344)
>         at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
>         at
>
>  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
>         at java.lang.Thread.run(Thread.java:722)
> Caused by: java.sql.SQLSyntaxErrorException: Table/View 'VERSION_BUNDLE'
> does not exist.
>         at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>         at org.apache.derby.client.am.SqlException.getSQLException(Unknown
> Source)
>         at org.apache.derby.client.am.Connection.prepareStatement(Unknown
> Source)
>         at
> org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:285)
>         at
> org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1179)
>         at
>
>  org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107)
>         ... 56 more
> Caused by: org.apache.derby.client.am.SqlException: Table/View
> 'VERSION_BUNDLE' does not exist.
>         at org.apache.derby.client.am.Statement.completeSqlca(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
> Source)
>         at
> org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
> Source)
>         at
>  org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
> Source)
>         at
> org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown
> Source)
>         at
> org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown
> Source)
>         at
> org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
> Source)
>         at org.apache.derby.client.am.PreparedStatement.prepare(Unknown
> Source)
>         at org.apache.derby.client.am.Connection.prepareStatementX(Unknown
> Source)
>         ... 60 more
> 2012-06-26 03:56:18,332 ERROR [ConnectionHelper] Failed to execute SQL
> (stacktrace on DEBUG log level)
> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement
>  from pool failed
>         at
> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:113)
>         at
> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
>         at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:386)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:370)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:366)
>         at
>
>  org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:493)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:366)
>
>  at
>
> org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:827)
>
>  at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundleCacheMiss(AbstractBundlePersistenceManager.java:737)
>
>  at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundle(AbstractBundlePersistenceManager.java:720)
>
>  at
>
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.exists(AbstractBundlePersistenceManager.java:534)
>         at
> org.apache.jackrabbit.core.version.InternalVersionManagerImpl.<init>(InternalVersionManagerImpl.java:162)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:492)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:311)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:589)
>         at
> org.apache.jackrabbit.jca.JCARepositoryManager.createNonTransientRepository(JCARepositoryManager.java:124)
>         at
>
>  org.apache.jackrabbit.jca.JCARepositoryManager.createRepository(JCARepositoryManager.java:79)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.getRepository(JCAManagedConnectionFactory.java:205)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnection.openSession(JCAManagedConnection.java:100)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnection.<init>(JCAManagedConnection.java:85)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createManagedConnection(JCAManagedConnectionFactory.java:174)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createManagedConnection(JCAManagedConnectionFactory.java:166)
>         at
>
>  org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
>
>  at
>
> org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java:41)
>
>  at
>
> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:69)
>
>  at
>
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80)
>
>  at
>
> org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:49)
>         at
>
>  org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:109)
>         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:77)
>         at
> org.apache.jackrabbit.jca.JCARepositoryHandle.login(JCARepositoryHandle.java:75)
>         at
>
>  org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:111)
>         at com.clsts.test.Test5.doGet(Test5.java:31)
>         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.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>         at
>
>  org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>         at
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:420)
>         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.valves.AccessLogValve.invoke(AccessLogValve.java:555)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>         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$SocketProcessor.run(JIoEndpoint.java:396)
>         at org.apache.geronimo.pool.ThreadPool$1.run(ThreadPool.java:214)
>         at
> org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run(ThreadPool.java:344)
>         at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
>         at
>
>  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
>         at java.lang.Thread.run(Thread.java:722)
> Caused by: java.sql.SQLSyntaxErrorException: Table/View 'VERSION_BUNDLE'
> does not exist.
>         at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>         at org.apache.derby.client.am.SqlException.getSQLException(Unknown
> Source)
>         at org.apache.derby.client.am.Connection.prepareStatement(Unknown
> Source)
>         at
> org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:285)
>         at
> org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1179)
>         at
>
>  org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107)
>         ... 56 more
> Caused by: org.apache.derby.client.am.SqlException: Table/View
> 'VERSION_BUNDLE' does not exist.
>         at org.apache.derby.client.am.Statement.completeSqlca(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
> Source)
>         at
> org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
> Source)
>         at
>  org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
> Source)
>         at
> org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown
> Source)
>         at
> org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown
> Source)
>         at
> org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
> Source)
>         at org.apache.derby.client.am.PreparedStatement.prepare(Unknown
> Source)
>         at org.apache.derby.client.am.Connection.prepareStatementX(Unknown
> Source)
>         ... 60 more
> 2012-06-26
>  03:56:18,333 ERROR [BundleDbPersistenceManager] failed to read bundle:
> deadbeef-face-babe-cafe-babecafebabe:
> org.apache.commons.dbcp.SQLNestedException: Borrow
>  prepareStatement from pool failed
> 2012-06-26 03:56:18,334 ERROR
> [RepositoryImpl] failed to start Repository:
> org.apache.jackrabbit.core.state.ItemStateException: failed to read
> bundle: deadbeef-face-babe-cafe-babecafebabe:
> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from
>  pool failed
> javax.jcr.RepositoryException:
> org.apache.jackrabbit.core.state.ItemStateException: failed to read
> bundle: deadbeef-face-babe-cafe-babecafebabe:
> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from
>  pool failed
>         at
> org.apache.jackrabbit.core.version.InternalVersionManagerImpl.<init>(InternalVersionManagerImpl.java:208)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:492)
>         at
>  org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:311)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:589)
>         at
> org.apache.jackrabbit.jca.JCARepositoryManager.createNonTransientRepository(JCARepositoryManager.java:124)
>         at
> org.apache.jackrabbit.jca.JCARepositoryManager.createRepository(JCARepositoryManager.java:79)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.getRepository(JCAManagedConnectionFactory.java:205)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnection.openSession(JCAManagedConnection.java:100)
>         at
>
>  org.apache.jackrabbit.jca.JCAManagedConnection.<init>(JCAManagedConnection.java:85)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createManagedConnection(JCAManagedConnectionFactory.java:174)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createManagedConnection(JCAManagedConnectionFactory.java:166)
>         at
> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
>
>  at
>
> org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java:41)
>
>  at
>
>
> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:69)
>
>  at
>
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80)
>
>  at
>
> org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:49)
>
>  at
>
> org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:109)
>         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:77)
>         at
> org.apache.jackrabbit.jca.JCARepositoryHandle.login(JCARepositoryHandle.java:75)
>         at
> org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:111)
>         at com.clsts.test.Test5.doGet(Test5.java:31)
>         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.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>         at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>         at
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:420)
>         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.valves.AccessLogValve.invoke(AccessLogValve.java:555)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>         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$SocketProcessor.run(JIoEndpoint.java:396)
>         at org.apache.geronimo.pool.ThreadPool$1.run(ThreadPool.java:214)
>         at
> org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run(ThreadPool.java:344)
>         at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
>         at java.lang.Thread.run(Thread.java:722)
> Caused
>  by: org.apache.jackrabbit.core.state.ItemStateException: failed to read
>  bundle: deadbeef-face-babe-cafe-babecafebabe:
> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from
>  pool failed
>         at
>
>  org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:841)
>
>  at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundleCacheMiss(AbstractBundlePersistenceManager.java:737)
>
>  at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundle(AbstractBundlePersistenceManager.java:720)
>
>  at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.exists(AbstractBundlePersistenceManager.java:534)
>         at
> org.apache.jackrabbit.core.version.InternalVersionManagerImpl.<init>(InternalVersionManagerImpl.java:162)
>         ... 44 more
> Caused by: org.apache.commons.dbcp.SQLNestedException: Borrow
>  prepareStatement from pool failed
>         at
> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:113)
>         at
> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
>         at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:386)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:370)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:366)
>         at
>
>  org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:493)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:366)
>
>  at
>
> org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:827)
>         ... 48 more
> Caused by: java.sql.SQLSyntaxErrorException: Table/View 'VERSION_BUNDLE'
> does not exist.
>         at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>         at org.apache.derby.client.am.SqlException.getSQLException(Unknown
> Source)
>         at org.apache.derby.client.am.Connection.prepareStatement(Unknown
> Source)
>
>  at
> org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:285)
>         at
> org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1179)
>         at
> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107)
>         ... 56 more
> Caused by: org.apache.derby.client.am.SqlException: Table/View
> 'VERSION_BUNDLE' does not exist.
>         at org.apache.derby.client.am.Statement.completeSqlca(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
> Source)
>         at
>  org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
> Source)
>         at
> org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
> Source)
>         at
> org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown
> Source)
>         at
> org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown
> Source)
>         at
> org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
> Source)
>         at org.apache.derby.client.am.PreparedStatement.prepare(Unknown
> Source)
>         at
>  org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
>         ... 60 more
> 2012-06-26 03:56:18,334 INFO  [RepositoryImpl] Shutting down repository...
> 2012-06-26 03:56:18,336 INFO  [RepositoryImpl] Repository has been shutdown
> 2012-06-26
>  03:56:18,336 ERROR [MCFConnectionInterceptor] Error occurred creating
> ManagedConnection for handle: nullManagedConnectionInfo:
> org.apache.geronimo.connector.outbound.ManagedConnectionInfo@38df2289.
> mc: null]
> javax.resource.ResourceException: Failed to create session:
>  org.apache.jackrabbit.core.state.ItemStateException: failed to read
> bundle: deadbeef-face-babe-cafe-babecafebabe:
> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from
>  pool failed
>         at
> org.apache.jackrabbit.jca.JCAManagedConnection.openSession(JCAManagedConnection.java:106)
>
>  at
> org.apache.jackrabbit.jca.JCAManagedConnection.<init>(JCAManagedConnection.java:85)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createManagedConnection(JCAManagedConnectionFactory.java:174)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createManagedConnection(JCAManagedConnectionFactory.java:166)
>         at
> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
>
>  at
>
> org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java:41)
>
>  at
>
>
> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:69)
>
>  at
>
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80)
>
>  at
>
> org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:49)
>
>  at
>
> org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:109)
>         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:77)
>         at
> org.apache.jackrabbit.jca.JCARepositoryHandle.login(JCARepositoryHandle.java:75)
>         at
> org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:111)
>         at com.clsts.test.Test5.doGet(Test5.java:31)
>         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.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>         at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>         at
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:420)
>         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.valves.AccessLogValve.invoke(AccessLogValve.java:555)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>         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$SocketProcessor.run(JIoEndpoint.java:396)
>         at org.apache.geronimo.pool.ThreadPool$1.run(ThreadPool.java:214)
>         at
> org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run(ThreadPool.java:344)
>         at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
>         at java.lang.Thread.run(Thread.java:722)
> Caused
>  by: javax.jcr.RepositoryException:
> org.apache.jackrabbit.core.state.ItemStateException: failed to read
> bundle: deadbeef-face-babe-cafe-babecafebabe:
> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from
>  pool failed
>         at
>
>  org.apache.jackrabbit.core.version.InternalVersionManagerImpl.<init>(InternalVersionManagerImpl.java:208)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:492)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:311)
>         at
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:589)
>         at
> org.apache.jackrabbit.jca.JCARepositoryManager.createNonTransientRepository(JCARepositoryManager.java:124)
>         at
> org.apache.jackrabbit.jca.JCARepositoryManager.createRepository(JCARepositoryManager.java:79)
>         at
>
>  org.apache.jackrabbit.jca.JCAManagedConnectionFactory.getRepository(JCAManagedConnectionFactory.java:205)
>         at
> org.apache.jackrabbit.jca.JCAManagedConnection.openSession(JCAManagedConnection.java:100)
>         ... 37 more
> Caused
>  by: org.apache.jackrabbit.core.state.ItemStateException: failed to read
>  bundle: deadbeef-face-babe-cafe-babecafebabe:
> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from
>  pool failed
>         at
>
> org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:841)
>
>  at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundleCacheMiss(AbstractBundlePersistenceManager.java:737)
>
>  at
>
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundle(AbstractBundlePersistenceManager.java:720)
>
>  at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.exists(AbstractBundlePersistenceManager.java:534)
>         at
> org.apache.jackrabbit.core.version.InternalVersionManagerImpl.<init>(InternalVersionManagerImpl.java:162)
>         ... 44 more
> Caused by: org.apache.commons.dbcp.SQLNestedException: Borrow
> prepareStatement from pool failed
>         at
> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:113)
>         at
> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
>         at
>
>  org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:386)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:370)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:366)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:493)
>         at
> org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:366)
>         at
>
>  org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:827)
>         ... 48 more
> Caused by: java.sql.SQLSyntaxErrorException: Table/View 'VERSION_BUNDLE'
> does not exist.
>         at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>         at org.apache.derby.client.am.SqlException.getSQLException(Unknown
> Source)
>         at org.apache.derby.client.am.Connection.prepareStatement(Unknown
> Source)
>         at
> org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:285)
>         at
> org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1179)
>         at
>
>  org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107)
>         ... 56 more
> Caused by: org.apache.derby.client.am.SqlException: Table/View
> 'VERSION_BUNDLE' does not exist.
>         at org.apache.derby.client.am.Statement.completeSqlca(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
> Source)
>         at
> org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
> Source)
>         at
> org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
> Source)
>         at
>  org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
> Source)
>         at
> org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown
> Source)
>         at
> org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown
> Source)
>         at
> org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
> Source)
>         at org.apache.derby.client.am.PreparedStatement.prepare(Unknown
> Source)
>         at org.apache.derby.client.am.Connection.prepareStatementX(Unknown
> Source)
>         ... 60 more
>



-- 
Ivan

Mime
View raw message