org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select onmsnode0_.nodeId as nodeId8_, onmsnode0_.nodeCreateTime as nodeCrea2_8_, onmsnode0_.dpName as dpName8_, onmsnode0_.foreignId as foreignId8_, onmsnode0_.foreignSource as foreignS4_8_, onmsnode0_.nodeLabel as nodeLabel8_, onmsnode0_.nodeLabelSource as nodeLabe6_8_, onmsnode0_.lastCapsdPoll as lastCaps7_8_, onmsnode0_.nodeDomainName as nodeDoma8_8_, onmsnode0_.nodeNetBIOSName as nodeNetB9_8_, onmsnode0_.operatingSystem as operati10_8_, onmsnode0_.nodeParentID as nodePar18_8_, onmsnode0_.nodeSysContact as nodeSys11_8_, onmsnode0_.nodeSysDescription as nodeSys12_8_, onmsnode0_.nodeSysLocation as nodeSys13_8_, onmsnode0_.nodeSysName as nodeSys14_8_, onmsnode0_.nodeSysOID as nodeSysOID8_, onmsnode0_.nodeType as nodeType8_, onmsnode0_1_.criticalPathIp as critical1_9_, onmsnode0_1_.criticalPathServiceName as critical2_9_ from node onmsnode0_ left outer join pathOutage onmsnode0_1_ on onmsnode0_.nodeId=onmsnode0_1_.nodeId where onmsnode0_.nodeLabel=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via The OpenNMS Issue Tracker by Amol Paranjpe, 1 year ago
as nodeType8_, onmsnode0_1_.criticalPathIp as critical1_9_, onmsnode0_1_.criticalPathServiceName as critical2_9_ from node onmsnode0_ left outer join pathOutage onmsnode0_1_ on onmsnode0_.nodeId=onmsnode0_1_.nodeId where onmsnode0_.nodeLabel=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
via Stack Overflow by Thiagarajan Hariharan
, 2 years ago
, wifinetwor0_.pairwise_cipher as pairwise7_0_, wifinetwor0_.protocol as protocol0_, wifinetwor0_.vpn_type as vpn9_0_, wifinetwor0_.vpn_url as vpn10_0_, wifinetwor0_.authAlgorithm as authAlg11_0_ from wifi_network_config wifinetwor0_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
via Stack Overflow by A1ucard
, 1 year ago
could not initialize a collection: [com.inventory.inventory.vo.Person.listAddress#1]; nested exception is org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.inventory.inventory.vo.Person.listAddress#1]
via atomikos.com by Unknown author, 1 year ago
Could not execute JDBC batch update; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
via spring.io by Unknown author, 2 years ago
could not insert: [com.acs.gs.juror.model.accounting.Adjustment]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.acs.gs.juror.model.accounting.Adjustment]
via hsqldb by dma_k
, 1 year ago
could not execute query; SQL [select count(*) from document where current_date - cast(image_indexing_date as date) >= 20]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select onmsnode0_.nodeId as nodeId8_, onmsnode0_.nodeCreateTime as nodeCrea2_8_, onmsnode0_.dpName as dpName8_, onmsnode0_.foreignId as foreignId8_, onmsnode0_.foreignSource as foreignS4_8_, onmsnode0_.nodeLabel as nodeLabel8_, onmsnode0_.nodeLabelSource as nodeLabe6_8_, onmsnode0_.lastCapsdPoll as lastCaps7_8_, onmsnode0_.nodeDomainName as nodeDoma8_8_, onmsnode0_.nodeNetBIOSName as nodeNetB9_8_, onmsnode0_.operatingSystem as operati10_8_, onmsnode0_.nodeParentID as nodePar18_8_, onmsnode0_.nodeSysContact as nodeSys11_8_, onmsnode0_.nodeSysDescription as nodeSys12_8_, onmsnode0_.nodeSysLocation as nodeSys13_8_, onmsnode0_.nodeSysName as nodeSys14_8_, onmsnode0_.nodeSysOID as nodeSysOID8_, onmsnode0_.nodeType as nodeType8_, onmsnode0_1_.criticalPathIp as critical1_9_, onmsnode0_1_.criticalPathServiceName as critical2_9_ from node onmsnode0_ left outer join pathOutage onmsnode0_1_ on onmsnode0_.nodeId=onmsnode0_1_.nodeId where onmsnode0_.nodeLabel=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921)
at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:1)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.find(AbstractDaoHibernate.java:155)
at org.opennms.netmgt.dao.hibernate.NodeDaoHibernate.findByLabel(NodeDaoHibernate.java:104)
at org.opennms.netmgt.provision.adapters.link.DefaultNodeLinkService.getNodeId(DefaultNodeLinkService.java:175)
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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at undefined.$Proxy76.getNodeId(Unknown Source)
at org.opennms.netmgt.provision.adapters.link.LinkProvisioningAdapter.doAddNode(LinkProvisioningAdapter.java:86)
at org.opennms.netmgt.provision.SimplerQueuedProvisioningAdapter$1.doInTransaction(SimplerQueuedProvisioningAdapter.java:126)
at org.opennms.netmgt.provision.SimplerQueuedProvisioningAdapter.processPendingOperationForNode(SimplerQueuedProvisioningAdapter.java:123)
at org.opennms.netmgt.provision.SimpleQueuedProvisioningAdapter$AdapterOperation.run(SimpleQueuedProvisioningAdapter.java:408)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

Users with the same issue

Once, 1 week ago
32 times, 4 weeks ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.