After studying:
jbosscmp-jdbc_3_0.dtd
And contemplating:
2003-03-03 15:26:19,276 WARN [org.jboss.system.ServiceController] Problem
starting service jboss.j2ee:jndiName=ejb/advert/MediumDocument,service=EJB
org.jboss.deployment.DeploymentException: expected one true-mapping tag
at org.jboss.metadata.MetaData.getUniqueChild(MetaData.java:101)
at
org.jboss.metadata.MetaData.getUniqueChildContent(MetaData.java:208)
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCTypeMappingMetaData.(JDBCTypeMappingMetaData.java:136)
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:202)
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:67)
And modifying:
standardjbosscmp-jdbc.xml
jbosscmp-jdbc.xml
To look something like:
<type-mapping>
mySQL
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR
UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY
(?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN
KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<true-mapping>TRUE</true-mapping>
<false-mapping>FALSE</false-mapping>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>false</subquery-supported>
<function-mapping>
I am still failing. Does anyone have an exmple the can post? many thanks
It seems that you don't want to copy the MySql control files from 3.0, you want to edit the new version that has true mapping already in it.