Increase the range of Double

[Steve Howerton]

Hello all.
In my Apache derby db I set up Decimal data types like this:

admin_pay_rate DECIMAL(5,2),

I use JFormattedTextFields to filter decimal usage in text fields concerning money
Like admin pay rate would be 150.00: this is good.

In the JFormattedTextField it will allow 1,000.00 but the db crashes when this
Decimal is presented.

Will I have to change the db data type ?

admin_pay_rate DECIMAL(5,2),

I am not sure about maxValue in my class. Because I am not sure what is a good value
Or how to change maxValue to restrict a value that exceeds what the data base considers
A double.

Would someone know the best way to coordinate the field with the db ?

It works ok for now but the user has the ability to present number like
1,000,000,000.00 and in most of the values I am working with are not
that big.

package view.utils.formattedFields;

import java.beans.PropertyChangeSupport;
import java.io.Serializable;
import java.text.DecimalFormat;
import javax.swing.JFormattedTextField;
import javax.swing.text.DefaultFormatterFactory;
import javax.swing.text.NumberFormatter;

/**
 * Provides a JFormattedTextField that accepts only doubles. Allows for the setting of the number
 * of decimal places displayed, and min/max values allowed.
 * 
 * @author Mark Pendergast
 * Copyright Mark Pendergast
 */
public class FormattedDoubleField extends JFormattedTextField implements Serializable{

    public static final String PROP_MINVALUE_PROPERTY = "minimum value";
    public static final String PROP_MAXVALUE_PROPERTY = "maximum value";
    public static final String PROP_DECIMALPLACES_PROPERTY = "decimal places";
    
    public static final String displayFormat = "#,###,##0.000000000000000";
    public static final String editFormat = "#.###############";
    
     
    private double minValue = -Double.MAX_VALUE;
    private double maxValue = Double.MAX_VALUE;
    private int decimalPlaces = DEFAULT_DECIMALPLACES;
    private DefaultFormatterFactory dff;
    private view.utils.formattedFields.verifiers.DoubleVerifier verifier;

    
    private static final int DEFAULT_DECIMALPLACES = 2;
    private static final int MAX_DECIMALPLACES = 15;
    private static final int POSITIONS_LEFT_OF_DECIMALDISPLAY = displayFormat.indexOf('.');
    private static final int POSITIONS_LEFT_OF_DECIMALEDIT = editFormat.indexOf('.');

    private PropertyChangeSupport propertySupport;
/**
 * Default constructor
 */
    public FormattedDoubleField() {
       this(-Double.MAX_VALUE, Double.MAX_VALUE,0, DEFAULT_DECIMALPLACES);
    }
/**
 * Constructor that accepts the number of decimal places to display 
 *
 * @param places number of decimal places to display
 */
    public FormattedDoubleField(int places) {
       this(-Double.MAX_VALUE, Double.MAX_VALUE,0, places);
    }
/**
 *  Constructor that accepts a min and max allowed value
 * 
 * @param min min allowed value
 * @param max max alloed value
 * @throws java.lang.IllegalArgumentException
 */
     public FormattedDoubleField(double min, double max) throws IllegalArgumentException{
        this(min,max,0,DEFAULT_DECIMALPLACES);
    }
  /**
   *  Working Constructor
   * 
   * @param min min allowed value
   * @param max max allowed value
   * @param value inital value
   * @param places number of decimal places to display
   * @throws java.lang.IllegalArgumentException
   */   
     public FormattedDoubleField(double min, double max, double value, int places) throws IllegalArgumentException{
        propertySupport = new PropertyChangeSupport(this);

        setValue(new Double(value));
        minValue = min;
        maxValue = max;
        if(min > max)
            throw new IllegalArgumentException("min value cannot be greater than max value");
        verifier = new view.utils.formattedFields.verifiers.DoubleVerifier(min, max);
        setInputVerifier(verifier);
        NumberFormatter def = new NumberFormatter();
        def.setValueClass(Double.class);
        NumberFormatter disp = new NumberFormatter((new DecimalFormat(displayFormat.substring(0,POSITIONS_LEFT_OF_DECIMALDISPLAY+places+1))));
        disp.setValueClass(Double.class);
        NumberFormatter ed = new NumberFormatter((new DecimalFormat(editFormat.substring(0,POSITIONS_LEFT_OF_DECIMALEDIT+places+1))));
        ed.setValueClass(Double.class);
        dff = new DefaultFormatterFactory(def,disp,ed);
        setFormatterFactory(dff);
      
    }
     /*
      * Accessor methods
      */
    public double getMinValue() {
        return minValue;
    }
    
