> 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*
