Hibernate:
insert
into
node
(nodeCreateTime, nodeSysOID, nodeSysName, nodeSysDescription, nodeSysLocation, nodeSysContact, nodeLabelSource, nodeNetBIOSName, nodeDomainName, operatingSystem, lastCapsdPoll, dpName, nodeParentID, nodeType, nodeLabel, nodeId)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
ipInterface
(ipAddr, nodeId, ifIndex, ipHostName, isManaged, ipStatus, ipLastCapsdPoll, isSnmpPrimary, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
2006-09-11 04:24:21,190 WARN [Thread-2] org.hibernate.util.JDBCExceptionReporter: SQL Error: 0, SQLState: 23503
2006-09-11 04:24:21,191 ERROR [Thread-2] org.hibernate.util.JDBCExceptionReporter: ERROR: insert or update on table "ipinterface" violates foreign key constraint "snmpinterface_fkey1"
Detail: Key (nodeid,ifindex)=(1,1) is not present in table "snmpinterface".
2006-09-11 04:24:21,192 ERROR [Thread-2] org.hibernate.event.def.AbstractFlushingEventListener: Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [org.opennms.netmgt.model.OnmsIpInterface]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2140)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:962)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1107)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:125)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:129)
at org.opennms.netmgt.dao.hibernate.MonitoredServiceDaoHibernate.get(MonitoredServiceDaoHibernate.java:55)
at org.opennms.netmgt.dao.AbstractDaoTestCase.populateDB(AbstractDaoTestCase.java:436)
at org.opennms.netmgt.dao.AbstractDaoTestCase.access$1(AbstractDaoTestCase.java:342)
at org.opennms.netmgt.dao.AbstractDaoTestCase$1.doInTransaction(AbstractDaoTestCase.java:278)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at org.opennms.netmgt.dao.AbstractDaoTestCase$2.run(AbstractDaoTestCase.java:288)
at java.lang.Thread.run(Thread.java:613)
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ipinterface" violates foreign key constraint "snmpinterface_fkey1"
Detail: Key (nodeid,ifindex)=(1,1) is not present in table "snmpinterface".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2120)
... 22 more
Exception in thread "Thread-2" org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [org.opennms.netmgt.model.OnmsIpInterface]; SQL [insert into ipInterface (ipAddr, nodeId, ifIndex, ipHostName, isManaged, ipStatus, ipLastCapsdPoll, isSnmpPrimary, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?)]; ERROR: insert or update on table "ipinterface" violates foreign key constraint "snmpinterface_fkey1"
Detail: Key (nodeid,ifindex)=(1,1) is not present in table "snmpinterface".; nested exception is org.postgresql.util.PSQLException: ERROR: insert or update on table "ipinterface" violates foreign key constraint "snmpinterface_fkey1"
Detail: Key (nodeid,ifindex)=(1,1) is not present in table "snmpinterface".
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ipinterface" violates foreign key constraint "snmpinterface_fkey1"
Detail: Key (nodeid,ifindex)=(1,1) is not present in table "snmpinterface".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2120)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:962)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1107)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:125)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:129)
at org.opennms.netmgt.dao.hibernate.MonitoredServiceDaoHibernate.get(MonitoredServiceDaoHibernate.java:55)
at org.opennms.netmgt.dao.AbstractDaoTestCase.populateDB(AbstractDaoTestCase.java:436)
at org.opennms.netmgt.dao.AbstractDaoTestCase.access$1(AbstractDaoTestCase.java:342)
at org.opennms.netmgt.dao.AbstractDaoTestCase$1.doInTransaction(AbstractDaoTestCase.java:278)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at org.opennms.netmgt.dao.AbstractDaoTestCase$2.run(AbstractDaoTestCase.java:288)
at java.lang.Thread.run(Thread.java:613)