Your choices are to use a bean, use a result map, or look to see if there is a way to get your driver to return the results as all lower case.
Larry On 10/11/05, Неверов Дмитрий <[EMAIL PROTECTED]> wrote: > Hi, I have statement: > > <statement id="getSA" parameterClass="java.util.HashMap" > resultClass="java.util.HashMap"> > <![CDATA[ > select t11.nplv_old as nplv, > nvl(t21.sname, ' ') as marka, > t41.conc as conc1, > t42.conc as conc2, > abs(to_number(t41.conc, '99.9999')-to_number(t42.conc,'99.9999')) > as razn, > i.id as interval > from him_head t11, sp_name_nsi t21, him_dev t31, him_an t41, him_head > t12, him_an t42, him_dev t32, sp_name_nsi t22, sp_interval i > where t11.id_mark = t21.id(+) > and t31.id_head = t11.id_head > and t31.dt_dev between to_date(#dataN#, 'dd.mm.yyyy hh24:mi') and > to_date(#dataK#, 'dd.mm.yyyy hh24:mi') > and t31.id_dev = 78 > and t41.id_analiz = t31.id_analiz > and t41.id_elem = #elementId:NUMERIC# > and t11.id_prob = #probaId1# > > and t12.id_mark = t22.id(+) > and t32.id_head = t12.id_head > and t32.dt_dev between to_date(#dataN#, 'dd.mm.yyyy hh24:mi') and > to_date(#dataK#, 'dd.mm.yyyy hh24:mi') > and t32.id_dev = 78 > and t42.id_analiz = t32.id_analiz > and t42.id_elem = #elementId:NUMERIC# > and t12.id_prob = #probaId2# > > and t11.nplv_old = t12.nplv_old > > and abs(to_number(t41.conc, '99.9999')-to_number(t42.conc, '99.9999')) > > to_number(i.conc_ot, '999.9999') > and abs(to_number(t41.conc, '99.9999')-to_number(t42.conc, '99.9999')) <= > to_number(i.conc_do, '999.9999') > ]]> > </statement> > > > As result I get a HashMap, but all keys of it in UpperCase: NPLV, > MARKA, CONC1... Can I get keys in lowercase? > > -- > Thanks. > mailto:[EMAIL PROTECTED] > > > > >
