SQL syntax error at startup of site-admin-0.0.1-SNAPSHOT
Posted: Mon Nov 14, 2011 4:40 am
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
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