Inserting 444.44 into a DECimal(11,2) defined database field does not work

Arnold Peters · Oct 19, 2004

When I try to insert a record into a database I got a SQLException

java.sql.SQLException: Unexpected token: 444.0 in statement [

The database column is defined DECimal(11,2) and the value is of type double and value 444.44

Why does the database not accept this value ?

Arni

Paul Lutus · Oct 20, 2004

Arnold said:
When I try to insert a record into a database I got a SQLException

java.sql.SQLException: Unexpected token: 444.0 in statement [

The database column is defined DECimal(11,2) and the value is of type
double and value 444.44

Why does the database not accept this value ?

Because of a problem in the code you forgot to post?

Inserting into a database	1	Sep 13, 2006
Connected SQLite to my java program but information are not submitted	2	Aug 2, 2022
My http request is working but not doing it correctly	0	Oct 13, 2023
Issue with passing fetched data to POST form. How can I?	0	Jul 23, 2023
Data Not Inserting into Database	0	Oct 20, 2009
If a validation script fails, how do I place focus back into the field until entered correctly	2	May 14, 2017
Inserting record into postgresql database	0	Mar 11, 2011
insert decimal value into MS SQL database	1	Jan 30, 2005

Inserting 444.44 into a DECimal(11,2) defined database field does not work

Arnold Peters

Paul Lutus

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads