Hi all, According to [1] and [2] 'SET OPTION' syntax has been removed when moving into mysql 5.6 from 5.5 since it has long been deprecated. Maybe that is the cause.
Thanks, Akalanka. [1] - http://dev.mysql.com/doc/refman/5.5/en/set-statement.html [2] - http://dev.mysql.com/doc/refman/5.6/en/set-statement.html On Thu, Apr 2, 2015 at 2:32 AM, Darshana Gunawardana <darsh...@wso2.com> wrote: > [adding dev list] > > Hi Olivier, > > Are you trying to migrate the system from H2 to mysql? And can you please > mention the version of the product you are trying. > > Regards, > Darshana. > > On Wed, Apr 1, 2015 at 5:33 AM, Tokpanou Olivier <tokli...@gmail.com> > wrote: > >> Hello sir >> I am a beginner on your product wso2emm. I want to migrate h2 mysql, I >> followed the product documentation. I can not seem to successful >> migration. I oudrais you aidier me to solve the problem. Attached is the log >> file. >> TID: [0] [EMM] [2015-04-01 11:18:42,473] ERROR >> {org.wso2.carbon.user.core.tenant.TenantManager} - Error in getting the >> tenants. {org.wso2.carbon.user.core.tenant.TenantManager} >> TID: [0] [EMM] [2015-04-01 11:18:47,480] ERROR >> {org.wso2.carbon.registry.core.jdbc.dao.JDBCLogsDAO} - Failed to get logs. >> 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 'OPTION >> SQL_SELECT_LIMIT=DEFAULT' at line 1 >> {org.wso2.carbon.registry.core.jdbc.dao.JDBCLogsDAO} >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'OPTION >> SQL_SELECT_LIMIT=DEFAULT' at line 1 >> >> -- >> TOKPANOU Olivier >> Ingénieur d'études et développement informatique >> Casablanca,Maroc >> Tél : +212 6 06 60 85 15 >> > > > > -- > Regards, > > > *Darshana Gunawardana*Software Engineer > WSO2 Inc.; http://wso2.com > > *E-mail: darsh...@wso2.com <darsh...@wso2.com>* > *Mobile: +94718566859 <%2B94718566859>*Lean . Enterprise . Middleware > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Darshana Akalanka Pagoda Arachchi,* *Software Engineer* *078-4721791*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev