0 Replies Latest reply on Apr 18, 2007 9:57 AM by Harri Eleftheriadis

    Type Mapping Oracle 9i

    Harri Eleftheriadis Newbie

      Hello,

      i am using Jboss 4.0.4 with EJB2.1 and a Oracle Database.
      In my database there are tables containing CLOB fields.
      The EJB accessing these tables use a "special" jbosscmp-jdbc.xml in which i explicitely define the CLOB type for the relevant fields.

      <cmp-field>
       <field-name>lsData</field-name>
       <column-name>LSDATA</column-name>
       <jdbc-type>CLOB</jdbc-type>
       <sql-type>CLOB</sql-type>
      </cmp-field>


      That works fine but makes me have to use different jbosscmp-jdbc.xml files for different databases (e.g SQLServer).
      Maybe i misunderstood something but i think normaly such type-mapping has do be done in standardjbosscmp-jdbc.xml in the conf directory of my used server implementation.
      But when i define the CLOB mapping in that file it does not work.

      <mapping>
       <java-type>java.lang.String</java-type>
       <jdbc-type>CLOB</jdbc-type>
       <sql-type>CLOB</sql-type>
      </mapping>


      JBoss does not throw neither an exception nor error or warning.
      The accessing method in the bean just returns null such as if the db field contains null. I draw the conclusion, that JBoss just has problems reading the db data of the CLOB field.

      Can someone explain why my the "global" mapping does not work?
      Maybe i just forgot something else?

      Thanks for your help


      Harri E.