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

how to prompt save As Box in Excel Interlop c# MVC 4 -

i want export excel sheet using excel interloop... i have datatable convert excel sheet... now there way save file using save dialogue box in mvc 4 here code public string datatabletoexcel(datatable dt, string htmlheading, string key) { try { microsoft.office.interop.excel.application excel; microsoft.office.interop.excel.workbook excelworkbook; microsoft.office.interop.excel.worksheet excelsheet; microsoft.office.interop.excel.range excelcellrange; excel = new microsoft.office.interop.excel.application(); excel.visible = false; excel.displayalerts = false; excelworkbook = excel.workbooks.add(type.missing); excelsheet = (microsoft.office.interop.excel.worksheet)excelworkbook.activesheet; excelsheet.name = "sheet1"; dataset ...
Read more

xslt 1.0 - How to access or retrieve mets content of an item from another item? -

my use case have item has link in item. example, item 123456789/152 has metadata field dc.relation.hasversion=123456789/717 . within item view of 123456789/152 , how can retrieve values of metadata of 123456789/717 ? example, want retrieve dc.language.iso value of 123456789/717 123456789/152 . i looked @ related items feature in dspace don't know how metadata displayed in related items list pulled items in list. i using dspace version 5.3 mirage 2 theme . edit based on schweerelos answer, below actual code. using custom metadata field dc.relation.languageversion . basically, want link other version instead of displaying value, display dc.language.iso of other version in item-view.xsl . i've incorporated answer of schweerelos question in code just displaying value of dc.relation.languageversion . sample values of dc.relation.languageversion 10665.1/9843 ; 10665.1/9844 ie not complete uri handle. thanks in advance! actual code <xsl:template name=...
Read more