Spring + Oracle Database = Populating CachedRowSet produces SQLException: Invalid scale size

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…

A thread from the sun forums addresses the potential workarounds that can be used.

Author: dan

Leave a Reply

Your email address will not be published. Required fields are marked *