This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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?