Error occured during startup of OpenNMS

"Modha, Sanjay" <[email protected]>
Newsgroups gmane.network.opennms.install
Message-ID <[email protected]>
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
[email protected]<mailto:[email protected]> | www.logica.com
<http://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.

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.