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.

had the same issue, as far as i remember putting these 3 lines also in my xy-shared.properties solved it. i think the settings in common-shared.properties are not being picked up or are overwritten somewhere.

This is how I was able to get DemoSite 3.0.8-GA going on MySql using a Linux Mint Ubuntu system.

As was already mentioned in this forum above, replace all org.hibernate.dialect.HSQLDialect with org.hibernate.dialect.MySQL5InnoDBDialect in /DemoSite/core/src/main/resources/runtime-properties/common-shared.properties (and everywhere else you may find it).

#This won’t be required after we go to 3.1JAVA_OPTS="${JAVA_OPTS} -javaagent:/<PATHTO>/spring-instrument-3.2.2.RELEASE.jar"

#This is for jconsole, if we enable jmxremote in production we’ll have to lock down security more than this:CATALINA_OPTS="${CATALINA_OPTS} -Dcom.sun.management.jmxremote"CATALINA_OPTS="${CATALINA_OPTS} -Dcom.sun.management.jmxremote.port=9902"CATALINA_OPTS="${CATALINA_OPTS} -Dcom.sun.management.jmxremote.ssl=false"CATALINA_OPTS="${CATALINA_OPTS} -Dcom.sun.management.jmxremote.authenticate=false"

Thanks for your help panopset. I ditch running jetty-demo all together because it just failed during database tables creation. I used Tomcat 7 now.

Also in addition to your info I also has to do these additional things:1. Copy tomcat-jdbc-7.0.30.jar to tomcat/lib dir. Without doing this it will complain ClassNotFoundException for "org.apache.tomcat.jdbc.pool.DataSourceFactory".2. Also I have to remove site/src/main/webapp/META-INF/context.xml & in admin/src/main/webapp/context.xml

Once you make this change you will need to restart MySQL and likely recreate the schema so that it has these defaults.

I also updated the documentation that you referenced to recommend these MySQL settings.

The Broadleaf forums are being retired as a readonly archive of questions. For active discussions and questions, check out the broadleaf-commerce tag on Stack Overflow which is actively monitored by the Broadleaf team.