Deborah,
On 2/2/07, Deborah Merico <[EMAIL PROTECTED]> wrote:
I'm trying to get sequoia (version 2.10.4) running with mysql5 but i have
this error:
----------------------------------------------
java.lang.RuntimeException: Unable to initialize the database:
java.sql.SQLException: Unable to create table RECOVERY (You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'sql VARCHAR(255) NOT
NULL,sql_param varchar(255) default NULL,auto_conn_tran cha' at line 1)
Yes, "sql" is a reserved keywords in MySQL 5. It was not in previous versions.
See:
http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
It's not a problem as you can configure the name yourself. In your
RecoveryLogTable element, add sqlColumnName="sql_query" for example
and it will name this column sql_query instead of sql.
--
Guillaume
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
