Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Insert BigDecimal from Java to Decimal in h2 database

I have create this table here:

enter image description here

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

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

I also tried to do in the h2 database:
enter image description here

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

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading