[FIXED] Insert BigDecimal from Java to Decimal in h2 database

Issue

I have create this table here:

As you can see from above. It successfully created a table However, when I tried this command:

I also tried to do in the h2 database:

At this point, I don't know where I did wrong. Is this my syntax or the bigdecimal problem. Please help me.

Solution

When you do the insert specify the columns by name

insert into mystock (name, date, open, high, low, close) values (....);

BTW Date is not a good column name

Answered By - Scary Wombat
Answer Checked By - Clifford M. (JavaFixing Volunteer)