Hibernate: java.lang.ClassCastException: java.util.GregorianCalendar

[Dave Alvarado]

Hi,

I'm using Hibernate 3.3.2 .GA. I have a Java model in which one column of the model maps to an Oracle DATE column that can be null.

  @Temporal(TemporalType.DATE)
  @Column(name="paid_date", nullable=true)
  public Date getPaidDate() {
    return paidDate;
  }
  public void setPaidDate(Date paidDate) {
    this.paidDate = paidDate;
  }

However, when I try and get results that include one of these columns with the null value,

			session = HibernateFactory.getSessionFactory().openSession();

			Criteria criteria = session
					.createCriteria(FinancialAidPayment.class);
			criteria.add(Expression.between("paymentDate", startDate, endDate));
			if (loadUnpaidOnly) { 
				criteria.add(Restrictions.isNull("paidDate"));
			}	// if
			
			List<FinancialAidPayment> queryResults = criteria.list();      // exception thrown here

I get the error below. Any ideas why? I have included the complete class below the stack trace.

Thanks, - Dave

Stack trace ...

ERROR [myco.dor.online.interlock.service.reports.utils.DBUtils, main 2010-01-25 10:39:44,642]:
Failed to load financial aid payments
java.lang.ClassCastException: java.util.GregorianCalendar
	at org.hibernate.type.DateType.toString(DateType.java:101)
	at org.hibernate.type.NullableType.nullSafeToString(NullableType.java:117)
	at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:158)
	at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
	at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1732)
	at org.hibernate.loader.Loader.bindParameterValues(Loader.java:1703)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1593)
	at org.hibernate.loader.Loader.doQuery(Loader.java:696)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
	at org.hibernate.loader.Loader.doList(Loader.java:2232)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
	at org.hibernate.loader.Loader.list(Loader.java:2124)
	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597)
	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
	at myco.dor.online.interlock.service.reports.utils.DBUtils.loadPayments(DBUtils.java:193)
	at myco.dor.online.interlock.service.reports.InvoicingReport.getReportData(InvoicingReport.java:32)
	at myco.dor.online.interlock.service.ejb.ReportsServiceBean.getInvoicingReport(ReportsServiceBean.java:136)
	at myco.dor.online.interlock.service.ejb.ReportsServiceBean$$FastClassByCGLIB$$4d0b53c6.invoke(<generated>)
	at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)

Model class

package myco.dor.online.interlock.model;

import java.io.Serializable;
import java.util.Date;
import java.math.BigDecimal;

import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.Table;
import javax.persistence.Id;
import javax.persistence.Column;
import javax.persistence.SequenceGenerator;
import javax.persistence.GenerationType;
import javax.persistence.GeneratedValue;
import javax.persistence.ManyToOne;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.UniqueConstraint;

@Entity
@Table(name="PAYMENT",
     uniqueConstraints = {@UniqueConstraint(columnNames={"payment_date"})}
)

public class FinancialAidPayment implements Serializable {
  static final long serialVersionUID = 2479962280853675775L;
  
  private Integer    id;
  private Date       paymentDate;
  private BigDecimal paymentAmt;
  private Integer    daysPaid;
  private Applicant  applicant;
  private Date		 paidDate;
  
  @Id
  @SequenceGenerator(name="PAYMENT", sequenceName="payment_id_seq")
  @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="PAYMENT")
  public Integer getId() {
    return id;
  }
  public void setId(Integer id) {
    this.id = id;
  }
  
  @Temporal(TemporalType.DATE)
  @Column(name="payment_date", nullable=false)
  public Date getPaymentDate() {
    return paymentDate;
  }
  public void setPaymentDate(Date paymentDate) {
    this.paymentDate = paymentDate;
  }
  
  @Column(name="payment_amt", nullable=false, scale=11, precision=2)
  public BigDecimal getPaymentAmt() {
    return paymentAmt;
  }
  public void setPaymentAmt(BigDecimal paymentAmt) {
    this.paymentAmt = paymentAmt;
  }
  
  @Column(name="days_paid")
  public Integer getDaysPaid() {
    return daysPaid;
  }
  public void setDaysPaid(Integer daysPaid) {
    this.daysPaid = daysPaid;
  }
  
  @ManyToOne
  @JoinColumn(name="applicant_id", referencedColumnName="id")
  public Applicant getApplicant() {
    return applicant;
  }
  public void setApplicant(Applicant applicant) {
    this.applicant = applicant;
  }

  @Temporal(TemporalType.DATE)
  @Column(name="paid_date", nullable=true)
  public Date getPaidDate() {
    return paidDate;
  }
  public void setPaidDate(Date paidDate) {
    this.paidDate = paidDate;
  }
  
  public int hashCode() {
	  final int prime = 31;
	  int result = 1;
	  result = prime * result
	  + ((paymentDate == null) ? 0 : paymentDate.hashCode());
	  return result;
  }
  public boolean equals(Object obj) {
	  if (this == obj)
		  return true;
	  if (obj == null)
		  return false;
	  if (getClass() != obj.getClass())
		  return false;
	  FinancialAidPayment other = (FinancialAidPayment) obj;
	  if (paymentDate == null) {
		  if (other.paymentDate != null)
			  return false;
	  } else if (!paymentDate.equals(other.paymentDate))
		  return false;
	  return true;
  }

  
}//end class

[Victor Dolirio]

I think that the problem is in this line:

criteria.add(Expression.between("paymentDate", startDate, endDate));  

As I guess that at least one of the variables startDate and endDate is of type GregorianCalendar. You must pass a Date once you have mapped it as a Date.

Try something like this:

criteria.add(Expression.between("paymentDate", startDate.getTime(), endDate.getTime()));

Hope to help you.