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?