java - How to get all records of today date through Hibernate HSQL? -

java - How to get all records of today date through Hibernate HSQL? -

i trying record of today date through below hsql query

query query = session.getnamedquery("findusersorder") .settimestamp("todaydate", date);

and query in db table

@namedqueries({ @namedquery(name = "findusersorder", query = "from grouptweetorder gtoaddeddate = :todaydate "), })

but returning 0 record ....

can tell me how records of current date or today date only?

updated

severe: java.lang.stringindexoutofboundsexception: string index out of range: 0 @ java.lang.string.charat(string.java:658) @ org.hibernate.type.descriptor.java.charactertypedescriptor.wrap(charactertypedescriptor.java:79) @ org.hibernate.type.descriptor.java.charactertypedescriptor.wrap(charactertypedescriptor.java:33) @ org.hibernate.type.descriptor.sql.varchartypedescriptor$2.doextract(varchartypedescriptor.java:66) @ org.hibernate.type.descriptor.sql.basicextractor.extract(basicextractor.java:65) @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:269) @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:265) @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:238) @ org.hibernate.type.abstractstandardbasictype.hydrate(abstractstandardbasictype.java:357) @ org.hibernate.persister.entity.abstractentitypersister.hydrate(abstractentitypersister.java:2701) @ org.hibernate.loader.loader.loadfromresultset(loader.java:1541) @ org.hibernate.loader.loader.instancenotyetloaded(loader.java:1473) @ org.hibernate.loader.loader.getrow(loader.java:1373) @ org.hibernate.loader.loader.getrowfromresultset(loader.java:640) @ org.hibernate.loader.loader.doquery(loader.java:850) @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:289) @ org.hibernate.loader.loader.dolist(loader.java:2447) @ org.hibernate.loader.loader.dolist(loader.java:2433) @ org.hibernate.loader.loader.listignorequerycache(loader.java:2263) @ org.hibernate.loader.loader.list(loader.java:2258) @ org.hibernate.loader.hql.queryloader.list(queryloader.java:470) @ org.hibernate.hql.internal.ast.querytranslatorimpl.list(querytranslatorimpl.java:355) @ org.hibernate.engine.query.spi.hqlqueryplan.performlist(hqlqueryplan.java:196) @ org.hibernate.internal.sessionimpl.list(sessionimpl.java:1161) @ org.hibernate.internal.queryimpl.list(queryimpl.java:101) @ com.ccc.spring.dao.groupdistdao.fetchtodaygrouporder(groupdistdao.java:82) @ com.ccc.spring.service.groupdistservice.fetchtodaygrouporder(groupdistservice.java:40) @ com.ccc.spring.service.groupdistservice$$fastclassbyspringcglib$$a552f952.invoke() @ org.springframework.cglib.proxy.methodproxy.invoke(methodproxy.java:204) @ org.springframework.aop.framework.cglibaopproxy$cglibmethodinvocation.invokejoinpoint(cglibaopproxy.java:711) @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:157) @ org.springframework.transaction.interceptor.transactioninterceptor$1.proceedwithinvocation(transactioninterceptor.java:98) @ org.springframework.transaction.interceptor.transactionaspectsupport.invokewithintransaction(transactionaspectsupport.java:262) @ org.springframework.transaction.interceptor.transactioninterceptor.invoke(transactioninterceptor.java:95) @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) @ org.springframework.aop.framework.cglibaopproxy$dynamicadvisedinterceptor.intercept(cglibaopproxy.java:644) @ com.ccc.spring.service.groupdistservice$$enhancerbyspringcglib$$dbd2ed38.fetchtodaygrouporder() @ com.ccc.managedcontroller.tweetdistributionmanagedbean.sendgrouptweets(tweetdistributionmanagedbean.java:175) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:601) @ org.apache.el.parser.astvalue.invoke(astvalue.java:264) @ org.apache.el.methodexpressionimpl.invoke(methodexpressionimpl.java:278) @ javax.faces.event.methodexpressionactionlistener.processaction(methodexpressionactionlistener.java:153) @ javax.faces.event.actionevent.processlistener(actionevent.java:88) @ javax.faces.component.uicomponentbase.broadcast(uicomponentbase.java:769) @ javax.faces.component.uicommand.broadcast(uicommand.java:300) @ javax.faces.component.uiviewroot.broadcastevents(uiviewroot.java:794) @ javax.faces.component.uiviewroot.processapplication(uiviewroot.java:1259) @ com.sun.faces.lifecycle.invokeapplicationphase.execute(invokeapplicationphase.java:81) @ com.sun.faces.lifecycle.phase.dophase(phase.java:101) @ com.sun.faces.lifecycle.lifecycleimpl.execute(lifecycleimpl.java:118) @ javax.faces.webapp.facesservlet.service(facesservlet.java:593) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.primefaces.webapp.filter.fileuploadfilter.dofilter(fileuploadfilter.java:98) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ com.ocpsoft.pretty.prettyfilter.dofilter(prettyfilter.java:145) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:225) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:123) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:168) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:98) @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:927) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:407) @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1001) @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:585) @ org.apache.tomcat.util.net.jioendpoint$socketprocessor.run(jioendpoint.java:312) @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1145) @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615) @ java.lang.thread.run(thread.java:722)

jun 23, 2014 3:17:49 pm com.sun.faces.context.ajaxexceptionhandlerimpl log severe: jsf1073: javax.faces.event.abortprocessingexception caught during processing of invoke_application 5 : uicomponent-clientid=formcontract:icononly, message=java.lang.stringindexoutofboundsexception: string index out of range: 0 jun 23, 2014 3:17:49 pm com.sun.faces.context.ajaxexceptionhandlerimpl log severe: java.lang.stringindexoutofboundsexception: string index out of range: 0 javax.faces.event.abortprocessingexception: java.lang.stringindexoutofboundsexception: string index out of range: 0 @ javax.faces.event.methodexpressionactionlistener.processaction(methodexpressionactionlistener.java:182) @ javax.faces.event.actionevent.processlistener(actionevent.java:88) @ javax.faces.component.uicomponentbase.broadcast(uicomponentbase.java:769) @ javax.faces.component.uicommand.broadcast(uicommand.java:300) @ javax.faces.component.uiviewroot.broadcastevents(uiviewroot.java:794) @ javax.faces.component.uiviewroot.processapplication(uiviewroot.java:1259) @ com.sun.faces.lifecycle.invokeapplicationphase.execute(invokeapplicationphase.java:81) @ com.sun.faces.lifecycle.phase.dophase(phase.java:101) @ com.sun.faces.lifecycle.lifecycleimpl.execute(lifecycleimpl.java:118) @ javax.faces.webapp.facesservlet.service(facesservlet.java:593) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.primefaces.webapp.filter.fileuploadfilter.dofilter(fileuploadfilter.java:98) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ com.ocpsoft.pretty.prettyfilter.dofilter(prettyfilter.java:145) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:225) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:123) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:168) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:98) @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:927) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:407) @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1001) @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:585) @ org.apache.tomcat.util.net.jioendpoint$socketprocessor.run(jioendpoint.java:312) @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1145) @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615) @ java.lang.thread.run(thread.java:722) caused by: java.lang.stringindexoutofboundsexception: string index out of range: 0 @ java.lang.string.charat(string.java:658) @ org.hibernate.type.descriptor.java.charactertypedescriptor.wrap(charactertypedescriptor.java:79) @ org.hibernate.type.descriptor.java.charactertypedescriptor.wrap(charactertypedescriptor.java:33) @ org.hibernate.type.descriptor.sql.varchartypedescriptor$2.doextract(varchartypedescriptor.java:66) @ org.hibernate.type.descriptor.sql.basicextractor.extract(basicextractor.java:65) @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:269) @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:265) @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:238) @ org.hibernate.type.abstractstandardbasictype.hydrate(abstractstandardbasictype.java:357) @ org.hibernate.persister.entity.abstractentitypersister.hydrate(abstractentitypersister.java:2701) @ org.hibernate.loader.loader.loadfromresultset(loader.java:1541) @ org.hibernate.loader.loader.instancenotyetloaded(loader.java:1473) @ org.hibernate.loader.loader.getrow(loader.java:1373) @ org.hibernate.loader.loader.getrowfromresultset(loader.java:640) @ org.hibernate.loader.loader.doquery(loader.java:850) @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:289) @ org.hibernate.loader.loader.dolist(loader.java:2447) @ org.hibernate.loader.loader.dolist(loader.java:2433) @ org.hibernate.loader.loader.listignorequerycache(loader.java:2263) @ org.hibernate.loader.loader.list(loader.java:2258) @ org.hibernate.loader.hql.queryloader.list(queryloader.java:470) @ org.hibernate.hql.internal.ast.querytranslatorimpl.list(querytranslatorimpl.java:355) @ org.hibernate.engine.query.spi.hqlqueryplan.performlist(hqlqueryplan.java:196) @ org.hibernate.internal.sessionimpl.list(sessionimpl.java:1161) @ org.hibernate.internal.queryimpl.list(queryimpl.java:101) @ com.ccc.spring.dao.groupdistdao.fetchtodaygrouporder(groupdistdao.java:82) @ com.ccc.spring.service.groupdistservice.fetchtodaygrouporder(groupdistservice.java:40) @ com.ccc.spring.service.groupdistservice$$fastclassbyspringcglib$$a552f952.invoke() @ org.springframework.cglib.proxy.methodproxy.invoke(methodproxy.java:204) @ org.springframework.aop.framework.cglibaopproxy$cglibmethodinvocation.invokejoinpoint(cglibaopproxy.java:711) @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:157) @ org.springframework.transaction.interceptor.transactioninterceptor$1.proceedwithinvocation(transactioninterceptor.java:98) @ org.springframework.transaction.interceptor.transactionaspectsupport.invokewithintransaction(transactionaspectsupport.java:262) @ org.springframework.transaction.interceptor.transactioninterceptor.invoke(transactioninterceptor.java:95) @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) @ org.springframework.aop.framework.cglibaopproxy$dynamicadvisedinterceptor.intercept(cglibaopproxy.java:644) @ com.ccc.spring.service.groupdistservice$$enhancerbyspringcglib$$dbd2ed38.fetchtodaygrouporder() @ com.ccc.managedcontroller.tweetdistributionmanagedbean.sendgrouptweets(tweetdistributionmanagedbean.java:175) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:601) @ org.apache.el.parser.astvalue.invoke(astvalue.java:264) @ org.apache.el.methodexpressionimpl.invoke(methodexpressionimpl.java:278) @ javax.faces.event.methodexpressionactionlistener.processaction(methodexpressionactionlistener.java:153) ... 31 more

