shopizer-ecommerce / shopizer

Shopizer java e-commerce software

Shopizer 3.X (for java 1.8 +) (tested with Java 11)

Java open source e-commerce software

Headless commerce and Rest api for ecommerce

• Catalog
• Shopping cart
• Checkout
• Merchant
• Order
• Customer
• User

Shopizer Headless commerce consists of the following components:

• Spring boot Java / Spring boot backend
• Angular administration web application
• React JS front end application

See the demo: [**New demo on the way 2023]

Headless demo Available soon

1. Run from Docker images:

From the command line:

docker run -p 8080:8080 shopizerecomm/shopizer:latest

2. Run the administration tool

⋅⋅⋅ Requires the java backend to be running

docker run \
 -e "APP_BASE_URL=http://localhost:8080/api" \
 -p 82:80 shopizerecomm/shopizer-admin

3. Run react shop sample site

⋅⋅⋅ Requires the java backend to be running

docker run \
 -e "APP_MERCHANT=DEFAULT"
 -e "APP_BASE_URL=http://localhost:8080"
 -p 80:80 shopizerecomm/shopizer-shop-reactjs

API documentation:

https://app.swaggerhub.com/apis-docs/shopizer/shopizer-rest-api/3.0.1#/

Get the source code:

Clone the repository:

 $ git clone git://github.com/shopizer-ecommerce/shopizer.git
 
 $ git clone git://github.com/shopizer-ecommerce/shopizer-admin.git
 
 $ git clone git://github.com/shopizer-ecommerce/shopizer-shop-reactjs.git

If this is your first time using Github, review http://help.github.com to learn the basics.

You can also download the zip file containing the code from https://github.com/shopizer-ecommerce for each of the the projects above

To build the application:

1. Shopizer backend

From the command line:

$ cd shopizer
$ mvnw clean install
$ cd sm-shop
$ mvnw spring-boot:run

2. Shopizer admin

Form compiling and running Shopizer admin consult the repo README file

3. Shop sample site

Form compiling and running Shopizer admin consult the repo README file

Access the application:

---

Access the headless web application at: http://localhost:8080/swagger-ui.html

The instructions above will let you run the application with default settings and configurations. Please read the instructions on how to connect to MySQL, configure an email server and configure other subsystems

Documentation:

---

Documentation available https://shopizer-ecommerce.github.io/documentation/

Api documentation https://app.swaggerhub.com/apis-docs/shopizer/shopizer-rest-api/3.0.1#/

ChatOps https://shopizer.slack.com - Join our Slack channel https://communityinviter.com/apps/shopizer/shopizer

More information is available on shopizer web site here http://www.shopizer.com

Participation:

---

If you have interest in giving feedback or for participating to Shopizer project in any way Feel to use the contact form http://www.shopizer.com/contact.html and share your email address so we can send an invite to our Slack channel

How to Contribute:

---

Fork the repository to your GitHub account

Clone from fork repository

   $ git clone https://github.com/yourusername/shopizer.git

Build application according to steps provided above

Synchronize lastest version with the upstream

  $ git remote add upstream https://github.com/yourusername/shopizer.git
  $ git pull upstream 3.2.5

Create new branch in your repository

   $ git checkout -b branch-name

Push your changes to Shopizer

Please open a PR (pull request) in order to have your changes merged to the upstream

shopizer's Issues

Unable to fins the customer register or login link in footer of a shop

Unable to fins the customer register or login link in footer of a shop , it is expecting some permission, hasRole(AUTHCUSTOMER) am i need to any access related configuration for this. i am new to this please help me out of this

when maven install can not find shopizer:shopizer-shipping-distance-processor:jar

Failed to execute goal on project sm-core: Could not resolve dependencies for project com.shopizer:sm-core:jar:2.0.3-SNAPSHOT: Failure to find com.shopizer:shopizer-shipping-distance-processor:jar:0.0.1 in http://maven.springframework.org/milestone was cached in the local repository, resolution will not be reattempted until the update interval of org.springframework.maven.milestone has elapsed or updates are forced -> [Help 1]

this artifactId can not found.

    <dependency>
        <groupId>com.shopizer</groupId>
        <artifactId>shopizer-shipping-distance-processor</artifactId>
        <version>0.0.1</version>
           </dependency>

Error while building Shopizer -smcore

Hi,

Getting below exception while building sm-core.

E:\shopizer-2.0.2\shopizer\sm-core>mvn clean install
[INFO] Scanning for projects...
Downloading: http://maven.springframework.org/snapshot/com/shopizer/shopizer/2.0.2-SNAPSHOT/maven-metadata.xml
Downloading: http://maven.springframework.org/snapshot/com/shopizer/shopizer/2.0.2-SNAPSHOT/shopizer-2.0.2-SNAPSHOT.pom
[ERROR] [ERROR] Some problems were encountered while processing the POMs:
[FATAL] Non-resolvable parent POM for com.shopizer:sm-core:[unknown-version]: Could not find artifact com.shopizer:shopizer:pom:2.0.2-SNAPSHOT in org.springframework.maven.snapshot (http://maven.springframework.org/snapshot) and 'parent.relativePath' points at wrong local POM @ line 6, column 11
@
[ERROR] The build could not read 1 project -> [Help 1]
[ERROR]
[ERROR] The project com.shopizer:sm-core:unknown-version has 1 error
[ERROR] Non-resolvable parent POM for com.shopizer:sm-core:[unknown-version]: Could not find artifact com.shopizer:shopizer:pom:2.0.2-SNAPSHOT in org.springframework.maven.snapshot (http://maven.springframework.org/snapshot) and 'parent.relativePath' points at wrong local POM @ line 6, column 11 -> [Help 2]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:

Compilation while building master branch

Latest code having compilations ?
I am not able to build the master branch code (sm-core) because of compilations.In com.salesmanager.core.business.user.dao.UserDaoImpl.java getting compilations i,e not able to resolve imports for

com.salesmanager.core.business.user.model.QGroup;
com.salesmanager.core.business.user.model.QUser;

Since QUser and QGroup does not exist - Is it really a compilation or I am missing something ? Please help me out

I am using intellij idea with jdk version jdk1.7.0_67.

Thanks,

Not able to run clean install. Version 2.0.2

$ mvn clean install
[INFO] Scanning for projects...
[ERROR] [ERROR] Some problems were encountered while processing the POMs:
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.shopizer:sm-core:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-core/pom.xml, line 58, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-modules:jar must be a valid version but is '${sm-core-modules.version}'. @ com.shopizer:sm-core:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-core/pom.xml, line 65, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-search:jar must be a valid version but is '${sm-search.version}'. @ com.shopizer:sm-core:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-core/pom.xml, line 72, column 13
[WARNING] 'build.pluginManagement.plugins.plugin.(groupId:artifactId)' must be unique but found duplicate declaration of plugin org.bsc.maven:maven-processor-plugin @ com.shopizer:sm-core-model:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-core-model/pom.xml, line 426, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.shopizer:sm-core-modules:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-core-modules/pom.xml, line 30, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core:jar must be a valid version but is '${sm-core.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 42, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 49, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-modules:jar must be a valid version but is '${sm-core-modules.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 56, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-search:jar must be a valid version but is '${sm-search.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 64, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:shopizer-shipping-canadapost-module:jar must be a valid version but is '${shopizer-canadapost.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 71, column 13
@
[ERROR] The build could not read 3 projects -> [Help 1]
[ERROR]
[ERROR] The project com.shopizer:sm-core:0.0.1-SNAPSHOT (/Volumes/A/myProjects/shopizer/shopizer/sm-core/pom.xml) has 3 errors
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.shopizer:sm-core:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-core/pom.xml, line 58, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-modules:jar must be a valid version but is '${sm-core-modules.version}'. @ com.shopizer:sm-core:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-core/pom.xml, line 65, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-search:jar must be a valid version but is '${sm-search.version}'. @ com.shopizer:sm-core:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-core/pom.xml, line 72, column 13
[ERROR]
[ERROR] The project com.shopizer:sm-core-modules:0.0.1-SNAPSHOT (/Volumes/A/myProjects/shopizer/shopizer/sm-core-modules/pom.xml) has 1 error
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.shopizer:sm-core-modules:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-core-modules/pom.xml, line 30, column 13
[ERROR]
[ERROR] The project com.salesmanager:sm-shop:0.0.1-SNAPSHOT (/Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml) has 5 errors
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core:jar must be a valid version but is '${sm-core.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 42, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 49, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-modules:jar must be a valid version but is '${sm-core-modules.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 56, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-search:jar must be a valid version but is '${sm-search.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 64, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:shopizer-shipping-canadapost-module:jar must be a valid version but is '${shopizer-canadapost.version}'. @ com.salesmanager:sm-shop:[unknown-version], /Volumes/A/myProjects/shopizer/shopizer/sm-shop/pom.xml, line 71, column 13
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException

Ability to change schema name

Currently we have restriction in place to use schema name as SALESMANAGER. There should be a way to use schema name as per user choice and ability to configure it through property file.

Invalid characters when coming in with a french brower using french language

Shop and admin pages display invalid characters when coming in with a french browser

some classes missing beginning with Q

Hi there,

I pulled this project and while compiling it, i noticed that classes beginning with Q are not there i.e QCategory,QCategoryDescription,QProduct,QProductAttribute,QProductOption,QProductOptionValue,QProductOptionValueDescription,QProductOption,QProductOptionDescription,QProductOptionValue,QProductOptionValueDescription,QProduct,QDigitalProduct etc.

Were they left intentionally or its a bug ?

Demo data does not show Order in admin order list

In the demo data a dummy order is created. During startup demo data is inserted but it looks like the demo 'Order' object is skipped

Getting NullPointerException while placing the order after I log in

Getting NullPointerException while placing the order after I log in.

error while building sm-shop

[ERROR] Failed to execute goal on project sm-shop: Could not resolve dependencie
s for project com.salesmanager:sm-shop:war:2.0.2-SNAPSHOT: Failure to find com.s
hopizer:sm-core:jar:2.0.2 in http://maven.springframework.org/milestone was cach
ed in the local repository, resolution will not be reattempted until the update
interval of org.springframework.maven.milestone has elapsed or updates are force

pls help me regarding this

HTTP Status 500 - Request processing failed; nested exception

Dears,
After building and moving sm-shop.war to Tomcat webapps folder and then accessing the url:
http://localhost:8080/sm-shop/shop

I'm facing this error

HTTP Status 500 - Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection

So, what is the problem, can anybody help ?

Could not resolve dependencies com.shopizer:sm-search:jar:0.0.5-SNAPSHOT, com.shopizer:shopizer-shipping-distance-processor:jar:0.0.1

Mvn clean install master getting this dependence error
[ERROR] Failed to execute goal on project sm-core: Could not resolve dependencies for project com.shopizer:sm-core:jar:2.0.3-SNAPSHOT: The following artifacts could not be resolved: com.shopizer:sm-search:jar:0.0.5-SNAPSHOT, com.shopizer:shopizer-shipping-distance-processor:jar:0.0.1: Failure to find com.shopizer:sm-search:jar:0.0.5-SNAPSHOT in http://maven.springframework.org/snapshot was cached in the local repository, resolution will not be reattempted until the update interval of org.springframework.maven.snapshot has elapsed or updates are forced -> [Help 1]

ShippingDistancePreProcessorImpl ClassNotFind

com.shopizer.modules.shipping.distance.ShippingDistancePreProcessorImpl ClassNotFind plz upload

Problem with java.lang.OutOfMemoryError: PermGen space

Hi ,

As much as I increase XX:MaxPermSize. it still fails on PermGen space.

Thanks,
Marin

I clone the project and try to building it, it's failed: not found ProductType.code

I clone the project and try to building it, it's failed: not found ProductType.code

in master and 2.0.1 branches

Ability to customize order number series

Sometime we have need where we want order number to have a specific number series say

AB000001 , CD000001 or may be OR1234566

There should be a way where developer can configure order number pattern as well the starting number through property file etc
like
order.prefix=OR
order.total.length=10
order.series.start=00000020

In short we should have a way that order number pattern should be configurable.

My Account link is not working

When I click on My Account link after I login, it takes me to the dashboard.html page. There I am provided with three links like My Account, Billing and shipping address and one more. When I click on the My account link on the dashboard.html it takes me to nowhere. I checked the code, it seems its trying to get some customer option name and customer option code from the DB. I am not sure how these would be populated. I could see some option in the admin panel and tried to put some name and value there but it went in vain. Any idea how this My Account link works.

Thanks,
Ratnesh

Manufacture create issue

Hi Team,

I am trying to create manufacture, getting bellow error. can you help me out.

org.springframework.beans.NotReadablePropertyException: Invalid property 'code' of bean class [com.salesmanager.web.admin.entity.catalog.Manufacturer]: Bean property 'code' is not readable or has an invalid getter method: Does the return type of the getter match the parameter type of the setter?
org.springframework.beans.BeanWrapperImpl.getPropertyValue(BeanWrapperImpl.java:729)
org.springframework.beans.BeanWrapperImpl.getPropertyValue(BeanWrapperImpl.java:721)
org.springframework.validation.AbstractPropertyBindingResult.getActualFieldValue(AbstractPropertyBindingResult.java:99)
org.springframework.validation.AbstractBindingResult.getFieldValue(AbstractBindingResult.java:226)
org.springframework.web.servlet.support.BindStatus.(BindStatus.java:120)
org.springframework.web.servlet.tags.form.AbstractDataBoundFormElementTag.getBindStatus(AbstractDataBoundFormElementTag.java:178)
org.springframework.web.servlet.tags.form.AbstractDataBoundFormElementTag.getPropertyPath(AbstractDataBoundFormElementTag.java:198)
org.springframework.web.servlet.tags.form.AbstractDataBoundFormElementTag.getName(AbstractDataBoundFormElementTag.java:164)
org.springframework.web.servlet.tags.form.AbstractDataBoundFormElementTag.autogenerateId(AbstractDataBoundFormElementTag.java:151)
org.springframework.web.servlet.tags.form.AbstractDataBoundFormElementTag.resolveId(AbstractDataBoundFormElementTag.java:142)
org.springframework.web.servlet.tags.form.AbstractDataBoundFormElementTag.writeDefaultAttributes(AbstractDataBoundFormElementTag.java:126)
org.springframework.web.servlet.tags.form.AbstractHtmlElementTag.writeDefaultAttributes(AbstractHtmlElementTag.java:421)
org.springframework.web.servlet.tags.form.InputTag.writeTagContent(InputTag.java:142)
org.springframework.web.servlet.tags.form.AbstractFormTag.doStartTagInternal(AbstractFormTag.java:102)
org.springframework.web.servlet.tags.RequestContextAwareTag.doStartTag(RequestContextAwareTag.java:79)
org.apache.jsp.pages.admin.products.manufacturer_jsp._jspx_meth_form_005finput_005f1(manufacturer_jsp.java:1390)
org.apache.jsp.pages.admin.products.manufacturer_jsp._jspService(manufacturer_jsp.java:384)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
org.apache.jasper.runtime.PageContextImpl.doInclude(PageContextImpl.java:688)
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:682)
org.apache.tiles.jsp.context.JspTilesRequestContext.include(JspTilesRequestContext.java:103)
org.apache.tiles.jsp.context.JspTilesRequestContext.dispatch(JspTilesRequestContext.java:96)
org.apache.tiles.renderer.impl.UntypedAttributeRenderer.write(UntypedAttributeRenderer.java:61)
org.apache.tiles.renderer.impl.AbstractBaseAttributeRenderer.render(AbstractBaseAttributeRenderer.java:103)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:659)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:337)
org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:234)
org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:211)
org.apache.tiles.jsp.taglib.RenderTag.doEndTag(RenderTag.java:220)
org.apache.jsp.layout.admin.layout_jsp._jspx_meth_tiles_005finsertAttribute_005f0(layout_jsp.java:1301)
org.apache.jsp.layout.admin.layout_jsp._jspService(layout_jsp.java:265)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.tiles.servlet.context.ServletTilesRequestContext.forward(ServletTilesRequestContext.java:241)
org.apache.tiles.servlet.context.ServletTilesRequestContext.dispatch(ServletTilesRequestContext.java:222)
org.apache.tiles.renderer.impl.TemplateAttributeRenderer.write(TemplateAttributeRenderer.java:44)
org.apache.tiles.renderer.impl.AbstractBaseAttributeRenderer.render(AbstractBaseAttributeRenderer.java:103)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:659)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:678)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:633)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:322)
org.springframework.web.servlet.view.tiles2.TilesView.renderMergedOutputModel(TilesView.java:124)
org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:262)
org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1157)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:927)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

