H2 has some built in functions to work with csv files

select  count(id)  from  CSVREAD ('C:\users\richard\Downloads\testData.csv' , 'ID, NAME' )