File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "error" Watch "error" New topic


rakhi sinha
Ranch Hand

Joined: Mar 26, 2012
Posts: 147
how to remove this error
SQLException caught: Incorrect decimal value: '' for column 'QUANTITY' at row 1
Swastik Dey

Joined: Jan 08, 2009
Posts: 1508

You need to give some more detail about your code.

Wendy Gibbons

Joined: Oct 21, 2008
Posts: 1107

well what is the value you are trying to insert into the quantity column? is it a valid number?

check the parameters you are getting. Put some system outs and use a debuggable prepared statement so you can actually see what you are trying to insert.

William P O'Sullivan
Ranch Hand

Joined: Mar 28, 2012
Posts: 859

You need to ensure that the Java attribute type matches the expected column definition.

In this case it seems that QUANTITY is expecting a decimal (numeric) value.
Maybe you are trying to insert a String?

Again, more information would help.

I agree. Here's the link:
subject: error
jQuery in Action, 3rd edition