Broadleaf Commerce Discussion Forums

Hi,
I was running the demo with mysql turned on. I made all the modification as per instructions http://www.broadleafcommerce.com/docs/core/current/tutorials/getting-started-tutorials/switch-to-mysql-tutorial. I have granted the right permission to the mysql-user 'bibhash' (I am using mysql 5.6, the latest one)and did maven-install on all the projects - still I am getting the following error message on starting the Jetty server:

Caused by: org.hsqldb.HsqlException: invalid authorization specification - not found: bibhash

Details"
---------------------------------------------------------------------------------------------------------------------------------------------
[artifact:mvn] Caused by: java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specification - not found: bibhash
[artifact:mvn] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
[artifact:mvn] at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
[artifact:mvn] at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
[artifact:mvn] at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
[artifact:mvn] at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
[artifact:mvn] ... 47 more
[artifact:mvn] Caused by: org.hsqldb.HsqlException: invalid authorization specification - not found: bibhash
[artifact:mvn] at org.hsqldb.error.Error.error(Unknown Source)
[artifact:mvn] at org.hsqldb.ClientConnection.<init>(Unknown Source)
------------------------------------------------------------------------------------------------------------------------------------

Please help!

NOTE: I want to attach the full stack-trace, but I was not allowed by the page to do so since it was not accepting the extension ".txt" or other extensions ....sorry I am new to this forum and is getting used to the rules.

Regards,
Bibhash Roy

I think that you have missed a step in the switch to mysql tutorial. What usually happens is that you did not do a re-compile of the core module along with the site and admin before you deployed. Because you are still seeing "org.hsqldb.HsqlException" this means that something is still trying to use the HSQL database and not MySQL. This could also be the JNDI data source.

Yes, I missed some edit on certain files....now it works!

Bibhash Roy