Yes, you are right. Thanks!
On Fri, Aug 10, 2012 at 9:47 PM, Rick Curtis <curti...@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 <wangy...@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 <wangy...@gmail.com> wrote: >> > Why there is a (+) appended to the SQL? >> > >> > On Fri, Aug 10, 2012 at 5:19 PM, yu wang <wangy...@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 <wangy...@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*