1 Reply Latest reply on Feb 2, 2004 3:54 PM by Jeff Shelley

    cmp on intersystems cache

    Jeff Shelley Newbie

      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

        • 1. Re: cmp on intersystems cache
          Jeff Shelley Newbie

          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