DeadLockSelector

Hi all,
I have just download, build and deploy .war to tomcat 7. When I start the project, I got an exception
DeadLockSelector Apprent DeadLock, when loading InstrumentaionLoadTimeweaver.
Would you please help to fix this issue.
Thank you so much

When I create product, There is a Exception: java.lang.OutOfMemoryError: PermGen space

The memory in my computer is 6G, there is still has 3G free when the exception occured. I have try to add "JAVA_OPTS" in catalina.bat as "JAVA_OPTS="-server -Xms512m -Xmx2048m -XX:PermSize=512m -XX:MaxNewSize=256m -XX:MaxPermSize=1536m -Djava.awt.headless=true". but the issue still exist, please give me some suggestion?

The detail of issue:

NFO : org.elasticsearch.node - [Stunner] {0.90.2}[3376]: initializing ...
INFO : org.elasticsearch.plugins - [Stunner] loaded [], sites []
2014-10-23 16:46:05 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet appServlet threw exception
java.lang.OutOfMemoryError: PermGen space
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:621)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)
at java.net.URLClassLoader.access$000(URLClassLoader.java:56)
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at org.elasticsearch.action.ActionModule.configure(ActionModule.java:187)
at org.elasticsearch.common.inject.AbstractModule.configure(AbstractModule.java:60)
at org.elasticsearch.common.inject.spi.Elements$RecordingBinder.install(Elements.java:201)
at org.elasticsearch.common.inject.spi.Elements.getElements(Elements.java:82)
at org.elasticsearch.common.inject.InjectorShell$Builder.build(InjectorShell.java:130)
at org.elasticsearch.common.inject.InjectorBuilder.build(InjectorBuilder.java:99)
at org.elasticsearch.common.inject.Guice.createInjector(Guice.java:93)
at org.elasticsearch.common.inject.Guice.createInjector(Guice.java:70)
at org.elasticsearch.common.inject.ModulesBuilder.createInjector(ModulesBuilder.java:59)
at org.elasticsearch.node.internal.InternalNode.(InternalNode.java:164)
at org.elasticsearch.node.NodeBuilder.build(NodeBuilder.java:159)
at org.elasticsearch.node.NodeBuilder.node(NodeBuilder.java:166)
at com.shopizer.search.utils.SearchClient.initClient(SearchClient.java:95)
at com.shopizer.search.utils.SearchClient.getClient(SearchClient.java:41)
at com.shopizer.search.services.impl.SearchDelegateImpl.indexExist(SearchDelegateImpl.java:70)
at com.shopizer.search.services.worker.ObjectIndexerImpl.init(ObjectIndexerImpl.java:76)
at com.shopizer.search.services.worker.ObjectIndexerImpl.execute(ObjectIndexerImpl.java:102)
at com.shopizer.search.services.workflow.IndexWorkflow.index(IndexWorkflow.java:51)
at com.shopizer.search.services.SearchService.index(SearchService.java:84)
at com.salesmanager.core.business.search.service.SearchServiceImpl.index(SearchServiceImpl.java:148)
at com.salesmanager.core.business.catalog.product.service.ProductServiceImpl.addProductDescription(ProductServiceImpl.java:94)

Not found QCategory and QCategoryDescription class!

Hi All,

I am new to shopizer, I just download the source code and build it, but this source code doesn't have following 2 class.
com.salesmanager.core.business.catalog.category.model.QCategory;
com.salesmanager.core.business.catalog.category.model.QCategoryDescription;

Please check it, thanks you

getting exception when saving store branding information please help

while saving MerchantStore in db hibernate is saying

save the transient instance before flushing: com.salesmanager.core.business.merchant.model.MerchantStore.zone -> com.salesmanager.core.business.reference.zone.model.Zone

here is log which i got

org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.TransientPropertyValueException: object references an unsaved transient instance - save the transient instance before flushing: com.salesmanager.core.business.merchant.model.MerchantStore.zone -> com.salesmanager.core.business.reference.zone.model.Zone; nested exception is java.lang.IllegalStateException: org.hibernate.TransientPropertyValueException: object references an unsaved transient instance - save the transient instance before flushing: com.salesmanager.core.business.merchant.model.MerchantStore.zone -> com.salesmanager.core.business.reference.zone.model.Zone
at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:298)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:106)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:516)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy139.saveOrUpdate(Unknown Source)
at com.salesmanager.web.admin.controller.merchant.StoreBrandingController.saveTemplate(StoreBrandingController.java:132)
at com.salesmanager.web.admin.controller.merchant.StoreBrandingController$$FastClassByCGLIB$$5f454fcb.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at com.salesmanager.web.admin.controller.merchant.StoreBrandingController$$EnhancerByCGLIB$$7b35875f.saveTemplate()
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
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:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
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.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
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:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: org.hibernate.TransientPropertyValueException: object references an unsaved transient instance - save the transient instance before flushing: com.salesmanager.core.business.merchant.model.MerchantStore.zone -> com.salesmanager.core.business.reference.zone.model.Zone
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1362)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1293)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:80)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512)
... 78 more
Caused by: org.hibernate.TransientPropertyValueException: object references an unsaved transient instance - save the transient instance before flushing: com.salesmanager.core.business.merchant.model.MerchantStore.zone -> com.salesmanager.core.business.reference.zone.model.Zone
at org.hibernate.engine.spi.CascadingAction$8.noCascade(CascadingAction.java:380)
at org.hibernate.engine.internal.Cascade.cascade(Cascade.java:176)
at org.hibernate.event.internal.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:160)
at org.hibernate.event.internal.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:151)
at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:88)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1181)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:379)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:75)
... 79 more

org.hibernate.TransientPropertyValueException: object references an unsaved transient instance - save the transient instance before flushing: com.salesmanager.core.business.merchant.model.MerchantStore.zone -> com.salesmanager.core.business.reference.zone.model.Zone
at org.hibernate.engine.spi.CascadingAction$8.noCascade(CascadingAction.java:380)
at org.hibernate.engine.internal.Cascade.cascade(Cascade.java:176)
at org.hibernate.event.internal.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:160)
at org.hibernate.event.internal.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:151)
at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:88)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1181)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:379)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:75)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy139.saveOrUpdate(Unknown Source)
at com.salesmanager.web.admin.controller.merchant.StoreBrandingController.saveTemplate(StoreBrandingController.java:132)
at com.salesmanager.web.admin.controller.merchant.StoreBrandingController$$FastClassByCGLIB$$5f454fcb.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at com.salesmanager.web.admin.controller.merchant.StoreBrandingController$$EnhancerByCGLIB$$7b35875f.saveTemplate()
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
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:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
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.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
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:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)

DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing POST request for [/sm-shop/admin/store/saveTemplate.html]
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /admin/store/saveTemplate.html

Hello Carl

Hello Carl, I don't know you ever understand alibaba druid connection pool, with good, recommend you.

creating manufacturer is giving "Field required"

In admin panel when i click catalogue and create manufacturer, Form shows "Field Required" and did not save the details what should i do..............

error while building shopizer 2.0.2

[ERROR]
[ERROR] For more information about the errors and possible solutions, please rea
d the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyReso
lutionException

C:\shopizer\shopizer>mvn clean install
[INFO] Scanning for projects...
[WARNING]
[WARNING] Some problems were encountered while building the effective model for
com.shopizer:sm-core-model:jar:2.0.2-SNAPSHOT
[WARNING] 'build.pluginManagement.plugins.plugin.(groupId:artifactId)' must be u
nique but found duplicate declaration of plugin org.bsc.maven:maven-processor-pl
ugin @ com.shopizer:sm-core-model:[unknown-version], C:\shopizer\shopizer\sm-cor
e-model\pom.xml, line 426, column 13
[WARNING]
[WARNING] It is highly recommended to fix these problems because they threaten t
he stability of your build.
[WARNING]
[WARNING] For this reason, future Maven versions might no longer support buildin
g such malformed projects.
[WARNING]
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Build Order:
[INFO]
[INFO] shopizer
[INFO] sm-core
[INFO] sm-core-model
[INFO] sm-core-modules
[INFO] sm-shop
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building shopizer 2.0.2-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- maven-clean-plugin:2.5:clean (default-clean) @ shopizer ---
[INFO]
[INFO] --- maven-install-plugin:2.4:install (default-install) @ shopizer ---
[INFO] Installing C:\shopizer\shopizer\pom.xml to C:\Users\customer.m2\reposito
ry\com\shopizer\shopizer\2.0.2-SNAPSHOT\shopizer-2.0.2-SNAPSHOT.pom
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building sm-core 2.0.2-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[WARNING] The artifact aspectj:aspectjrt:jar:1.5.4 has been relocated to org.asp
ectj:aspectjrt:jar:1.5.4
[WARNING] The artifact aspectj:aspectjweaver:jar:1.5.4 has been relocated to org
.aspectj:aspectjweaver:jar:1.5.4
[INFO]
[INFO] --- maven-clean-plugin:2.5:clean (default-clean) @ sm-core ---
[INFO] Deleting C:\shopizer\shopizer\sm-core\target
[INFO]

[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ sm-core --

[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 40 resources
[INFO]
[INFO] --- maven-compiler-plugin:2.3.2:compile (default-compile) @ sm-core ---
[INFO] Compiling 268 source files to C:\shopizer\shopizer\sm-core\target\classes

[INFO]
[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ sm
-core ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 6 resources
[INFO]
[INFO] --- maven-compiler-plugin:2.3.2:testCompile (default-testCompile) @ sm-co
re ---
[INFO] Compiling 28 source files to C:\shopizer\shopizer\sm-core\target\test-cla
sses
[INFO]
[INFO] --- maven-surefire-plugin:2.12:test (default-test) @ sm-core ---
[INFO] Tests are skipped.
[INFO]
[INFO] --- maven-jar-plugin:2.4:jar (default-jar) @ sm-core ---
[INFO] Building jar: C:\shopizer\shopizer\sm-core\target\sm-core-2.0.2-SNAPSHOT.
jar
[INFO]
[INFO] --- maven-install-plugin:2.3.1:install (default-install) @ sm-core ---
[INFO] Installing C:\shopizer\shopizer\sm-core\target\sm-core-2.0.2-SNAPSHOT.jar
to C:\Users\customer.m2\repository\com\shopizer\sm-core\2.0.2-SNAPSHOT\sm-core
-2.0.2-SNAPSHOT.jar
[INFO] Installing C:\shopizer\shopizer\sm-core\pom.xml to C:\Users\customer.m2
repository\com\shopizer\sm-core\2.0.2-SNAPSHOT\sm-core-2.0.2-SNAPSHOT.pom
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building sm-core-model 2.0.2-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[WARNING] The artifact aspectj:aspectjrt:jar:1.5.4 has been relocated to org.asp
ectj:aspectjrt:jar:1.5.4
[WARNING] The artifact aspectj:aspectjweaver:jar:1.5.4 has been relocated to org
.aspectj:aspectjweaver:jar:1.5.4
[INFO]
[INFO] --- maven-clean-plugin:2.5:clean (default-clean) @ sm-core-model ---
[INFO] Deleting C:\shopizer\shopizer\sm-core-model\target
[INFO]

[INFO] --- maven-processor-plugin:3.1.0-beta1:process (process) @ sm-core-model

[WARNING] No processors specified. Using default discovery mechanism.
[INFO] diagnostic: Note: Hibernate JPA 2 Static-Metamodel Generator 1.1.1.Final
[WARNING] diagnostic: warning: Supported source version 'RELEASE_6' from annotat
ion processor 'org.hibernate.jpamodelgen.JPAMetaModelEntityProcessor' less than
-source '1.7'
[WARNING] diagnostic: warning: Supported source version 'RELEASE_6' from annotat
ion processor 'org.eclipse.sisu.scanners.index.SisuIndexAPT6' less than -source
'1.7'
[WARNING] diagnostic: warning: The following options were not recognized by any
processor: '[addSuppressWarningsAnnotation]'
[INFO]

[INFO] --- maven-processor-plugin:3.1.0-beta1:process (default) @ sm-core-model

[WARNING] No processors specified. Using default discovery mechanism.
[INFO] diagnostic: Note: Hibernate JPA 2 Static-Metamodel Generator 1.1.1.Final
[WARNING] diagnostic: warning: Supported source version 'RELEASE_6' from annotat
ion processor 'org.hibernate.jpamodelgen.JPAMetaModelEntityProcessor' less than
-source '1.7'
[WARNING] diagnostic: warning: Supported source version 'RELEASE_6' from annotat
ion processor 'org.eclipse.sisu.scanners.index.SisuIndexAPT6' less than -source
'1.7'
[INFO]
[INFO] --- maven-apt-plugin:1.0.2:process (default) @ sm-core-model ---
[INFO]
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ sm-core-mo
del ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] skip non existing resourceDirectory C:\shopizer\shopizer\sm-core-model\sr
c\main\resources
[INFO]
[INFO] --- maven-compiler-plugin:2.3.2:compile (default-compile) @ sm-core-model

---

[INFO] Compiling 290 source files to C:\shopizer\shopizer\sm-core-model\target\c
lasses
[INFO]
[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ sm
-core-model ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] skip non existing resourceDirectory C:\shopizer\shopizer\sm-core-model\sr
c\test\resources
[INFO]
[INFO] --- maven-compiler-plugin:2.3.2:testCompile (default-testCompile) @ sm-co
re-model ---
[INFO] No sources to compile
[INFO]
[INFO] --- maven-surefire-plugin:2.12:test (default-test) @ sm-core-model ---
[INFO] Tests are skipped.
[INFO]
[INFO] --- maven-jar-plugin:2.4:jar (default-jar) @ sm-core-model ---
[INFO] Building jar: C:\shopizer\shopizer\sm-core-model\target\sm-core-model-2.0
.2-SNAPSHOT.jar
[INFO]

[INFO] --- maven-install-plugin:2.3.1:install (default-install) @ sm-core-model

[INFO] Installing C:\shopizer\shopizer\sm-core-model\target\sm-core-model-2.0.2-
SNAPSHOT.jar to C:\Users\customer.m2\repository\com\shopizer\sm-core-model\2.0.
2-SNAPSHOT\sm-core-model-2.0.2-SNAPSHOT.jar
[INFO] Installing C:\shopizer\shopizer\sm-core-model\pom.xml to C:\Users\custome
r.m2\repository\com\shopizer\sm-core-model\2.0.2-SNAPSHOT\sm-core-model-2.0.2-S
NAPSHOT.pom
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building sm-core-modules 2.0.2-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- maven-clean-plugin:2.5:clean (default-clean) @ sm-core-modules ---
[INFO] Deleting C:\shopizer\shopizer\sm-core-modules\target
[INFO]
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ sm-core-mo
dules ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] skip non existing resourceDirectory C:\shopizer\shopizer\sm-core-modules
src\main\resources
[INFO]
[INFO] --- maven-compiler-plugin:2.3.2:compile (default-compile) @ sm-core-modul
es ---
[INFO] Compiling 12 source files to C:\shopizer\shopizer\sm-core-modules\target
classes
[INFO]
[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ sm
-core-modules ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] skip non existing resourceDirectory C:\shopizer\shopizer\sm-core-modules
src\test\resources
[INFO]
[INFO] --- maven-compiler-plugin:2.3.2:testCompile (default-testCompile) @ sm-co
re-modules ---
[INFO] No sources to compile
[INFO]
[INFO] --- maven-surefire-plugin:2.12:test (default-test) @ sm-core-modules ---
[INFO] Tests are skipped.
[INFO]
[INFO] --- maven-jar-plugin:2.4:jar (default-jar) @ sm-core-modules ---
[INFO] Building jar: C:\shopizer\shopizer\sm-core-modules\target\sm-core-modules
-2.0.2-SNAPSHOT.jar
[INFO]
[INFO] --- maven-install-plugin:2.3.1:install (default-install) @ sm-core-module
s ---
[INFO] Installing C:\shopizer\shopizer\sm-core-modules\target\sm-core-modules-2.
0.2-SNAPSHOT.jar to C:\Users\customer.m2\repository\com\shopizer\sm-core-module
s\2.0.2-SNAPSHOT\sm-core-modules-2.0.2-SNAPSHOT.jar
[INFO] Installing C:\shopizer\shopizer\sm-core-modules\pom.xml to C:\Users\custo
mer.m2\repository\com\shopizer\sm-core-modules\2.0.2-SNAPSHOT\sm-core-modules-2
.0.2-SNAPSHOT.pom
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building sm-shop 2.0.2-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[WARNING] The POM for com.shopizer:sm-core:jar:2.0.2 is missing, no dependency i
nformation available
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] shopizer ........................................... SUCCESS [ 0.294 s]
[INFO] sm-core ............................................ SUCCESS [ 7.905 s]
[INFO] sm-core-model ...................................... SUCCESS [ 7.648 s]
[INFO] sm-core-modules .................................... SUCCESS [ 0.625 s]
[INFO] sm-shop ............................................ FAILURE [ 0.215 s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 16.819 s
[INFO] Finished at: 2015-09-11T17:55:16+05:30
[INFO] Final Memory: 63M/168M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project sm-shop: Could not resolve dependencie
s for project com.salesmanager:sm-shop:war:2.0.2-SNAPSHOT: Failure to find com.s
hopizer:sm-core:jar:2.0.2 in http://maven.springframework.org/milestone was cach
ed in the local repository, resolution will not be reattempted until the update
interval of org.springframework.maven.milestone has elapsed or updates are force
d -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e swit
ch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please rea
d the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyReso
lutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command

[ERROR] mvn -rf :sm-shop

Unable to install Syntax error, annotations are only available if source level is 5.0

I'm getting errors while installing through $mvn clean install

[INFO] --- aspectj-maven-plugin:1.2:compile (default) @ sm-shop ---
[ERROR] Syntax error, annotations are only available if source level is 5.0
[ERROR] The type AbstractDataPopulator is not generic; it cannot be parameterized with arguments <ShoppingCartData, ShoppingCart>
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] Syntax error, annotations are only available if source level is 5.0
[ERROR] The operator > is undefined for the argument type(s) Long, int
[ERROR] The type List is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] The type Set is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] The type HashSet is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] Syntax error, 'for each' statements are only available if source level is 5.0
[ERROR] The type Set is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] Syntax error, 'for each' statements are only available if source level is 5.0
[ERROR] Incompatible operand types long and Long
[ERROR] The method setQuantity(Integer) in the type ShoppingCartItem is not applicable for the arguments (int)
[ERROR] The type Set is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] The type Set is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] The type HashSet is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] The type List is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] Syntax error, 'for each' statements are only available if source level is 5.0
[ERROR] Syntax error, 'for each' statements are only available if source level is 5.0
[ERROR] Incompatible operand types long and Long
[ERROR] The type Set is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] The type HashSet is not generic; it cannot be parameterized with arguments
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] The method getById(Serializable) in the type SalesManagerEntityService is not applicable for the arguments (long)
[ERROR] Syntax error, parameterized types are only available if source level is 5.0
[ERROR] The type ArrayList is not generic; it cannot be parameterized with arguments
.
.
.
.
.and so on :-(
kindly guide me on this issue

Typo in eclipse setup wiki page

Right-click shopizer > Run As > Maven gerate-sources
Shouldn't this be generate-sources

Ability of enhance product data in staged enviornment

Currently we have everything (Catalog , Category, products ) in the online version and any changes directly reflects in the store which is sometime good but can cause issue if not done carefully.

Idea is to create 2 version of catalog (staged and online).
Everything assigned to the catalog will be in staged version initially so that admin / product manager can enhance change products and other things related to it.

Once everything is ok, we can have a button (push to online version) which will move these products to the online version.

Apart from the facility of enrich the products without directly changing the online version, it will also provide a way to handle the products in case some one want to get product feed from third party system where these products needs to be verified and approved.

build error:QCategory cannot be resolved

the import com.salesmanager.core.business.catalog.category.model.QCategory cannot be resolved

Ability to create search index from admin pannel

It is always a good option to have a way where admin can run indexing job from the admin panel so that it should be re index with the ES.

There should be an option which can be used to re index everything from fresh by discarding previous indexed data with the ES

Ability to create Permission group using configuration

Currently Shopizer is creating Predefined Permission through InitializationLoader.java class by creating new Permission object and creating it though permissionService.

User should have ability to create new permission instance through configuration.

1.All Permission should be defined in a property file or XML file.
2. Ability to read this file and create permission on server initialization

Need Document

Hi Team,

I am trying to customize the template, if possible can you please send dme the step by step document.

Thanks,
Vincent Louis

So many java source missing. Can't work ?

This is an extract for mvn generate-sources why so many sources are missing ?

symbol: class QCountryDescription
location: package com.salesmanager.core.business.reference.country.model
[ERROR] diagnostic: C:\Users\Fab\workspace-eclipse\shopizer-master\sm-core\src\main\java\com\salesmanager\core\business\reference\cu
rrency\dao\CurrencyDaoImpl.java:11: error: cannot find symbol
import com.salesmanager.core.business.reference.currency.model.QCurrency;
^
symbol: class QCurrency
location: package com.salesmanager.core.business.reference.currency.model
[ERROR] diagnostic: C:\Users\Fab\workspace-eclipse\shopizer-master\sm-core\src\main\java\com\salesmanager\core\business\reference\zo
ne\dao\ZoneDaoImpl.java:12: error: cannot find symbol
import com.salesmanager.core.business.reference.zone.model.QZone;
^
symbol: class QZone
location: package com.salesmanager.core.business.reference.zone.model
[ERROR] diagnostic: C:\Users\Fab\workspace-eclipse\shopizer-master\sm-core\src\main\java\com\salesmanager\core\business\reference\zo
ne\dao\ZoneDaoImpl.java:13: error: cannot find symbol
import com.salesmanager.core.business.reference.zone.model.QZoneDescription;
^
symbol: class QZoneDescription
location: package com.salesmanager.core.business.reference.zone.model
[ERROR] diagnostic: C:\Users\Fab\workspace-eclipse\shopizer-master\sm-core\src\main\java\com\salesmanager\core\business\shoppingcart
\dao\ShoppingCartDaoImpl.java:14: error: cannot find symbol
import com.salesmanager.core.business.shoppingcart.model.QShoppingCart;
^
symbol: class QShoppingCart
location: package com.salesmanager.core.business.shoppingcart.model
[ERROR] diagnostic: C:\Users\Fab\workspace-eclipse\shopizer-master\sm-core\src\main\java\com\salesmanager\core\business\shoppingcart
\dao\ShoppingCartDaoImpl.java:15: error: cannot find symbol
import com.salesmanager.core.business.shoppingcart.model.QShoppingCartItem;
^
symbol: class QShoppingCartItem
location: package com.salesmanager.core.business.shoppingcart.model
[ERROR] diagnostic: C:\Users\Fab\workspace-eclipse\shopizer-master\sm-core\src\main\java\com\salesmanager\core\business\system\dao\M
erchantConfigurationDaoImpl.java:13: error: cannot find symbol
import com.salesmanager.core.business.system.model.QMerchantConfiguration;

Admin dashboard should present last 20 orders

Log in the admin, the home page should present last 20 orders, the ordering by reverse date do not seem to work

Category filter by category code not working

Requires a DAO that finds a list of category based on a like query

Orders are not filtered in the admin tool

Log in the admin, left menu choose orders, try to filter by name or payment method, returns an empty list or fails

Unable to install ($mvn clean install) getting following errors

Error log :-(
[INFO] Scanning for projects...
[ERROR] [ERROR] Some problems were encountered while processing the POMs:
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.shopizer:sm-core:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-core\pom.xml, line 58, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-modules:jar must be a valid version but is '${sm-core-modules.version}'. @ com.shopizer:sm-core:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-core\pom.xml, line 65, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-search:jar must be a valid version but is '${sm-search.version}'. @ com.shopizer:sm-core:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-core\pom.xml, line 72, column 13
[WARNING] 'build.pluginManagement.plugins.plugin.(groupId:artifactId)' must be unique but found duplicate declaration of plugin org.bsc.maven:maven-processor-plugin @ com.shopizer:sm-core-model:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-core-model\pom.xml, line 426, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.shopizer:sm-core-modules:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-core-modules\pom.xml, line 30, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core:jar must be a valid version but is '${sm-core.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 42, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 49, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-modules:jar must be a valid version but is '${sm-core-modules.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 56, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-search:jar must be a valid version but is '${sm-search.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 64, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:shopizer-shipping-canadapost-module:jar must be a valid version but is '${shopizer-canadapost.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 71, column 13
@
[ERROR] The build could not read 3 projects -> [Help 1]
[ERROR]
[ERROR] The project com.shopizer:sm-core:0.0.1-SNAPSHOT (F:\Projects\shopizer-2.0.2\shopizer\sm-core\pom.xml) has 3 errors
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.shopizer:sm-core:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-core\pom.xml, line 58, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-modules:jar must be a valid version but is '${sm-core-modules.version}'. @ com.shopizer:sm-core:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-core\pom.xml, line 65, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-search:jar must be a valid version but is '${sm-search.version}'. @ com.shopizer:sm-core:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-core\pom.xml, line 72, column 13
[ERROR]
[ERROR] The project com.shopizer:sm-core-modules:0.0.1-SNAPSHOT (F:\Projects\shopizer-2.0.2\shopizer\sm-core-modules\pom.xml) has 1 error
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.shopizer:sm-core-modules:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-core-modules\pom.xml, line 30, column 13
[ERROR]
[ERROR] The project com.salesmanager:sm-shop:0.0.1-SNAPSHOT (F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml) has 5 errors
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core:jar must be a valid version but is '${sm-core.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 42, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-model:jar must be a valid version but is '${sm-core-model.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 49, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-core-modules:jar must be a valid version but is '${sm-core-modules.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 56, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:sm-search:jar must be a valid version but is '${sm-search.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 64, column 13
[ERROR] 'dependencies.dependency.version' for com.shopizer:shopizer-shipping-canadapost-module:jar must be a valid version but is '${shopizer-canadapost.version}'. @ com.salesmanager:sm-shop:[unknown-version], F:\Projects\shopizer-2.0.2\shopizer\sm-shop\pom.xml, line 71, column 13
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException

Can't find Customer login link

Deployed Shopizer to my tomcat. Build & Deployment process is pretty smooth with no issues. But once the site is online , i can't see the login link or My Account or a way to create a new customer from the site. Do i need to enable something ?

http://localhost:8080/sm-shop/shop

Any help would be great

No class QProductAttribute

can't import source code into eclipse

when i import the source code into eclipse i met a problem as blew:i do it follows the documents,

who can give me some advices?

Generate invoice does not download the generated PDF V2.0ALPHA

Go to invoice details, click on generate invoice, wrong mim type

sm-core mvn generate-sources fail

mvn generate-sources

/work/workspace/Reach/shopizer/sm-core/src/main/java/com/salesmanager/core/business/system/dao/MerchantConfigurationDaoImpl.java:13: cannot find symbol
symbol : class QMerchantConfiguration
location: package com.salesmanager.core.business.system.model
import com.salesmanager.core.business.system.model.QMerchantConfiguration;
^
/work/workspace/Reach/shopizer/sm-core/src/main/java/com/salesmanager/core/business/system/dao/ModuleConfigurationDaoImpl.java:11: cannot find symbol
symbol : class QIntegrationModule
location: package com.salesmanager.core.business.system.model
import com.salesmanager.core.business.system.model.QIntegrationModule;
^
/work/workspace/Reach/shopizer/sm-core/src/main/java/com/salesmanager/core/business/system/service/SystemConfigurationServiceImpl.java:10: cannot find symbol
symbol : class SystemConfiguration_
location: package com.salesmanager.core.business.system.model
import com.salesmanager.core.business.system.model.SystemConfiguration_;
^
/work/workspace/Reach/shopizer/sm-core/src/main/java/com/salesmanager/core/business/tax/dao/taxclass/TaxClassDaoImpl.java:11: cannot find symbol
symbol : class QTaxClass
location: package com.salesmanager.core.business.tax.model.taxclass
import com.salesmanager.core.business.tax.model.taxclass.QTaxClass;
^
/work/workspace/Reach/shopizer/sm-core/src/main/java/com/salesmanager/core/business/tax/dao/taxrate/TaxRateDaoImpl.java:15: cannot find symbol
symbol : class QTaxRate
location: package com.salesmanager.core.business.tax.model.taxrate
import com.salesmanager.core.business.tax.model.taxrate.QTaxRate;
^
/work/workspace/Reach/shopizer/sm-core/src/main/java/com/salesmanager/core/business/tax/dao/taxrate/TaxRateDaoImpl.java:16: cannot find symbol
symbol : class QTaxRateDescription
location: package com.salesmanager.core.business.tax.model.taxrate
import com.salesmanager.core.business.tax.model.taxrate.QTaxRateDescription;
^
/work/workspace/Reach/shopizer/sm-core/src/main/java/com/salesmanager/core/business/user/dao/GroupDaoImpl.java:15: cannot find symbol
symbol : class QGroup
location: package com.salesmanager.core.business.user.model
import com.salesmanager.core.business.user.model.QGroup;
^
/work/workspace/Reach/shopizer/sm-core/src/main/java/com/salesmanager/core/business/user/dao/PermissionDaoImpl.java:20: cannot find symbol
symbol : class QPermission
location: package com.salesmanager.core.business.user.model
import com.salesmanager.core.business.user.model.QPermission;

It can't be compiled (mvn generate-sources) under jdk8

Caused by: javax.lang.model.type.UnknownTypeException: Unknown type: java.lang.Object&java.io.Serializable&java.lang.Comparable
at javax.lang.model.util.AbstractTypeVisitor6.visitUnknown(AbstractTypeVisitor6.java:150)
at javax.lang.model.util.AbstractTypeVisitor6.visitIntersection(AbstractTypeVisitor6.java:133)
at com.sun.tools.javac.code.Type$IntersectionClassType.accept(Type.java:1019)
at javax.lang.model.util.AbstractTypeVisitor6.visit(AbstractTypeVisitor6.java:92)
at com.mysema.query.apt.ExtendedTypeFactory$2.visitTypeVariable(ExtendedTypeFactory.java:250)
at com.mysema.query.apt.ExtendedTypeFactory$2.visitTypeVariable(ExtendedTypeFactory.java:199)
at com.sun.tools.javac.code.Type$TypeVar.accept(Type.java:1319)
at javax.lang.model.util.AbstractTypeVisitor6.visit(AbstractTypeVisitor6.java:92)
at com.mysema.query.apt.ExtendedTypeFactory$2.visitDeclared(ExtendedTypeFactory.java:233)
at com.mysema.query.apt.ExtendedTypeFactory$2.visitDeclared(ExtendedTypeFactory.java:199)
at com.sun.tools.javac.code.Type$ClassType.accept(Type.java:936)
at javax.lang.model.util.AbstractTypeVisitor6.visit(AbstractTypeVisitor6.java:92)
at com.mysema.query.apt.ExtendedTypeFactory.getEntityType(ExtendedTypeFactory.java:461)
at com.mysema.query.apt.AbstractQuerydslProcessor.processAnnotations(AbstractQuerydslProcessor.java:114)
at com.mysema.query.apt.AbstractQuerydslProcessor.process(AbstractQuerydslProcessor.java:97)
at com.sun.tools.javac.processing.JavacProcessingEnvironment.callProcessor(JavacProcessingEnvironment.java:794)
at com.sun.tools.javac.processing.JavacProcessingEnvironment.discoverAndRunProcs(JavacProcessingEnvironment.java:705)
at com.sun.tools.javac.processing.JavacProcessingEnvironment.access$1800(JavacProcessingEnvironment.java:91)
at com.sun.tools.javac.processing.JavacProcessingEnvironment$Round.run(JavacProcessingEnvironment.java:1035)
at com.sun.tools.javac.processing.JavacProcessingEnvironment.doProcessing(JavacProcessingEnvironment.java:1176)
at com.sun.tools.javac.main.JavaCompiler.processAnnotations(JavaCompiler.java:1170)
at com.sun.tools.javac.main.JavaCompiler.compile(JavaCompiler.java:856)
at com.sun.tools.javac.main.Main.compile(Main.java:523)
... 24 more

Customers are not filtered in the admin tool

Log in the admin, left menu choose customers, try to filter by name or email, returns an empty list

java.lang.ClassNotFoundException: com.salesmanager.core.modules.integration.shipping.model.ShippingQuotePrePostProcessModule

I deploy sm-shop.war to tomcat server, the following exception occurs：
`01-Mar-2016 21:02:31.898 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log No Spring WebApplicationInitializer types detected on classpath
01-Mar-2016 21:02:32.169 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log Initializing Spring root WebApplicationContext
01-Mar-2016 21:02:49.741 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'categoryDao': Injection of persistence dependencies failed; nested exception is org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [com.shopizer.modules.shipping.distance.ShippingDistancePreProcessorImpl] for bean with name 'shippingDistancePreProcessor' defined in class path resource [spring/processors/shopizer-core-shipping-processors.xml]: problem with class file or dependent class; nested exception is java.lang.NoClassDefFoundError: com/salesmanager/core/modules/integration/shipping/model/ShippingQuotePrePostProcessModule
Related cause: org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [com.shopizer.modules.shipping.distance.ShippingDistancePreProcessorImpl] for bean with name 'shippingDistancePreProcessor' defined in class path resource [spring/processors/shopizer-core-shipping-processors.xml]: problem with class file or dependent class; nested exception is java.lang.NoClassDefFoundError: com/salesmanager/core/modules/integration/shipping/model/ShippingQuotePrePostProcessModule
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessPropertyValues(PersistenceAnnotationBeanPostProcessor.java:345)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:636)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:938)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5221)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:919)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1703)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [com.shopizer.modules.shipping.distance.ShippingDistancePreProcessorImpl] for bean with name 'shippingDistancePreProcessor' defined in class path resource [spring/processors/shopizer-core-shipping-processors.xml]: problem with class file or dependent class; nested exception is java.lang.NoClassDefFoundError: com/salesmanager/core/modules/integration/shipping/model/ShippingQuotePrePostProcessModule
at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1281)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.predictBeanType(AbstractAutowireCapableBeanFactory.java:575)
at org.springframework.beans.factory.support.AbstractBeanFactory.isFactoryBean(AbstractBeanFactory.java:1347)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doGetBeanNamesForType(DefaultListableBeanFactory.java:358)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:335)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:322)
at org.springframework.beans.factory.BeanFactoryUtils.beanNamesForTypeIncludingAncestors(BeanFactoryUtils.java:143)
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findDefaultEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:534)
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:504)
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.resolveEntityManager(PersistenceAnnotationBeanPostProcessor.java:667)
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.getResourceToInject(PersistenceAnnotationBeanPostProcessor.java:638)
at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:169)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessPropertyValues(PersistenceAnnotationBeanPostProcessor.java:342)
... 26 more
Caused by: java.lang.NoClassDefFoundError: com/salesmanager/core/modules/integration/shipping/model/ShippingQuotePrePostProcessModule
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:760)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2450)
at org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:852)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1262)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1145)
at org.springframework.util.ClassUtils.forName(ClassUtils.java:265)
at org.springframework.beans.factory.support.AbstractBeanDefinition.resolveBeanClass(AbstractBeanDefinition.java:419)
at org.springframework.beans.factory.support.AbstractBeanFactory.doResolveBeanClass(AbstractBeanFactory.java:1299)
at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1270)
... 39 more
Caused by: java.lang.ClassNotFoundException: com.salesmanager.core.modules.integration.shipping.model.ShippingQuotePrePostProcessModule
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1293)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1145)
... 50 more
Related cause:
org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [com.shopizer.modules.shipping.distance.ShippingDistancePreProcessorImpl] for bean with name 'shippingDistancePreProcessor' defined in class path resource [spring/processors/shopizer-core-shipping-processors.xml]: problem with class file or dependent class; nested exception is java.lang.NoClassDefFoundError: com/salesmanager/core/modules/integration/shipping/model/ShippingQuotePrePostProcessModule
at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1281)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.predictBeanType(AbstractAutowireCapableBeanFactory.java:575)
at org.springframework.beans.factory.support.AbstractBeanFactory.isFactoryBean(AbstractBeanFactory.java:1347)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doGetBeanNamesForType(DefaultListableBeanFactory.java:358)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:327)
at org.springframework.beans.factory.BeanFactoryUtils.beanNamesForTypeIncludingAncestors(BeanFactoryUtils.java:186)
at org.springframework.aop.framework.autoproxy.BeanFactoryAdvisorRetrievalHelper.findAdvisorBeans(BeanFactoryAdvisorRetrievalHelper.java:73)
at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findCandidateAdvisors(AbstractAdvisorAutoProxyCreator.java:101)
at org.springframework.aop.aspectj.autoproxy.AspectJAwareAdvisorAutoProxyCreator.shouldSkip(AspectJAwareAdvisorAutoProxyCreator.java:103)
at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessBeforeInstantiation(AbstractAutoProxyCreator.java:278)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:922)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:894)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:448)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:636)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:938)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5221)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:919)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1703)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: com/salesmanager/core/modules/integration/shipping/model/ShippingQuotePrePostProcessModule
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:760)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2450)
at org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:852)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1262)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1145)
at org.springframework.util.ClassUtils.forName(ClassUtils.java:265)
at org.springframework.beans.factory.support.AbstractBeanDefinition.resolveBeanClass(AbstractBeanDefinition.java:419)
at org.springframework.beans.factory.support.AbstractBeanFactory.doResolveBeanClass(AbstractBeanFactory.java:1299)
at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1270)
... 35 more
Caused by: java.lang.ClassNotFoundException: com.salesmanager.core.modules.integration.shipping.model.ShippingQuotePrePostProcessModule
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1293)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1145)
... 46 more

01-Mar-2016 21:02:49.749 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log Closing Spring root WebApplicationContext
`
@shopizer-ecommerce

org.hibernate.exception.GenericJDBCException: Order by expression "LANGUAGE3_.LANGUAGE_ID

Hi ,

I am getting the following error while I click on Novels or Home links in the shop site.

16:13:19,066 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 90068, SQLState: 90068
16:13:19,082 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper Order by expression "LANGUAGE3_.LANGUAGE_ID" must be in the result list in this case; SQL statement:
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.LANGUAGE language3_ on descriptio1_.LANGUAGE_ID=language3_.LANGUAGE_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.LINEAGE like ? escape '!') and category0_.MERCHANT_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, language3_.LANGUAGE_ID desc [90068-152]
16:13:19,082 ERROR org.springframework.transaction.interceptor.TransactionInterceptor Application exception overridden by commit exception: com.salesmanager.core.business.generic.exception.ServiceException: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [90068]; error code [90068]; Order by expression "LANGUAGE3_.LANGUAGE_ID" must be in the result list in this case; SQL statement:
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.LANGUAGE language3_ on descriptio1_.LANGUAGE_ID=language3_.LANGUAGE_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.LINEAGE like ? escape '!') and category0_.MERCHANT_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, language3_.LANGUAGE_ID desc [90068-152]; nested exception is org.hibernate.exception.GenericJDBCException: Order by expression "LANGUAGE3_.LANGUAGE_ID" must be in the result list in this case; SQL statement:
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.LANGUAGE language3_ on descriptio1_.LANGUAGE_ID=language3_.LANGUAGE_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.LINEAGE like ? escape '!') and category0_.MERCHANT_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, language3_.LANGUAGE_ID desc [90068-152]
at com.salesmanager.core.business.catalog.category.service.CategoryServiceImpl.listByLineage(CategoryServiceImpl.java:108) [sm-core-2.0.2-SNAPSHOT.jar:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_31]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_31]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_31]
at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_31]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at $Proxy75.listByLineage(Unknown Source) at com.salesmanager.web.shop.controller.category.ShoppingCategoryController.displayCategory(ShoppingCategoryController.java:178) [classes:]
at com.salesmanager.web.shop.controller.category.ShoppingCategoryController.displayCategoryWithReference(ShoppingCategoryController.java:115) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_31]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_31]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_31]
at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_31]
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.1.Final-redhat-2.jar:1.0.1.Final-redhat-2]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.1.Final-redhat-2.jar:1.0.1.Final-redhat-2]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:372) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931) [jbossweb-7.0.17.Final-redhat-1.jar:]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]
Caused by: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [90068]; error code [90068]; Order by expression "LANGUAGE3_.LANGUAGE_ID" must be in the result list in this case; SQL statement:
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.LANGUAGE language3_ on descriptio1_.LANGUAGE_ID=language3_.LANGUAGE_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.LINEAGE like ? escape '!') and category0_.MERCHANT_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, language3_.LANGUAGE_ID desc [90068-152]; nested exception is org.hibernate.exception.GenericJDBCException: Order by expression "LANGUAGE3_.LANGUAGE_ID" must be in the result list in this case; SQL statement:
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.LANGUAGE language3_ on descriptio1_.LANGUAGE_ID=language3_.LANGUAGE_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.LINEAGE like ? escape '!') and category0_.MERCHANT_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, language3_.LANGUAGE_ID desc [90068-152]
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:649) [spring-orm-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:104) [spring-orm-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403) [spring-orm-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at $Proxy73.listByLineage(Unknown Source) at com.salesmanager.core.business.catalog.category.service.CategoryServiceImpl.listByLineage(CategoryServiceImpl.java:106) [sm-core-2.0.2-SNAPSHOT.jar:]
... 79 more
Caused by: org.hibernate.exception.GenericJDBCException: Order by expression "LANGUAGE3_.LANGUAGE_ID" must be in the result list in this case; SQL statement:
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.LANGUAGE language3_ on descriptio1_.LANGUAGE_ID=language3_.LANGUAGE_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.LINEAGE like ? escape '!') and category0_.MERCHANT_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, language3_.LANGUAGE_ID desc [90068-152]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) [hibernate-core-4.1.2.jar:4.1.2]
at $Proxy161.prepareStatement(Unknown Source) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1720) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.loader.Loader.doQuery(Loader.java:828) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.loader.Loader.doList(Loader.java:2447) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.loader.Loader.doList(Loader.java:2433) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2263) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.loader.Loader.list(Loader.java:2258) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1215) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) [hibernate-core-4.1.2.jar:4.1.2]
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:256) [hibernate-entitymanager-4.1.2.jar:4.1.2]
at com.mysema.query.jpa.impl.AbstractJPAQuery.getResultList(AbstractJPAQuery.java:195) [querydsl-jpa-3.4.2.jar:]
at com.mysema.query.jpa.impl.AbstractJPAQuery.list(AbstractJPAQuery.java:243) [querydsl-jpa-3.4.2.jar:]
at com.salesmanager.core.business.catalog.category.dao.CategoryDaoImpl.listByLineage(CategoryDaoImpl.java:198) [sm-core-2.0.2-SNAPSHOT.jar:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_31]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_31]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_31]
at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_31]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
... 85 more
Caused by: org.h2.jdbc.JdbcSQLException: Order by expression "LANGUAGE3_.LANGUAGE_ID" must be in the result list in this case; SQL statement:
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.LANGUAGE language3_ on descriptio1_.LANGUAGE_ID=language3_.LANGUAGE_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.LINEAGE like ? escape '!') and category0_.MERCHANT_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, language3_.LANGUAGE_ID desc [90068-152]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) [h2-1.3.152.jar:1.3.152]
at org.h2.message.DbException.get(DbException.java:167) [h2-1.3.152.jar:1.3.152]
at org.h2.message.DbException.get(DbException.java:144) [h2-1.3.152.jar:1.3.152]
at org.h2.command.dml.Query.initOrder(Query.java:359) [h2-1.3.152.jar:1.3.152]
at org.h2.command.dml.Select.init(Select.java:695) [h2-1.3.152.jar:1.3.152]
at org.h2.command.Parser.parseSelect(Parser.java:1470) [h2-1.3.152.jar:1.3.152]
at org.h2.command.Parser.parsePrepared(Parser.java:401) [h2-1.3.152.jar:1.3.152]
at org.h2.command.Parser.parse(Parser.java:275) [h2-1.3.152.jar:1.3.152]
at org.h2.command.Parser.parse(Parser.java:247) [h2-1.3.152.jar:1.3.152]
at org.h2.command.Parser.prepare(Parser.java:201) [h2-1.3.152.jar:1.3.152]
at org.h2.command.Parser.prepareCommand(Parser.java:214) [h2-1.3.152.jar:1.3.152]
at org.h2.engine.Session.prepareLocal(Session.java:426) [h2-1.3.152.jar:1.3.152]
at org.h2.engine.Session.prepareCommand(Session.java:374) [h2-1.3.152.jar:1.3.152]
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1093) [h2-1.3.152.jar:1.3.152]
at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:71) [h2-1.3.152.jar:1.3.152]
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243) [h2-1.3.152.jar:1.3.152]
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213) [c3p0-0.9.1.2.jar:0.9.1.2]
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source) [:1.6.0_31]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_31]
at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_31]
at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138) [hibernate-core-4.1.2.jar:4.1.2]
... 114 more

