importer-exporter
importer-exporter copied to clipboard
3dcitydb
Successfully imported gml file, but geometry value in database is 'null'
Hello,
I'm trying to create an ADE based on this diagram:
Importing the GML file was done successfully, but when I check in the database the geometry table contains 'null'.
Is this due to an error in the XSD schema, java file, or something else? I've checked and compared with Test ADE but still haven't found a solution.
Have you implemented the Java code for importing your surface geometries? Please check the example code of the Test ADE here: https://github.com/3dcitydb/extension-test-ade/blob/master/test-ade-citydb/src/main/java/org/citydb/ade/test/importer/BuildingUnitImporter.java#L162
I already implemented it as follows:
Is there any other part that needs to be fixed to import the geometry values?
Hm, this is hard to debug just by the small code snippet. Have you checked the geometry table whether it contains entries? I guess it has entries because the log says "Processed geometry objects: 687".
If the geometry table contains entries, then is it just your ADE feature table that contains NULL for the foreign key columns to geometry? If so, maybe you are not correctly executing your PreparedStatement object ps in your code? Populating and managing the ADE feature tables is not done by the Importer/Exporter code but fully up to the ADE developer.
