ah ok. I was under the impression UM script got some changes. If what you meant is, to use a given MySQL version compatible version of ConnectorJ is needed with UM SQL script unchanged, then I guess no backward compatibility is broken.
On Sun, Aug 18, 2013 at 1:36 AM, Darshana Gunawardana <[email protected]>wrote: > 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 > -- /sumedha b : bit.ly/sumedha
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
