Skip to content

Instantly share code, notes, and snippets.

@m-kuhn
Created October 25, 2019 11:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save m-kuhn/81487e4b9285e4989839513a71cfc664 to your computer and use it in GitHub Desktop.
Save m-kuhn/81487e4b9285e4989839513a71cfc664 to your computer and use it in GitHub Desktop.
java -jar ili2pg-4.1.0.jar --schemaimport --dbhost localhost --dbport 5432 --defaultSrsCode 2056 --dbdatabase horw --dbschema vw --dbusr postgres --dbpwd postgres --createBasketCol --trace View.ili
Info: dburl <jdbc:postgresql://localhost:5432/horw>
Info: dbusr <postgres>
Info: readSettings(): SELECT tag,setting FROM vw.T_ILI2DB_SETTINGS (TransferFromIli.java:699)
Info: ili2pg-4.1.0-aa1d00a37ee431852bdee6b990f34b3620f9c1c1
Info: ili2c-5.0.0-20190401
Info: iox-ili-1.20.11-13a1c5b39c33dae68eca9146e8b26d07cdedfebe
Info: java.version 1.8.0_222
Info: user.name <mkuhn>
Info: maxMemory 3593728 KB
Info: currentTime 2019-10-25 13:18:19
Info: dbschema <vw>
Info: dburl <jdbc:postgresql://localhost:5432/horw>
Info: dbusr <postgres>
Info: databaseProduct <PostgreSQL>
Info: databaseVersion <12.0 (Debian 12.0-2.pgdg100+1)>
Info: driverName <PostgreSQL JDBC Driver>
Info: driverVersion <42.1.4.jre6>
Info: postGISVersion <POSTGIS="3.0.0 r17983" [EXTENSION] PGSQL="120" GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel. 5.2.0, September 15th, 2018" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.3.1" WAGYU="0.4.3 (Internal)">
Info: readIliFiles(): SELECT filename,iliversion,modelName FROM vw.T_ILI2DB_MODEL (TransferFromIli.java:459)
Info: compile models...
Info: getModelRepos(): pathmap key <%ILI_FROM_DB> (Main.java:893)
Info: getModelRepos(): pathmap key <%XTF_DIR> (Main.java:893)
Info: getModelRepos(): pathmap key <%JAR_DIR> (Main.java:893)
Info: setRepositories(): uri <jdbc:postgresql://localhost:5432/horw/vw> (IliManager.java:86)
Info: setRepositories(): uri </tmp> (IliManager.java:86)
Info: setRepositories(): uri <http://models.interlis.ch/> (IliManager.java:86)
Info: setIliFiles(): uri <jdbc:postgresql://localhost:5432/horw/vw/> (IliManager.java:93)
Info: lookup model <Units> 2.3 in repository <jdbc:postgresql://localhost:5432/horw/vw/>
Info: lookup model <Base_LV95> 2.3 in repository <jdbc:postgresql://localhost:5432/horw/vw/>
Info: readIliFile(): SELECT content FROM vw.T_ILI2DB_MODEL WHERE filename=? (TransferFromIli.java:512)
Info: readIliFile(): SELECT content FROM vw.T_ILI2DB_MODEL WHERE filename=? (TransferFromIli.java:512)
Info: ilifile </home/mkuhn/.ilicache/jdbc&003apostgresql&003a/localhost&003a5432/horw/vw/Units-20120220.ili>
Info: ilifile </home/mkuhn/.ilicache/jdbc&003apostgresql&003a/localhost&003a5432/horw/vw/Base_d-20140418.ili>
Info: ilifile <View.ili>
Info: read(): SELECT iliname,tag,setting FROM vw.T_ILI2DB_TRAFO (TrafoConfig.java:36)
Info: doSmartOff(): viewable View_LV95.MyView.Tbl newClass, tbl (Viewable2TableMapper.java:218)
Info: doSmartOff(): viewable View_LV95.View_LK.ViewProjected newClass, viewprojected (Viewable2TableMapper.java:218)
Info: create table structure, if not existing...
Info: generateViewable(): wrapper of viewable CLASS View_LV95.MyView.Tbl (TransferFromIli.java:258)
Info: generateViewable(): wrapper of viewable VIEW View_LV95.View_LK.ViewProjected (TransferFromIli.java:258)
Info: generateViewable(): wrapper of viewable CLASS View_LV95.MyView.Tbl (TransferFromIli.java:258)
Info: generateViewable(): wrapper of viewable VIEW View_LV95.View_LK.ViewProjected (TransferFromIli.java:258)
mapping of ili-classes to sql-tables failed
ch.ehi.ili2db.base.Ili2db.runSchemaImport(Ili2db.java:1170)
ch.ehi.ili2db.base.Ili2db.run(Ili2db.java:223)
ch.ehi.ili2db.AbstractMain.domain(AbstractMain.java:533)
ch.ehi.ili2pg.PgMain.main(PgMain.java:70)
mapping of View_LV95.View_LK.ViewProjected failed
ch.ehi.ili2db.fromili.TransferFromIli.generatModelEles(TransferFromIli.java:199)
ch.ehi.ili2db.fromili.TransferFromIli.doit(TransferFromIli.java:159)
ch.ehi.ili2db.base.Ili2db.runSchemaImport(Ili2db.java:1168)
ch.ehi.ili2db.base.Ili2db.run(Ili2db.java:223)
ch.ehi.ili2db.AbstractMain.domain(AbstractMain.java:533)
ch.ehi.ili2pg.PgMain.main(PgMain.java:70)
View_LV95.View_LK.ViewProjected.Geometrie
ch.ehi.ili2db.fromili.FromIliRecordConverter.generateTable(FromIliRecordConverter.java:291)
ch.ehi.ili2db.fromili.TransferFromIli.generateViewable(TransferFromIli.java:261)
ch.ehi.ili2db.fromili.TransferFromIli.generatModelEles(TransferFromIli.java:193)
ch.ehi.ili2db.fromili.TransferFromIli.doit(TransferFromIli.java:159)
ch.ehi.ili2db.base.Ili2db.runSchemaImport(Ili2db.java:1168)
ch.ehi.ili2db.base.Ili2db.run(Ili2db.java:223)
ch.ehi.ili2db.AbstractMain.domain(AbstractMain.java:533)
ch.ehi.ili2pg.PgMain.main(PgMain.java:70)
java.lang.NullPointerException
ch.ehi.ili2db.fromili.FromIliRecordConverter.generateAttr(FromIliRecordConverter.java:562)
ch.ehi.ili2db.fromili.FromIliRecordConverter.generateTable(FromIliRecordConverter.java:287)
ch.ehi.ili2db.fromili.TransferFromIli.generateViewable(TransferFromIli.java:261)
ch.ehi.ili2db.fromili.TransferFromIli.generatModelEles(TransferFromIli.java:193)
ch.ehi.ili2db.fromili.TransferFromIli.doit(TransferFromIli.java:159)
ch.ehi.ili2db.base.Ili2db.runSchemaImport(Ili2db.java:1168)
ch.ehi.ili2db.base.Ili2db.run(Ili2db.java:223)
ch.ehi.ili2db.AbstractMain.domain(AbstractMain.java:533)
ch.ehi.ili2pg.PgMain.main(PgMain.java:70)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment