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