4 Replies Latest reply: Jan 24, 2013 11:00 PM by 913349 RSS

    java.sql.SQLException: Invalid column type in adf

    913349
      Dear all,
      i am using 11.1.2.1.0 V
      my question is i have column having data type number(10,3) in database. but in it showing in EO and VO column type is big Decimal.
      while i am inserting a new record it showing in valid column type.
      below i am putting console also.

      +<ADFLogger> <begin> Commit transaction+
      +<OracleSQLBuilderImpl> <setSavepoint> [1959] OracleSQLBuilder: SAVEPOINT 'BO_SP'+
      +<ADFLogger> <begin> Posting the entity's changes+
      +<ADFLogger> <begin> Before posting the entity's changes+
      +<ADFLogger> <begin> Updating audit columns+
      +<ADFLogger> <end> Updating audit columns+
      +<ADFLogger> <end> Before posting the entity's changes+
      +<OracleSQLBuilderImpl> <doEntityDML> [1960] OracleSQLBuilder Executing, Lock 2 DML on: MOFWDB.AC_GSD_TT (Insert)+
      +<OracleSQLBuilderImpl> <buildInsertStatement> [1961] INSERT buf GsdEO>#i SQLStmtBufLen: 435, actual=162+
      +<OracleSQLBuilderImpl> <doEntityDML> [1962] BEGIN INSERT INTO MOFWDB.AC_GSD_TT(ID_AC,SAMPLE_NUMBER,TOTAL_LENGTH_TL_CM,ACT_NUM_OF_STOCK_IND,BODY_WEIGHT_BW_G,SEX) VALUES (:1,:2,:3,:4,:5,:6) RETURNING ROWID INTO :7; END;+
      +<ADFLogger> <begin> Entity DML+
      +<OracleSQLBuilderImpl> <bindInsertStatement> [1963] Insert binding param 1: 195+
      +<OracleSQLBuilderImpl> <bindInsertStatement> [1964] Insert binding param 2: 34+
      +<OracleSQLBuilderImpl> <bindInsertStatement> [1965] Insert binding param 3: 11.01+
      +<OracleSQLBuilderImpl> <bindInsertStatement> [1966] Insert binding param 4: 98+
      +<OracleSQLBuilderImpl> <doEntityDML> [1967] OracleSQLBuilderImpl.doEntityDML failed...+
      +<OracleSQLBuilderImpl> <doEntityDML> [1968] X/Open SQL State is: 99999+
      +<OracleSQLBuilderImpl> <doEntityDML> [1969] java.sql.SQLException: Invalid column type+

      Thanks
      Damby

      Edited by: 910346 on Jan 24, 2013 5:25 AM