I'm using h2 in oracle mode and when I set double in prepareStatment the update process record only integer value. Someone would help me here is the sql
update tb_parametro p set p.nr_parametro = nvl(p.nr_parametro,0) + case when p.fl_data = 0 and (select c.fl_double from tb_contador c where c.cd_sigla_contador=? )= 1 then? else 1 end where p.cd_parametro = 8; -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
