MySql CMP Create Table SQLException

[sradford]

Hi,

Using Jboss3.1alpha I get an SQLException when the CMP system tries to create one of my bean tables.

From the log the create statement is: CREATE TABLE G1_EHR (ID BIGINT NOT NULL, ehr_source VARCHAR(50), dt_creation OBJECT, hcp_created_by VARCHAR(50), subjectTransaction BIGINT, CONSTRAINT pk_G1_EHR PRIMARY KEY (ID))

The dt_creation column appears to be the problem as MySql doesn't have an OBJECT type, does it?

The dt_creation column is a class (not declared as a DVC yet) and so should be of BLOB type (this is what is specified in standardjbosscmp-jdbc.xml)?

I will be declaring the DVC, so should get rid of the problem, but wanted to find out if this is a bug or not.

Regards,

Sean

[dsundstrom]

Did you set the datasource mapping in your jbosscmp-jdbc.xml file of the standardjbosscmp-jdbc.xml file?

[sradford]

Yes. My jbosscmp-jdbc.xml file states a type mapping of <type-mapping>mySQL</type-mapping> and I have left the standardjbosscmp-jdbc.xml file unchanged (for mySQL it contains the following:


<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB</sql-type>


).

Thanks in advance.

[dsundstrom]

Good, but it is nolonger called type-mapping it is called datasource-mapping. Add the doctype to your jbosscmp-jdbc.xml file so you can see the validation errors.

[stitzl]

Ahh, this explains many other things as well :)

Relieved,
Lars :D