[Geotools-devel] [JIRA] (GEOT-5261) [jdbc-spatialite] Datastore removeSchema doesn't delete geometry_columns record for dropped table

[Oscar Fonts (JIRA)]

Title: Message Title

Oscar Fonts created an issue   GeoTools / GEOT-5261 [jdbc-spatialite] Datastore removeSchema doesn't delete geometry_columns record for dropped table Issue Type: Bug Affects Versions: 14.0 Assignee: Unassigned Components: jdbc-spatialite plugin Created: 22/Oct/15 12:48 PM Priority: Medium Reporter: Oscar Fonts So: spatialiteDatastore.removeSchema(typeName); // Remove apparently OK, but spatialiteDatastore.createSchema(featureTypeWithSameName); // Recreating it fails with: 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) 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 Add Comment   This message was sent by Atlassian JIRA (v7.0.0-OD-08-002#70107-sha1:3f098e8)

------------------------------------------------------------------------------

_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel