You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by yu wang <wa...@gmail.com> on 2012/08/10 08:55:59 UTC

Error like "Borrow prepareStatement from pool failed"

Hello,
I am using OpenJPA 1.2.2 in weblogic server. When connecting oracle
Database, it works well.
But when it connects 10.8.2.2, I got error messages like "Borrow
prepareStatement from pool failed".

My OpenJPA Properties in persistence.xml is like:

		<properties>

			<property name="openjpa.ConnectionDriverName"
				value="org.apache.commons.dbcp.BasicDataSource" />

                        <property name="openjpa.ConnectionProperties"
				value="driverClassName=org.apache.derby.jdbc.ClientDriver,

url=jdbc:derby://localhost:1527/test;create=true, username=app,
password=app,
                                maxActive=30, maxWait=10000,
poolPreparedStatements=true" />


			<!--  Single-JVM Data Cache  -->
			<property name="openjpa.RemoteCommitProvider" value="sjvm" />
			<property name="openjpa.DataCache"
				value="true(CacheSize=50000, SoftReferenceSize=0)" />
			<property name="openjpa.QueryCache" value="false" />
			<property name="openjpa.jdbc.QuerySQLCache" value="false" />
			<property name="openjpa.QueryCompilationCache"
				value="false" />

			<!-- Whether persistent fields retain their values on transaction commit -->
			<property name="openjpa.RetainState" value="false" />

			<property name="openjpa.jdbc.TransactionIsolation"
				value="read-committed" />

			<!-- EntityManager won't be thread safe -->
			<property name="openjpa.Multithreaded" value="false" />

			<property name="openjpa.Optimistic" value="true" />

			<property name="openjpa.FlushBeforeQueries" value="false" />


			<property name="openjpa.DetachState" value="loaded" />


			<!--
				A connection is obtained when each transaction begins (optimistic
or datastore), and is released when the
				transaction completes. Non-transactional connections are obtained on-demand.
			-->
			<property name="openjpa.ConnectionRetainMode"
				value="transaction" />

			
                        <property name="openjpa.jdbc.SynchronizeMappings"
				value="buildSchema(ForeignKeys=true)" />


			<property name="openjpa.jdbc.UpdateManager"
				value="operation-order" />

                        <property name="openjpa.Compatibility"
                            value="ReloadOnDetach=false,
FlushBeforeDetach=false"/>
			
			<property name="openjpa.jdbc.DBDictionary"
value="oracle(DatePrecision=1000)"/>

			<property name="openjpa.Log"
value="File=openjpa.log,DefaultLevel=TRACE,SQL=TRACE" />
		
		</properties>

My exception stack is like:
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'ActiveAgentList' defined in ServletContext
resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
to bean 'dao_container' while setting constructor argument; nested
exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'dao_container' defined in
ServletContext resource [/WEB-INF/applicationContext.xml]:
Instantiation of bean failed; nested exception is
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
	at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
	at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:481)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
	at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:181)
	at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1801)
	at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3045)
	at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1397)
	at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
	at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
	at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
	at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
	at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
	at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
	at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
	at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
	at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
	at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
	at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:1267)
	at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
	at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:409)
	at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:54)
	at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
	at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
	at weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
	at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
	at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
	at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
	at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
	at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
	at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
	at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
	at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
	at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
	at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
	at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'dao_container' defined in
ServletContext resource [/WEB-INF/applicationContext.xml]:
Instantiation of bean failed; nested exception is
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
	... 57 more
Caused by: org.springframework.beans.BeanInstantiationException: Could
not instantiate bean class [com.test.dao.DAOContainer]: Constructor
threw exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
	... 67 more
Caused by: com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
	at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
	... 69 more
Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
	at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
	at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
	at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
	at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
	at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)
	at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)
	at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)
	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:597)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:434)
	at $Proxy136.createEntityManager(Unknown Source)
	at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:62)
	... 75 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
	at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:153)
	at org.apache.openjpa.jdbc.sql.DBDictionary.prepareStatement(DBDictionary.java:4489)
	at org.apache.openjpa.jdbc.sql.DBDictionary.getSequences(DBDictionary.java:3619)
	at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSequences(SchemaGenerator.java:827)
	at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:338)
	at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:284)
	at org.apache.openjpa.jdbc.schema.SchemaTool.getDBSchemaGroup(SchemaTool.java:1133)
	at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)
	at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)
	at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:501)
	... 89 more
<Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
defined listener org.springframework.web.context.ContextLoaderListener
failed: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'ActiveAgentList' defined in ServletContext
resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
to bean 'dao_container' while setting constructor argument; nested
exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'dao_container' defined in
ServletContext resource [/WEB-INF/applicationContext.xml]:
Instantiation of bean failed; nested exception is
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null].
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'ActiveAgentList' defined in ServletContext
resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
to bean 'dao_container' while setting constructor argument; nested
exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'dao_container' defined in
ServletContext resource [/WEB-INF/applicationContext.xml]:
Instantiation of bean failed; nested exception is
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
	Truncated. see log file for complete stacktrace

Caused By: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'dao_container' defined in
ServletContext resource [/WEB-INF/applicationContext.xml]:
Instantiation of bean failed; nested exception is
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
	Truncated. see log file for complete stacktrace

Caused By: org.springframework.beans.BeanInstantiationException: Could
not instantiate bean class [com.test.dao.DAOContainer]: Constructor
threw exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
	Truncated. see log file for complete stacktrace

Caused By: com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
	at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	Truncated. see log file for complete stacktrace

Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
	at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
	at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
	at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
	at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
	Truncated. see log file for complete stacktrace

Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
	at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
	Truncated. see log file for complete stacktrace
>
<Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
defined listener com.test.ds.ListenerContext failed:
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'ActiveAgentList' defined in ServletContext
resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
to bean 'dao_container' while setting constructor argument; nested
exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'dao_container' defined in
ServletContext resource [/WEB-INF/applicationContext.xml]:
Instantiation of bean failed; nested exception is
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null].
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'ActiveAgentList' defined in ServletContext
resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
to bean 'dao_container' while setting constructor argument; nested
exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'dao_container' defined in
ServletContext resource [/WEB-INF/applicationContext.xml]:
Instantiation of bean failed; nested exception is
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
	Truncated. see log file for complete stacktrace

Caused By: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'dao_container' defined in
ServletContext resource [/WEB-INF/applicationContext.xml]:
Instantiation of bean failed; nested exception is
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
	Truncated. see log file for complete stacktrace

Caused By: org.springframework.beans.BeanInstantiationException: Could
not instantiate bean class [com.test.dao.DAOContainer]: Constructor
threw exception; nested exception is
com.test.exception.ExceptionServerInternal:
<openjpa0.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
	Truncated. see log file for complete stacktrace

Caused By: com.test.exception.ExceptionServerInternal:
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
	at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	Truncated. see log file for complete stacktrace

Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
	at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
	at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
	at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
	at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
	Truncated. see log file for complete stacktrace

Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
	at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
	Truncated. see log file for complete stacktrace
>
<Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149265> <Failure
occurred in the execution of deployment request with ID
'1344580668609' for task '0'. Error is:
'weblogic.application.ModuleException: '
weblogic.application.ModuleException:
	at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
	at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
	at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
	at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
	at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
	Truncated. see log file for complete stacktrace

Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
	at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
	Truncated. see log file for complete stacktrace
>
<Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149202>
<Encountered an exception while attempting to commit the 1 task for
the application 'adf'.>
<Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149004>
<Failures were detected while initiating deploy task for application
'adf'.>
<Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149078> <Stack
trace for message 149004
weblogic.application.ModuleException:
	at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
	at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
	at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
	at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
	at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
	Truncated. see log file for complete stacktrace

Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
state=null]
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
	at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
	Truncated. see log file for complete stacktrace
>
<Aug 10, 2012 2:38:19 PM CST> <Warning> <RMI> <BEA-080004> <An error
was thrown by rmi server:
javax.management.remote.rmi.RMIConnectionImpl.getAttribute(Ljavax.management.ObjectName;Ljava.lang.String;Ljavax.security.auth.Subject;)
 java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter.
java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter
	at java.lang.Class.getDeclaredMethods0(Native Method)
	at java.lang.Class.privateGetDeclaredMethods(Class.java:2427)
	at java.lang.Class.getDeclaredMethod(Class.java:1935)
	at java.io.ObjectStreamClass.getPrivateMethod(ObjectStreamClass.java:1382)
	at java.io.ObjectStreamClass.access$1700(ObjectStreamClass.java:52)
	Truncated. see log file for complete stacktrace

Caused By: java.lang.ClassNotFoundException:
org.apache.derby.client.am.LogWriter
	at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:296)
	at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:269)
	at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:56)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
	Truncated. see log file for complete stacktrace
>



Any suggestions will be appreciated.

Regards,
Yu Wang

Re: Error like "Borrow prepareStatement from pool failed"

Posted by yu wang <wa...@gmail.com>.
Yes, you are right. Thanks!

On Fri, Aug 10, 2012 at 9:47 PM, Rick Curtis <cu...@gmail.com> wrote:
>>  I guess it is a bug of OpenJPA 1.2.2..
> This is clearly a case of incorrect configuration... not a bug.
>
> You are connecting to Derby[1], yet you told OpenJPA that you were
> connecting to an Oracle[2] database.
>
> Thanks,
> Rick
>
> [1] <property name="openjpa.ConnectionProperties"
> value="driverClassName=org.apache.derby.jdbc.ClientDriver,url=jdbc:derby://localhost:1527/test;create=true,
> username=app,password=app,maxActive=30,
> maxWait=10000,poolPreparedStatements=true" />
> [2]  <property name="openjpa.jdbc.DBDictionary" value="oracle(DatePrecision=
> 1000)"/>
>
> On Fri, Aug 10, 2012 at 6:09 AM, yu wang <wa...@gmail.com> wrote:
>
>> Find the root cause.
>> If I comment out "<property name="openjpa.jdbc.DBDictionary"
>> value="oracle(DatePrecision=1000)"/>", then it works fine.
>>
>> I guess it is a bug of OpenJPA 1.2.2..
>>
>> Regards,
>> Yu Wang
>>
>> On Fri, Aug 10, 2012 at 6:44 PM, yu wang <wa...@gmail.com> wrote:
>> > Why there is a (+)  appended to the SQL?
>> >
>> > On Fri, Aug 10, 2012 at 5:19 PM, yu wang <wa...@gmail.com> wrote:
>> >> Hello,
>> >> I got a lot of error messages like:
>> >>
>> >> <ListPolicyPanel><refreshList> <openjpa-1.2.2-r422266:898935 nonfatal
>> >> general error> org.apache.openjpa.persistence.PersistenceException:
>> >> Syntax error: Encountered ")" at line 1, column 282. {SELECT t0.ID,
>> >> t0.AGENTTYPE, t0.ATTRIBUTES, t0.CREATEDTIME, t0.DEFINITION, t1.ID,
>> >> t1.ATTRIBUTES, t1.MASTER, t1.TUXMODE, t1.NAME, t1.STATUS, t1.TAG,
>> >> t0.MODIFIEDTIME, t0.NAME, t0.STATUS, t0.TSAMVERSION FROM POLICY t0,
>> >> TUXDOMAIN t1 WHERE (t0.AGENTTYPE = ?) AND t0.TUXDOMAINID = t1.ID(+)}
>> >> [code=-1, state=42X01]
>> >>
>> >>
>> >> Regards,
>> >> Yu Wang
>> >>
>> >>
>> >> On Fri, Aug 10, 2012 at 2:55 PM, yu wang <wa...@gmail.com> wrote:
>> >>> Hello,
>> >>> I am using OpenJPA 1.2.2 in weblogic server. When connecting oracle
>> >>> Database, it works well.
>> >>> But when it connects 10.8.2.2, I got error messages like "Borrow
>> >>> prepareStatement from pool failed".
>> >>>
>> >>> My OpenJPA Properties in persistence.xml is like:
>> >>>
>> >>>                 <properties>
>> >>>
>> >>>                         <property name="openjpa.ConnectionDriverName"
>> >>>
>> value="org.apache.commons.dbcp.BasicDataSource" />
>> >>>
>> >>>                         <property name="openjpa.ConnectionProperties"
>> >>>
>> value="driverClassName=org.apache.derby.jdbc.ClientDriver,
>> >>>
>> >>> url=jdbc:derby://localhost:1527/test;create=true, username=app,
>> >>> password=app,
>> >>>                                 maxActive=30, maxWait=10000,
>> >>> poolPreparedStatements=true" />
>> >>>
>> >>>
>> >>>                         <!--  Single-JVM Data Cache  -->
>> >>>                         <property name="openjpa.RemoteCommitProvider"
>> value="sjvm" />
>> >>>                         <property name="openjpa.DataCache"
>> >>>                                 value="true(CacheSize=50000,
>> SoftReferenceSize=0)" />
>> >>>                         <property name="openjpa.QueryCache"
>> value="false" />
>> >>>                         <property name="openjpa.jdbc.QuerySQLCache"
>> value="false" />
>> >>>                         <property name="openjpa.QueryCompilationCache"
>> >>>                                 value="false" />
>> >>>
>> >>>                         <!-- Whether persistent fields retain their
>> values on transaction commit -->
>> >>>                         <property name="openjpa.RetainState"
>> value="false" />
>> >>>
>> >>>                         <property
>> name="openjpa.jdbc.TransactionIsolation"
>> >>>                                 value="read-committed" />
>> >>>
>> >>>                         <!-- EntityManager won't be thread safe -->
>> >>>                         <property name="openjpa.Multithreaded"
>> value="false" />
>> >>>
>> >>>                         <property name="openjpa.Optimistic"
>> value="true" />
>> >>>
>> >>>                         <property name="openjpa.FlushBeforeQueries"
>> value="false" />
>> >>>
>> >>>
>> >>>                         <property name="openjpa.DetachState"
>> value="loaded" />
>> >>>
>> >>>
>> >>>                         <!--
>> >>>                                 A connection is obtained when each
>> transaction begins (optimistic
>> >>> or datastore), and is released when the
>> >>>                                 transaction completes.
>> Non-transactional connections are obtained on-demand.
>> >>>                         -->
>> >>>                         <property name="openjpa.ConnectionRetainMode"
>> >>>                                 value="transaction" />
>> >>>
>> >>>
>> >>>                         <property
>> name="openjpa.jdbc.SynchronizeMappings"
>> >>>                                 value="buildSchema(ForeignKeys=true)"
>> />
>> >>>
>> >>>
>> >>>                         <property name="openjpa.jdbc.UpdateManager"
>> >>>                                 value="operation-order" />
>> >>>
>> >>>                         <property name="openjpa.Compatibility"
>> >>>                             value="ReloadOnDetach=false,
>> >>> FlushBeforeDetach=false"/>
>> >>>
>> >>>                         <property name="openjpa.jdbc.DBDictionary"
>> >>> value="oracle(DatePrecision=1000)"/>
>> >>>
>> >>>                         <property name="openjpa.Log"
>> >>> value="File=openjpa.log,DefaultLevel=TRACE,SQL=TRACE" />
>> >>>
>> >>>                 </properties>
>> >>>
>> >>> My exception stack is like:
>> >>> org.springframework.beans.factory.BeanCreationException: Error
>> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> >>> to bean 'dao_container' while setting constructor argument; nested
>> >>> exception is org.springframework.beans.factory.BeanCreationException:
>> >>> Error creating bean with name 'dao_container' defined in
>> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> >>> Instantiation of bean failed; nested exception is
>> >>> org.springframework.beans.BeanInstantiationException: Could not
>> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> >>> exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>> >>>         at
>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>> >>>         at java.security.AccessController.doPrivileged(Native Method)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
>> >>>         at
>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
>> >>>         at
>> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
>> >>>         at
>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
>> >>>         at
>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
>> >>>         at
>> org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
>> >>>         at
>> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
>> >>>         at
>> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
>> >>>         at
>> weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:481)
>> >>>         at
>> weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
>> >>>         at
>> weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
>> >>>         at
>> weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:181)
>> >>>         at
>> weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1801)
>> >>>         at
>> weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3045)
>> >>>         at
>> weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1397)
>> >>>         at
>> weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>> >>>         at
>> weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>> >>>         at
>> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>> >>>         at
>> weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>> >>>         at
>> weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
>> >>>         at
>> weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
>> >>>         at
>> weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>> >>>         at
>> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>> >>>         at
>> weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>> >>>         at
>> weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
>> >>>         at
>> weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:1267)
>> >>>         at
>> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>> >>>         at
>> weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:409)
>> >>>         at
>> weblogic.application.internal.EarDeployment.activate(EarDeployment.java:54)
>> >>>         at
>> weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
>> >>>         at
>> weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
>> >>>         at
>> weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
>> >>>         at
>> weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
>> >>>         at
>> weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
>> >>>         at
>> weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
>> >>>         at
>> weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
>> >>>         at
>> weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
>> >>>         at
>> weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
>> >>>         at
>> weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
>> >>>         at
>> weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
>> >>>         at
>> weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
>> >>>         at
>> weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
>> >>>         at
>> weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
>> >>>         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
>> >>>         at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
>> >>> Caused by: org.springframework.beans.factory.BeanCreationException:
>> >>> Error creating bean with name 'dao_container' defined in
>> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> >>> Instantiation of bean failed; nested exception is
>> >>> org.springframework.beans.BeanInstantiationException: Could not
>> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> >>> exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>> >>>         at java.security.AccessController.doPrivileged(Native Method)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
>> >>>         at
>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
>> >>>         ... 57 more
>> >>> Caused by: org.springframework.beans.BeanInstantiationException: Could
>> >>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
>> >>> threw exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>> >>>         at
>> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>> >>>         ... 67 more
>> >>> Caused by: com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>> >>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>> >>>         at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>> >>>         at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>> >>>         at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>> >>>         at
>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>> >>>         at
>> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
>> >>>         ... 69 more
>> >>> Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>> >>>         at
>> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>> >>>         at
>> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>> >>>         at
>> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>> >>>         at
>> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>> >>>         at
>> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)
>> >>>         at
>> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)
>> >>>         at
>> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)
>> >>>         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:597)
>> >>>         at
>> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:434)
>> >>>         at $Proxy136.createEntityManager(Unknown Source)
>> >>>         at
>> com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:62)
>> >>>         ... 75 more
>> >>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:153)
>> >>>         at
>> org.apache.openjpa.jdbc.sql.DBDictionary.prepareStatement(DBDictionary.java:4489)
>> >>>         at
>> org.apache.openjpa.jdbc.sql.DBDictionary.getSequences(DBDictionary.java:3619)
>> >>>         at
>> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSequences(SchemaGenerator.java:827)
>> >>>         at
>> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:338)
>> >>>         at
>> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:284)
>> >>>         at
>> org.apache.openjpa.jdbc.schema.SchemaTool.getDBSchemaGroup(SchemaTool.java:1133)
>> >>>         at
>> org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)
>> >>>         at
>> org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)
>> >>>         at
>> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:501)
>> >>>         ... 89 more
>> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
>> >>> defined listener org.springframework.web.context.ContextLoaderListener
>> >>> failed: org.springframework.beans.factory.BeanCreationException: Error
>> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> >>> to bean 'dao_container' while setting constructor argument; nested
>> >>> exception is org.springframework.beans.factory.BeanCreationException:
>> >>> Error creating bean with name 'dao_container' defined in
>> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> >>> Instantiation of bean failed; nested exception is
>> >>> org.springframework.beans.BeanInstantiationException: Could not
>> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> >>> exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null].
>> >>> org.springframework.beans.factory.BeanCreationException: Error
>> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> >>> to bean 'dao_container' while setting constructor argument; nested
>> >>> exception is org.springframework.beans.factory.BeanCreationException:
>> >>> Error creating bean with name 'dao_container' defined in
>> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> >>> Instantiation of bean failed; nested exception is
>> >>> org.springframework.beans.BeanInstantiationException: Could not
>> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> >>> exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>> >>>         at
>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: org.springframework.beans.factory.BeanCreationException:
>> >>> Error creating bean with name 'dao_container' defined in
>> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> >>> Instantiation of bean failed; nested exception is
>> >>> org.springframework.beans.BeanInstantiationException: Could not
>> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> >>> exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: org.springframework.beans.BeanInstantiationException: Could
>> >>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
>> >>> threw exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>> >>>         at
>> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>> >>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>> >>>         at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>> >>>         at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>> >>>         at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>> >>>         at
>> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>> >>>         at
>> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>> >>>         at
>> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>> >>>         at
>> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>>
>> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
>> >>> defined listener com.test.ds.ListenerContext failed:
>> >>> org.springframework.beans.factory.BeanCreationException: Error
>> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> >>> to bean 'dao_container' while setting constructor argument; nested
>> >>> exception is org.springframework.beans.factory.BeanCreationException:
>> >>> Error creating bean with name 'dao_container' defined in
>> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> >>> Instantiation of bean failed; nested exception is
>> >>> org.springframework.beans.BeanInstantiationException: Could not
>> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> >>> exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null].
>> >>> org.springframework.beans.factory.BeanCreationException: Error
>> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> >>> to bean 'dao_container' while setting constructor argument; nested
>> >>> exception is org.springframework.beans.factory.BeanCreationException:
>> >>> Error creating bean with name 'dao_container' defined in
>> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> >>> Instantiation of bean failed; nested exception is
>> >>> org.springframework.beans.BeanInstantiationException: Could not
>> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> >>> exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>> >>>         at
>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: org.springframework.beans.factory.BeanCreationException:
>> >>> Error creating bean with name 'dao_container' defined in
>> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> >>> Instantiation of bean failed; nested exception is
>> >>> org.springframework.beans.BeanInstantiationException: Could not
>> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> >>> exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: org.springframework.beans.BeanInstantiationException: Could
>> >>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
>> >>> threw exception; nested exception is
>> >>> com.test.exception.ExceptionServerInternal:
>> >>> <openjpa0.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>> >>>         at
>> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>> >>>         at
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>> >>>         at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: com.test.exception.ExceptionServerInternal:
>> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>> >>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>> >>>         at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>> >>>         at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>> >>>         at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>> >>>         at
>> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>> >>>         at
>> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>> >>>         at
>> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>> >>>         at
>> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>>
>> >>> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149265> <Failure
>> >>> occurred in the execution of deployment request with ID
>> >>> '1344580668609' for task '0'. Error is:
>> >>> 'weblogic.application.ModuleException: '
>> >>> weblogic.application.ModuleException:
>> >>>         at
>> weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
>> >>>         at
>> weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>> >>>         at
>> weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>> >>>         at
>> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>> >>>         at
>> weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>>
>> >>> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149202>
>> >>> <Encountered an exception while attempting to commit the 1 task for
>> >>> the application 'adf'.>
>> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149004>
>> >>> <Failures were detected while initiating deploy task for application
>> >>> 'adf'.>
>> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149078> <Stack
>> >>> trace for message 149004
>> >>> weblogic.application.ModuleException:
>> >>>         at
>> weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
>> >>>         at
>> weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>> >>>         at
>> weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>> >>>         at
>> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>> >>>         at
>> weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> >>> state=null]
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>> >>>         at
>> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>>
>> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <RMI> <BEA-080004> <An error
>> >>> was thrown by rmi server:
>> >>>
>> javax.management.remote.rmi.RMIConnectionImpl.getAttribute(Ljavax.management.ObjectName;Ljava.lang.String;Ljavax.security.auth.Subject;)
>> >>>  java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter.
>> >>> java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter
>> >>>         at java.lang.Class.getDeclaredMethods0(Native Method)
>> >>>         at java.lang.Class.privateGetDeclaredMethods(Class.java:2427)
>> >>>         at java.lang.Class.getDeclaredMethod(Class.java:1935)
>> >>>         at
>> java.io.ObjectStreamClass.getPrivateMethod(ObjectStreamClass.java:1382)
>> >>>         at
>> java.io.ObjectStreamClass.access$1700(ObjectStreamClass.java:52)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>
>> >>> Caused By: java.lang.ClassNotFoundException:
>> >>> org.apache.derby.client.am.LogWriter
>> >>>         at
>> weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:296)
>> >>>         at
>> weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:269)
>> >>>         at
>> weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:56)
>> >>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
>> >>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
>> >>>         Truncated. see log file for complete stacktrace
>> >>>>
>> >>>
>> >>>
>> >>>
>> >>> Any suggestions will be appreciated.
>> >>>
>> >>> Regards,
>> >>> Yu Wang
>>
>
>
>
> --
> *Rick Curtis*

Re: Error like "Borrow prepareStatement from pool failed"

Posted by Rick Curtis <cu...@gmail.com>.
>  I guess it is a bug of OpenJPA 1.2.2..
This is clearly a case of incorrect configuration... not a bug.

You are connecting to Derby[1], yet you told OpenJPA that you were
connecting to an Oracle[2] database.

Thanks,
Rick

[1] <property name="openjpa.ConnectionProperties"
value="driverClassName=org.apache.derby.jdbc.ClientDriver,url=jdbc:derby://localhost:1527/test;create=true,
username=app,password=app,maxActive=30,
maxWait=10000,poolPreparedStatements=true" />
[2]  <property name="openjpa.jdbc.DBDictionary" value="oracle(DatePrecision=
1000)"/>

On Fri, Aug 10, 2012 at 6:09 AM, yu wang <wa...@gmail.com> wrote:

> Find the root cause.
> If I comment out "<property name="openjpa.jdbc.DBDictionary"
> value="oracle(DatePrecision=1000)"/>", then it works fine.
>
> I guess it is a bug of OpenJPA 1.2.2..
>
> Regards,
> Yu Wang
>
> On Fri, Aug 10, 2012 at 6:44 PM, yu wang <wa...@gmail.com> wrote:
> > Why there is a (+)  appended to the SQL?
> >
> > On Fri, Aug 10, 2012 at 5:19 PM, yu wang <wa...@gmail.com> wrote:
> >> Hello,
> >> I got a lot of error messages like:
> >>
> >> <ListPolicyPanel><refreshList> <openjpa-1.2.2-r422266:898935 nonfatal
> >> general error> org.apache.openjpa.persistence.PersistenceException:
> >> Syntax error: Encountered ")" at line 1, column 282. {SELECT t0.ID,
> >> t0.AGENTTYPE, t0.ATTRIBUTES, t0.CREATEDTIME, t0.DEFINITION, t1.ID,
> >> t1.ATTRIBUTES, t1.MASTER, t1.TUXMODE, t1.NAME, t1.STATUS, t1.TAG,
> >> t0.MODIFIEDTIME, t0.NAME, t0.STATUS, t0.TSAMVERSION FROM POLICY t0,
> >> TUXDOMAIN t1 WHERE (t0.AGENTTYPE = ?) AND t0.TUXDOMAINID = t1.ID(+)}
> >> [code=-1, state=42X01]
> >>
> >>
> >> Regards,
> >> Yu Wang
> >>
> >>
> >> On Fri, Aug 10, 2012 at 2:55 PM, yu wang <wa...@gmail.com> wrote:
> >>> Hello,
> >>> I am using OpenJPA 1.2.2 in weblogic server. When connecting oracle
> >>> Database, it works well.
> >>> But when it connects 10.8.2.2, I got error messages like "Borrow
> >>> prepareStatement from pool failed".
> >>>
> >>> My OpenJPA Properties in persistence.xml is like:
> >>>
> >>>                 <properties>
> >>>
> >>>                         <property name="openjpa.ConnectionDriverName"
> >>>
> value="org.apache.commons.dbcp.BasicDataSource" />
> >>>
> >>>                         <property name="openjpa.ConnectionProperties"
> >>>
> value="driverClassName=org.apache.derby.jdbc.ClientDriver,
> >>>
> >>> url=jdbc:derby://localhost:1527/test;create=true, username=app,
> >>> password=app,
> >>>                                 maxActive=30, maxWait=10000,
> >>> poolPreparedStatements=true" />
> >>>
> >>>
> >>>                         <!--  Single-JVM Data Cache  -->
> >>>                         <property name="openjpa.RemoteCommitProvider"
> value="sjvm" />
> >>>                         <property name="openjpa.DataCache"
> >>>                                 value="true(CacheSize=50000,
> SoftReferenceSize=0)" />
> >>>                         <property name="openjpa.QueryCache"
> value="false" />
> >>>                         <property name="openjpa.jdbc.QuerySQLCache"
> value="false" />
> >>>                         <property name="openjpa.QueryCompilationCache"
> >>>                                 value="false" />
> >>>
> >>>                         <!-- Whether persistent fields retain their
> values on transaction commit -->
> >>>                         <property name="openjpa.RetainState"
> value="false" />
> >>>
> >>>                         <property
> name="openjpa.jdbc.TransactionIsolation"
> >>>                                 value="read-committed" />
> >>>
> >>>                         <!-- EntityManager won't be thread safe -->
> >>>                         <property name="openjpa.Multithreaded"
> value="false" />
> >>>
> >>>                         <property name="openjpa.Optimistic"
> value="true" />
> >>>
> >>>                         <property name="openjpa.FlushBeforeQueries"
> value="false" />
> >>>
> >>>
> >>>                         <property name="openjpa.DetachState"
> value="loaded" />
> >>>
> >>>
> >>>                         <!--
> >>>                                 A connection is obtained when each
> transaction begins (optimistic
> >>> or datastore), and is released when the
> >>>                                 transaction completes.
> Non-transactional connections are obtained on-demand.
> >>>                         -->
> >>>                         <property name="openjpa.ConnectionRetainMode"
> >>>                                 value="transaction" />
> >>>
> >>>
> >>>                         <property
> name="openjpa.jdbc.SynchronizeMappings"
> >>>                                 value="buildSchema(ForeignKeys=true)"
> />
> >>>
> >>>
> >>>                         <property name="openjpa.jdbc.UpdateManager"
> >>>                                 value="operation-order" />
> >>>
> >>>                         <property name="openjpa.Compatibility"
> >>>                             value="ReloadOnDetach=false,
> >>> FlushBeforeDetach=false"/>
> >>>
> >>>                         <property name="openjpa.jdbc.DBDictionary"
> >>> value="oracle(DatePrecision=1000)"/>
> >>>
> >>>                         <property name="openjpa.Log"
> >>> value="File=openjpa.log,DefaultLevel=TRACE,SQL=TRACE" />
> >>>
> >>>                 </properties>
> >>>
> >>> My exception stack is like:
> >>> org.springframework.beans.factory.BeanCreationException: Error
> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> >>> to bean 'dao_container' while setting constructor argument; nested
> >>> exception is org.springframework.beans.factory.BeanCreationException:
> >>> Error creating bean with name 'dao_container' defined in
> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
> >>> Instantiation of bean failed; nested exception is
> >>> org.springframework.beans.BeanInstantiationException: Could not
> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> >>> exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
> >>>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> >>>         at java.security.AccessController.doPrivileged(Native Method)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> >>>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
> >>>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
> >>>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
> >>>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
> >>>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
> >>>         at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
> >>>         at
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
> >>>         at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
> >>>         at
> org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
> >>>         at
> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
> >>>         at
> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
> >>>         at
> weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:481)
> >>>         at
> weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
> >>>         at
> weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
> >>>         at
> weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:181)
> >>>         at
> weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1801)
> >>>         at
> weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3045)
> >>>         at
> weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1397)
> >>>         at
> weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
> >>>         at
> weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
> >>>         at
> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
> >>>         at
> weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
> >>>         at
> weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
> >>>         at
> weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
> >>>         at
> weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
> >>>         at
> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
> >>>         at
> weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
> >>>         at
> weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
> >>>         at
> weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:1267)
> >>>         at
> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
> >>>         at
> weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:409)
> >>>         at
> weblogic.application.internal.EarDeployment.activate(EarDeployment.java:54)
> >>>         at
> weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
> >>>         at
> weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
> >>>         at
> weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
> >>>         at
> weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
> >>>         at
> weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
> >>>         at
> weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
> >>>         at
> weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
> >>>         at
> weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
> >>>         at
> weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
> >>>         at
> weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
> >>>         at
> weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
> >>>         at
> weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
> >>>         at
> weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
> >>>         at
> weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
> >>>         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
> >>>         at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
> >>> Caused by: org.springframework.beans.factory.BeanCreationException:
> >>> Error creating bean with name 'dao_container' defined in
> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
> >>> Instantiation of bean failed; nested exception is
> >>> org.springframework.beans.BeanInstantiationException: Could not
> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> >>> exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> >>>         at java.security.AccessController.doPrivileged(Native Method)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> >>>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283)
> >>>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
> >>>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
> >>>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
> >>>         ... 57 more
> >>> Caused by: org.springframework.beans.BeanInstantiationException: Could
> >>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
> >>> threw exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
> >>>         at
> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
> >>>         ... 67 more
> >>> Caused by: com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
> >>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
> >>>         at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> >>>         at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> >>>         at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> >>>         at
> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> >>>         at
> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
> >>>         ... 69 more
> >>> Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
> >>>         at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
> >>>         at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
> >>>         at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
> >>>         at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
> >>>         at
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)
> >>>         at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)
> >>>         at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)
> >>>         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:597)
> >>>         at
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:434)
> >>>         at $Proxy136.createEntityManager(Unknown Source)
> >>>         at
> com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:62)
> >>>         ... 75 more
> >>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
> >>>         at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
> >>>         at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
> >>>         at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:153)
> >>>         at
> org.apache.openjpa.jdbc.sql.DBDictionary.prepareStatement(DBDictionary.java:4489)
> >>>         at
> org.apache.openjpa.jdbc.sql.DBDictionary.getSequences(DBDictionary.java:3619)
> >>>         at
> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSequences(SchemaGenerator.java:827)
> >>>         at
> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:338)
> >>>         at
> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:284)
> >>>         at
> org.apache.openjpa.jdbc.schema.SchemaTool.getDBSchemaGroup(SchemaTool.java:1133)
> >>>         at
> org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)
> >>>         at
> org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)
> >>>         at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:501)
> >>>         ... 89 more
> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
> >>> defined listener org.springframework.web.context.ContextLoaderListener
> >>> failed: org.springframework.beans.factory.BeanCreationException: Error
> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> >>> to bean 'dao_container' while setting constructor argument; nested
> >>> exception is org.springframework.beans.factory.BeanCreationException:
> >>> Error creating bean with name 'dao_container' defined in
> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
> >>> Instantiation of bean failed; nested exception is
> >>> org.springframework.beans.BeanInstantiationException: Could not
> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> >>> exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null].
> >>> org.springframework.beans.factory.BeanCreationException: Error
> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> >>> to bean 'dao_container' while setting constructor argument; nested
> >>> exception is org.springframework.beans.factory.BeanCreationException:
> >>> Error creating bean with name 'dao_container' defined in
> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
> >>> Instantiation of bean failed; nested exception is
> >>> org.springframework.beans.BeanInstantiationException: Could not
> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> >>> exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
> >>>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: org.springframework.beans.factory.BeanCreationException:
> >>> Error creating bean with name 'dao_container' defined in
> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
> >>> Instantiation of bean failed; nested exception is
> >>> org.springframework.beans.BeanInstantiationException: Could not
> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> >>> exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: org.springframework.beans.BeanInstantiationException: Could
> >>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
> >>> threw exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
> >>>         at
> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
> >>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
> >>>         at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> >>>         at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> >>>         at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
> >>>         at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
> >>>         at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
> >>>         at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
> >>>         at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
> >>>         at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
> >>>         at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
> >>>         Truncated. see log file for complete stacktrace
> >>>>
> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
> >>> defined listener com.test.ds.ListenerContext failed:
> >>> org.springframework.beans.factory.BeanCreationException: Error
> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> >>> to bean 'dao_container' while setting constructor argument; nested
> >>> exception is org.springframework.beans.factory.BeanCreationException:
> >>> Error creating bean with name 'dao_container' defined in
> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
> >>> Instantiation of bean failed; nested exception is
> >>> org.springframework.beans.BeanInstantiationException: Could not
> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> >>> exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null].
> >>> org.springframework.beans.factory.BeanCreationException: Error
> >>> creating bean with name 'ActiveAgentList' defined in ServletContext
> >>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> >>> to bean 'dao_container' while setting constructor argument; nested
> >>> exception is org.springframework.beans.factory.BeanCreationException:
> >>> Error creating bean with name 'dao_container' defined in
> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
> >>> Instantiation of bean failed; nested exception is
> >>> org.springframework.beans.BeanInstantiationException: Could not
> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> >>> exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
> >>>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: org.springframework.beans.factory.BeanCreationException:
> >>> Error creating bean with name 'dao_container' defined in
> >>> ServletContext resource [/WEB-INF/applicationContext.xml]:
> >>> Instantiation of bean failed; nested exception is
> >>> org.springframework.beans.BeanInstantiationException: Could not
> >>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> >>> exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: org.springframework.beans.BeanInstantiationException: Could
> >>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
> >>> threw exception; nested exception is
> >>> com.test.exception.ExceptionServerInternal:
> >>> <openjpa0.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
> >>>         at
> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
> >>>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
> >>>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: com.test.exception.ExceptionServerInternal:
> >>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
> >>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
> >>>         at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> >>>         at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> >>>         at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
> >>> org.apache.openjpa.persistence.PersistenceException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
> >>>         at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
> >>>         at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
> >>>         at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
> >>>         at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
> >>>         at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
> >>>         at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
> >>>         Truncated. see log file for complete stacktrace
> >>>>
> >>> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149265> <Failure
> >>> occurred in the execution of deployment request with ID
> >>> '1344580668609' for task '0'. Error is:
> >>> 'weblogic.application.ModuleException: '
> >>> weblogic.application.ModuleException:
> >>>         at
> weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
> >>>         at
> weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
> >>>         at
> weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
> >>>         at
> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
> >>>         at
> weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
> >>>         at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
> >>>         at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
> >>>         Truncated. see log file for complete stacktrace
> >>>>
> >>> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149202>
> >>> <Encountered an exception while attempting to commit the 1 task for
> >>> the application 'adf'.>
> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149004>
> >>> <Failures were detected while initiating deploy task for application
> >>> 'adf'.>
> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149078> <Stack
> >>> trace for message 149004
> >>> weblogic.application.ModuleException:
> >>>         at
> weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
> >>>         at
> weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
> >>>         at
> weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
> >>>         at
> weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
> >>>         at
> weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> >>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> >>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> >>> state=null]
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
> >>>         at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
> >>>         at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
> >>>         at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
> >>>         Truncated. see log file for complete stacktrace
> >>>>
> >>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <RMI> <BEA-080004> <An error
> >>> was thrown by rmi server:
> >>>
> javax.management.remote.rmi.RMIConnectionImpl.getAttribute(Ljavax.management.ObjectName;Ljava.lang.String;Ljavax.security.auth.Subject;)
> >>>  java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter.
> >>> java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter
> >>>         at java.lang.Class.getDeclaredMethods0(Native Method)
> >>>         at java.lang.Class.privateGetDeclaredMethods(Class.java:2427)
> >>>         at java.lang.Class.getDeclaredMethod(Class.java:1935)
> >>>         at
> java.io.ObjectStreamClass.getPrivateMethod(ObjectStreamClass.java:1382)
> >>>         at
> java.io.ObjectStreamClass.access$1700(ObjectStreamClass.java:52)
> >>>         Truncated. see log file for complete stacktrace
> >>>
> >>> Caused By: java.lang.ClassNotFoundException:
> >>> org.apache.derby.client.am.LogWriter
> >>>         at
> weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:296)
> >>>         at
> weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:269)
> >>>         at
> weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:56)
> >>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
> >>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
> >>>         Truncated. see log file for complete stacktrace
> >>>>
> >>>
> >>>
> >>>
> >>> Any suggestions will be appreciated.
> >>>
> >>> Regards,
> >>> Yu Wang
>



-- 
*Rick Curtis*

Re: Error like "Borrow prepareStatement from pool failed"

Posted by yu wang <wa...@gmail.com>.
Find the root cause.
If I comment out "<property name="openjpa.jdbc.DBDictionary"
value="oracle(DatePrecision=1000)"/>", then it works fine.

I guess it is a bug of OpenJPA 1.2.2..

Regards,
Yu Wang

On Fri, Aug 10, 2012 at 6:44 PM, yu wang <wa...@gmail.com> wrote:
> Why there is a (+)  appended to the SQL?
>
> On Fri, Aug 10, 2012 at 5:19 PM, yu wang <wa...@gmail.com> wrote:
>> Hello,
>> I got a lot of error messages like:
>>
>> <ListPolicyPanel><refreshList> <openjpa-1.2.2-r422266:898935 nonfatal
>> general error> org.apache.openjpa.persistence.PersistenceException:
>> Syntax error: Encountered ")" at line 1, column 282. {SELECT t0.ID,
>> t0.AGENTTYPE, t0.ATTRIBUTES, t0.CREATEDTIME, t0.DEFINITION, t1.ID,
>> t1.ATTRIBUTES, t1.MASTER, t1.TUXMODE, t1.NAME, t1.STATUS, t1.TAG,
>> t0.MODIFIEDTIME, t0.NAME, t0.STATUS, t0.TSAMVERSION FROM POLICY t0,
>> TUXDOMAIN t1 WHERE (t0.AGENTTYPE = ?) AND t0.TUXDOMAINID = t1.ID(+)}
>> [code=-1, state=42X01]
>>
>>
>> Regards,
>> Yu Wang
>>
>>
>> On Fri, Aug 10, 2012 at 2:55 PM, yu wang <wa...@gmail.com> wrote:
>>> Hello,
>>> I am using OpenJPA 1.2.2 in weblogic server. When connecting oracle
>>> Database, it works well.
>>> But when it connects 10.8.2.2, I got error messages like "Borrow
>>> prepareStatement from pool failed".
>>>
>>> My OpenJPA Properties in persistence.xml is like:
>>>
>>>                 <properties>
>>>
>>>                         <property name="openjpa.ConnectionDriverName"
>>>                                 value="org.apache.commons.dbcp.BasicDataSource" />
>>>
>>>                         <property name="openjpa.ConnectionProperties"
>>>                                 value="driverClassName=org.apache.derby.jdbc.ClientDriver,
>>>
>>> url=jdbc:derby://localhost:1527/test;create=true, username=app,
>>> password=app,
>>>                                 maxActive=30, maxWait=10000,
>>> poolPreparedStatements=true" />
>>>
>>>
>>>                         <!--  Single-JVM Data Cache  -->
>>>                         <property name="openjpa.RemoteCommitProvider" value="sjvm" />
>>>                         <property name="openjpa.DataCache"
>>>                                 value="true(CacheSize=50000, SoftReferenceSize=0)" />
>>>                         <property name="openjpa.QueryCache" value="false" />
>>>                         <property name="openjpa.jdbc.QuerySQLCache" value="false" />
>>>                         <property name="openjpa.QueryCompilationCache"
>>>                                 value="false" />
>>>
>>>                         <!-- Whether persistent fields retain their values on transaction commit -->
>>>                         <property name="openjpa.RetainState" value="false" />
>>>
>>>                         <property name="openjpa.jdbc.TransactionIsolation"
>>>                                 value="read-committed" />
>>>
>>>                         <!-- EntityManager won't be thread safe -->
>>>                         <property name="openjpa.Multithreaded" value="false" />
>>>
>>>                         <property name="openjpa.Optimistic" value="true" />
>>>
>>>                         <property name="openjpa.FlushBeforeQueries" value="false" />
>>>
>>>
>>>                         <property name="openjpa.DetachState" value="loaded" />
>>>
>>>
>>>                         <!--
>>>                                 A connection is obtained when each transaction begins (optimistic
>>> or datastore), and is released when the
>>>                                 transaction completes. Non-transactional connections are obtained on-demand.
>>>                         -->
>>>                         <property name="openjpa.ConnectionRetainMode"
>>>                                 value="transaction" />
>>>
>>>
>>>                         <property name="openjpa.jdbc.SynchronizeMappings"
>>>                                 value="buildSchema(ForeignKeys=true)" />
>>>
>>>
>>>                         <property name="openjpa.jdbc.UpdateManager"
>>>                                 value="operation-order" />
>>>
>>>                         <property name="openjpa.Compatibility"
>>>                             value="ReloadOnDetach=false,
>>> FlushBeforeDetach=false"/>
>>>
>>>                         <property name="openjpa.jdbc.DBDictionary"
>>> value="oracle(DatePrecision=1000)"/>
>>>
>>>                         <property name="openjpa.Log"
>>> value="File=openjpa.log,DefaultLevel=TRACE,SQL=TRACE" />
>>>
>>>                 </properties>
>>>
>>> My exception stack is like:
>>> org.springframework.beans.factory.BeanCreationException: Error
>>> creating bean with name 'ActiveAgentList' defined in ServletContext
>>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>>> to bean 'dao_container' while setting constructor argument; nested
>>> exception is org.springframework.beans.factory.BeanCreationException:
>>> Error creating bean with name 'dao_container' defined in
>>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>>> Instantiation of bean failed; nested exception is
>>> org.springframework.beans.BeanInstantiationException: Could not
>>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>>> exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>>>         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>>>         at java.security.AccessController.doPrivileged(Native Method)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
>>>         at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
>>>         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>>>         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
>>>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
>>>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
>>>         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
>>>         at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
>>>         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
>>>         at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
>>>         at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
>>>         at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
>>>         at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:481)
>>>         at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
>>>         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
>>>         at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:181)
>>>         at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1801)
>>>         at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3045)
>>>         at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1397)
>>>         at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>>>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>>>         at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
>>>         at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
>>>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>>>         at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
>>>         at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:1267)
>>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>>         at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:409)
>>>         at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:54)
>>>         at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
>>>         at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
>>>         at weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
>>>         at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
>>>         at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
>>>         at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
>>>         at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
>>>         at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
>>>         at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
>>>         at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
>>>         at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
>>>         at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
>>>         at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
>>>         at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
>>>         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
>>>         at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
>>> Caused by: org.springframework.beans.factory.BeanCreationException:
>>> Error creating bean with name 'dao_container' defined in
>>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>>> Instantiation of bean failed; nested exception is
>>> org.springframework.beans.BeanInstantiationException: Could not
>>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>>> exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>>>         at java.security.AccessController.doPrivileged(Native Method)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
>>>         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283)
>>>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
>>>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
>>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
>>>         ... 57 more
>>> Caused by: org.springframework.beans.BeanInstantiationException: Could
>>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
>>> threw exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>>>         at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>>>         ... 67 more
>>> Caused by: com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>>         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>>>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
>>>         ... 69 more
>>> Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>>>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>>>         at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)
>>>         at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)
>>>         at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)
>>>         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:597)
>>>         at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:434)
>>>         at $Proxy136.createEntityManager(Unknown Source)
>>>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:62)
>>>         ... 75 more
>>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:153)
>>>         at org.apache.openjpa.jdbc.sql.DBDictionary.prepareStatement(DBDictionary.java:4489)
>>>         at org.apache.openjpa.jdbc.sql.DBDictionary.getSequences(DBDictionary.java:3619)
>>>         at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSequences(SchemaGenerator.java:827)
>>>         at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:338)
>>>         at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:284)
>>>         at org.apache.openjpa.jdbc.schema.SchemaTool.getDBSchemaGroup(SchemaTool.java:1133)
>>>         at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)
>>>         at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)
>>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:501)
>>>         ... 89 more
>>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
>>> defined listener org.springframework.web.context.ContextLoaderListener
>>> failed: org.springframework.beans.factory.BeanCreationException: Error
>>> creating bean with name 'ActiveAgentList' defined in ServletContext
>>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>>> to bean 'dao_container' while setting constructor argument; nested
>>> exception is org.springframework.beans.factory.BeanCreationException:
>>> Error creating bean with name 'dao_container' defined in
>>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>>> Instantiation of bean failed; nested exception is
>>> org.springframework.beans.BeanInstantiationException: Could not
>>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>>> exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null].
>>> org.springframework.beans.factory.BeanCreationException: Error
>>> creating bean with name 'ActiveAgentList' defined in ServletContext
>>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>>> to bean 'dao_container' while setting constructor argument; nested
>>> exception is org.springframework.beans.factory.BeanCreationException:
>>> Error creating bean with name 'dao_container' defined in
>>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>>> Instantiation of bean failed; nested exception is
>>> org.springframework.beans.BeanInstantiationException: Could not
>>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>>> exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>>>         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: org.springframework.beans.factory.BeanCreationException:
>>> Error creating bean with name 'dao_container' defined in
>>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>>> Instantiation of bean failed; nested exception is
>>> org.springframework.beans.BeanInstantiationException: Could not
>>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>>> exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: org.springframework.beans.BeanInstantiationException: Could
>>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
>>> threw exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>>>         at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>>>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>>         Truncated. see log file for complete stacktrace
>>>>
>>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
>>> defined listener com.test.ds.ListenerContext failed:
>>> org.springframework.beans.factory.BeanCreationException: Error
>>> creating bean with name 'ActiveAgentList' defined in ServletContext
>>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>>> to bean 'dao_container' while setting constructor argument; nested
>>> exception is org.springframework.beans.factory.BeanCreationException:
>>> Error creating bean with name 'dao_container' defined in
>>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>>> Instantiation of bean failed; nested exception is
>>> org.springframework.beans.BeanInstantiationException: Could not
>>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>>> exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null].
>>> org.springframework.beans.factory.BeanCreationException: Error
>>> creating bean with name 'ActiveAgentList' defined in ServletContext
>>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>>> to bean 'dao_container' while setting constructor argument; nested
>>> exception is org.springframework.beans.factory.BeanCreationException:
>>> Error creating bean with name 'dao_container' defined in
>>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>>> Instantiation of bean failed; nested exception is
>>> org.springframework.beans.BeanInstantiationException: Could not
>>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>>> exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>>>         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: org.springframework.beans.factory.BeanCreationException:
>>> Error creating bean with name 'dao_container' defined in
>>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>>> Instantiation of bean failed; nested exception is
>>> org.springframework.beans.BeanInstantiationException: Could not
>>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>>> exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: org.springframework.beans.BeanInstantiationException: Could
>>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
>>> threw exception; nested exception is
>>> com.test.exception.ExceptionServerInternal:
>>> <openjpa0.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>>>         at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: com.test.exception.ExceptionServerInternal:
>>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>>>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>>         Truncated. see log file for complete stacktrace
>>>>
>>> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149265> <Failure
>>> occurred in the execution of deployment request with ID
>>> '1344580668609' for task '0'. Error is:
>>> 'weblogic.application.ModuleException: '
>>> weblogic.application.ModuleException:
>>>         at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
>>>         at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>>>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>>         Truncated. see log file for complete stacktrace
>>>>
>>> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149202>
>>> <Encountered an exception while attempting to commit the 1 task for
>>> the application 'adf'.>
>>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149004>
>>> <Failures were detected while initiating deploy task for application
>>> 'adf'.>
>>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149078> <Stack
>>> trace for message 149004
>>> weblogic.application.ModuleException:
>>>         at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
>>>         at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>>>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>>> state=null]
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>>         Truncated. see log file for complete stacktrace
>>>>
>>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <RMI> <BEA-080004> <An error
>>> was thrown by rmi server:
>>> javax.management.remote.rmi.RMIConnectionImpl.getAttribute(Ljavax.management.ObjectName;Ljava.lang.String;Ljavax.security.auth.Subject;)
>>>  java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter.
>>> java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter
>>>         at java.lang.Class.getDeclaredMethods0(Native Method)
>>>         at java.lang.Class.privateGetDeclaredMethods(Class.java:2427)
>>>         at java.lang.Class.getDeclaredMethod(Class.java:1935)
>>>         at java.io.ObjectStreamClass.getPrivateMethod(ObjectStreamClass.java:1382)
>>>         at java.io.ObjectStreamClass.access$1700(ObjectStreamClass.java:52)
>>>         Truncated. see log file for complete stacktrace
>>>
>>> Caused By: java.lang.ClassNotFoundException:
>>> org.apache.derby.client.am.LogWriter
>>>         at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:296)
>>>         at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:269)
>>>         at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:56)
>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
>>>         Truncated. see log file for complete stacktrace
>>>>
>>>
>>>
>>>
>>> Any suggestions will be appreciated.
>>>
>>> Regards,
>>> Yu Wang

Re: Error like "Borrow prepareStatement from pool failed"

Posted by yu wang <wa...@gmail.com>.
Why there is a (+)  appended to the SQL?

On Fri, Aug 10, 2012 at 5:19 PM, yu wang <wa...@gmail.com> wrote:
> Hello,
> I got a lot of error messages like:
>
> <ListPolicyPanel><refreshList> <openjpa-1.2.2-r422266:898935 nonfatal
> general error> org.apache.openjpa.persistence.PersistenceException:
> Syntax error: Encountered ")" at line 1, column 282. {SELECT t0.ID,
> t0.AGENTTYPE, t0.ATTRIBUTES, t0.CREATEDTIME, t0.DEFINITION, t1.ID,
> t1.ATTRIBUTES, t1.MASTER, t1.TUXMODE, t1.NAME, t1.STATUS, t1.TAG,
> t0.MODIFIEDTIME, t0.NAME, t0.STATUS, t0.TSAMVERSION FROM POLICY t0,
> TUXDOMAIN t1 WHERE (t0.AGENTTYPE = ?) AND t0.TUXDOMAINID = t1.ID(+)}
> [code=-1, state=42X01]
>
>
> Regards,
> Yu Wang
>
>
> On Fri, Aug 10, 2012 at 2:55 PM, yu wang <wa...@gmail.com> wrote:
>> Hello,
>> I am using OpenJPA 1.2.2 in weblogic server. When connecting oracle
>> Database, it works well.
>> But when it connects 10.8.2.2, I got error messages like "Borrow
>> prepareStatement from pool failed".
>>
>> My OpenJPA Properties in persistence.xml is like:
>>
>>                 <properties>
>>
>>                         <property name="openjpa.ConnectionDriverName"
>>                                 value="org.apache.commons.dbcp.BasicDataSource" />
>>
>>                         <property name="openjpa.ConnectionProperties"
>>                                 value="driverClassName=org.apache.derby.jdbc.ClientDriver,
>>
>> url=jdbc:derby://localhost:1527/test;create=true, username=app,
>> password=app,
>>                                 maxActive=30, maxWait=10000,
>> poolPreparedStatements=true" />
>>
>>
>>                         <!--  Single-JVM Data Cache  -->
>>                         <property name="openjpa.RemoteCommitProvider" value="sjvm" />
>>                         <property name="openjpa.DataCache"
>>                                 value="true(CacheSize=50000, SoftReferenceSize=0)" />
>>                         <property name="openjpa.QueryCache" value="false" />
>>                         <property name="openjpa.jdbc.QuerySQLCache" value="false" />
>>                         <property name="openjpa.QueryCompilationCache"
>>                                 value="false" />
>>
>>                         <!-- Whether persistent fields retain their values on transaction commit -->
>>                         <property name="openjpa.RetainState" value="false" />
>>
>>                         <property name="openjpa.jdbc.TransactionIsolation"
>>                                 value="read-committed" />
>>
>>                         <!-- EntityManager won't be thread safe -->
>>                         <property name="openjpa.Multithreaded" value="false" />
>>
>>                         <property name="openjpa.Optimistic" value="true" />
>>
>>                         <property name="openjpa.FlushBeforeQueries" value="false" />
>>
>>
>>                         <property name="openjpa.DetachState" value="loaded" />
>>
>>
>>                         <!--
>>                                 A connection is obtained when each transaction begins (optimistic
>> or datastore), and is released when the
>>                                 transaction completes. Non-transactional connections are obtained on-demand.
>>                         -->
>>                         <property name="openjpa.ConnectionRetainMode"
>>                                 value="transaction" />
>>
>>
>>                         <property name="openjpa.jdbc.SynchronizeMappings"
>>                                 value="buildSchema(ForeignKeys=true)" />
>>
>>
>>                         <property name="openjpa.jdbc.UpdateManager"
>>                                 value="operation-order" />
>>
>>                         <property name="openjpa.Compatibility"
>>                             value="ReloadOnDetach=false,
>> FlushBeforeDetach=false"/>
>>
>>                         <property name="openjpa.jdbc.DBDictionary"
>> value="oracle(DatePrecision=1000)"/>
>>
>>                         <property name="openjpa.Log"
>> value="File=openjpa.log,DefaultLevel=TRACE,SQL=TRACE" />
>>
>>                 </properties>
>>
>> My exception stack is like:
>> org.springframework.beans.factory.BeanCreationException: Error
>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> to bean 'dao_container' while setting constructor argument; nested
>> exception is org.springframework.beans.factory.BeanCreationException:
>> Error creating bean with name 'dao_container' defined in
>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> Instantiation of bean failed; nested exception is
>> org.springframework.beans.BeanInstantiationException: Could not
>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>>         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>>         at java.security.AccessController.doPrivileged(Native Method)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
>>         at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
>>         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>>         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
>>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
>>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
>>         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
>>         at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
>>         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
>>         at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
>>         at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
>>         at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
>>         at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:481)
>>         at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
>>         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
>>         at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:181)
>>         at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1801)
>>         at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3045)
>>         at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1397)
>>         at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>>         at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
>>         at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
>>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>>         at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
>>         at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:1267)
>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>         at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:409)
>>         at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:54)
>>         at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
>>         at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
>>         at weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
>>         at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
>>         at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
>>         at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
>>         at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
>>         at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
>>         at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
>>         at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
>>         at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
>>         at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
>>         at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
>>         at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
>>         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
>>         at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
>> Caused by: org.springframework.beans.factory.BeanCreationException:
>> Error creating bean with name 'dao_container' defined in
>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> Instantiation of bean failed; nested exception is
>> org.springframework.beans.BeanInstantiationException: Could not
>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>>         at java.security.AccessController.doPrivileged(Native Method)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
>>         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283)
>>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
>>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
>>         ... 57 more
>> Caused by: org.springframework.beans.BeanInstantiationException: Could
>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
>> threw exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>>         at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>>         ... 67 more
>> Caused by: com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
>>         ... 69 more
>> Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>>         at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)
>>         at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)
>>         at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)
>>         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:597)
>>         at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:434)
>>         at $Proxy136.createEntityManager(Unknown Source)
>>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:62)
>>         ... 75 more
>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:153)
>>         at org.apache.openjpa.jdbc.sql.DBDictionary.prepareStatement(DBDictionary.java:4489)
>>         at org.apache.openjpa.jdbc.sql.DBDictionary.getSequences(DBDictionary.java:3619)
>>         at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSequences(SchemaGenerator.java:827)
>>         at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:338)
>>         at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:284)
>>         at org.apache.openjpa.jdbc.schema.SchemaTool.getDBSchemaGroup(SchemaTool.java:1133)
>>         at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)
>>         at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)
>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:501)
>>         ... 89 more
>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
>> defined listener org.springframework.web.context.ContextLoaderListener
>> failed: org.springframework.beans.factory.BeanCreationException: Error
>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> to bean 'dao_container' while setting constructor argument; nested
>> exception is org.springframework.beans.factory.BeanCreationException:
>> Error creating bean with name 'dao_container' defined in
>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> Instantiation of bean failed; nested exception is
>> org.springframework.beans.BeanInstantiationException: Could not
>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null].
>> org.springframework.beans.factory.BeanCreationException: Error
>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> to bean 'dao_container' while setting constructor argument; nested
>> exception is org.springframework.beans.factory.BeanCreationException:
>> Error creating bean with name 'dao_container' defined in
>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> Instantiation of bean failed; nested exception is
>> org.springframework.beans.BeanInstantiationException: Could not
>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>>         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: org.springframework.beans.factory.BeanCreationException:
>> Error creating bean with name 'dao_container' defined in
>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> Instantiation of bean failed; nested exception is
>> org.springframework.beans.BeanInstantiationException: Could not
>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: org.springframework.beans.BeanInstantiationException: Could
>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
>> threw exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>>         at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>         Truncated. see log file for complete stacktrace
>>>
>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
>> defined listener com.test.ds.ListenerContext failed:
>> org.springframework.beans.factory.BeanCreationException: Error
>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> to bean 'dao_container' while setting constructor argument; nested
>> exception is org.springframework.beans.factory.BeanCreationException:
>> Error creating bean with name 'dao_container' defined in
>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> Instantiation of bean failed; nested exception is
>> org.springframework.beans.BeanInstantiationException: Could not
>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null].
>> org.springframework.beans.factory.BeanCreationException: Error
>> creating bean with name 'ActiveAgentList' defined in ServletContext
>> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
>> to bean 'dao_container' while setting constructor argument; nested
>> exception is org.springframework.beans.factory.BeanCreationException:
>> Error creating bean with name 'dao_container' defined in
>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> Instantiation of bean failed; nested exception is
>> org.springframework.beans.BeanInstantiationException: Could not
>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>>         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: org.springframework.beans.factory.BeanCreationException:
>> Error creating bean with name 'dao_container' defined in
>> ServletContext resource [/WEB-INF/applicationContext.xml]:
>> Instantiation of bean failed; nested exception is
>> org.springframework.beans.BeanInstantiationException: Could not
>> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
>> exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: org.springframework.beans.BeanInstantiationException: Could
>> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
>> threw exception; nested exception is
>> com.test.exception.ExceptionServerInternal:
>> <openjpa0.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>>         at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: com.test.exception.ExceptionServerInternal:
>> <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>         Truncated. see log file for complete stacktrace
>>>
>> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149265> <Failure
>> occurred in the execution of deployment request with ID
>> '1344580668609' for task '0'. Error is:
>> 'weblogic.application.ModuleException: '
>> weblogic.application.ModuleException:
>>         at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
>>         at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>         Truncated. see log file for complete stacktrace
>>>
>> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149202>
>> <Encountered an exception while attempting to commit the 1 task for
>> the application 'adf'.>
>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149004>
>> <Failures were detected while initiating deploy task for application
>> 'adf'.>
>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149078> <Stack
>> trace for message 149004
>> weblogic.application.ModuleException:
>>         at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
>>         at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
>> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
>> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
>> state=null]
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>>         Truncated. see log file for complete stacktrace
>>>
>> <Aug 10, 2012 2:38:19 PM CST> <Warning> <RMI> <BEA-080004> <An error
>> was thrown by rmi server:
>> javax.management.remote.rmi.RMIConnectionImpl.getAttribute(Ljavax.management.ObjectName;Ljava.lang.String;Ljavax.security.auth.Subject;)
>>  java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter.
>> java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter
>>         at java.lang.Class.getDeclaredMethods0(Native Method)
>>         at java.lang.Class.privateGetDeclaredMethods(Class.java:2427)
>>         at java.lang.Class.getDeclaredMethod(Class.java:1935)
>>         at java.io.ObjectStreamClass.getPrivateMethod(ObjectStreamClass.java:1382)
>>         at java.io.ObjectStreamClass.access$1700(ObjectStreamClass.java:52)
>>         Truncated. see log file for complete stacktrace
>>
>> Caused By: java.lang.ClassNotFoundException:
>> org.apache.derby.client.am.LogWriter
>>         at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:296)
>>         at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:269)
>>         at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:56)
>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
>>         Truncated. see log file for complete stacktrace
>>>
>>
>>
>>
>> Any suggestions will be appreciated.
>>
>> Regards,
>> Yu Wang

Re: Error like "Borrow prepareStatement from pool failed"

Posted by yu wang <wa...@gmail.com>.
Hello,
I got a lot of error messages like:

<ListPolicyPanel><refreshList> <openjpa-1.2.2-r422266:898935 nonfatal
general error> org.apache.openjpa.persistence.PersistenceException:
Syntax error: Encountered ")" at line 1, column 282. {SELECT t0.ID,
t0.AGENTTYPE, t0.ATTRIBUTES, t0.CREATEDTIME, t0.DEFINITION, t1.ID,
t1.ATTRIBUTES, t1.MASTER, t1.TUXMODE, t1.NAME, t1.STATUS, t1.TAG,
t0.MODIFIEDTIME, t0.NAME, t0.STATUS, t0.TSAMVERSION FROM POLICY t0,
TUXDOMAIN t1 WHERE (t0.AGENTTYPE = ?) AND t0.TUXDOMAINID = t1.ID(+)}
[code=-1, state=42X01]


Regards,
Yu Wang


On Fri, Aug 10, 2012 at 2:55 PM, yu wang <wa...@gmail.com> wrote:
> Hello,
> I am using OpenJPA 1.2.2 in weblogic server. When connecting oracle
> Database, it works well.
> But when it connects 10.8.2.2, I got error messages like "Borrow
> prepareStatement from pool failed".
>
> My OpenJPA Properties in persistence.xml is like:
>
>                 <properties>
>
>                         <property name="openjpa.ConnectionDriverName"
>                                 value="org.apache.commons.dbcp.BasicDataSource" />
>
>                         <property name="openjpa.ConnectionProperties"
>                                 value="driverClassName=org.apache.derby.jdbc.ClientDriver,
>
> url=jdbc:derby://localhost:1527/test;create=true, username=app,
> password=app,
>                                 maxActive=30, maxWait=10000,
> poolPreparedStatements=true" />
>
>
>                         <!--  Single-JVM Data Cache  -->
>                         <property name="openjpa.RemoteCommitProvider" value="sjvm" />
>                         <property name="openjpa.DataCache"
>                                 value="true(CacheSize=50000, SoftReferenceSize=0)" />
>                         <property name="openjpa.QueryCache" value="false" />
>                         <property name="openjpa.jdbc.QuerySQLCache" value="false" />
>                         <property name="openjpa.QueryCompilationCache"
>                                 value="false" />
>
>                         <!-- Whether persistent fields retain their values on transaction commit -->
>                         <property name="openjpa.RetainState" value="false" />
>
>                         <property name="openjpa.jdbc.TransactionIsolation"
>                                 value="read-committed" />
>
>                         <!-- EntityManager won't be thread safe -->
>                         <property name="openjpa.Multithreaded" value="false" />
>
>                         <property name="openjpa.Optimistic" value="true" />
>
>                         <property name="openjpa.FlushBeforeQueries" value="false" />
>
>
>                         <property name="openjpa.DetachState" value="loaded" />
>
>
>                         <!--
>                                 A connection is obtained when each transaction begins (optimistic
> or datastore), and is released when the
>                                 transaction completes. Non-transactional connections are obtained on-demand.
>                         -->
>                         <property name="openjpa.ConnectionRetainMode"
>                                 value="transaction" />
>
>
>                         <property name="openjpa.jdbc.SynchronizeMappings"
>                                 value="buildSchema(ForeignKeys=true)" />
>
>
>                         <property name="openjpa.jdbc.UpdateManager"
>                                 value="operation-order" />
>
>                         <property name="openjpa.Compatibility"
>                             value="ReloadOnDetach=false,
> FlushBeforeDetach=false"/>
>
>                         <property name="openjpa.jdbc.DBDictionary"
> value="oracle(DatePrecision=1000)"/>
>
>                         <property name="openjpa.Log"
> value="File=openjpa.log,DefaultLevel=TRACE,SQL=TRACE" />
>
>                 </properties>
>
> My exception stack is like:
> org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'ActiveAgentList' defined in ServletContext
> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> to bean 'dao_container' while setting constructor argument; nested
> exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'dao_container' defined in
> ServletContext resource [/WEB-INF/applicationContext.xml]:
> Instantiation of bean failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Could not
> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
>         at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
>         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
>         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
>         at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
>         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
>         at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
>         at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
>         at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
>         at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:481)
>         at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
>         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
>         at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:181)
>         at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1801)
>         at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3045)
>         at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1397)
>         at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>         at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
>         at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>         at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
>         at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:1267)
>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>         at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:409)
>         at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:54)
>         at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
>         at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
>         at weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
>         at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
>         at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
>         at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
>         at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
>         at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
>         at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
>         at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
>         at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
>         at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
>         at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
>         at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
>         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
>         at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
> Caused by: org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'dao_container' defined in
> ServletContext resource [/WEB-INF/applicationContext.xml]:
> Instantiation of bean failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Could not
> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
>         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283)
>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
>         ... 57 more
> Caused by: org.springframework.beans.BeanInstantiationException: Could
> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
> threw exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>         at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>         ... 67 more
> Caused by: com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
>         ... 69 more
> Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>         at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)
>         at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)
>         at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)
>         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:597)
>         at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:434)
>         at $Proxy136.createEntityManager(Unknown Source)
>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:62)
>         ... 75 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:153)
>         at org.apache.openjpa.jdbc.sql.DBDictionary.prepareStatement(DBDictionary.java:4489)
>         at org.apache.openjpa.jdbc.sql.DBDictionary.getSequences(DBDictionary.java:3619)
>         at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSequences(SchemaGenerator.java:827)
>         at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:338)
>         at org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:284)
>         at org.apache.openjpa.jdbc.schema.SchemaTool.getDBSchemaGroup(SchemaTool.java:1133)
>         at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)
>         at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:501)
>         ... 89 more
> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
> defined listener org.springframework.web.context.ContextLoaderListener
> failed: org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'ActiveAgentList' defined in ServletContext
> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> to bean 'dao_container' while setting constructor argument; nested
> exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'dao_container' defined in
> ServletContext resource [/WEB-INF/applicationContext.xml]:
> Instantiation of bean failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Could not
> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null].
> org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'ActiveAgentList' defined in ServletContext
> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> to bean 'dao_container' while setting constructor argument; nested
> exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'dao_container' defined in
> ServletContext resource [/WEB-INF/applicationContext.xml]:
> Instantiation of bean failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Could not
> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         Truncated. see log file for complete stacktrace
>
> Caused By: org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'dao_container' defined in
> ServletContext resource [/WEB-INF/applicationContext.xml]:
> Instantiation of bean failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Could not
> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>         Truncated. see log file for complete stacktrace
>
> Caused By: org.springframework.beans.BeanInstantiationException: Could
> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
> threw exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>         at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>         Truncated. see log file for complete stacktrace
>
> Caused By: com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>         Truncated. see log file for complete stacktrace
>
> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>         Truncated. see log file for complete stacktrace
>
> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>         Truncated. see log file for complete stacktrace
>>
> <Aug 10, 2012 2:38:19 PM CST> <Warning> <HTTP> <BEA-101162> <User
> defined listener com.test.ds.ListenerContext failed:
> org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'ActiveAgentList' defined in ServletContext
> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> to bean 'dao_container' while setting constructor argument; nested
> exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'dao_container' defined in
> ServletContext resource [/WEB-INF/applicationContext.xml]:
> Instantiation of bean failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Could not
> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null].
> org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'ActiveAgentList' defined in ServletContext
> resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference
> to bean 'dao_container' while setting constructor argument; nested
> exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'dao_container' defined in
> ServletContext resource [/WEB-INF/applicationContext.xml]:
> Instantiation of bean failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Could not
> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495)
>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         Truncated. see log file for complete stacktrace
>
> Caused By: org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'dao_container' defined in
> ServletContext resource [/WEB-INF/applicationContext.xml]:
> Instantiation of bean failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Could not
> instantiate bean class [com.test.dao.DAOContainer]: Constructor threw
> exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>         Truncated. see log file for complete stacktrace
>
> Caused By: org.springframework.beans.BeanInstantiationException: Could
> not instantiate bean class [com.test.dao.DAOContainer]: Constructor
> threw exception; nested exception is
> com.test.exception.ExceptionServerInternal:
> <openjpa0.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)
>         at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
>         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>         Truncated. see log file for complete stacktrace
>
> Caused By: com.test.exception.ExceptionServerInternal:
> <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at com.test.util.ManagerFactory.createEntityManager(ManagerFactory.java:66)
>         at com.test.dao.DAOContainer.<init>(DAOContainer.java:87)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>         Truncated. see log file for complete stacktrace
>
> Caused By: <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)
>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)
>         Truncated. see log file for complete stacktrace
>
> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>         Truncated. see log file for complete stacktrace
>>
> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149265> <Failure
> occurred in the execution of deployment request with ID
> '1344580668609' for task '0'. Error is:
> 'weblogic.application.ModuleException: '
> weblogic.application.ModuleException:
>         at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
>         at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>         Truncated. see log file for complete stacktrace
>
> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>         Truncated. see log file for complete stacktrace
>>
> <Aug 10, 2012 2:38:19 PM CST> <Error> <Deployer> <BEA-149202>
> <Encountered an exception while attempting to commit the 1 task for
> the application 'adf'.>
> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149004>
> <Failures were detected while initiating deploy task for application
> 'adf'.>
> <Aug 10, 2012 2:38:19 PM CST> <Warning> <Deployer> <BEA-149078> <Stack
> trace for message 149004
> weblogic.application.ModuleException:
>         at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1399)
>         at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
>         at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
>         at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
>         at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
>         Truncated. see log file for complete stacktrace
>
> Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: Borrow
> prepareStatement from pool failed {SELECT SEQUENCE_OWNER AS
> SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES} [code=0,
> state=null]
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
>         at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
>         at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
>         Truncated. see log file for complete stacktrace
>>
> <Aug 10, 2012 2:38:19 PM CST> <Warning> <RMI> <BEA-080004> <An error
> was thrown by rmi server:
> javax.management.remote.rmi.RMIConnectionImpl.getAttribute(Ljavax.management.ObjectName;Ljava.lang.String;Ljavax.security.auth.Subject;)
>  java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter.
> java.lang.NoClassDefFoundError: org/apache/derby/client/am/LogWriter
>         at java.lang.Class.getDeclaredMethods0(Native Method)
>         at java.lang.Class.privateGetDeclaredMethods(Class.java:2427)
>         at java.lang.Class.getDeclaredMethod(Class.java:1935)
>         at java.io.ObjectStreamClass.getPrivateMethod(ObjectStreamClass.java:1382)
>         at java.io.ObjectStreamClass.access$1700(ObjectStreamClass.java:52)
>         Truncated. see log file for complete stacktrace
>
> Caused By: java.lang.ClassNotFoundException:
> org.apache.derby.client.am.LogWriter
>         at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:296)
>         at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:269)
>         at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:56)
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
>         Truncated. see log file for complete stacktrace
>>
>
>
>
> Any suggestions will be appreciated.
>
> Regards,
> Yu Wang