Exception in thread "main" java.io.IOException: Error occurred creating table
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:757)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:144)
at co.geomati.geotools.Exporter.copyLayer(Exporter.java:370)
at co.geomati.geotools.Exporter.run(Exporter.java:231)
at co.geomati.geotools.Exporter.main(Exporter.java:132)
Caused by: java.sql.SQLException: columns f_table_name, f_geometry_column are not unique
at org.spatialite.NativeDB.throwex(NativeDB.java:213)
at org.spatialite.NativeDB._exec(Native Method)
at org.spatialite.Stmt.executeUpdate(Stmt.java:152)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.geotools.data.spatialite.SpatiaLiteDialect.postCreateTable(SpatiaLiteDialect.java:414)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:754)
... 4 more
When deleting and recreating the same table:
Exception in thread "main" java.io.IOException: Error occurred creating table at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:757) at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:144) at co.geomati.geotools.Exporter.copyLayer(Exporter.java:370) at co.geomati.geotools.Exporter.run(Exporter.java:231) at co.geomati.geotools.Exporter.main(Exporter.java:132) Caused by: java.sql.SQLException: columns f_table_name, f_geometry_column are not unique at org.spatialite.NativeDB.throwex(NativeDB.java:213) at org.spatialite.NativeDB._exec(Native Method) at org.spatialite.Stmt.executeUpdate(Stmt.java:152) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.geotools.data.spatialite.SpatiaLiteDialect.postCreateTable(SpatiaLiteDialect.java:414) at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:754) ... 4 more