0 Replies Latest reply on Mar 12, 2003 11:17 AM by mekatoka

    MySQL 3.23.55, JBoss 3.0.6, BLOB

    mekatoka Newbie

      Hi,

      I am using MySQL 3.23.55, JBOSS 3.0.6, EJB 2.0, CMP 2.0
      I have configured the database, the tables are created but it stops at one place.In the type mappings-mappings , i have the following in the standardjbosscmp-jdbc.xml

      java-type jdbc-type sql-type

      java.lang.Object Blob LongBlob


      I get the following error while creating one of the fields at the time of deployment.

      org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: General error, message from server: "BLOB column 'start_ip' used in key specification without a key length")

      I have searched on the net and came up with the following,

      it seems that we need to specify the column legnth in the create table statement. I would have to use the following

      CREATE INDEX part_of_name ON customer (name(10))

      if i was directly working on the database @ command line.


      But i am using CMP, so how do i fix this ?

      Any help is appreciated

      Regards

      Meka Toka