• Post Reply Bookmark Topic Watch Topic
  • New Topic

Data type mismatch  RSS feed

 
Fred Victa
Ranch Hand
Posts: 202
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have the variable, MAX_ACV, which is of type double. In my program, it is equal to 1000000.00

I also have another variable, ACV, which is of type double.

In my program if the ACV is greater than the MAX_ACV, then there will be an error message that says that the ACV is too large.

My program reads an XML file and puts the data into a database. If the ACV in the XML file is a large number such as 999999.00, then I get an error message that says, "java.sql.SQLException: Data type mismatch. (javaValue (999999.00): Length is not valid)

Could anyone explain what that error means and how I can correct my program?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 36857
481
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Fred,
What is the data type you are using in the database?
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!