cmp on intersystems cache

[jeshell]

Has anyone here successfully gotten jboss to do cmp ejb's with intersystems cache? If so, do you know where there's a standardjbosscmp-jdbc.xml with the correct configuration?

Thanks to anyone that can help!

--Jeff

[jeshell]

OK. I didn't know that cache would do this for me. I knew it did BMP, but not CMP. When I hit build, it made me a jbosscmp-jdbc.xml.

Here it is for anyone interested.

<type-mapping>
InterSystemsCache
<row-locking-template></row-locking-template>
<pk-constraint-template></pk-constraint-template>
<fk-constraint-template></fk-constraint-template>
<alias-header-prefix>CachePrefix</alias-header-prefix>
<alias-header-suffix>CacheSuffix</alias-header-suffix>
<alias-max-length>255</alias-max-length>
<subquery-supported>false</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>

<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>BIT</sql-type>


<java-type>java.lang.Byte</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>VARBINARY</sql-type>


<java-type>java.lang.Short</java-type>
<jdbc-type>SMALLINT</jdbc-type>
<sql-type>SMALLINT</sql-type>


<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>


<java-type>java.lang.Long</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>


<java-type>java.lang.Float</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>


<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>


<java-type>java.lang.Character</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR</sql-type>


<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR</sql-type>


<java-type>java.math.BigDecimal</java-type>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC</sql-type>


<java-type>java.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>


<java-type>java.sql.Time</java-type>
<jdbc-type>TIME</jdbc-type>
<sql-type>TIME</sql-type>


<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>


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

</type-mapping>


Thanks.
--Jeff