16:13:19,098 ERROR org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/sm-shop-2.0.2-SNAPSHOT].[appServlet] Servlet.service() for servlet appServlet threw exception: javax.persistence.RollbackException: Transaction marked as rollbackOnly
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:72) [hibernate-entitymanager-4.1.2.jar:4.1.2]
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512) [spring-orm-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:431) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:114) [spring-tx-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at $Proxy75.listByLineage(Unknown Source) at com.salesmanager.web.shop.controller.category.ShoppingCategoryController.displayCategory(ShoppingCategoryController.java:178) [classes:]
at com.salesmanager.web.shop.controller.category.ShoppingCategoryController.displayCategoryWithReference(ShoppingCategoryController.java:115) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_31]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_31]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_31]
at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_31]
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.1.Final-redhat-2.jar:1.0.1.Final-redhat-2]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.1.Final-redhat-2.jar:1.0.1.Final-redhat-2]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) [spring-security-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:372) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679) [jbossweb-7.0.17.Final-redhat-1.jar:]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931) [jbossweb-7.0.17.Final-redhat-1.jar:]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]

shoppizer demo

dears,
Shopizzer demo doesn't work on this link
http://demo.shopizer.com/sm-shop

Please fix it

null ponter error when changing to national currency format while placing order

issue:-
when we changes the store setting on admin panel as below,
store-->national currency format--> and checked the box (National currency format ex $1,345.79 or International currency format ex USD1,345.79).
after saving and restarting the tomcat applcaition server.we gets error while checking out the cart.

we cant place order once changing to national currency format

error logs is below:-

com.salesmanager.core.business.generic.exception.ServiceException: java.lang.NullPointerException at com.salesmanager.core.business.order.service.OrderServiceImpl.caculateOrderTotal(OrderServiceImpl.java:342) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) 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.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy117.caculateOrderTotal(Unknown Source) at com.salesmanager.web.shop.controller.order.facade.OrderFacadeImpl.calculateOrderTotal(OrderFacadeImpl.java:204) at com.salesmanager.web.shop.controller.order.facade.OrderFacadeImpl.calculateOrderTotal(OrderFacadeImpl.java:160) at com.salesmanager.web.shop.controller.order.ShoppingOrderController.displayCheckout(ShoppingOrderController.java:311) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) at

2.0.1 setup issues tax calculation shipping h2database persistence xml

PersistableCustomerPopulator.java - state was not populated for Billing and Delivery so tax calculation was throw null pointer exception if tax calculation option is set to either shipping of billing address. I am using it in Singapore so zone is empty. If store address is used for tax calculation then it works as zone is present in prepopulated data. Again stateprovince is empty for store too. I am not sure if zone concept is new and there will be maintenance screens developed in admin to populate zones.?

TaxServiceImpl.java - comparison with enum SHIPPINGADDRESS, BILLINGADDRESS, STOREADDRESS is not working as STOREADDRESS.name() is not used while doing equals comparison.

