I have a simple table definition:
CREATE TABLE TABLE1 ( COL1 CHAR(3) NOT NULL, COL2 VARCHAR2(28) NOT NULL, COL3 NUMBER))
I noticed that I get this error when I have a column of type ‘number’ created with default type. When I removed this column from the table, everything worked fine.
I have a number of columns which have a type of NUMBER. When the table was created they were not set a precision or scale value, so by default they are considered floating point numbers. When they are retrieved into my ResultSet, they are coming back with a scale of -127. As this is a negative, this affects the population of the CachedRowSet…