How does this effect the backward compatibility of working with older MySQL versions?
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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
