This discussion is archived
4 Replies Latest reply: Jan 24, 2013 9:00 PM by 913349 RSS

java.sql.SQLException: Invalid column type in adf

913349 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points