Guillaume, thank you very much! bye Deborah
Sequoia general mailing list <[email protected]> writes: >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
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
