springmock 错误记录

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause: ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:825)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
... 23 more
[color=red]Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded[/color]
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:644)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:298)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:343)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
... 26 more


解决办法
[color=blue]由于提前关闭了session所致! 或可能 hibernate.cache.use_query_cache等属性设置问题[/color]问题
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sytcun.main.TemplateMain': [color=red]Unsatisfied dependency expressed through bean property 'dataSource': Set this property value or disable dependency checking for this bean.[/color] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.checkDependencies(AbstractAutowireCapableBeanFactory.java:1039)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:858)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireBeanProperties(AbstractAutowireCapableBeanFactory.java:276)
at org.springframework.test.AbstractDependencyInjectionSpringContextTests.injectDependencies(AbstractDependencyInjectionSpringContextTests.java:179)
at org.springframework.test.AbstractDependencyInjectionSpringContextTests.prepareTestInstance(AbstractDependencyInjectionSpringContextTests.java:158)
at org.springframework.test.AbstractSingleSpringContextTests.setUp(AbstractSingleSpringContextTests.java:88)
at junit.framework.TestCase.runBare(TestCase.java:125)
at org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.java:69)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

解决方法
[color=blue]<prop key="hibernate.bytecode.use_reflection_optimizer">true</prop>[/color]问题
2011-04-12 10:49:00,531 INFO context.support.GenericApplicationContext:672 - Closing org.springframework.context.support.GenericApplicationContext@4f80d6: display name [org.springframework.context.support.GenericApplicationContext@4f80d6]; startup date [Tue Apr 12 10:48:57 CST 2011]; root of context hierarchy
2011-04-12 10:49:00,531 INFO factory.support.DefaultListableBeanFactory:285 - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@814013: defining beans [lobHandler,nativeJdbcExtractor,myTransactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.aop.aspectj.AspectJExpressionPointcut,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor,org.springframework.aop.aspectj.AspectJPointcutAdvisor,queryPointCut,txAdvice,jdbcTemplate,cacheManager,methodCache,methodCacheInterceptor,methodCacheAfterAdvice,projectHibernateDs,hibernateProperties,projectSesinFtry,templateService]; root of factory hierarchy
2011-04-12 10:49:00,531 INFO cache.ehcache.EhCacheManagerFactoryBean:126 - Shutting down EHCache CacheManager
2011-04-12 10:49:00,546 ERROR factory.support.DisposableBeanAdapter:148 [color=red]- Couldn't invoke destroy method of bean with name 'cacheManager'
java.lang.IllegalStateException: The org.hibernate.cache.StandardQueryCache Cache is not alive.[/color] at net.sf.ehcache.Cache.checkStatus(Cache.java:1201)
at net.sf.ehcache.Cache.dispose(Cache.java:1081)
at net.sf.ehcache.CacheManager.shutdown(CacheManager.java:702)
at org.springframework.cache.ehcache.EhCacheManagerFactoryBean.destroy(EhCacheManagerFactoryBean.java:127)
at org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:145)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:347)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingleton(DefaultSingletonBeanRegistry.java:320)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:293)
at org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:706)
at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:684)
at org.springframework.context.support.AbstractApplicationContext$1.run(AbstractApplicationContext.java:621)
2011-04-12 10:49:00,546 INFO orm.hibernate3.LocalSessionFactoryBean:188 - Closing Hibernate SessionFactory
2011-04-12 10:49:00,546 WARN sf.ehcache.CacheManager:685 - CacheManager already shutdown