    public double getMaxValue() {
        return maxValue;
    }
    
    public int getDecimalPlaces()
    {
      return decimalPlaces;
    }
   /*
    * mutator methods
    */
    public void setMinValue(double value) throws IllegalArgumentException{
        if(value > maxValue)
               throw new IllegalArgumentException("min value cannot be greater than max value");
        double oldValue = minValue;
        minValue  = value;
        propertySupport.firePropertyChange(PROP_MINVALUE_PROPERTY, oldValue, minValue);
        verifier.setMinValue(value);
    }
    
    public void setMaxValue(double value) throws IllegalArgumentException {
        if(value < minValue)
               throw new IllegalArgumentException("max value cannot be less than min value");
        double oldValue = maxValue;
        maxValue  = value;
        propertySupport.firePropertyChange(PROP_MAXVALUE_PROPERTY, oldValue, maxValue);
        verifier.setMaxValue(value);
    }
    
    public void setDecimalPlaces(int value) throws IllegalArgumentException {
        if(value < 0 || value > MAX_DECIMALPLACES)
               throw new IllegalArgumentException("decimal places cannot be negative");
        int oldValue = decimalPlaces;
        decimalPlaces  = value;
        propertySupport.firePropertyChange(PROP_DECIMALPLACES_PROPERTY, oldValue, decimalPlaces);
        dff.setDisplayFormatter(new NumberFormatter((new DecimalFormat(displayFormat.substring(0,POSITIONS_LEFT_OF_DECIMALDISPLAY+value+1)))));
        dff.setEditFormatter(new NumberFormatter((new DecimalFormat(editFormat.substring(0,POSITIONS_LEFT_OF_DECIMALEDIT+value+1)))));
        setFormatterFactory(dff);
        repaint();
    }    
}

error

