Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Data type mismatch

 
Fred Victa
Ranch Hand
Posts: 189
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: 34973
379
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