org.h2.jdbc.JdbcSQLException: Parameter "#11" is not set; SQL statement: SELECT INT_CHANNEL_MESSAGE.MESSAGE_ID, INT_CHANNEL_MESSAGE.MESSAGE_BYTES from INT_CHANNEL_MESSAGE where INT_CHANNEL_MESSAGE.GROUP_KEY = ? and INT_CHANNEL_MESSAGE.REGION = ? and INT_CHANNEL_MESSAGE.MESSAGE_ID not in (?, ?, ?, ?, ?, ?, ?, ?, ?) order by CREATED_DATE ASC LIMIT 1 [90012-161]

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

Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via Spring JIRA by Jason Pell, 1 year ago
Parameter "#11" is not set; SQL statement: SELECT INT_CHANNEL_MESSAGE.MESSAGE_ID, INT_CHANNEL_MESSAGE.MESSAGE_BYTES from INT_CHANNEL_MESSAGE where INT_CHANNEL_MESSAGE.GROUP_KEY = ? and INT_CHANNEL_MESSAGE.REGION = ? and INT_CHANNEL_MESSAGE.MESSAGE_ID not in (?, ?, ?, ?, ?, ?, ?, ?, ?) order by CREATED_DATE ASC LIMIT 1 [90012-161]
via Spring JIRA by Jason Pell, 1 year ago
Parameter "#11" is not set; SQL statement: SELECT INT_CHANNEL_MESSAGE.MESSAGE_ID, INT_CHANNEL_MESSAGE.MESSAGE_BYTES from INT_CHANNEL_MESSAGE where INT_CHANNEL_MESSAGE.GROUP_KEY = ? and INT_CHANNEL_MESSAGE.REGION = ? and INT_CHANNEL_MESSAGE.MESSAGE_ID not in (?, ?, ?, ?, ?, ?, ?, ?, ?) order by CREATED_DATE ASC LIMIT 1 [90012-161]
via Stack Overflow by Aaron
, 1 year ago
Parameter "#1" is not set; SQL statement: ?=call PS_SLEEP(?) [90012-173]
via GitHub by HaoSs07
, 1 year ago
Parameter "#1" is not set; SQ statement: SELECT groups.groupName, groups.priority, groups.prefix, groups.suffix, groups.parent FROM groupConnectors INNER JOIN groups ON groupConnectors.groupID=groups.groupID WHERE groupConnectors.playerID=? AND groupConnectors.zoneID=? [90012-170
via Google Groups by Remo, 2 years ago
Timeout trying to lock table "USERS"; SQL statement: SELECT ... <removed rest of select statement>' [50200-139]
via Stack Overflow by Martin Ahrer
, 1 year ago
Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-160]
org.h2.jdbc.JdbcSQLException: Parameter "#11" is not set; SQL statement: SELECT INT_CHANNEL_MESSAGE.MESSAGE_ID, INT_CHANNEL_MESSAGE.MESSAGE_BYTES from INT_CHANNEL_MESSAGE where INT_CHANNEL_MESSAGE.GROUP_KEY = ? and INT_CHANNEL_MESSAGE.REGION = ? and INT_CHANNEL_MESSAGE.MESSAGE_ID not in (?, ?, ?, ?, ?, ?, ?, ?, ?) order by CREATED_DATE ASC LIMIT 1 [90012-161]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.expression.Parameter.checkSet(Parameter.java:73)
at org.h2.command.Prepared.checkParameters(Prepared.java:162)
at org.h2.command.CommandContainer.query(CommandContainer.java:81)
at org.h2.command.Command.executeQuery(Command.java:185)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:662)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:702)
at org.springframework.integration.jdbc.store.JdbcChannelMessageStore.doPollForMessage(JdbcChannelMessageStore.java:456)
at org.springframework.integration.jdbc.store.JdbcChannelMessageStore.pollMessageFromGroup(JdbcChannelMessageStore.java:568)
at org.springframework.integration.store.MessageGroupQueue.doPoll(MessageGroupQueue.java:278)
at org.springframework.integration.store.MessageGroupQueue.poll(MessageGroupQueue.java:130)
at org.springframework.integration.store.MessageGroupQueue.poll(MessageGroupQueue.java:47)
at org.springframework.integration.channel.QueueChannel.doReceive(QueueChannel.java:91)
at org.springframework.integration.channel.AbstractPollableChannel.receive(AbstractPollableChannel.java:57)
at org.springframework.integration.endpoint.PollingConsumer.receiveMessage(PollingConsumer.java:79)
at org.springframework.integration.endpoint.AbstractTransactionSynchronizingPollingEndpoint.doPoll(AbstractTransactionSynchronizingPollingEndpoint.java:67)
at org.springframework.integration.endpoint.AbstractPollingEndpoint$1.call(AbstractPollingEndpoint.java:146)
at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
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:319)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at undefined.$Proxy18.call(Unknown Source)
at org.springframework.integration.endpoint.AbstractPollingEndpoint$Poller$1.run(AbstractPollingEndpoint.java:236)
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, 3 days ago
9 times, 1 week ago
22 times, 3 weeks ago
2 times, 1 month ago
Once, 2 months ago

Write tip

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