search

orbisgis / h2gis

A spatial extension of the H2 database.
http://www.h2gis.org
GNU Lesser General Public License v3.0
208 stars 63 forks source link

multiple asc files into the same table #1270

Closed nicolas-f closed 2 years ago

nicolas-f commented 2 years ago

Add feature in order to add multiple asc files into the same table

Asc files may be tiled, it is interesting to have a method to read all asc files into the same output table

ebocher commented 2 years ago

If I understand well this change is to update an existing table not to create a tiled grid ?

Don't forget to update the https://github.com/orbisgis/h2gis/blob/master/docs/CHANGELOG.md file

ebocher commented 2 years ago

The test AscReaderDriverTest.testReadPrecipEnvelopePOSTGIS doesn't compile

ebocher commented 2 years ago

@nicolas-f any plan to fix this PR ?

ebocher commented 2 years ago

ping

ebocher commented 2 years ago

I have in mind that the autocommit must be set to false to take full advantage of the batch mode especially with pg driver ? Am I wrong ? By the way, why the create table throws an error with this PR ?

nicolas-f commented 2 years ago

So I restored autocommit(false) I had to change JDBCUtilities.isTableExists() because if you use this function into a Postgresql transaction, you will have to reopen a transaction if the table does not exists