java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: jakarta.servlet.ServletException: Request processing failed: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.core.web.RequestFilter.doFilter(RequestFilter.java:43)
at org.httpstudio.core.web.RequestFilterProxy.doFilter(RequestFilterProxy.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.multipart.support.MultipartFilter.doFilterInternal(MultipartFilter.java:125)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:731)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:663)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:384)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:904)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: jakarta.servlet.ServletException: Request processing failed: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.core.api.DatabaseWork.doWork(DatabaseWork.java:139)
at org.httpstudio.core.api.DatabaseWork.doWork(DatabaseWork.java:53)
at org.httpstudio.core.web.TransactionFilter.doFilter(TransactionFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.httpstudio.core.web.RequestFilter.doFilter(RequestFilter.java:41)
... 29 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: jakarta.servlet.ServletException: Request processing failed: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.core.api.DatabaseWork.lambda$doWork$0(DatabaseWork.java:105)
at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)
at org.hibernate.internal.AbstractSharedSessionContract.lambda$doWork$1(AbstractSharedSessionContract.java:1109)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:308)
at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1125)
at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1112)
at org.httpstudio.core.api.DatabaseWork.doWork(DatabaseWork.java:95)
... 34 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: jakarta.servlet.ServletException: Request processing failed: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.core.api.DatabaseWork.executeProxy(DatabaseWork.java:157)
at org.httpstudio.core.api.DatabaseWork.lambda$doWork$0(DatabaseWork.java:101)
... 40 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: jakarta.servlet.ServletException: Request processing failed: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.core.api.DatabaseWork.doWork(DatabaseWork.java:139)
at org.httpstudio.core.api.DatabaseWork.doWork(DatabaseWork.java:53)
at org.httpstudio.core.api.DatabaseWork.doWork(DatabaseWork.java:47)
at org.httpstudio.core.api.DatabaseWork.doWork(DatabaseWork.java:39)
at com.httpstudio.base.http.HttpStudioFilter.doFilter(HttpStudioFilter.java:191)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.httpstudio.core.web.TransactionFilter$1.execute(TransactionFilter.java:39)
at org.httpstudio.core.api.DatabaseWork.executeProxy(DatabaseWork.java:155)
... 41 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: jakarta.servlet.ServletException: Request processing failed: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.core.api.DatabaseWork.lambda$doWork$0(DatabaseWork.java:105)
at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)
at org.hibernate.internal.AbstractSharedSessionContract.lambda$doWork$1(AbstractSharedSessionContract.java:1109)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:308)
at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1125)
at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1112)
at org.httpstudio.core.api.DatabaseWork.doWork(DatabaseWork.java:95)
... 49 more
Caused by: java.lang.RuntimeException: jakarta.servlet.ServletException: Request processing failed: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.core.api.DatabaseWork.executeProxy(DatabaseWork.java:157)
at org.httpstudio.core.api.DatabaseWork.lambda$doWork$0(DatabaseWork.java:101)
... 55 more
Caused by: jakarta.servlet.ServletException: Request processing failed: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1022)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:564)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:195)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at com.httpstudio.base.http.HttpStudioFilter$1.execute(HttpStudioFilter.java:187)
at org.httpstudio.core.api.DatabaseWork.executeProxy(DatabaseWork.java:155)
... 56 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.core.web.MainAdapter.handleRequest(MainAdapter.java:48)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:51)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
... 67 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.core.web.flow.Action.execute(Action.java:83)
at org.httpstudio.core.web.flow.Action.call(Action.java:55)
at org.httpstudio.core.web.Router.send(Router.java:107)
at org.httpstudio.core.web.MainAdapter.handleRequest(MainAdapter.java:46)
... 71 more
Caused by: java.lang.RuntimeException: Error occurred while rendering page
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:161)
at org.httpstudio.core.web.StaticPageRequestHandler.processRequest(StaticPageRequestHandler.java:55)
at org.httpstudio.core.web.RequestHandler.execute(RequestHandler.java:90)
at org.httpstudio.core.web.flow.Action.execute(Action.java:81)
... 74 more
Caused by: java.lang.RuntimeException: org.apache.jasper.JasperException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: org.hibernate.QueryException: Legacy-style query parameters (`?`) are no longer supported; use JPA-style ordinal parameters (e.g., `?1`) instead : select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 [ select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 ]
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.core.web.flow.Screen.includeHTML(Screen.java:738)
at org.httpstudio.core.web.flow.Screen.execute(Screen.java:507)
at org.httpstudio.core.web.flow.Screen.call(Screen.java:454)
at org.httpstudio.core.web.StaticPageRequestHandler.processRequest(StaticPageRequestHandler.java:50)
... 76 more
Caused by: org.apache.jasper.JasperException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: org.hibernate.QueryException: Legacy-style query parameters (`?`) are no longer supported; use JPA-style ordinal parameters (e.g., `?1`) instead : select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 [ select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 ]
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:612)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:488)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:377)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:325)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:195)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:632)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:510)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:453)
at org.httpstudio.core.web.flow.Screen.includeHTML(Screen.java:735)
... 79 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: org.hibernate.QueryException: Legacy-style query parameters (`?`) are no longer supported; use JPA-style ordinal parameters (e.g., `?1`) instead : select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 [ select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 ]
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.core.web.flow.Action.execute(Action.java:83)
at org.httpstudio.core.web.flow.Action.call(Action.java:55)
at org.httpstudio.core.web.flow.Screen.executeBlock(Screen.java:297)
at org.httpstudio.core.web.flow.BlockHelper.executeBlocksInOrder(BlockHelper.java:213)
at org.httpstudio.core.web.flow.BlockHelper.render(BlockHelper.java:100)
at org.httpstudio.core.web.flow.BlockHelper.render(BlockHelper.java:226)
at org.httpstudio.core.web.flow.Screen.render(Screen.java:135)
at org.apache.jsp.WEB_002dINF.comp_template_palavayal.jsp.readymade_005ftemplate_jsp._jspService(readymade_005ftemplate_jsp.java:227)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:456)
... 88 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: org.hibernate.QueryException: Legacy-style query parameters (`?`) are no longer supported; use JPA-style ordinal parameters (e.g., `?1`) instead : select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 [ select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 ]
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.core.api.CommonOperation.execute(CommonOperation.java:85)
at org.httpstudio.ecom.search.ws.web.item.listitems.ListItemsController.processRequest(ListItemsController.java:54)
at org.httpstudio.core.web.RequestHandler.execute(RequestHandler.java:90)
at org.httpstudio.core.web.flow.Action.execute(Action.java:81)
... 98 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: org.hibernate.QueryException: Legacy-style query parameters (`?`) are no longer supported; use JPA-style ordinal parameters (e.g., `?1`) instead : select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 [ select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 ]
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.core.api.CommonOperation.execute(CommonOperation.java:69)
... 101 more
Caused by: java.lang.RuntimeException: java.lang.IllegalArgumentException: org.hibernate.QueryException: Legacy-style query parameters (`?`) are no longer supported; use JPA-style ordinal parameters (e.g., `?1`) instead : select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 [ select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 ]
at org.httpstudio.base.ClassService.throwRuntime(ClassService.java:117)
at org.httpstudio.base.ClassService.handleException(ClassService.java:90)
at org.httpstudio.ecom.search.ws.service.item.listitems.ListItems.execute(ListItems.java:111)
at org.httpstudio.ecom.search.ws.service.item.listitems.ListItems.execute(ListItems.java:25)
at org.httpstudio.core.api.CommonOperation.execute(CommonOperation.java:67)
... 101 more
Caused by: java.lang.IllegalArgumentException: org.hibernate.QueryException: Legacy-style query parameters (`?`) are no longer supported; use JPA-style ordinal parameters (e.g., `?1`) instead : select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 [ select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 ]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:757)
at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:114)
at org.httpstudio.ecom.core.services.impl.DbItemSearchServiceImpl.executeSiteSQL(DbItemSearchServiceImpl.java:159)
at org.httpstudio.ecom.core.services.impl.DbItemSearchServiceImpl.search(DbItemSearchServiceImpl.java:202)
at org.httpstudio.ecom.core.services.impl.DbItemSearchServiceImpl.search(DbItemSearchServiceImpl.java:197)
at org.httpstudio.ecom.core.services.impl.DbItemSearchServiceImpl.search(DbItemSearchServiceImpl.java:192)
at org.httpstudio.ecom.core.services.impl.ItemSearchProxyServiceImpl.search(ItemSearchProxyServiceImpl.java:23)
at org.httpstudio.ecom.search.ws.service.item.listitems.ListItems.execute(ListItems.java:75)
... 103 more
Caused by: org.hibernate.QueryException: Legacy-style query parameters (`?`) are no longer supported; use JPA-style ordinal parameters (e.g., `?1`) instead : select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 [ select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1 ]
at org.hibernate.QueryException.generateQueryException(QueryException.java:120)
at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:103)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:220)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144)
at org.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:112)
at org.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:73)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:162)
at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:636)
at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:748)
... 110 more
Caused by: org.hibernate.QueryException: Legacy-style query parameters (`?`) are no longer supported; use JPA-style ordinal parameters (e.g., `?1`) instead : select distinct item.itemId from org.httpstudio.ecom.db.entity.Item item , org.httpstudio.ecom.db.entity.ItemCategory itemCategory1, org.httpstudio.ecom.db.entity.ItemCategory itemCategory2 where item.deleted=0 and (itemCategory1.categoryId = ? and itemCategory1.itemId = item.itemId and itemCategory1.deleted=0) and (itemCategory2.categoryId = ? and itemCategory2.itemId = item.itemId and itemCategory2.deleted=0) and item.accountId = 145 and item.hide != 1
at org.hibernate.hql.internal.ast.HqlSqlWalker.generatePositionalParameter(HqlSqlWalker.java:1120)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.parameter(HqlSqlBaseWalker.java:3548)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1404)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4797)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4264)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2180)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2105)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2105)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2108)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2105)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2105)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2105)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:841)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:635)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:339)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:287)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:276)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:192)
... 116 more