•           if(taxBasisCalculation.name().equals(TaxBasisCalculation.SHIPPINGADDRESS)){
  

•           if(taxBasisCalculation.name().equals(TaxBasisCalculation.SHIPPINGADDRESS.name())){
  

sm-shop/src/main/java/com/salesmanager/web/utils/LocaleUtils.java - gives MissingResourceException while fetching getISO3Country(). Just wrap the exception in try catch and ignore the exception.

sm-shop/src/main/resources/log4j.xml - org.apache.log4j.rolling.RollingFileAppender should be changed to org.apache.log4j.RollingFileAppender.

shopizer-properties.xml - I would suggest to keep prepopulate data on as default as it will help a lot of people to evaluate the product. Just like I was doing.

sm-shop/src/main/webapp/pages/shop/templates/bootstrap3/sections/header.jsp - missing taglib inclusion for sm:storeLogo/.

Tax, Shipping configuration needs to be done in prepopulated data to run smoothly.

H2database - orderBy with language was giving errors saying order by column should be part of select columns, but in mysql it seems to be working. I had to remove all the orderBy language.id portion to make it work. http://www.h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90068

shipping option - while submitting as guest shipping option was coming as null, and this was giving a lot of problems.

sm-core/src/main/resources/META-INF/sm-persistence.xml - missing entry

•           <class>com.salesmanager.core.business.payments.model.Transaction</class>
  

I am not creating multiple issue requests as I believe these are basic and might have been already fixed.

functionality - after order fulfillment I couldn't find the remaining quantity available getting reduced to reflect the number of items delivered.

Overall I liked the application but its a bit limited in inventory management and order fulfillment.