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]
****** http://localhost:8080/sm-shop/shop/search/search.html
****** /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
****** http://localhost:8080/sm-shop/shop/cart/displayMiniCartByCode.html
****** /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)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
ERROR: com.salesmanager.web.shop.controller.search.SearchController - Exception occured while querying {"query":{"query_string" : {"fields" : ["name^3", "description", "tags"], "query" : "*Spring in Action*", "use_dis_max" : true }},"facets" : { "categories" : { "terms" : {"field" : "categories"}}}}
org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select category
from com.salesmanager.core.business.catalog.category.model.Category category
  left join fetch category.descriptions as categoryDescription
  left join fetch category.merchantStore
where category.code in () and category.merchantStore.id = ?2 and categoryDescription.language.id = ?2
order by category.sortOrder asc, category.lineage asc, category.lineage asc, category.depth asc, categoryDescription.language.id desc]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select category
from com.salesmanager.core.business.catalog.category.model.Category category
  left join fetch category.descriptions as categoryDescription
  left join fetch category.merchantStore
where category.code in () and category.merchantStore.id = ?2 and categoryDescription.language.id = ?2
order by category.sortOrder asc, category.lineage asc, category.lineage asc, category.depth asc, categoryDescription.language.id desc]
	at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:296)
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:108)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403)
	at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
	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)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select category
from com.salesmanager.core.business.catalog.category.model.Category category
  left join fetch category.descriptions as categoryDescription
  left join fetch category.merchantStore
where category.code in () and category.merchantStore.id = ?2 and categoryDescription.language.id = ?2
order by category.sortOrder asc, category.lineage asc, category.lineage asc, category.depth asc, categoryDescription.language.id desc]
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1352)
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1293)
	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:265)
	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)
	... 93 more
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select category
from com.salesmanager.core.business.catalog.category.model.Category category
  left join fetch category.descriptions as categoryDescription
  left join fetch category.merchantStore
where category.code in () and category.merchantStore.id = ?2 and categoryDescription.language.id = ?2
order by category.sortOrder asc, category.lineage asc, category.lineage asc, category.depth asc, categoryDescription.language.id desc]
	at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
	at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
	at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:79)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:255)
	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)
	... 104 more
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor - Written [com.salesmanager.web.entity.catalog.SearchProductList@3a94d778] 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