How to import CSV files to an H2 Database

1. Start the H2 database without opening the browser window (opened by default)
2. Added support for the BigDecimal type for database creation SQL statements. By default, the h2 database does not support the bigdecimal type:

SQL code
Copy codeThe Code is as follows:
Create table test (id int (11), charge BigDecimal (12 ))

SQL code
Copy codeThe Code is as follows:
Create table test (id int (11), charge BigDecimal (12 ))


3. Import database scripts by passing Parameters
Copy codeThe Code is as follows:
New Console (). runTool ();
New RunScript (). runCustomTool ("jdbc: h2 :~ /Test "," sa "," "," c:/schema. SQL ");

Import CSV files to the H2 Database
Copy codeThe Code is as follows:
Insert into prefill (select * from csvread ('C:/JV/Demo/prescription2012-05-10 22-26-37.csv '));