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

From: Arnold Peters (apet10_at_hotmail.com)
Date: 10/20/04 

Date: Wed, 20 Oct 2004 00:05:02 +0200

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

Relevant Pages

  • Re: Business Objects
    ... indicate NULL in the 'mapped' database column, then it is imperative that, ... This way, when the database column is supposed to contain NULL, then it ... private string stringProp; ... private int intProp; ...
    (microsoft.public.dotnet.general)
  • Re: Re-linking problems if linked db no longer exists..Help!
    ... I went back into my database, located the 2 memo fields, changed the Append ... Then, I rebuilt my main program database, and searched MSysObjects again and ... However, if you remove or even rename the old database, then launch your ... search under the Database column for the db that is no longer present. ...
    (comp.databases.ms-access)
  • Reserved Words
    ... I am attempting to update/insert to a Microsoft Access Database. ... a database column that is unfortunately using a the reserved word ... is a problem with using the reserved word 'output'. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with the following code??
    ... data validation within the column. ... That is my question I basiclly want a change event code that will copy the ... state abbreviation to the database when the user selects the full state name. ... Now I have used this code within my database column but I ...
    (microsoft.public.excel.programming)
  • re: Database Column Value
    ... >I'm having trouble with a database column value. ... >added a new form component on the Submission Form in the ... >when I go to the Results Page> Database Column Value ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)