CLASS 
 public class PaymentRegisterForm extends MasterPaymentForm implements ActionListener {: 
validateBtnAction() : 2: txtFieldArray[UIDSEARCHFIELD].getText() : 
CONFIRM!: The Payment amount does not match the Instructors Lesson rate.
Error: Empty field: All Fields are required
CLASS 
 public class PaymentRegisterForm extends MasterPaymentForm implements ActionListener {: 
Exception in thread "AWT-EventQueue-0" java.lang.NumberFormatException: For input string: "1,000.00"
chkEmptyFields() : 2: txtFieldArray[UIDSEARCHFIELD].getText() : 
CLASS 
        at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1222)
 public class PaymentRegisterForm extends MasterPaymentForm implements ActionListener {: 
chkEmptyFields() : true: returns : 
CLASS 
        at java.lang.Double.parseDouble(Double.java:510)
 public class PaymentRegisterForm extends MasterPaymentForm implements ActionListener {: 
        at view.content.entities.payment.PaymentRegisterForm.validateBtnAction(PaymentRegisterForm.java:1423)
validateBtnAction() : 2: txtFieldArray[UIDSEARCHFIELD].getText() : 
        at view.content.entities.payment.PaymentRegisterForm.actionPerformed(PaymentRegisterForm.java:728)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6288)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
        at java.awt.Component.processEvent(Component.java:6053)
        at java.awt.Container.processEvent(Container.java:2041)
        at java.awt.Component.dispatchEventImpl(Component.java:4651)
        at java.awt.Container.dispatchEventImpl(Container.java:2099)
        at java.awt.Component.dispatchEvent(Component.java:4481)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
        at java.awt.Container.dispatchEventImpl(Container.java:2085)
        at java.awt.Window.dispatchEventImpl(Window.java:2478)
        at java.awt.Component.dispatchEvent(Component.java:4481)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
        at java.awt.EventQueue.access$000(EventQueue.java:84)
        at java.awt.EventQueue$1.run(EventQueue.java:602)
        at java.awt.EventQueue$1.run(EventQueue.java:600)
        at java.security.AccessController.doPrivileged(Native Method)

[Stephan van Hulst]

Do NOT use floating point values to store money. Never. Ever. Hit yourself with a stick when you try doing it.

Floating point values are an approximation. You wouldn't like your bank to remember the approximate amount in your bank account, would you?

Instead, use exact values, like integers.

[Campbell Ritchie]

. . . or BigDecimal.

[Steve Howerton]

Thanks I have some studying to do. I will have to try to use the BigDecimal data type in apache derby db. All my forms collect values for double. The JFormattedTextFields wlll allow input of doubles of any size so maybe I will just have to re-write and convert them to BigDecimal in order to save them. When I address this
I will try to supply some code to show a simple example for using BigDecimal.
I have not found to many examples stressing the use of BigDecimal thou it
is an essential concept.
Thank you for your time.

Compound interest
https://coderanch.com/forums/posts/preList/552780/2507967
BigDecimal . RoundingMode and MathContext

[Campbell Ritchie]

Steve Howerton wrote: . . . Compound interest
https://coderanch.com/forums/posts/preList/552780/2507967
BigDecimal . RoundingMode and MathContext

Who wrote that code? I wouldn’t believe anything he says!

[Pat Farrell]

Stephan van Hulst wrote:Do NOT use floating point values to store money. Never. Ever. Hit yourself with a stick when you try doing it.

When I teach Java at the local university, I spend a half lecture on this topic.

Listen to @stephan. Never use floating point for money. Not for dollars, euros, swiss francs, yen, etc. Never. Don't do it.

[Rob Spoor]

Except maybe Zimbabwean dollars; the difference between 100 and 1000 was so small you wouldn't even notice

[Winston Gutkowski]

Steve Howerton wrote:In my Apache derby db I set up Decimal data types like this:

admin_pay_rate DECIMAL(5,2),

I use JFormattedTextFields to filter decimal usage in text fields concerning money
Like admin pay rate would be 150.00: this is good.

In the JFormattedTextField it will allow 1,000.00 but the db crashes when this
Decimal is presented.

Will I have to change the db data type ?

Going back to your original question, the answer is YES. If you need to pass a value that is more than 999.99, then you will have to change the database definition, regardless of what Java type you use.

However, you should still heed the good advice you've been given.

Winston

[Stephan van Hulst]

Rob Spoor wrote:Except maybe Zimbabwean dollars; the difference between 100 and 1000 was so small you wouldn't even notice

Hahah

[Campbell Ritchie]

Not at all. It is still larger than the difference between

double d1 = 1.0e-300;
double d2 = 1.0e-299;

d1 and d2. Ten times. Just because the absolute values are small, that doesn’t vitiate the difference.

[Campbell Ritchie]

Oh, I forgot. Zimbabwean dollars don’t have absolute values. They shrink as you watch. Sorry for the mistake.

[Winston Gutkowski]

Campbell Ritchie wrote:Oh, I forgot. Zimbabwean dollars don’t have absolute values. They shrink as you watch. Sorry for the mistake.

Actually, I believe it is no more. It has ceased to be. This, from Wikipedia:

"..the use of the dollar as an official currency was effectively abandoned on 12 April 2009. This was a result of the Reserve Bank of Zimbabwe legalizing the use of foreign currencies for transactions in January 2009.
Currencies such as the South African rand, Botswana pula, pound sterling, euro, and the United States dollar are now used for all transactions in Zimbabwe; the policy of the government of Zimbabwe has insisted that any attempts to reintroduce Zimbabwean currency should be considered only if industrial output improves.[5]..."

Not surprising I suppose when they had a Z$100-trillion note. I imagine the ink to print the zeroes was a a limiting factor.

Winston

[Stephan van Hulst]

They started writing the denominations in scientific notation.

[Campbell Ritchie]

It has shrunk so much it has vanished up its own *****, you mean.

[Steve Howerton]

Thanks for the input. I really can not offer a good code example but I can say that I use Netbeans and I had to insure that BigDecimal was imported because it was
Allowing me to use methods from the pkg but there was no import for BigDecimal and it did not indicate it. I found very few examples but the Compound Interest example
Mentioned does offer some relative conventions.
Thanks again

[Campbell Ritchie]

The problem is that a lot of people who teach computing don’t know about it, so you get few examples in tutorials. People who write banking applications know all about BigDecimal, and they always post their code on the net, don’t they.