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. Jeremy -- 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.
