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

Reply via email to