0 Replies Latest reply on Jul 13, 2004 5:21 AM by mj123

    Oracle NUMBER with 20 bytes

    mj123

      Hello,

      I have to change my application to handle user ids which have 20 bytes.
      I know that in ORACLE I'm able to set NUMBER (20), but the question
      is how to set deployment descriptors and attribute type in Entity CMP.
      I know that in JAVA there is a BigInteger type, which probablly can be used (maybe?). What about mappings in jboss-jdbc.xml i.e. jdbc-type
      <cmp-field>
      <field-name>id</field-name>
      <column-name>user_id</column-name>
      <jdbc-type>????????</jdbc-type>
      <sql-type>NUMBER (20)</sql-type>
      </cmp-field>

      thanks for help