java - How to map a custom table returned from a stored procedure -


i'm using postgresql , hibernate, have stored procedure returns custom table, how map java bean custom table? wrote java class not sure if should use annotations.

my sp:

create or replace function reporte_gas_federal()   returns table(tipologia text, "número de clientes" bigint, "saturación de mercado" text, "distribución clientes nivel federal" text) $body$   cruce_tipo_gas      (select wise_ageb.id_ageb,                 wise_ageb.cvgeo_ageb,                 wise_ageb.tipo,                 nombre,tipologias_ageb.clave,                 wise_ageb_geom.geom            wise_ageb                 join wise_ageb_geom                   on wise_ageb.id_ageb = wise_ageb_geom.id_ageb                 join tipologias_ageb                   on tipologias_ageb.id_ageb = wise_ageb.id_ageb                 join tipologias                   on tipologias_ageb.clave = tipologias.clave),      conteo_parcial      (select distinct nombre,                          count(nombre) conteo            gasnatural_clientes                 inner join cruce_tipo_gas                         on st_intersects(cruce_tipo_gas.geom,                            gasnatural_clientes.geom)          group  by( nombre )          order  nombre asc),    cruce_manzana      (--obtiene cruce de las manzanas para pobtnener datos de pob         select id_manzana,                  clave            wise_manzana                 join cruce_tipo_gas using(id_ageb)),      pob_tipologia --poblacio total x tipologia      (select sum(cast(pobtot int))as poblacion,                 clave            wise_manzana_poblacion                 join cruce_manzana using (id_manzana)          group  clave),       conteo_total_pob --poblacion total en la region      (select sum(poblacion) pobtot            pob_tipologia),      conteo_total      (select sum(conteo) total            conteo_parcial) select     nombre "tipología",conteo "número de clientes",        concat( round(( ( conteo / total ) * 100 ),4),'%')    "saturación de mercado",        concat(round(( cast(conteo decimal) / pobtot ) * 100, 4), '%') "distribución clientes nivel federal"    conteo_parcial        cross join conteo_total         cross join conteo_total_pob order conteo desc;           $body$   language sql volatile   cost 100   rows 1000; alter function reporte_gas_federal()   owner postgres;

you can use rowmapper if have jdbctemplate example:

public customresult getcustomresult(){     final string sql = "call reporte_gas_federal";     final customresult customresult = (customresult) jdbctemplate.queryforobject(sql, new customresultrowmapper());      return customresult; }  public class customresultrowmapper implements rowmapper {     public object maprow(resultset rs, int rownum) throws sqlexception {         customresult customresult = new customresult();         customresult.set(...         ...         return customresult;     } }

otherwise can use resultransformer example:

customresult customresult = (customresult)session.createsqlquery("call reporte_gas_federal")     .setresulttransformer(new basictransformeradapter() {             private static final long   serialversionuid    = 1l;              @override             public object transformtuple(object[] tuple, string[] aliases){                 final customresult customresult = new customresult();                 customresult customresult = new customresult();                 customresult.set(...                 ...                 return customresult;             }     }).uniqueresult();

or .setresulttransformer(transformers.aliastobean(customresult.class)) instead of custom transformer.


Comments

Post a Comment

Popular posts from this blog

java - pagination of xlsx file to XSSFworkbook using apache POI -

right in code, reading xlsx file, xssfworkbook, , writing database. but, when size of xlsx file increases, causes outofmemory error. can not increase server size, or divide xlsx file pieces. tried loading workbook using file (instead of inputstream), didn't either. i looking way read 10k rows @ time (instead of entire file @ once) , iteratively write workbook , database. is there way apache poi? poi contains called "eventmodel" designed purpose. it's mentioned in faq : the ss eventmodel package api reading excel files without loading whole spreadsheet memory. require more knowledge on part of user, reduces memory consumption more tenfold. based on awt event model in combination sax. if need read-only access, best way it. however, may want double check first if issue somewhere else. check out this item : i think poi using memory! can do? 1 comes quite lot, reason isn't might think. so, first thing check - what's source of prob...
Read more

Unlimited choices in BASH case statement -

consider simple bash snippet: case $option in 1) image=${options[0]%.tar} ;; 2) image=${options[1]%.tar} ;; 3) image=${options[2]%.tar} ;; 4) image=${options[3]%.tar} ;; *) echo "invalid option" exit 1 esac in real script numbers goes 30. makes pretty long. can somehow specify cases variable? something this: case $option in $i) image=${options[$(($i-1))]%.tar} any pointer appreciated. you can match against multiple patterns in single clause: case $option in 1|2|3: echo "$option one, 2 or three" ;; esac if still typing you, can use simple pattern matching: case $option in # following matches # - single-digit numbers 0-9 # - two-digit numbers starting either 1 or 2 # - number 30 [0-9]|[12][0-9]|30) image=${options[$(($option-1))]%.tar} ;; *) echo "invalid option" 1>&2 exit 1 esac
Read more

apache - How do I stop my index.php being run twice for every user -

we've got webapp initial html served using apache , php. i noticed index.php being run twice every request. seems caused / effected rewrite rules in our .htaccess - rewritecond %{http_host} ^(www\.|hotels\.)ourdomain\.com$ [nc,or] rewritecond %{server_name} ^(www\.|hotels\.)ourdomain\.com$ [nc] rewriterule (.*) http://ourdomain.com/$1 [r=301] rewriterule ^hotels/([^/]+)/?\??(.*)$ ?d=$1&$2 [qsa] the final rule moving parameter url path query string. i.e. http://ourdomain.com/hotels/vegas?someparam=1 becomes http://ourdomain.com?d=vegas&someparam=1 if go directly query string version index.php run once. if use url redirected, index.php run twice (i'm checking adding error_log('end of index.php') file). so example going http://ourdomain.com/hotels/paris hits file twice http://ourdomain.com?d=paris hits once. i've seen this question , had @ blog mentioned , , can't find empty string url's (i've tried using yslow process). ...
Read more