SQLException of "Invalid scale size. Cannot be less than zero" after upgrade from WLS 8.1

(Doc ID 1088343.1)

Last updated on JUNE 09, 2016

Applies to:

Oracle Weblogic Server - Version 9.2 and later
Information in this document applies to any platform.
***Checked for relevance on 24-May-2013***

Symptoms

After upgrading the application from WLS 8.1.5 to WLS 9.2, server throws the following exception in server log:

####<Nov 21, 2009 11:29:29 AM CET> <Error> ... ... ... <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <BEA1-1968CF3523BB9835697E> <> <1258799369717> <000000> <MyBean.executeQuery.SQLException: select MY_SEQ.NEXTVAL from dual - com.mycomp.MyService_Impl:Invalid scale size. Cannot be less than zero>


The application used to work fine in WLS 8.1 environment.  The database (Oracle 9.2.0.4) remains unchanged in the application upgrade.

Tested using all the Oracle JDBC drivers that comes with WLS 8.1 and 9.2 with the upgraded application in WLS 9.2 environment, but the error remains.

Changes

Application upgrade from WLS 8.1.5 to WLS 9.2.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms