Conversion problem between org.joda.time.LocalDate and java.sql.Date field for dates before Jan 2 1900

[TRoorda]

Expected behavior

Conversion between org.joda.time.LocalDate and java.sql.Date result in the same date.

Actual behavior

Conversion between org.joda.time.LocalDate and java.sql.Date of dates before Feb 2nd 1900 are one day off. For instance 1899-12-01 is converted to 1899-11-30. This is tested and confirmed wrong for Joda versions 2.9.7, 2.9.9 and 2.10.1. Note that dates after 1-1-1900 are not affected.

Steps to reproduce

Either take a look of the committed test or at the code example below:

Ebean entity:

  ...
import org.joda.time.LocalDate;
...

@Entity
@Table(name = "unit_assignment")
public class UnitAssignment {

    ...

    @Column(name = "datebegin")
    private LocalDate beginDate;

    ...

    public LocalDate getBeginDate() {
        return beginDate;
    }

    public void setBeginDate(LocalDate beginDate) {
        this.beginDate = beginDate;
    }

    ...
}

Database table:

CREATE TABLE `unit_assignment` (
  ...
  `datebegin` date DEFAULT NULL,
  ...
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

Possible workaround is editting the Ebean entity:

...
import org.joda.time.LocalDate;
import java.util.Date;
...

@Entity
@Table(name = "unit_assignment")
public class UnitAssignment {

    ...

    @Column(name = "datebegin")
    private Date beginDate;

    ...

    public LocalDate getBeginDate() {
        return beginDate != null ? LocalDate.fromDateFields(beginDate) : null;
    }

    public void setBeginDate(LocalDate beginDate) {
        this.beginDate = beginDate.toDate();
    }

    ...
}