java.sql.SQLException: The resulting value is outside the range for the data type DECIMAL/NUMERIC(31,31).

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via db-derby-user by Marco Rico-Gomez, 1 year ago
The resulting value is outside the range for the data type DECIMAL/NUMERIC(31,31).
via Mirth Project by joe tilley, 1 year ago
A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, SYSCONGLOMERATES, (5,15) Waiting XID : {153691294, S} , APP, INSERT INTO MESSAGE (ID, SERVER_ID, CHANNEL_ID, SOURCE, TYPE, DATE_CREATED, VERSION
via Stack Overflow by Jahid
, 2 years ago
DELETE on table 'APPLICATIONENTITY' caused a violation of foreign key constraint 'FK109DF15D362F642' for key (32779). The statement has been rolled back.
via Mirth Project by Eric Butterfield, 1 year ago
INSERT on table 'D_MC2' caused a violation of foreign key constraint 'MC2_FKEY' for key (2,1). The statement has been rolled back.
via jackrabbit-users by anand, 1 year ago
Failed to start database '/home/sda_tr1/Desktop/simer/apache-tomcat-6.0.20/bin/jackrabbit/version/db', see the next exception for details.
via Stack Overflow by Unknown author, 2 years ago
Database at /home/username/dev/db-agents/TESTDB has an incompatible format with the current version of the software. The database was created by or upgraded by version 10.11.
java.sql.SQLException: The resulting value is outside the range for the data type DECIMAL/NUMERIC(31,31).
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(UnknownSource)

Users with the same issue

81 times, 1 year ago
Once, 5 months ago
Once, 7 months ago
Once, 8 months ago
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.