java - query not returning a result though data is in database -

in spring mvc application using hibernate , jpa, following jpa query throwing no result error, when have confirmed there result in drugwords table , set of rxcui values chosen drugword in rxnconsojunction table:

@suppresswarnings("unchecked") public drugword finddrugword(string wrd) {     system.out.println("..... wrd is: "+wrd);//prints value valid records in database     query query = this.em.createquery("select word drugword word left join fetch word.concepts word.name =:wrd");     query.setparameter("wrd", wrd); //        try{         return (drugword) query.getsingleresult(); //          } //        catch(exception e){} //        return new drugword(); }   

note: keep posting brief, have uploaded relevant code file sharing site. can view code clicking on following links:
code drugword entity at link.
code drugconcept entity at link.
code create underlying data tables in mysql at link.
code populate underlying data tables is @ link.
data 1 of tables is @ link.
data other table is @ link. (this big file, may take few moments load.)

here complete stack trace:

hibernate: select drugword0_.name name1_12_0_, drugconcep2_.rxcui rxcui1_10_1_, concepts1_.word word1_12_0__, concepts1_.rxcui rxcui2_13_0__ drugwords drugword0_ left outer join drugwordsconsojunction concepts1_ on drugword0_.name=concepts1_.word left outer join drugconcepts drugconcep2_ on concepts1_.rxcui=drugconcep2_.rxcui drugword0_.name=? warn  warn - handler execution resulted in exception org.springframework.dao.emptyresultdataaccessexception: no entity found query; nested exception javax.persistence.noresultexception: no entity found query     @ org.springframework.orm.jpa.entitymanagerfactoryutils.convertjpaaccessexceptionifpossible(entitymanagerfactoryutils.java:304) ~[spring-orm-3.2.5.release.jar:3.2.5.release]     @ org.springframework.orm.jpa.vendor.hibernatejpadialect.translateexceptionifpossible(hibernatejpadialect.java:108) ~[spring-orm-3.2.5.release.jar:3.2.5.release]     @ org.springframework.orm.jpa.abstractentitymanagerfactorybean.translateexceptionifpossible(abstractentitymanagerfactorybean.java:403) ~[spring-orm-3.2.5.release.jar:3.2.5.release]     @ org.springframework.dao.support.chainedpersistenceexceptiontranslator.translateexceptionifpossible(chainedpersistenceexceptiontranslator.java:58) ~[spring-tx-3.2.5.release.jar:3.2.5.release]     @ org.springframework.dao.support.dataaccessutils.translateifnecessary(dataaccessutils.java:213) ~[spring-tx-3.2.5.release.jar:3.2.5.release]     @ org.springframework.dao.support.persistenceexceptiontranslationinterceptor.invoke(persistenceexceptiontranslationinterceptor.java:163) ~[spring-tx-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.aspectj.methodinvocationproceedingjoinpoint.proceed(methodinvocationproceedingjoinpoint.java:80) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.samples.knowledgemanager.util.callmonitoringaspect.invoke(callmonitoringaspect.java:80) ~[callmonitoringaspect.class:na]     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.6.0_29]     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) ~[na:1.6.0_29]     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) ~[na:1.6.0_29]     @ java.lang.reflect.method.invoke(method.java:597) ~[na:1.6.0_29]     @ org.springframework.aop.aspectj.abstractaspectjadvice.invokeadvicemethodwithgivenargs(abstractaspectjadvice.java:621) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.aspectj.abstractaspectjadvice.invokeadvicemethod(abstractaspectjadvice.java:610) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.aspectj.aspectjaroundadvice.invoke(aspectjaroundadvice.java:65) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.interceptor.exposeinvocationinterceptor.invoke(exposeinvocationinterceptor.java:91) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.jdkdynamicaopproxy.invoke(jdkdynamicaopproxy.java:204) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ $proxy48.finddrugword(unknown source) ~[na:na]     @ org.springframework.samples.knowledgemanager.service.clinicserviceimpl.finddrugword(clinicserviceimpl.java:284) ~[clinicserviceimpl.class:na]     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.6.0_29]     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) ~[na:1.6.0_29]     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) ~[na:1.6.0_29]     @ java.lang.reflect.method.invoke(method.java:597) ~[na:1.6.0_29]     @ org.springframework.aop.support.aoputils.invokejoinpointusingreflection(aoputils.java:317) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.reflectivemethodinvocation.invokejoinpoint(reflectivemethodinvocation.java:183) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:150) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.transaction.interceptor.transactioninterceptor$1.proceedwithinvocation(transactioninterceptor.java:96) ~[spring-tx-3.2.5.release.jar:3.2.5.release]     @ org.springframework.transaction.interceptor.transactionaspectsupport.invokewithintransaction(transactionaspectsupport.java:260) ~[spring-tx-3.2.5.release.jar:3.2.5.release]     @ org.springframework.transaction.interceptor.transactioninterceptor.invoke(transactioninterceptor.java:94) ~[spring-tx-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:172) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.jdkdynamicaopproxy.invoke(jdkdynamicaopproxy.java:204) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ $proxy50.finddrugword(unknown source) ~[na:na]     @ org.springframework.samples.knowledgemanager.web.medicationcontroller.processfindform(medicationcontroller.java:84) ~[medicationcontroller.class:na]     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.6.0_29]     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) ~[na:1.6.0_29]     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) ~[na:1.6.0_29]     @ java.lang.reflect.method.invoke(method.java:597) ~[na:1.6.0_29]     @ org.springframework.web.method.support.invocablehandlermethod.invoke(invocablehandlermethod.java:219) ~[spring-web-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.method.support.invocablehandlermethod.invokeforrequest(invocablehandlermethod.java:132) ~[spring-web-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.servlet.mvc.method.annotation.servletinvocablehandlermethod.invokeandhandle(servletinvocablehandlermethod.java:104) ~[spring-webmvc-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.invokehandlemethod(requestmappinghandleradapter.java:745) ~[spring-webmvc-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.handleinternal(requestmappinghandleradapter.java:686) ~[spring-webmvc-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.servlet.mvc.method.abstracthandlermethodadapter.handle(abstracthandlermethodadapter.java:80) ~[spring-webmvc-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:925) [spring-webmvc-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:856) [spring-webmvc-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:936) [spring-webmvc-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.servlet.frameworkservlet.doget(frameworkservlet.java:827) [spring-webmvc-3.2.5.release.jar:3.2.5.release]     @ javax.servlet.http.httpservlet.service(httpservlet.java:621) [servlet-api.jar:na]     @ org.springframework.web.servlet.frameworkservlet.service(frameworkservlet.java:812) [spring-webmvc-3.2.5.release.jar:3.2.5.release]     @ javax.servlet.http.httpservlet.service(httpservlet.java:728) [servlet-api.jar:na]     @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305) [catalina.jar:7.0.42]     @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) [catalina.jar:7.0.42]     @ org.springframework.web.filter.hiddenhttpmethodfilter.dofilterinternal(hiddenhttpmethodfilter.java:77) [spring-web-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) [spring-web-3.2.5.release.jar:3.2.5.release]     @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) [catalina.jar:7.0.42]     @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) [catalina.jar:7.0.42]     @ com.github.dandelion.datatables.core.web.filter.datatablesfilter.dofilter(datatablesfilter.java:73) [datatables-core-0.9.2.jar:na]     @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) [catalina.jar:7.0.42]     @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) [catalina.jar:7.0.42]     @ com.github.dandelion.datatables.extras.servlet2.filter.datatablesfilter.dofilter(datatablesfilter.java:71) [datatables-servlet2-0.9.2.jar:na]     @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) [catalina.jar:7.0.42]     @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) [catalina.jar:7.0.42]     @ org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:88) [spring-web-3.2.5.release.jar:3.2.5.release]     @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) [spring-web-3.2.5.release.jar:3.2.5.release]     @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) [catalina.jar:7.0.42]     @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) [catalina.jar:7.0.42]     @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:222) [catalina.jar:7.0.42]     @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:123) [catalina.jar:7.0.42]     @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:502) [catalina.jar:7.0.42]     @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:171) [catalina.jar:7.0.42]     @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:99) [catalina.jar:7.0.42]     @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:953) [catalina.jar:7.0.42]     @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118) [catalina.jar:7.0.42]     @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:408) [catalina.jar:7.0.42]     @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1023) [tomcat-coyote.jar:7.0.42]     @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:589) [tomcat-coyote.jar:7.0.42]     @ org.apache.tomcat.util.net.jioendpoint$socketprocessor.run(jioendpoint.java:310) [tomcat-coyote.jar:7.0.42]     @ java.util.concurrent.threadpoolexecutor$worker.runtask(threadpoolexecutor.java:886) [na:1.6.0_29]     @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:908) [na:1.6.0_29]     @ java.lang.thread.run(thread.java:662) [na:1.6.0_29] caused by: javax.persistence.noresultexception: no entity found query     @ org.hibernate.ejb.queryimpl.getsingleresult(queryimpl.java:286) ~[hibernate-entitymanager-4.2.1.final.jar:4.2.1.final]     @ org.springframework.samples.knowledgemanager.repository.jpa.jpamedicationrepositoryimpl.finddrugword(jpamedicationrepositoryimpl.java:75) ~[jpamedicationrepositoryimpl.class:na]     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.6.0_29]     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) ~[na:1.6.0_29]     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) ~[na:1.6.0_29]     @ java.lang.reflect.method.invoke(method.java:597) ~[na:1.6.0_29]     @ org.springframework.aop.support.aoputils.invokejoinpointusingreflection(aoputils.java:317) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.reflectivemethodinvocation.invokejoinpoint(reflectivemethodinvocation.java:183) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:150) ~[spring-aop-3.2.5.release.jar:3.2.5.release]     @ org.springframework.dao.support.persistenceexceptiontranslationinterceptor.invoke(persistenceexceptiontranslationinterceptor.java:155) ~[spring-tx-3.2.5.release.jar:3.2.5.release]     ... 77 common frames omitted 

note: changing query em.find(drugword.class, wrd) identified different, unrelated error, resolved. showing concepts collection selected drugword, though there data in underlying table.

you can read other error in detail at link.

the problme might may forgot declare @entity on top of entity class or otherwise in configuration hbm2ddl might create instead of update.