Hi there,

Anyone has successfully deployed roster application following the instructions in chapter 8 using MySql? I tried to get seeming correct records in the table but with an exception (appends at end). Who know how to solve it or met the same/similar problem please?

Thanks.

The stack trace:

12:17:02,375 INFO [STDOUT] Debug: RosterBean getPlayersByPosition
12:17:02,390 INFO [STDOUT] Debug: PlayerBean ejbLoad
12:17:02,406 INFO [STDOUT] Debug: PlayerBean ejbLoad
12:17:02,406 INFO [STDOUT] Debug: PlayerBean ejbLoad
12:17:02,406 INFO [STDOUT] Debug: PlayerBean ejbLoad
12:17:02,421 INFO [STDOUT] Debug: PlayerBean ejbLoad
12:17:02,421 INFO [STDOUT] Debug: PlayerBean ejbStore
12:17:02,421 INFO [STDOUT] Debug: PlayerBean ejbStore
12:17:02,421 INFO [STDOUT] Debug: PlayerBean ejbStore
12:17:02,421 INFO [STDOUT] Debug: PlayerBean ejbStore
12:17:02,421 INFO [STDOUT] Debug: PlayerBean ejbStore
12:17:02,453 INFO [STDOUT] Debug: RosterBean getLeaguesOfPlayer
12:17:02,453 INFO [STDOUT] Debug: PlayerBean ejbLoad
12:17:02,453 INFO [STDOUT] Debug: PlayerBean ejbStore
12:17:02,468 ERROR [PlayerBean#ejbSelectLeagues] Find failed
java.sql.SQLException: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:206)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:128)
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.execute(JDBCSelectorBridge.java:99)
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.invoke(JDBCSelectorBridge.java:70)
at org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationHandler.invoke(EntityBridgeInvocationHandler.java:91)
at org.jboss.proxy.compiler.Runtime.invoke(Runtime.java:62)
at team.PlayerBean$Proxy.ejbSelectLeagues()
at team.PlayerBean.getLeagues(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke(EntityContainer.java:1174)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.invoke(JDBCRelationInterceptor.java:72)
at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:273)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)