Hibernate - filter Single Column data using date where clause

Question

Lets say One table ABC having two column i.e. ID & CREATED_DATE

I want to fetch those ID which is created lets say '09-11-2017' and '09-17-2017'

Below SQL query working fine but I want to implement same logic using hibernate.

select ID from ABC where between TO_DATE('09-11-2017', 'MM-DD-YYYY')  AND TO_DATE('09-17-2017', 'MM-DD-YYYY')

My code is not working.

public List getData(final Date startDate, final Date endDate){

    String sqlString = "select ID from ABC where CREATED_DATE between :startDate and :endDate";
    SQLQuery query = getSession().createSQLQuery(sqlString);
    query.setParameter(CREATED_DATE);
    return query.list();
}

Ori Marko · Accepted Answer · 2017-09-17 13:03:41Z

3

You are missing End date parameter :

query.setParameter(CREATED_DATE, startDate);
query.setParameter(END_DATE, endDate);

answered Sep 17, 2017 at 13:03

Ori Marko

59.3k26 gold badges157 silver badges259 bronze badges

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

1 Comment

SKP Over a year ago

Thank you @user7294900. Its really helpful.

Youcef LAIDANI · Accepted Answer · 2017-09-17 13:06:22Z

3

It not work because you don't set the correct parameters :

String sqlString = "select ID from ABC where CREATED_DATE between :startDate and :endDate";
SQLQuery query = getSession().createSQLQuery(sqlString);
query.setParameter("startDate ", start_date);
query.setParameter("endDate", end_date);
return query.list();

edited Sep 17, 2017 at 13:06

answered Sep 17, 2017 at 13:05

Youcef LAIDANI

60.3k21 gold badges111 silver badges178 bronze badges

2 Comments

Ori Marko Over a year ago

second parameter is endDate

SKP Over a year ago

Thank you @YCF_L. I just start read the online documents to learn more. You guys are rock

pscar13 · Accepted Answer · 2017-09-17 13:14:51Z

2

The parameters must match the string on the query

Try this:

public List getData(final Date startDate, final Date endDate){

    String sqlString = "select ID from ABC where CREATED_DATE between :startDate and :endDate";
    SQLQuery query = getSession().createSQLQuery(sqlString);
    query.setParameter("startDate",startDate);
    query.setParameter("endDate",endDate);
    return query.list();
}

--

pscar13

answered Sep 17, 2017 at 13:14

pscar13

213 bronze badges

Collectives™ on Stack Overflow

Hibernate - filter Single Column data using date where clause

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related