topic SQL grammar/WAR deployment error on Win/MySQL bundle install in Alfresco Archive

SQL grammar/WAR deployment error on Win/MySQL bundle install

dumpsterkitty — Thu, 01 Feb 2007 20:58:53 GMT

Trying to get Alfresco set up for evaluation purposes; have spent my whole day on this and I give. Hope someone can give some pointers. WinXP dev machine, which previously had older versions of Tomcat, JDK, MySQL, etc. etc. None of those were much needed so I deleted/disabled them (er: I think, I ho

Re: SQL grammar/WAR deployment error on Win/MySQL bundle install

kevinr — Fri, 02 Feb 2007 09:17:52 GMT

Stop the server, delete the alfresco schema, recreate the alfresco schema and delete the alf_data directory. Then start the server again - does this help?

Thanks,

Kevin

Re: SQL grammar/WAR deployment error on Win/MySQL bundle install

dumpsterkitty — Fri, 02 Feb 2007 16:23:44 GMT

Thank you, but I'm afraid it ends up the same when I try it.

Re: SQL grammar/WAR deployment error on Win/MySQL bundle install

rdanner — Sun, 04 Feb 2007 06:39:40 GMT

Thank you, but I'm afraid it ends up the same when I try it.

Can you check this file for me?

{YOUR TOMCAT}\shared\classes\alfresco\extension\custom-hibernate-dialect.properties

Make sure the following line is commented out
#
# HSQL dialect
#
#hibernate.dialect=org.hibernate.dialect.HSQLDialect

And the following comment line is removed
#
# MySQL dialect (default)
#
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect