On 28/05/2013 16:27, Nik wrote:
On 05/28/2013 04:22 PM, Francesco Chicchiriccò wrote:
On 28/05/2013 16:18, Nik wrote:
Another thing I noticed:
When I configure the persistence properties to be innodb mysql.
The quartz tables do not get written in the target DB even when they
are present in the init sql
file:
[nik@anvil org.apache.syncope]$ grep -c QRTZ
./core/target/syncope/WEB-INF/classes/quartz/tables_mysql_innodb.sql
47
What is the value of the 'quartz.sql' property in your
core/src/main/resources/persistence.properties?
quartz.sql=tables_mysql_innodb.sql
Ok: could you please:
1. drop and create again (or just make empty) your current MySQL database
2. download [1], save it under core/src/main/resources/quartz/ (create
required directories if needed)
3. change "TYPE=InnoDB" to "ENGINE=InnoDB" (or any relevant change
needed to make it work)
4. rebuild and redeploy
5. see if Quartz tables are now created
Thanks.
[1]
https://svn.apache.org/repos/asf/syncope/branches/1_1_X/core/src/main/resources/quartz/tables_mysql_innodb.sql
--
Francesco Chicchiriccò
ASF Member, Apache Syncope PMC chair, Apache Cocoon PMC Member
http://people.apache.org/~ilgrosso/