hibernate: select grouptweet0_.gto_id gto1_15_, grouptweet0_.gto_added_date gto2_15_, grouptweet0_.gto_email_id gto3_15_, grouptweet0_.gto_group_count gto4_15_, grouptweet0_.gto_send gto5_15_, grouptweet0_.gto_send_date gto6_15_, grouptweet0_.gto_user_active gto7_15_, grouptweet0_.gto_user_id gto8_15_ subodhc_ccc.group_tweet_order grouptweet0_ grouptweet0_.gto_added_date>=? , grouptweet0_.gto_added_date

you can utilize jodatime library best out of info functions. can plaing java 6 or 7 too, it's much more work timestamp of current day @ midnight.

with jodatime how can it:

@namedqueries({ @namedquery(name = "findusersorder", query = "from grouptweetorder gtoaddeddate >= :todayatmidnight , gtoaddeddate < :tomorrowatmidnight") }) datetime todayatmidnight = new datetime().withtimeatstartofday(); datetime tomorrowatmidnight = todayatmidnight.plusdays(1); query query = session.getnamedquery("findusersorder") .settimestamp("todayatmidnight", todayatmidnight.todate()) .settimestamp("tomorrowatmidnight", tomorrowatmidnight.todate());

java hibernate jpa orm hsqldb