2 Replies Latest reply on Oct 30, 2003 7:01 PM by charlton_b

    Sun's Smart Ticket Blueprint and JBoss

    qmqasim

      I am trying to deploy Sun's blueprint (Smart Ticket) onto Jboss.

      When I deploy smallticket onto Jboss, I get the errors regarding the primary key being too long:

      "
      ERROR [org.jboss.ejb.EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException:

      Error while creating table; - nested throwable: (java.sql.SQLException: Invalid argument value: Specified key was too long. Max key length is 500

      "

      The error is thrown for 2 EJBs whose primary key is aserialised object.

      any idea how I can get rid of this error without having to change the code.

      Also, how can I control the length of a primary key in CMP.

        • 1. Re: Sun's Smart Ticket Blueprint and JBoss
          qmqasim

          to solve the above problem I had to add <jdbc-type> and <sql-type> in the jbosscmp-jdbc.xml:



          <ejb-name>MovieShowBean</ejb-name>
          <table-name>MovieShow</table-name>

          <cmp-field>
          <field-name>movieId</field-name>
          <column-name>movieId</column-name>
          <jdbc-type>VARCHAR</jdbc-type>
          <sql-type>VARCHAR(100)</sql-type>
          </cmp-field>


          • 2. Re: Sun's Smart Ticket Blueprint and JBoss
            charlton_b

            i wanted to ask a couple of follow-up questions w.r.t. this:
            - were you working with Sun's Smart Ticket 2.0? Or 1.2?
            - do you have the Smart Ticket ear configured for JBoss (with all the necessary deployment descriptors for JBoss)? If so, is it possible to post it?

            thanks