java - Jdbctemplate query: EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0 -


i using jdbctemplate retrieve list of 'spittles' db. here method.

private static final string sql_select_spittle =                     "select id, spitter_id, spittletext, postedtime spittle";  public list<spittle> getrecentspittles() {                 return jdbctemplate.query(sql_select_spittle, new rowmapper<spittle>() {      public spittle maprow(resultset resultset, int i) throws sqlexception {                         spittle spittle = new spittle();                         spittle.setid(resultset.getlong(1));                         spittle.setspitter(getspitterbyid(resultset.getlong(2)));                         spittle.settext(resultset.getstring(3));                         spittle.setwhen(resultset.getdate(4));                         return spittle;                     }                 });             }

here table database

  id  spitter_id spittletext           postedtime   1       0        hello               2015-08-24   2       4        i've been in london!2015-08-25   3       3        i'm glad            2015-08-28

here stack trace: 

info: refreshing org.springframework.context.annotation.annotationconfigapplicationcontext@1b8d17c: startup date [sun aug 30 22:36:35 cest 2015]; root of context hierarchy sie 30, 2015 10:36:36 pm org.springframework.beans.factory.support.defaultlistablebeanfactory registerbeandefinition info: overriding bean definition bean 'jdbctemplatespitterdao' different definition: replacing [generic bean: class [com.gnology.springdataaccess.implementations.jdbctemplatespitterdao]; scope=singleton; abstract=false; lazyinit=false; autowiremode=0; dependencycheck=0; autowirecandidate=true; primary=false; factorybeanname=null; factorymethodname=null; initmethodname=null; destroymethodname=null; defined in file [c:\users\damian\jdbc-project\target\classes\com\gnology\springdataaccess\implementations\jdbctemplatespitterdao.class]] [root bean: class [null]; scope=; abstract=false; lazyinit=false; autowiremode=3; dependencycheck=0; autowirecandidate=true; primary=false; factorybeanname=appconfiguration; factorymethodname=jdbctemplatespitterdao; initmethodname=null; destroymethodname=(inferred); defined in com.gnology.springdataaccess.appconfiguration] sie 30, 2015 10:36:36 pm org.springframework.beans.factory.annotation.autowiredannotationbeanpostprocessor <init> info: jsr-330 'javax.inject.inject' annotation found , supported autowiring exception in thread "main" org.springframework.dao.emptyresultdataaccessexception: incorrect result size: expected 1, actual 0     @ org.springframework.dao.support.dataaccessutils.requiredsingleresult(dataaccessutils.java:71)     @ org.springframework.jdbc.core.jdbctemplate.queryforobject(jdbctemplate.java:797)     @ com.gnology.springdataaccess.implementations.jdbctemplatespitterdao.getspitterbyid(jdbctemplatespitterdao.java:74)     @ com.gnology.springdataaccess.implementations.jdbctemplatespitterdao$2.maprow(jdbctemplatespitterdao.java:94)     @ com.gnology.springdataaccess.implementations.jdbctemplatespitterdao$2.maprow(jdbctemplatespitterdao.java:90)     @ org.springframework.jdbc.core.rowmapperresultsetextractor.extractdata(rowmapperresultsetextractor.java:93)     @ org.springframework.jdbc.core.rowmapperresultsetextractor.extractdata(rowmapperresultsetextractor.java:60)     @ org.springframework.jdbc.core.jdbctemplate$1querystatementcallback.doinstatement(jdbctemplate.java:459)     @ org.springframework.jdbc.core.jdbctemplate.execute(jdbctemplate.java:404)     @ org.springframework.jdbc.core.jdbctemplate.query(jdbctemplate.java:470)     @ org.springframework.jdbc.core.jdbctemplate.query(jdbctemplate.java:480)     @ com.gnology.springdataaccess.implementations.jdbctemplatespitterdao.getrecentspittles(jdbctemplatespitterdao.java:90)     @ com.gnology.springdataaccess.implementations.spitterserviceimpl.getrecentspittles(spitterserviceimpl.java:32)     @ com.gnology.springdataaccess.main.main(main.java:19)     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method)     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62)     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43)     @ java.lang.reflect.method.invoke(method.java:483)     @ com.intellij.rt.execution.application.appmain.main(appmain.java:134)

yesterday haven't got problems that, don't know error. how can fix this? in advance.


-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being
Read more

Delphi 7 and decode UTF-8 base64 -

in delphi 7, have widestring encoded base64(that received web service widestring result) : pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg== when decoded it, result not utf-8: <?xml version="1.0"?> <string>طھط³طھ</string> but when decoded base64decode.org, result true : <?xml version="1.0"?> <string>تست</string> i have use encddecd unit decodestring function. the problem have using decodestring . function, in delphi 7, treats decoded binary data being ansi encoded. , problem text utf-8 encoded. to continue encddecd unit have couple of options. can switch decodestream . instance, code produce utf-8 encoded text file data: {$apptype console} uses classes, encddecd; const data = 'pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg=='; var input: tstringstream; output: tfilestream; begin input := tstringstream.create(data); try output := tfilestream.
Read more

html - Is there any way to exclude a single element from the style? (Bootstrap) -

so, have img logo, overlaid on div styled background-image: url("...") , , both elements inside 2 div classes .to-color , .to-overlay respectively, black transparent overlay. is there way exclude logo style given these 2 classes? here's jsfiddle example: link html , css example: - html - <div class="to-color"> <div class="to-overlay"> <div class="respo"> <div class="row"> <div class="col-xs-4 col-xs-offset-4 text-center"> <img src="http://ansonalex.com/wp-content/uploads/2011/06/google-logo-768x260.png" alt="..." class="img-responsive"> </div> </div> </div> </div> </div> - css - .to-color { background-color: #000; } .to-overlay { opacity : 0.5; } .respo { background-image: url("https://source.unsplash.com/category/objects/1600x900"); background-position: center center;
Read more