<true-mapping>slow death</true-mapping>

[jredden]

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

[jredden]

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.