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.

Related Posts

• Spring: ClassPathXmlApplicationContext File Lookup / Database Exceptions
• Oracle XA_RMERR & Spring Oracle LOB Handler Exceptions
• Still Springing Along
• WebSphere Application Server and The Spring Framework

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.