java - HSQLDB with multiple backing csv files -
i need bind group of csv file in format "yyyy-mm-dd hh:mm:ss.csv" present in same folder unique table contains data present in files.
i found how bind 1 file not how bind multiple files, example reading here or here couldn't find multiple backing files.
you cannot bind multiple files 1 table. options text tables documented here: http://hsqldb.org/doc/2.0/guide/texttables-chapt.html
you can use separate tables. file names can change, can write java code periodically list files in directory , link text tables more recent files. see set table t source ...
statement.
Comments
Post a Comment