Hi Sumedha, On Sun, Aug 18, 2013 at 9:35 AM, Sumedha Rubasinghe <[email protected]>wrote:
> 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. > > Yes, you are correct. > > 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 > -- 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
