0 Replies Latest reply on Dec 15, 2005 7:00 AM by Patricio Denzer

    Problem setting CMR fields + Identity Primary Key

    Patricio Denzer Newbie

      I have many related CMP's and when I try to create a instance of SOL that have 8 relationships
      throws a Exception like this:

      Could not create entity
      com.sybase.jdbc2.jdbc.SybSQLException: can't find class java.math.BigDecimal.
      Be shure that class is installed and have a entry in Sysxtypes

      the problem is that when I see the logs of JBOSS, the SQL query that JBOSS
      generates
      includes in the INSERT a CMR field that I not put in ejbCreate args.

      INSERT INTO SOL (
       SOL_DATE_SOL,
       SOL_DATE_MOD,
       SOL_RESULT,
       ALU_RUT,
       ESTADO_SOL_CODE,
       RUT_USER,
       SOL_MOTIV,
       SUBFAMILY_SOL_CODE,
       RES_NUM_RESOLUTION ---------- > THIS IS A CMR FIELD THAT I NOT USING WHEN I CALL EJBCREATE
       ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)


      the SOL CMP have a identity primary key defined as:

      <entity>
       <ejb-name>Sol</ejb-name>
       .
       .
       .
       <unknown-pk>
       <unknown-pk-class>java.math.BigDecimal</unknown-pk-class>
       <column-name>solNumSol</column-name>
       <jdbc-type>NUMERIC</jdbc-type>
       <sql-type>NUMERIC(18,0)</sql-type>
       </unknown-pk>
       <entity-command name="sybase-fetch-key" />
       </entity>


      I'm using Sybase + JBoss 3.2.7

      Please make suggestions