claeis / ili2db

interlis import/export to relational databases
30 stars 30 forks source link

[ili2fgdb] error when try to delete/replace dataset #153

Open alellez opened 6 years ago

alellez commented 6 years ago

When we are trying to delete or replace dataset using ili2fgdb the following error is presented for every table in the model:

Error: failed to delete from "TABLE" Error: line 1:34: expecting "IS", found '=' Error: expecting "IS", found '='

claeis commented 6 years ago

can you add a log-file (generated with ili2fgdb options --trace --log logfile.log)?

claeis commented 6 years ago

can't reproduce

claeis commented 6 years ago

support DELETE FROM .. WHERE t_id = ?. Add it to SqlSyntax.g and implement in package ch.ehi.ili2fgdb.jdbc.sql

mizehn commented 5 years ago

I got the same error, after the import --delete or --replace dataset isn't possible: BL_Natstr_oereb_Log.txt

Import commands: _java -d64 -jar C:\iliTools\ili2fgdb-4.1.0\ili2fgdb-4.1.0.jar --trace --proxy proxy.kt.lunet.ch --proxyPort 8080 --import --defaultSrsCode 2056 --fgdbXyResolution 0.00005 --fgdbXyTolerance 0.0004 --dataset ch_astra_baulinien_nationalstrassen_oereb_xtf --dbfile BL_Natstr_oereb_neu.gdb --importTid --createBasketCol --createEnumTabs --beautifyEnumDispName --modeldir http://models.interlis.ch/;http://models.geo.admin.ch --models OeREBKRMtrsfr_V1_1 --log BL_Natstr_oereb_Log.txt ch.astra.baulinien-nationalstrassen.oereb20190506.xtf

Replace commands: _java -d64 -jar C:\iliTools\ili2fgdb-4.1.0\ili2fgdb-4.1.0.jar --trace --proxy proxy.kt.lunet.ch --proxyPort 8080 --replace --dataset ch_astra_baulinien_nationalstrassen_oereb_xtf --dbfile BL_Natstr_oereb_neu.gdb --log BL_Natstr_oereb_Log.txt ch.astra.baulinien-nationalstrassen.oereb20190506.xtf

mizehn commented 4 years ago

Will this issue be resolved in the near future? The missing replace option is quite a pain.

KTAI-GIS commented 3 months ago

Hi there What ist the actual status of this issue? I have the same problem with ili2fgdb_5.1.0. Please see my trace log file for more information fgdb_Test_Import_3102.log