 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / October 2004Inserting 444.44 into a DECimal(11,2) defined database field does not work
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 > When I try to insert a record into a database I got a SQLException > [quoted text clipped - 5 lines] > > Arni The database is using DECIMAL. Change the database column definition to be double(11,2). More information required. What is the full SQL command sequence, and what DBMS are you using? It's probably not the constant value that's at fault here, but your SQL syntax. Luke > When I try to insert a record into a database I got a SQLException > [quoted text clipped - 5 lines] > > Arni > When I try to insert a record into a database I got a SQLException > [quoted text clipped - 4 lines] > > Why does the database not accept this value ? Because of a problem in the code you forgot to post?  SignaturePaul Lutus http://www.arachnoid.com > java.sql.SQLException: Unexpected token: 444.0 in statement [ [...] > Why does the database not accept this value ? It does not get that far: The error message comes from the SQL parser. Why didn't you post the SQL statement you tried to execute? which rdbms ? what is exactely the code ? Le 20/10/2004 00:05, Arnold Peters a écrit : > When I try to insert a record into a database I got a SQLException > [quoted text clipped - 5 lines] > > Arni Signaturestephane retirez les lettres majuscules et le 666 de l'adresse pour l'utiliser. > When I try to insert a record into a database I got a SQLException > [quoted text clipped - 5 lines] > > Arni What is your regional setup? Should it be 444,0 instead of 444.0... Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.