Hi,
I am a new user of OpenNMS.
I have installed PostgreSQL 9.1 and followed the steps given by OpenNMS website but I am not able to start OpenNMS from command line due to the following error.
D:\OpenNMS\bin>opennms.bat start
D:\OpenNMS\bin>"C:\java\bin\java" -Xmx256m -XX:MaxPermSize=128m -Dopennms.home="D:/OpenNMS" -jar "D:/OpenNMS/lib/opennms_bootstrap.jar" start
[DEBUG] System property 'opennms.library.jicmp' set to 'D:/OpenNMS/lib\jicmp.dll. Attempting to load jicmp library from this location.
[DEBUG] System property 'opennms.library.jicmp' set to 'D:/OpenNMS/lib\jicmp.dll. Attempting to load jicmp library from this location.
[DEBUG] System property 'opennms.library.jicmp6' set to 'D:/OpenNMS/lib\jicmp6.dll. Attempting to load jicmp6 library from this location.
[INFO] Successfully loaded jicmp6 library.
An error occurred while attempting to start the "OpenNMS:Name=Eventd" service (class org.opennms.netmgt.eventd.jmx.Eventd). Shutting down and exiting.
javax.management.RuntimeMBeanException: org.springframework.beans.factory.access.BootstrapException: Unable to return specified BeanFactory instance: factory key [eventDaemonContext], from group with
resource name [classpath*:beanRefContext.xml]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'eventDaemonContext' defined in URL [jar:file:
/D:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefContext.xml]: Cannot resolve reference to bean 'commonContext' while setting constructor argument; nested exception is org.springframework.beans.fac
tory.BeanCreationException: Error creating bean with name 'commonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefContext.xml]: Cannot resolve reference to bean 'd
aemonContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daemonContext' defined in URL [jar:file:/D
:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefContext.xml]: Cannot resolve reference to bean 'daoContext' while setting constructor argument; nested exception is org.springframework.beans.factory.
BeanCreationException: Error creating bean with name 'daoContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-dao-1.10.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception i
s org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested excep
tion is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'acknowledgmentDao' defined in class path resource [META-INF/opennms/applicationContext-dao.xml]: Invocat
ion of init method failed; nested exception is org.springframework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exception is org.springframework.jdbc.UncategorizedSQ
LException: Hibernate operation: could not retrieve snapshot: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException for SQL [select accesslock_.lockName from accessLock
s accesslock_ where accesslock_.lockName=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections c
ould not be acquired from the underlying database!
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.rethrow(DefaultMBeanServerInterceptor.java:856)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.rethrowMaybeMBeanException(DefaultMBeanServerInterceptor.java:869)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:838)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
at org.opennms.netmgt.vmmgr.Invoker.invoke(Invoker.java:316)
at org.opennms.netmgt.vmmgr.Invoker.invokeMethods(Invoker.java:239)
at org.opennms.netmgt.vmmgr.Starter.start(Starter.java:245)
at org.opennms.netmgt.vmmgr.Starter.startDaemon(Starter.java:116)
at org.opennms.netmgt.vmmgr.Controller.start(Controller.java:190)
at org.opennms.netmgt.vmmgr.Controller.main(Controller.java:162)
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.opennms.bootstrap.Bootstrap$3.run(Bootstrap.java:346)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.springframework.beans.factory.access.BootstrapException: Unable to return specified BeanFactory instance: factory key [eventDaemonContext], from group with resource name [classpath*:bea
nRefContext.xml]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'eventDaemonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-servi
ces-1.10.2.jar!/beanRefContext.xml]: Cannot resolve reference to bean 'commonContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: E
rror creating bean with name 'commonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefContext.xml]: Cannot resolve reference to bean 'daemonContext' while setting c
onstructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daemonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-service
s-1.10.2.jar!/beanRefContext.xml]: Cannot resolve reference to bean 'daoContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'daoContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-dao-1.10.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.B
eanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.b
eans.factory.BeanCreationException: Error creating bean with name 'acknowledgmentDao' defined in class path resource [META-INF/opennms/applicationContext-dao.xml]: Invocation of init method failed; ne
sted exception is org.springframework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operati
on: could not retrieve snapshot: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException for SQL [select accesslock_.lockName from accessLocks accesslock_ where accessloc
k_.lockName=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the
underlying database!
at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:409)
at org.opennms.core.utils.BeanUtils.getBeanFactory(BeanUtils.java:51)
at org.opennms.core.utils.BeanUtils.getFactory(BeanUtils.java:93)
at org.opennms.netmgt.daemon.AbstractSpringContextJmxServiceDaemon.init(AbstractSpringContextJmxServiceDaemon.java:97)
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 com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:93)
at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:27)
at com.sun.jmx.mbeanserver.MBeanIntrospector.invokeM(MBeanIntrospector.java:208)
at com.sun.jmx.mbeanserver.PerInterface.invoke(PerInterface.java:120)
at com.sun.jmx.mbeanserver.MBeanSupport.invoke(MBeanSupport.java:262)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
... 13 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'eventDaemonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefCont
ext.xml]: Cannot resolve reference to bean 'commonContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with nam
e 'commonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefContext.xml]: Cannot resolve reference to bean 'daemonContext' while setting constructor argument; nested
exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daemonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefContex
t.xml]: Cannot resolve reference to bean 'daoContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'da
oContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-dao-1.10.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException:
Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationEx
ception: Error creating bean with name 'acknowledgmentDao' defined in class path resource [META-INF/opennms/applicationContext-dao.xml]: Invocation of init method failed; nested exception is org.sprin
gframework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not retrieve snap
shot: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException for SQL [select accesslock_.lockName from accessLocks accesslock_ where accesslock_.lockName=?]; SQL state [
null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:630)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1079)
at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:397)
... 26 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'commonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefContext.x
ml]: Cannot resolve reference to bean 'daemonContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'da
emonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefContext.xml]: Cannot resolve reference to bean 'daoContext' while setting constructor argument; nested excepti
on is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daoContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-dao-1.10.2.jar!/beanRefContext.xml]: Instanti
ation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: C
onstructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'acknowledgmentDao' defined in class path resource [META-INF/open
nms/applicationContext-dao.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exception is
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not retrieve snapshot: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException for SQL [sel
ect accesslock_.lockName from accessLocks accesslock_ where accesslock_.lockName=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception
is java.sql.SQLException: Connections could not be acquired from the underlying database!
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:630)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 39 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daemonContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-services-1.10.2.jar!/beanRefContext.x
ml]: Cannot resolve reference to bean 'daoContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daoCo
ntext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-dao-1.10.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Cou
ld not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationExcep
tion: Error creating bean with name 'acknowledgmentDao' defined in class path resource [META-INF/opennms/applicationContext-dao.xml]: Invocation of init method failed; nested exception is org.springfr
amework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not retrieve snapsho
t: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException for SQL [select accesslock_.lockName from accessLocks accesslock_ where accesslock_.lockName=?]; SQL state [nul
l]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:630)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 51 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daoContext' defined in URL [jar:file:/D:/OpenNMS/lib/opennms-dao-1.10.2.jar!/beanRefContext.xml]: Ins
tantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContex
t]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'acknowledgmentDao' defined in class path resource [META-INF
/opennms/applicationContext-dao.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exceptio
n is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not retrieve snapshot: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException for SQL
[select accesslock_.lockName from accessLocks accesslock_ where accesslock_.lockName=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exce
ption is java.sql.SQLException: Connections could not be acquired from the underlying database!
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 63 more
Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nes
ted exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'acknowledgmentDao' defined in class path resource [META-INF/opennms/applicationContext-dao.xml]
: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exception is org.springframework.jdbc.Uncate
gorizedSQLException: Hibernate operation: could not retrieve snapshot: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException for SQL [select accesslock_.lockName from a
ccessLocks accesslock_ where accesslock_.lockName=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Conn
ections could not be acquired from the underlying database!
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:141)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:108)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
... 72 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'acknowledgmentDao' defined in class path resource [META-INF/opennms/applicationContext-dao.xml]: Invo
cation of init method failed; nested exception is org.springframework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exception is org.springframework.jdbc.Uncategorize
dSQLException: Hibernate operation: could not retrieve snapshot: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException for SQL [select accesslock_.lockName from accessL
ocks accesslock_ where accesslock_.lockName=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connection
s could not be acquired from the underlying database!
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:105)
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:126)
... 74 more
Caused by: org.springframework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: cou
ld not retrieve snapshot: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException for SQL [select accesslock_.lockName from accessLocks accesslock_ where accesslock_.lock
Name=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underl
ying database!
at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:51)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
... 90 more
Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not retrieve snapshot: [org.opennms.netmgt.dao.hibernate.AccessLock#ACKS_ACCESS]; uncategorized SQLException f
or SQL [select accesslock_.lockName from accessLocks accesslock_ where accesslock_.lockName=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; neste
d exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:737)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.initDao(AbstractDaoHibernate.java:85)
at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:48)
... 92 more
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.opennms.netmgt.config.C3P0ConnectionFactory.getConnection(C3P0ConnectionFactory.java:85)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.java:403)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
at $Proxy42.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:145)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1044)
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:269)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:212)
at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:535)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:103)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:534)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:526)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:522)
at org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate(HibernateTemplate.java:740)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
... 96 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
... 114 more
Also, PostgreSQL is running see below command
C:\Program Files\PostgreSQL\9.1\bin>pg_ctl status -D "C:\Program Files\PostgreSQL\9.1\data"
pg_ctl: server is running (PID: 2284)
C:/Program Files/PostgreSQL/9.1/bin/postgres.exe "-D" "C:/Program Files/PostgreSQL/9.1/data"
Can you please help me with this?
Thanks
Sanjay Modha
| IT Consultant
Keats House, The Office Park, Springfield Drive,
Leatherhead Surrey KT22 7LP
| United Kingdom
M: +44 (0) 7825 691041
sanjay.modha <at> logica.com |
www.logica.com
Logica UK Limited, registered in England & Wales (registered number 947968)
Registered Office: 250 Brook Drive, Green Park, Reading RG2 6UA, United Kingdom
Think green - keep it on the screen.
This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.