Hi, I'm sorry but I can't reproduce it. It sounds like a problem with the precision of the value, but we would need a reproducible test case, and we don't have one. My test case (doesn't throw an exception):
create table test (INDEPY NUMERIC(5, 0)); insert into test values(-660); Regards, Thomas On Thu, May 3, 2012 at 8:59 AM, cool2man <[email protected]> wrote: > Hello, > > I "exported" my database to a script. > Running this script results into an error, whenever negative NUMERICs > are tried to be inserted into a table. The following error message is > written: > > 05-03 08:18:30.608: W/System.err(420): org.h2.jdbc.JdbcSQLException: > Value too long for column "INDEPY NUMERIC(5, 0)": "-660 (10)"; SQL > statement: xxxxxxxx > > After patching the negative numbers to zero, the script could be > processed without any errors. > > Thanks for h2! > > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" 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/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" 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/h2-database?hl=en.
