Hey Roy, I didn't add the changes that you made, but it seems to run just fine with hsqldb. I did restart after making the changes to the DS, and I did restart mysql with the new my.cnf (although it should be noted that the my.cnf doesn't specify the sql_mode at all, as it's a fresh one pulled out of /usr/share/mysql/, so that could be the problem with using MySQL 5). As you can see below, MySQL is running in its default (relaxed) state: mysql> select @@SQL_MODE; +------------+ | @@SQL_MODE | +------------+ | | +------------+ 1 row in set (0.00 sec) mysql> select @(a)global.SQL_MODE; +-------------------+ | @(a)global.SQL_MODE | +-------------------+ | | +-------------------+ 1 row in set (0.00 sec) mysql> select @(a)session.SQL_MODE; +--------------------+ | @(a)session.SQL_MODE | +--------------------+ | | +--------------------+ 1 row in set (0.00 sec) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963357#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...