3 Replies Latest reply on Feb 25, 2004 1:32 PM by luke_t

    mysql example for RosterCMP up creek

    ahardy66

      I'm following the example diligently in 8.2.1 in the Getting-Started but I'm not getting very far.

      After swapping over the hsqldb-ds.xml for my own mysql-ds.xml whose contents I copied from the example, and after setting up mysql to accept the jboss user in the new jboss database, I get this as JBoss tries to create the tables for RosterCMP:

      Error while creating table TeamEJB; - nested throwable:
      (java.sql.SQLException: Syntax error or access violation, message from server:
      "BLOB/TEXT column 'teamId' used in key specification without a key length")]

      which someone also mentions here http://www.jboss.org/index.html?module=bb&op=viewtopic&t=13319

      I tried changing from hsqldb-jdbc2-service.xml to mysql-jdbc2-service.xml, but this didn't get me anywhere.

      Is there anything I can do? How come it worked for the author of the Getting Started?

      Thanks
      Adam

        • 1. Re: mysql example for RosterCMP up creek

           

          "ahardy66" wrote:
          I'm following the example diligently in 8.2.1 in the Getting-Started but I'm not getting very far.

          ....

          Is there anything I can do? How come it worked for the author of the Getting Started?

          Thanks
          Adam


          Dunno, it was a while ago, but it did. I pasted the output from the screen as I did it. Maybe you "skimmed" an important chapter and missed something :).

          Are you using the same versions of MySQL and the JDBC driver (you don't say)?

          Luke.


          • 2. Re: mysql example for RosterCMP up creek
            ahardy66

             

            "luke_t" wrote:
            Maybe you "skimmed" an important chapter and missed something :)

            Another chicken comes home to roost! But I read them all now :)

            I fixed it by changing all the primary keys in the EJBs to Long.


            Are you using the same versions of MySQL and the JDBC driver (you don't say)?

            Probably not. mysql 4.1.1 & jdbc 3.0.9. (and 4.1.1 is still in alpha - (ducking for cover))

            Luke.

            Are you Scottish, suffer from vertigo, & were in Cambodia 3 years ago? 'coz then I could say, Small World!

            rgds
            Adam


            • 3. Re: mysql example for RosterCMP up creek

              Ummm. Scottish yes, but no for the other two. Must be another version about somewhere...

              Luke.