HTTP Status 500 - org.hibernate.exception.GenericJDBCException: could not prepare statement

type Exception report

message org.hibernate.exception.GenericJDBCException: could not prepare statement

description The server encountered an internal error that prevented it from fulfilling this request.

exception

com.egoz.market.logic.email.NotifyException: org.hibernate.exception.GenericJDBCException: could not prepare statement
	com.egoz.market.logic.email.NotifyAdminLogic.sendDeveloperNotification(NotifyAdminLogic.java:166)
	com.egoz.market.MarketExceptionResolver.logCriticalException(MarketExceptionResolver.java:93)
	com.egoz.market.marketplace.CustomCharacterEncodingFilter.doFilterInternal(CustomCharacterEncodingFilter.java:31)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause

org.hibernate.exception.GenericJDBCException: could not prepare statement
	org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
	org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
	org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)
	org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.prepareQueryStatement(AbstractLoadPlanBasedLoader.java:226)
	org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:190)
	org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
	org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
	org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:197)
	org.hibernate.loader.entity.plan.LegacyBatchingEntityLoaderBuilder$LegacyBatchingEntityLoader.load(LegacyBatchingEntityLoaderBuilder.java:131)
	org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4272)
	org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:482)
	org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:452)
	org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:203)
	org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:262)
	org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:105)
	org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:73)
	org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1287)
	org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:211)
	org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2923)
	org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2904)
	org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2860)
	org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2904)
	org.hibernate.internal.SessionImpl.get(SessionImpl.java:1097)
	com.egoz.market.security.blocked.BlockedEmailLogic.getBlockedEmail(BlockedEmailLogic.java:141)
	com.egoz.market.security.blocked.BlockedEmailLogic.isEmailBlocked(BlockedEmailLogic.java:85)
	com.egoz.market.logic.email.MailEnqueueLogic.removeBlocked(MailEnqueueLogic.java:48)
	com.egoz.market.logic.email.MailEnqueueLogic.cleanFromBlocked(MailEnqueueLogic.java:37)
	com.egoz.market.logic.email.MailEnqueueLogic.enqueueMessage(MailEnqueueLogic.java:22)
	com.egoz.market.logic.email.NotifyLogicUtils.queueMail(NotifyLogicUtils.java:40)
	com.egoz.market.logic.email.NotifyAdminLogic.sendDeveloperNotification(NotifyAdminLogic.java:164)
	com.egoz.market.MarketExceptionResolver.logCriticalException(MarketExceptionResolver.java:93)
	com.egoz.market.marketplace.CustomCharacterEncodingFilter.doFilterInternal(CustomCharacterEncodingFilter.java:31)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause

java.sql.SQLException: Connection is closed
	com.zaxxer.hikari.pool.ProxyConnection$ClosedConnection$1.invoke(ProxyConnection.java:469)
	com.sun.proxy.$Proxy41.prepareStatement(Unknown Source)
	com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:310)
	com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
	org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)
	org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)
	org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)
	org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.prepareQueryStatement(AbstractLoadPlanBasedLoader.java:226)
	org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:190)
	org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
	org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
	org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:197)
	org.hibernate.loader.entity.plan.LegacyBatchingEntityLoaderBuilder$LegacyBatchingEntityLoader.load(LegacyBatchingEntityLoaderBuilder.java:131)
	org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4272)
	org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:482)
	org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:452)
	org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:203)
	org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:262)
	org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:105)
	org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:73)
	org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1287)
	org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:211)
	org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2923)
	org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2904)
	org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2860)
	org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2904)
	org.hibernate.internal.SessionImpl.get(SessionImpl.java:1097)
	com.egoz.market.security.blocked.BlockedEmailLogic.getBlockedEmail(BlockedEmailLogic.java:141)
	com.egoz.market.security.blocked.BlockedEmailLogic.isEmailBlocked(BlockedEmailLogic.java:85)
	com.egoz.market.logic.email.MailEnqueueLogic.removeBlocked(MailEnqueueLogic.java:48)
	com.egoz.market.logic.email.MailEnqueueLogic.cleanFromBlocked(MailEnqueueLogic.java:37)
	com.egoz.market.logic.email.MailEnqueueLogic.enqueueMessage(MailEnqueueLogic.java:22)
	com.egoz.market.logic.email.NotifyLogicUtils.queueMail(NotifyLogicUtils.java:40)
	com.egoz.market.logic.email.NotifyAdminLogic.sendDeveloperNotification(NotifyAdminLogic.java:164)
	com.egoz.market.MarketExceptionResolver.logCriticalException(MarketExceptionResolver.java:93)
	com.egoz.market.marketplace.CustomCharacterEncodingFilter.doFilterInternal(CustomCharacterEncodingFilter.java:31)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.69 logs.

Apache Tomcat/7.0.69