Spring, Java : Error, cannot cast java.lang.Long to java.util.Date

Question

When I am starting my server, I am getting an error that I cannot cast Long to Date. It is thrown at a specific line.

Error log :

java.lang.ClassCastException: java.lang.Long cannot be cast to java.util.Date
    at org.hibernate.type.descriptor.java.JdbcTimestampTypeDescriptor.unwrap(JdbcTimestampTypeDescriptor.java:41)
    at org.hibernate.type.descriptor.sql.TimestampTypeDescriptor$1.doBind(TimestampTypeDescriptor.java:64)
    at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:90)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:286)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:281)
    at org.hibernate.param.NamedParameterSpecification.bind(NamedParameterSpecification.java:67)
    at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:616)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1901)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
    at org.hibernate.loader.Loader.doQuery(Loader.java:910)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
    at org.hibernate.loader.Loader.doList(Loader.java:2554)
    at org.hibernate.loader.Loader.doList(Loader.java:2540)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
    at org.hibernate.loader.Loader.list(Loader.java:2365)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
    at com.journaldev.spring.dao.SupportRequestDAOImpl.getUnResolvedIssuesWithTimerExpired(SupportRequestDAOImpl.java:211)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

SupportRequestDAOImpl :

 @Override
    public List<SupportRequest> getUnResolvedIssuesWithTimerExpired() {
        Session session = this.sessionFactory.getCurrentSession();
        long now = System.currentTimeMillis();
        Query query = session.createQuery("from SupportRequest as sr where sr.resolved=false and sr.timeToResolve>:now and sr.requestStatus=false");
        query.setParameter("now", now); // error line
        return query.list();
    }

SupportRequest model :

@Entity
@Table(name = "supportrequest")
public class SupportRequest implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @Column(name = "supportrequestid")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "supportrequest_gen")
    @SequenceGenerator(name = "supportrequest_gen", sequenceName = "supportrequest_seq")
    private int supportRequestId;

    @Column(name = "subject")
    private String subject;

    @Column(name = "text")
    private String text;

    @Column(name = "type")
    private String type;

    @Column(name = "priority")
    private String priority;

    @Column(name = "status",columnDefinition = "boolean default false")
    private boolean requestStatus;

    @Column(name = "timetoresolve")
    private Timestamp timeToResolve;

    @Column(name = "creationtime")
    private Timestamp creationTime;

    @Column(name = "resolvedtime")
    private Timestamp resolvedTime;

    @Column(name = "assigned_team_member_id")
    private int assignedTeamMemberId;

    @Column(name = "resolved",columnDefinition = "boolean default false")
    private boolean resolved;

    @Column(name = "resolvedintime",columnDefinition = "boolean default false")
    private boolean resolvedInTime;

    // Only for testing
    @Transient
    private int assignedteamid;

    @Transient
    private Long assignedgroupid;

SupportRequest Database table :

CREATE TABLE supportrequest
(
  supportrequestid integer NOT NULL,
  subject character varying,
  text character varying,
  type character varying,
  priority character varying,
  timetoresolve timestamp without time zone,
  creationtime timestamp without time zone,
  resolvedtime timestamp without time zone,
  assigned_team_member_id integer DEFAULT 0,
  resolved boolean DEFAULT false,
  resolvedintime boolean DEFAULT false,
  groupid numeric NOT NULL,
  status boolean,
  CONSTRAINT supportrequestid PRIMARY KEY (supportrequestid),
  CONSTRAINT groupaccount_supportrequest_fk FOREIGN KEY (groupid)
      REFERENCES groupaccount (groupid) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE supportrequest
  OWNER TO postgres;

What am I doing wrong?

I also tried :

long now = new Timestamp(System.currentTimeMillis()).getTime();

Tunaki · Accepted Answer · 2015-09-25 12:06:21Z

5

The problem is that you are setting a long value to a field that should be a Date. Change your code to:

query.setParameter("now", new Date());

In the HQL query, you have the following condition sr.timeToResolve > :now. Since timeToResolve is declared as a Timestamp in SupportRequest, Hibernate expects the other side of the comparison to also be a Date.

answered Sep 25, 2015 at 12:06

Tunaki

138k46 gold badges370 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

We are Borg Over a year ago

Cool, it's gone. Thanks a lot.. :-) I will accept the answer in 1 minute, as SO not allowing now.

Kishore Reddy · Accepted Answer · 2015-09-25 12:09:05Z

2

You are passing 'now' parameter value as long, but your DB column type is 'time stamp'. In your query your comparing both of this. that is the cause for this exception.

answered Sep 25, 2015 at 12:09

Kishore Reddy

9363 gold badges11 silver badges19 bronze badges

Collectives™ on Stack Overflow

Spring, Java : Error, cannot cast java.lang.Long to java.util.Date

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related