Hello, These tickets have been resolved in jOOQ 1.6.6:
https://sourceforge.net/apps/trac/jooq/ticket/822 https://sourceforge.net/apps/trac/jooq/ticket/823 https://sourceforge.net/apps/trac/jooq/ticket/824 Relevant integration tests have been added. Thanks again for your feedback Cheers Lukas 2011/8/31 JC <[email protected]>: > Hi > > Using jooq 1.6.5 or 1.6.2 on Hsqldb 2.2.5 > > Im having a problem with scale when inserting into table a bigdecimal > when using dsl statement. > example: > > table z ( > d decimal(12,2) > ) > > create.insertInto(Z.Z,Z.D).values(new BigDecimal("5.19")).execute() > > The value on the database is 5.00 > Aparentely it scales before inserting into the database. > > if i do > > create.query("Insert into z values("+new BigDecimal("5.19+")") > > works fine, database returned 5.19 as it should.With createStatement > it works fine to. > > Tanks > Andre Bastos > >
