I have successfully deployed the site-admin from ecommerce.zip with mysql 5.1.56 database on glassfish 3.1.
I have populated the database with import.sql and checked that the data is effectively loaded.
When I launch http://localhost:8080/site-admin-0.0.1-SNAPSHOT I get an error from hibernate: (during request of login.jsp)
INFO: Hibernate: select top ? idgenerati0_.ID_TYPE as ID1_10_, idgenerati0_.BATCH_SIZE as BATCH2_10_, idgenerati0_.BATCH_START as BATCH3_10_, idgenerati0_.ID_MIN as ID4_10_, idgenerati0_.ID_MAX as ID5_10_, idgenerati0_.version as version10_ from BLC_ID_GENERATION idgenerati0_ where idgenerati0_.ID_TYPE=?
INFO: [ WARN] 09:40:06 JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000
INFO: [ERROR] 09:40:06 JDBCExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2 idgenerati0_.ID_TYPE as ID1_10_, idgenerati0_.BATCH_SIZE as BATCH2_10_, idgene' at line 1
WARNING: StandardWrapperValve[jsp]: PWC1406: Servlet.service() for servlet jsp threw exception
java.lang.RuntimeException: Unable to retrieve id range for org.broadleafcommerce.profile.core.domain.Customer
at org.broadleafcommerce.profile.core.service.IdGenerationServiceImpl.getCurrentIdRange(IdGenerationServiceImpl.java:88)
It seams that MySQL does not know the "select top" statement. I have tried with MySQLDialect, MySQL5Dialect and MySQLInnoDBDialect but this makes no difference. I have removed any reference to hsqldb in persistence-admin.xml and applicationContext-admin.xml and removed the dependency in pom.xml.
Any help appreciated
Thank you
Theo
This forum is in readonly mode and serves as an archive of old information. All posting, registration and commenting abilities have been turned off. To get help, the Broadleaf team reguarly monitors the broadleaf-commerce tag on Stack Overflow so please ask your questions there.