Sunday, October 4, 2015

'OPTION SQL_SELECT_LIMIT=DEFAULT' MySQL Error

I got this 'OPTION SQL_SELECT_LIMIT=DEFAULT' error when I try to mount the WSO2 ESB registry partitions into MySQL.

In here I used the mysql-connector-java-5.0.8-bin.jar version as a jdbc connector for MySQL. It seems like a bug in MySQL.
As it said in this stackoverflow link [1] mysql-connector-java 5.1.22 and newer versions are fine. So I download mysql-connector-java-5.1.34-bin.jar version and used.

Note: Before restarting the ESB server, have to clear 'dropins' folder in <ESB_HOME>/repository/components/dropins

Cool... Then it's working fine.

Reference links :
[1] http://stackoverflow.com/questions/15669270/option-sql-select-limit-default

No comments:

Post a Comment