Monday, October 5, 2015

Install SoapUI using .sh file in Ubuntu.

* Download SoapUI<version>.sh file (linux installer) and try out following commands in the Terminal.

$ sudo chmod +x SoapUI<version>.sh
$ ./SoapUI<version>.sh

* Note : Replace the name of the file according the downloaded version of the SOAP UI.

* It will run as following screen shot and prompt you to the installation window.

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