• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

error

 
rakhi sinha
Ranch Hand
Posts: 147
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how to remove this error
SQLException caught: Incorrect decimal value: '' for column 'QUANTITY' at row 1
 
Swastik Dey
Rancher
Posts: 1603
5
Android Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to give some more detail about your code.
 
Wendy Gibbons
Bartender
Posts: 1110
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 859
Chrome IBM DB2 Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

WP
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic