Jeremy Evans wrote: > On Dec 19, 10:00 pm, Paul F Fraser <[email protected]> wrote: > >> Using Bignum type in a h2 db, create_table correctly sets up BIGINT(19) >> Trying to store 64 bit value, fails if value greater than max integer. >> >> If I change (in jdbc.rb approx line# 330) >> when Integer >> cps.setLong(i,arg) >> .... >> It works for both integer columns and bigint columns both saving and >> retrieving records, during my limited testing. >> This is with the h2 db only, I cannot comment on other jdbc db's. >> >> Is there another way of storing 64 bit values or do we need to find a >> way for sequel to handle java.long? >> > > Try the patch at http://pastie.org/750923.txt. It uses setInt for > Fixnums and setLong for other Integers. I'm not sure if this is > better or worse than just using setLong for everything though. > Anybody with Java knowledge care to chime in? > > Also, this code is only used in prepared statements, so one work > around would be to not use prepared statements. > > Does not work, Jeremy, The bigint is turning up as a type fixnum arg in the set_ps_arg method. Paul
-- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
