Monday, 15 July 2013

Hibernate SQL Exception java.lang.StringIndexOutOfBoundsException: String index out of range -



Hibernate SQL Exception java.lang.StringIndexOutOfBoundsException: String index out of range -

i writing below query record today date

session session = getsessionfactory().getcurrentsession(); datetime todayatmidnight = new datetime().withtimeatstartofday(); datetime tomorrowatmidnight = todayatmidnight.plusdays(1); query query = session.getnamedquery("findusersorder") .settimestamp("todayatmidnight", todayatmidnight.todate()) .settimestamp("tomorrowatmidnight", tomorrowatmidnight.todate()); list<grouptweetorder> usersorder= query.list();

and in java class table

@namedqueries({ @namedquery(name = "findusersorder", query = "from grouptweetorder gtoaddeddate >= :todayatmidnight , gtoaddeddate < :tomorrowatmidnight") })

but when ever trying run hsql getting

jun 23, 2014 5:13:11 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 5:13:11 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(<generated>) @ 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$$647c04d.fetchtodaygrouporder(<generated>) @ 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

according java se 7 doc

thrown string methods indicate index either negative or greater size of string. methods such charat method, exception thrown when index equal size of string.

see more here.

java hibernate

No comments:

Post a Comment