I have replaced elastic search 2.3 to elastic search 1.7 again search is not working.
now auto suggestion on search box is working but when performs search action its not working.
please see attached log of elastic search and shopizer exception and provide some suggestion.
DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing POST request for [/sm-shop/shop/search/search.html]
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /shop/search/search.html
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public java.lang.String com.salesmanager.web.shop.controller.search.SearchController.displaySearch(java.lang.String,org.springframework.ui.Model,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,java.util.Locale) throws java.lang.Exception]
****** /sm-shop/shop/search/search.html
*** user.dir ***D:\NEERAJ\apache-tomcat-8.0.26\bin
DEBUG: com.salesmanager.web.filter.StoreFilter - *** user.dir ***D:\NEERAJ\apache-tomcat-8.0.26\bin
Hibernate: select content0_.CONTENT_ID as CONTENT1_167_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_168_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, content0_.DATE_CREATED as DATE2_167_0_, content0_.DATE_MODIFIED as DATE3_167_0_, content0_.UPDT_ID as UPDT4_167_0_, content0_.CODE as CODE167_0_, content0_.CONTENT_POSITION as CONTENT6_167_0_, content0_.CONTENT_TYPE as CONTENT7_167_0_, content0_.MERCHANT_ID as MERCHANT10_167_0_, content0_.SORT_ORDER as SORT8_167_0_, content0_.VISIBLE as VISIBLE167_0_, descriptio1_.DATE_CREATED as DATE2_168_1_, descriptio1_.DATE_MODIFIED as DATE3_168_1_, descriptio1_.UPDT_ID as UPDT4_168_1_, descriptio1_.DESCRIPTION as DESCRIPT5_168_1_, descriptio1_.LANGUAGE_ID as LANGUAGE12_168_1_, descriptio1_.NAME as NAME168_1_, descriptio1_.TITLE as TITLE168_1_, descriptio1_.CONTENT_ID as CONTENT13_168_1_, descriptio1_.META_DESCRIPTION as META8_168_1_, descriptio1_.META_KEYWORDS as META9_168_1_, descriptio1_.META_TITLE as META10_168_1_, descriptio1_.SEF_URL as SEF11_168_1_, descriptio1_.CONTENT_ID as CONTENT13_167_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CONTENT content0_ left outer join SALESMANAGER.CONTENT_DESCRIPTION descriptio1_ on content0_.CONTENT_ID=descriptio1_.CONTENT_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on content0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where descriptio1_.LANGUAGE_ID=? and content0_.MERCHANT_ID=? and (content0_.CONTENT_TYPE in (? , ?)) order by content0_.SORT_ORDER asc
Hibernate: select content0_.CONTENT_ID as CONTENT1_167_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_168_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, content0_.DATE_CREATED as DATE2_167_0_, content0_.DATE_MODIFIED as DATE3_167_0_, content0_.UPDT_ID as UPDT4_167_0_, content0_.CODE as CODE167_0_, content0_.CONTENT_POSITION as CONTENT6_167_0_, content0_.CONTENT_TYPE as CONTENT7_167_0_, content0_.MERCHANT_ID as MERCHANT10_167_0_, content0_.SORT_ORDER as SORT8_167_0_, content0_.VISIBLE as VISIBLE167_0_, descriptio1_.DATE_CREATED as DATE2_168_1_, descriptio1_.DATE_MODIFIED as DATE3_168_1_, descriptio1_.UPDT_ID as UPDT4_168_1_, descriptio1_.DESCRIPTION as DESCRIPT5_168_1_, descriptio1_.LANGUAGE_ID as LANGUAGE12_168_1_, descriptio1_.NAME as NAME168_1_, descriptio1_.TITLE as TITLE168_1_, descriptio1_.CONTENT_ID as CONTENT13_168_1_, descriptio1_.META_DESCRIPTION as META8_168_1_, descriptio1_.META_KEYWORDS as META9_168_1_, descriptio1_.META_TITLE as META10_168_1_, descriptio1_.SEF_URL as SEF11_168_1_, descriptio1_.CONTENT_ID as CONTENT13_167_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CONTENT content0_ left outer join SALESMANAGER.CONTENT_DESCRIPTION descriptio1_ on content0_.CONTENT_ID=descriptio1_.CONTENT_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on content0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where descriptio1_.LANGUAGE_ID=? and content0_.MERCHANT_ID=? and content0_.CONTENT_TYPE=? and content0_.VISIBLE=? order by content0_.SORT_ORDER asc
Hibernate: select distinct category0_.CATEGORY_ID as CATEGORY1_165_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_166_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, category0_.DATE_CREATED as DATE2_165_0_, category0_.DATE_MODIFIED as DATE3_165_0_, category0_.UPDT_ID as UPDT4_165_0_, category0_.CATEGORY_IMAGE as CATEGORY5_165_0_, category0_.CATEGORY_STATUS as CATEGORY6_165_0_, category0_.CODE as CODE165_0_, category0_.DEPTH as DEPTH165_0_, category0_.LINEAGE as LINEAGE165_0_, category0_.MERCHANT_ID as MERCHANT12_165_0_, category0_.PARENT_ID as PARENT13_165_0_, category0_.SORT_ORDER as SORT10_165_0_, category0_.VISIBLE as VISIBLE165_0_, descriptio1_.DATE_CREATED as DATE2_166_1_, descriptio1_.DATE_MODIFIED as DATE3_166_1_, descriptio1_.UPDT_ID as UPDT4_166_1_, descriptio1_.DESCRIPTION as DESCRIPT5_166_1_, descriptio1_.LANGUAGE_ID as LANGUAGE13_166_1_, descriptio1_.NAME as NAME166_1_, descriptio1_.TITLE as TITLE166_1_, descriptio1_.CATEGORY_ID as CATEGORY14_166_1_, descriptio1_.CATEGORY_HIGHLIGHT as CATEGORY8_166_1_, descriptio1_.META_DESCRIPTION as META9_166_1_, descriptio1_.META_KEYWORDS as META10_166_1_, descriptio1_.META_TITLE as META11_166_1_, descriptio1_.SEF_URL as SEF12_166_1_, descriptio1_.CATEGORY_ID as CATEGORY14_165_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CATEGORY category0_ left outer join SALESMANAGER.CATEGORY_DESCRIPTION descriptio1_ on category0_.CATEGORY_ID=descriptio1_.CATEGORY_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.DEPTH between ? and ?) and category0_.MERCHANT_ID=? and descriptio1_.LANGUAGE_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, descriptio1_.LANGUAGE_ID desc
Hibernate: select language0_.LANGUAGE_ID as LANGUAGE1_138_0_, language0_.DATE_CREATED as DATE2_138_0_, language0_.DATE_MODIFIED as DATE3_138_0_, language0_.UPDT_ID as UPDT4_138_0_, language0_.CODE as CODE138_0_, language0_.SORT_ORDER as SORT6_138_0_ from SALESMANAGER.LANGUAGE language0_ where language0_.LANGUAGE_ID=?
Hibernate: select merchantco0_.MERCHANT_CONFIG_ID as MERCHANT1_147_0_, merchantst1_.MERCHANT_ID as MERCHANT1_133_1_, merchantco0_.DATE_CREATED as DATE2_147_0_, merchantco0_.DATE_MODIFIED as DATE3_147_0_, merchantco0_.UPDT_ID as UPDT4_147_0_, merchantco0_.CONFIG_KEY as CONFIG5_147_0_, merchantco0_.TYPE as TYPE147_0_, merchantco0_.MERCHANT_ID as MERCHANT8_147_0_, merchantco0_.VALUE as VALUE147_0_, merchantst1_.STORE_CODE as STORE2_133_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_133_1_, merchantst1_.COUNTRY_ID as COUNTRY20_133_1_, merchantst1_.CURRENCY_ID as CURRENCY21_133_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_133_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_133_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_133_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_133_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_133_1_, merchantst1_.STORE_EMAIL as STORE9_133_1_, merchantst1_.STORE_LOGO as STORE10_133_1_, merchantst1_.STORE_TEMPLATE as STORE11_133_1_, merchantst1_.STORE_ADDRESS as STORE12_133_1_, merchantst1_.STORE_CITY as STORE13_133_1_, merchantst1_.STORE_NAME as STORE14_133_1_, merchantst1_.STORE_PHONE as STORE15_133_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_133_1_, merchantst1_.STORE_STATE_PROV as STORE17_133_1_, merchantst1_.USE_CACHE as USE18_133_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_133_1_, merchantst1_.ZONE_ID as ZONE23_133_1_ from SALESMANAGER.MERCHANT_CONFIGURATION merchantco0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on merchantco0_.MERCHANT_ID=merchantst1_.MERCHANT_ID where merchantco0_.MERCHANT_ID=? and merchantco0_.TYPE=?
Hibernate: select merchantco0_.MERCHANT_CONFIG_ID as MERCHANT1_147_0_, merchantst1_.MERCHANT_ID as MERCHANT1_133_1_, merchantco0_.DATE_CREATED as DATE2_147_0_, merchantco0_.DATE_MODIFIED as DATE3_147_0_, merchantco0_.UPDT_ID as UPDT4_147_0_, merchantco0_.CONFIG_KEY as CONFIG5_147_0_, merchantco0_.TYPE as TYPE147_0_, merchantco0_.MERCHANT_ID as MERCHANT8_147_0_, merchantco0_.VALUE as VALUE147_0_, merchantst1_.STORE_CODE as STORE2_133_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_133_1_, merchantst1_.COUNTRY_ID as COUNTRY20_133_1_, merchantst1_.CURRENCY_ID as CURRENCY21_133_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_133_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_133_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_133_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_133_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_133_1_, merchantst1_.STORE_EMAIL as STORE9_133_1_, merchantst1_.STORE_LOGO as STORE10_133_1_, merchantst1_.STORE_TEMPLATE as STORE11_133_1_, merchantst1_.STORE_ADDRESS as STORE12_133_1_, merchantst1_.STORE_CITY as STORE13_133_1_, merchantst1_.STORE_NAME as STORE14_133_1_, merchantst1_.STORE_PHONE as STORE15_133_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_133_1_, merchantst1_.STORE_STATE_PROV as STORE17_133_1_, merchantst1_.USE_CACHE as USE18_133_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_133_1_, merchantst1_.ZONE_ID as ZONE23_133_1_ from SALESMANAGER.MERCHANT_CONFIGURATION merchantco0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on merchantco0_.MERCHANT_ID=merchantst1_.MERCHANT_ID where merchantco0_.MERCHANT_ID=? and merchantco0_.CONFIG_KEY=? limit ?
DEBUG: org.springframework.web.servlet.DispatcherServlet - Rendering view [org.springframework.web.servlet.view.tiles2.TilesView: name 'search.bootstrap'; URL [search.bootstrap]] in DispatcherServlet with name 'appServlet'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'q' of type [java.lang.String] to request in view with name 'search.bootstrap'
DEBUG: org.springframework.web.servlet.DispatcherServlet - Successfully completed request
DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing GET request for [/sm-shop/shop/cart/displayMiniCartByCode.html]
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /shop/cart/displayMiniCartByCode.html
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public com.salesmanager.web.entity.shoppingcart.ShoppingCartData com.salesmanager.web.shop.controller.shoppingCart.MiniCartController.displayMiniCart(java.lang.String,javax.servlet.http.HttpServletRequest,org.springframework.ui.Model)]
DEBUG: org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/sm-shop/shop/cart/displayMiniCartByCode.html] is: -1
****** /sm-shop/shop/cart/displayMiniCartByCode.html
*** user.dir ***D:\NEERAJ\apache-tomcat-8.0.26\bin
DEBUG: com.salesmanager.web.filter.StoreFilter - *** user.dir ***D:\NEERAJ\apache-tomcat-8.0.26\bin
Hibernate: select content0_.CONTENT_ID as CONTENT1_167_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_168_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, content0_.DATE_CREATED as DATE2_167_0_, content0_.DATE_MODIFIED as DATE3_167_0_, content0_.UPDT_ID as UPDT4_167_0_, content0_.CODE as CODE167_0_, content0_.CONTENT_POSITION as CONTENT6_167_0_, content0_.CONTENT_TYPE as CONTENT7_167_0_, content0_.MERCHANT_ID as MERCHANT10_167_0_, content0_.SORT_ORDER as SORT8_167_0_, content0_.VISIBLE as VISIBLE167_0_, descriptio1_.DATE_CREATED as DATE2_168_1_, descriptio1_.DATE_MODIFIED as DATE3_168_1_, descriptio1_.UPDT_ID as UPDT4_168_1_, descriptio1_.DESCRIPTION as DESCRIPT5_168_1_, descriptio1_.LANGUAGE_ID as LANGUAGE12_168_1_, descriptio1_.NAME as NAME168_1_, descriptio1_.TITLE as TITLE168_1_, descriptio1_.CONTENT_ID as CONTENT13_168_1_, descriptio1_.META_DESCRIPTION as META8_168_1_, descriptio1_.META_KEYWORDS as META9_168_1_, descriptio1_.META_TITLE as META10_168_1_, descriptio1_.SEF_URL as SEF11_168_1_, descriptio1_.CONTENT_ID as CONTENT13_167_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CONTENT content0_ left outer join SALESMANAGER.CONTENT_DESCRIPTION descriptio1_ on content0_.CONTENT_ID=descriptio1_.CONTENT_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on content0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where descriptio1_.LANGUAGE_ID=? and content0_.MERCHANT_ID=? and (content0_.CONTENT_TYPE in (? , ?)) order by content0_.SORT_ORDER asc
Hibernate: select content0_.CONTENT_ID as CONTENT1_167_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_168_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, content0_.DATE_CREATED as DATE2_167_0_, content0_.DATE_MODIFIED as DATE3_167_0_, content0_.UPDT_ID as UPDT4_167_0_, content0_.CODE as CODE167_0_, content0_.CONTENT_POSITION as CONTENT6_167_0_, content0_.CONTENT_TYPE as CONTENT7_167_0_, content0_.MERCHANT_ID as MERCHANT10_167_0_, content0_.SORT_ORDER as SORT8_167_0_, content0_.VISIBLE as VISIBLE167_0_, descriptio1_.DATE_CREATED as DATE2_168_1_, descriptio1_.DATE_MODIFIED as DATE3_168_1_, descriptio1_.UPDT_ID as UPDT4_168_1_, descriptio1_.DESCRIPTION as DESCRIPT5_168_1_, descriptio1_.LANGUAGE_ID as LANGUAGE12_168_1_, descriptio1_.NAME as NAME168_1_, descriptio1_.TITLE as TITLE168_1_, descriptio1_.CONTENT_ID as CONTENT13_168_1_, descriptio1_.META_DESCRIPTION as META8_168_1_, descriptio1_.META_KEYWORDS as META9_168_1_, descriptio1_.META_TITLE as META10_168_1_, descriptio1_.SEF_URL as SEF11_168_1_, descriptio1_.CONTENT_ID as CONTENT13_167_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CONTENT content0_ left outer join SALESMANAGER.CONTENT_DESCRIPTION descriptio1_ on content0_.CONTENT_ID=descriptio1_.CONTENT_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on content0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where descriptio1_.LANGUAGE_ID=? and content0_.MERCHANT_ID=? and content0_.CONTENT_TYPE=? and content0_.VISIBLE=? order by content0_.SORT_ORDER asc
Hibernate: select distinct category0_.CATEGORY_ID as CATEGORY1_165_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_166_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, category0_.DATE_CREATED as DATE2_165_0_, category0_.DATE_MODIFIED as DATE3_165_0_, category0_.UPDT_ID as UPDT4_165_0_, category0_.CATEGORY_IMAGE as CATEGORY5_165_0_, category0_.CATEGORY_STATUS as CATEGORY6_165_0_, category0_.CODE as CODE165_0_, category0_.DEPTH as DEPTH165_0_, category0_.LINEAGE as LINEAGE165_0_, category0_.MERCHANT_ID as MERCHANT12_165_0_, category0_.PARENT_ID as PARENT13_165_0_, category0_.SORT_ORDER as SORT10_165_0_, category0_.VISIBLE as VISIBLE165_0_, descriptio1_.DATE_CREATED as DATE2_166_1_, descriptio1_.DATE_MODIFIED as DATE3_166_1_, descriptio1_.UPDT_ID as UPDT4_166_1_, descriptio1_.DESCRIPTION as DESCRIPT5_166_1_, descriptio1_.LANGUAGE_ID as LANGUAGE13_166_1_, descriptio1_.NAME as NAME166_1_, descriptio1_.TITLE as TITLE166_1_, descriptio1_.CATEGORY_ID as CATEGORY14_166_1_, descriptio1_.CATEGORY_HIGHLIGHT as CATEGORY8_166_1_, descriptio1_.META_DESCRIPTION as META9_166_1_, descriptio1_.META_KEYWORDS as META10_166_1_, descriptio1_.META_TITLE as META11_166_1_, descriptio1_.SEF_URL as SEF12_166_1_, descriptio1_.CATEGORY_ID as CATEGORY14_165_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CATEGORY category0_ left outer join SALESMANAGER.CATEGORY_DESCRIPTION descriptio1_ on category0_.CATEGORY_ID=descriptio1_.CATEGORY_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.DEPTH between ? and ?) and category0_.MERCHANT_ID=? and descriptio1_.LANGUAGE_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, descriptio1_.LANGUAGE_ID desc
Hibernate: select language0_.LANGUAGE_ID as LANGUAGE1_138_0_, language0_.DATE_CREATED as DATE2_138_0_, language0_.DATE_MODIFIED as DATE3_138_0_, language0_.UPDT_ID as UPDT4_138_0_, language0_.CODE as CODE138_0_, language0_.SORT_ORDER as SORT6_138_0_ from SALESMANAGER.LANGUAGE language0_ where language0_.LANGUAGE_ID=?
DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing POST request for [/sm-shop/services/public/search/DEFAULT/en/0/12/term.html]
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /services/public/search/DEFAULT/en/0/12/term.html
Hibernate: select merchantco0_.MERCHANT_CONFIG_ID as MERCHANT1_147_0_, merchantst1_.MERCHANT_ID as MERCHANT1_133_1_, merchantco0_.DATE_CREATED as DATE2_147_0_, merchantco0_.DATE_MODIFIED as DATE3_147_0_, merchantco0_.UPDT_ID as UPDT4_147_0_, merchantco0_.CONFIG_KEY as CONFIG5_147_0_, merchantco0_.TYPE as TYPE147_0_, merchantco0_.MERCHANT_ID as MERCHANT8_147_0_, merchantco0_.VALUE as VALUE147_0_, merchantst1_.STORE_CODE as STORE2_133_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_133_1_, merchantst1_.COUNTRY_ID as COUNTRY20_133_1_, merchantst1_.CURRENCY_ID as CURRENCY21_133_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_133_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_133_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_133_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_133_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_133_1_, merchantst1_.STORE_EMAIL as STORE9_133_1_, merchantst1_.STORE_LOGO as STORE10_133_1_, merchantst1_.STORE_TEMPLATE as STORE11_133_1_, merchantst1_.STORE_ADDRESS as STORE12_133_1_, merchantst1_.STORE_CITY as STORE13_133_1_, merchantst1_.STORE_NAME as STORE14_133_1_, merchantst1_.STORE_PHONE as STORE15_133_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_133_1_, merchantst1_.STORE_STATE_PROV as STORE17_133_1_, merchantst1_.USE_CACHE as USE18_133_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_133_1_, merchantst1_.ZONE_ID as ZONE23_133_1_ from SALESMANAGER.MERCHANT_CONFIGURATION merchantco0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on merchantco0_.MERCHANT_ID=merchantst1_.MERCHANT_ID where merchantco0_.MERCHANT_ID=? and merchantco0_.TYPE=?
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public com.salesmanager.web.entity.catalog.SearchProductList com.salesmanager.web.shop.controller.search.SearchController.search(java.lang.String,java.lang.String,java.lang.String,int,int,org.springframework.ui.Model,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)]
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor - Reading [java.lang.String] as "application/json;charset=UTF-8" using [org.springframework.http.converter.StringHttpMessageConverter@29d5b0cf]
Hibernate: select merchantco0_.MERCHANT_CONFIG_ID as MERCHANT1_147_0_, merchantst1_.MERCHANT_ID as MERCHANT1_133_1_, merchantco0_.DATE_CREATED as DATE2_147_0_, merchantco0_.DATE_MODIFIED as DATE3_147_0_, merchantco0_.UPDT_ID as UPDT4_147_0_, merchantco0_.CONFIG_KEY as CONFIG5_147_0_, merchantco0_.TYPE as TYPE147_0_, merchantco0_.MERCHANT_ID as MERCHANT8_147_0_, merchantco0_.VALUE as VALUE147_0_, merchantst1_.STORE_CODE as STORE2_133_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_133_1_, merchantst1_.COUNTRY_ID as COUNTRY20_133_1_, merchantst1_.CURRENCY_ID as CURRENCY21_133_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_133_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_133_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_133_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_133_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_133_1_, merchantst1_.STORE_EMAIL as STORE9_133_1_, merchantst1_.STORE_LOGO as STORE10_133_1_, merchantst1_.STORE_TEMPLATE as STORE11_133_1_, merchantst1_.STORE_ADDRESS as STORE12_133_1_, merchantst1_.STORE_CITY as STORE13_133_1_, merchantst1_.STORE_NAME as STORE14_133_1_, merchantst1_.STORE_PHONE as STORE15_133_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_133_1_, merchantst1_.STORE_STATE_PROV as STORE17_133_1_, merchantst1_.USE_CACHE as USE18_133_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_133_1_, merchantst1_.ZONE_ID as ZONE23_133_1_ from SALESMANAGER.MERCHANT_CONFIGURATION merchantco0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on merchantco0_.MERCHANT_ID=merchantst1_.MERCHANT_ID where merchantco0_.MERCHANT_ID=? and merchantco0_.CONFIG_KEY=? limit ?
Hibernate: select shoppingca0_.SHP_CART_ID as SHP1_191_0_, lineitems1_.SHP_CART_ITEM_ID as SHP1_193_1_, attributes2_.SHP_CART_ATTR_ITEM_ID as SHP1_192_2_, merchantst3_.MERCHANT_ID as MERCHANT1_133_3_, shoppingca0_.DATE_CREATED as DATE2_191_0_, shoppingca0_.DATE_MODIFIED as DATE3_191_0_, shoppingca0_.UPDT_ID as UPDT4_191_0_, shoppingca0_.CUSTOMER_ID as CUSTOMER5_191_0_, shoppingca0_.MERCHANT_ID as MERCHANT7_191_0_, shoppingca0_.SHP_CART_CODE as SHP6_191_0_, lineitems1_.DATE_CREATED as DATE2_193_1_, lineitems1_.DATE_MODIFIED as DATE3_193_1_, lineitems1_.UPDT_ID as UPDT4_193_1_, lineitems1_.PRODUCT_ID as PRODUCT5_193_1_, lineitems1_.QUANTITY as QUANTITY193_1_, lineitems1_.SHP_CART_ID as SHP7_193_1_, lineitems1_.SHP_CART_ID as SHP7_191_0__, lineitems1_.SHP_CART_ITEM_ID as SHP1_0__, attributes2_.DATE_CREATED as DATE2_192_2_, attributes2_.DATE_MODIFIED as DATE3_192_2_, attributes2_.UPDT_ID as UPDT4_192_2_, attributes2_.PRODUCT_ATTR_ID as PRODUCT5_192_2_, attributes2_.SHP_CART_ITEM_ID as SHP6_192_2_, attributes2_.SHP_CART_ITEM_ID as SHP6_193_1__, attributes2_.SHP_CART_ATTR_ITEM_ID as SHP1_1__, merchantst3_.STORE_CODE as STORE2_133_3_, merchantst3_.CONTINUESHOPPINGURL as CONTINUE3_133_3_, merchantst3_.COUNTRY_ID as COUNTRY20_133_3_, merchantst3_.CURRENCY_ID as CURRENCY21_133_3_, merchantst3_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_3_, merchantst3_.LANGUAGE_ID as LANGUAGE22_133_3_, merchantst3_.DOMAIN_NAME as DOMAIN5_133_3_, merchantst3_.IN_BUSINESS_SINCE as IN6_133_3_, merchantst3_.INVOICE_TEMPLATE as INVOICE7_133_3_, merchantst3_.SEIZEUNITCODE as SEIZEUNI8_133_3_, merchantst3_.STORE_EMAIL as STORE9_133_3_, merchantst3_.STORE_LOGO as STORE10_133_3_, merchantst3_.STORE_TEMPLATE as STORE11_133_3_, merchantst3_.STORE_ADDRESS as STORE12_133_3_, merchantst3_.STORE_CITY as STORE13_133_3_, merchantst3_.STORE_NAME as STORE14_133_3_, merchantst3_.STORE_PHONE as STORE15_133_3_, merchantst3_.STORE_POSTAL_CODE as STORE16_133_3_, merchantst3_.STORE_STATE_PROV as STORE17_133_3_, merchantst3_.USE_CACHE as USE18_133_3_, merchantst3_.WEIGHTUNITCODE as WEIGHTU19_133_3_, merchantst3_.ZONE_ID as ZONE23_133_3_ from SALESMANAGER.SHOPPING_CART shoppingca0_ left outer join SALESMANAGER.SHOPPING_CART_ITEM lineitems1_ on shoppingca0_.SHP_CART_ID=lineitems1_.SHP_CART_ID left outer join SALESMANAGER.SHOPPING_CART_ATTR_ITEM attributes2_ on lineitems1_.SHP_CART_ITEM_ID=attributes2_.SHP_CART_ITEM_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst3_ on shoppingca0_.MERCHANT_ID=merchantst3_.MERCHANT_ID where shoppingca0_.SHP_CART_CODE=? and shoppingca0_.MERCHANT_ID=?
WARN : org.hibernate.hql.internal.ast.QueryTranslatorImpl - HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
Hibernate: select merchantst0_.MERCHANT_ID as MERCHANT1_133_0_, language1_.LANGUAGE_ID as LANGUAGE1_138_1_, currency2_.CURRENCY_ID as CURRENCY1_139_2_, country3_.COUNTRY_ID as COUNTRY1_134_3_, zone4_.ZONE_ID as ZONE1_136_4_, language6_.LANGUAGE_ID as LANGUAGE1_138_5_, merchantst0_.STORE_CODE as STORE2_133_0_, merchantst0_.CONTINUESHOPPINGURL as CONTINUE3_133_0_, merchantst0_.COUNTRY_ID as COUNTRY20_133_0_, merchantst0_.CURRENCY_ID as CURRENCY21_133_0_, merchantst0_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_0_, merchantst0_.LANGUAGE_ID as LANGUAGE22_133_0_, merchantst0_.DOMAIN_NAME as DOMAIN5_133_0_, merchantst0_.IN_BUSINESS_SINCE as IN6_133_0_, merchantst0_.INVOICE_TEMPLATE as INVOICE7_133_0_, merchantst0_.SEIZEUNITCODE as SEIZEUNI8_133_0_, merchantst0_.STORE_EMAIL as STORE9_133_0_, merchantst0_.STORE_LOGO as STORE10_133_0_, merchantst0_.STORE_TEMPLATE as STORE11_133_0_, merchantst0_.STORE_ADDRESS as STORE12_133_0_, merchantst0_.STORE_CITY as STORE13_133_0_, merchantst0_.STORE_NAME as STORE14_133_0_, merchantst0_.STORE_PHONE as STORE15_133_0_, merchantst0_.STORE_POSTAL_CODE as STORE16_133_0_, merchantst0_.STORE_STATE_PROV as STORE17_133_0_, merchantst0_.USE_CACHE as USE18_133_0_, merchantst0_.WEIGHTUNITCODE as WEIGHTU19_133_0_, merchantst0_.ZONE_ID as ZONE23_133_0_, language1_.DATE_CREATED as DATE2_138_1_, language1_.DATE_MODIFIED as DATE3_138_1_, language1_.UPDT_ID as UPDT4_138_1_, language1_.CODE as CODE138_1_, language1_.SORT_ORDER as SORT6_138_1_, currency2_.CURRENCY_CODE as CURRENCY2_139_2_, currency2_.CURRENCY_CURRENCY_CODE as CURRENCY3_139_2_, currency2_.CURRENCY_NAME as CURRENCY4_139_2_, currency2_.CURRENCY_SUPPORTED as CURRENCY5_139_2_, country3_.GEOZONE_ID as GEOZONE4_134_3_, country3_.COUNTRY_ISOCODE as COUNTRY2_134_3_, country3_.COUNTRY_SUPPORTED as COUNTRY3_134_3_, zone4_.ZONE_CODE as ZONE2_136_4_, zone4_.COUNTRY_ID as COUNTRY3_136_4_, language6_.DATE_CREATED as DATE2_138_5_, language6_.DATE_MODIFIED as DATE3_138_5_, language6_.UPDT_ID as UPDT4_138_5_, language6_.CODE as CODE138_5_, language6_.SORT_ORDER as SORT6_138_5_, languages5_.stores_MERCHANT_ID as stores1_133_0__, languages5_.languages_LANGUAGE_ID as languages2_0__ from SALESMANAGER.MERCHANT_STORE merchantst0_ inner join SALESMANAGER.LANGUAGE language1_ on merchantst0_.LANGUAGE_ID=language1_.LANGUAGE_ID left outer join SALESMANAGER.CURRENCY currency2_ on merchantst0_.CURRENCY_ID=currency2_.CURRENCY_ID left outer join SALESMANAGER.COUNTRY country3_ on merchantst0_.COUNTRY_ID=country3_.COUNTRY_ID left outer join SALESMANAGER.ZONE zone4_ on merchantst0_.ZONE_ID=zone4_.ZONE_ID left outer join SALESMANAGER.MERCHANT_LANGUAGE languages5_ on merchantst0_.MERCHANT_ID=languages5_.stores_MERCHANT_ID left outer join SALESMANAGER.LANGUAGE language6_ on languages5_.languages_LANGUAGE_ID=language6_.LANGUAGE_ID where merchantst0_.STORE_CODE=?
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor - Written [com.salesmanager.web.entity.shoppingcart.ShoppingCartData@dc5b58c] as "application/json;charset=UTF-8" using [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@4e32d9a5]
DEBUG: org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'appServlet': assuming HandlerAdapter completed request handling
DEBUG: org.springframework.web.servlet.DispatcherServlet - Successfully completed request
ERROR: org.hibernate.hql.internal.ast.ErrorCounter - <AST>:0:0: unexpected end of subtree
ERROR: org.hibernate.hql.internal.ast.ErrorCounter - <AST>:0:0: unexpected end of subtree
<AST>:0:0: unexpected end of subtree
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3164)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:706)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:562)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.collectionFunctionOrSubselect(HqlSqlBaseWalker.java:4485)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.inRhs(HqlSqlBaseWalker.java:4390)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4065)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1935)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1860)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1860)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:794)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:595)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:216)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1207)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:256)
at com.mysema.query.jpa.impl.AbstractJPAQuery.getResultList(AbstractJPAQuery.java:195)
at com.mysema.query.jpa.impl.AbstractJPAQuery.list(AbstractJPAQuery.java:243)
at com.salesmanager.core.business.catalog.category.dao.CategoryDaoImpl.getByCodes(CategoryDaoImpl.java:114)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy216.getByCodes(Unknown Source)
at com.salesmanager.core.business.catalog.category.service.CategoryServiceImpl.listByCodes(CategoryServiceImpl.java:72)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy220.listByCodes(Unknown Source)
at com.salesmanager.web.shop.controller.search.SearchController.search(SearchController.java:239)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:155)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492)