3 Replies Latest reply on Mar 3, 2005 8:34 PM by Ricardo Arguello

    chapter 8 problem of 'Getting Started with JBoss 4.0'

    james www Newbie

      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)