Thank you very much Emmanuel! I did look at the dtd to solve other issues i had, but evidently didn't look at the whole thing...

Thanks!

Emmanuel Cecchet wrote:
Alexander,
Not sure if this is a bug or it can be worked around... But in the RecoveryLogTable, in the DumpTable node, Sequoia uses a field named tables, and the logs, when starting the controller, complain about not being able to create the dumps table, asking to check the syntax around 'tables' word... MySql wants that name like this: `tables` as the word is a reserved keyword... At least with the version of MySql I'm using (4.1)...

Just thought i passed this on... I manually created the table and I'm able to work, but if there is a work around, I'd like to know it...
At the end of xml/sequoia.dtd you will find:
<!ATTLIST DumpTable
...
   tablesColumnName         CDATA "tables"
   tablesColumnType         CDATA "VARCHAR NOT NULL"
   extraStatementDefinition CDATA ""
>

You can change the value of tablesColumnName to use another name than 'tables' if this is a reserved keyword for your database.

Hope this helps,
Emmanuel



_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to