Hi Sumedha, On Sun, Aug 18, 2013 at 12:03 AM, Sumedha Rubasinghe <[email protected]>wrote:
> How does this effect the backward compatibility of working with older > MySQL versions? > I'm not sure what you meant by 'this'. The error is happens not because of a SQL script change. From MySQL Server 5.6 it has stopped supporting some deprecated options, which are used by older MySQL connectors. If the MySQL server is an older version, it won't make this issue. Thanks, > > > On Sat, Aug 17, 2013 at 10:59 PM, Darshana Gunawardana > <[email protected]>wrote: > >> Hi, >> >> Although it sounds obvious, if you got [1] when server start-up please >> verify you are using latest/compatible MySQL connector with the MySQL >> server. >> >> Same reported in https://wso2.org/jira/browse/IDENTITY-1641 also. >> >> [1] >> TID: [0] [AS] [2013-08-16 14:33:07,715] ERROR >> {org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager} - Error while >> retrieving roles from Internal JDBC role store >> {org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager} >> 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=100' at line 1 >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >> at java.lang.reflect.Constructor.newInstance(Constructor.java:525) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) >> at com.mysql.jdbc.Util.getInstance(Util.java:384) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) >> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562) >> at >> com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1561) >> at >> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2262) >> at >> org.wso2.carbon.user.core.hybrid.HybridRoleManager.getHybridRoles(HybridRoleManager.java:233) >> at >> org.wso2.carbon.user.core.common.AbstractUserStoreManager.getRoleNames(AbstractUserStoreManager.java:2363) >> at >> org.wso2.carbon.user.core.common.AbstractUserStoreManager.getRoleNames(AbstractUserStoreManager.java:2296) >> at >> org.wso2.carbon.user.core.common.AbstractUserStoreManager.getRoleNames(AbstractUserStoreManager.java:2289) >> at >> org.wso2.carbon.event.core.internal.subscription.registry.RegistrySubscriptionManager.<init>(RegistrySubscriptionManager.java:91) >> >> -- >> Regards, >> >> * >> Darshana Gunawardana >> *Software Engineer >> WSO2 Inc.; http://wso2.com* >> E-mail: [email protected] >> **Mobile: +94718566859 >> *Lean . Enterprise . Middleware >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > /sumedha > b : bit.ly/sumedha > -- Regards, * Darshana Gunawardana *Software Engineer WSO2 Inc.; http://wso2.com* E-mail: [email protected] **Mobile: +94718566859 *Lean . Enterprise . Middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
