Hi
I'm trying to set up a versioned postgis datastore but ending with some errors
(see below). Do I have to create some special tables in the database first and
insert the tables the should be versioned? As far as I understand the source
code, the tables ('changesets' etc.) should be created by GeoTools. At least
there's some "CREATE TABLE" code.
(Using GeoTools 2.6.1)
VersionedPostgisDataStoreFactory fact = new VersionedPostgisDataStoreFactory();
Map params= new HashMap();
params.put("dbtype", "postgis-versioned");
params.put("host", "localhost");
params.put("port", Integer.valueOf(5432));
params.put("database", "sogis");
params.put("schema", "av");
params.put("user", "XXXXXX");
params.put("passwd", "XXXXXX");
params.put("namespace", "http://www.geoserver.org/versioning";);
DataStore store = fact.createDataStore(params);
Throws following error:
org.geotools.data.DataSourceException: Error querying database for
list of tables:ERROR: relation "av.changesets" does not exist
at
org.geotools.data.postgis.VersionedPostgisDataStore.checkVersioningDataStructures(VersionedPostgisDataStore.java:974)
at
org.geotools.data.postgis.VersionedPostgisDataStore.<init>(VersionedPostgisDataStore.java:166)
at
org.geotools.data.postgis.VersionedPostgisDataStoreFactory.createDataStoreInternal(VersionedPostgisDataStoreFactory.java:177)
at
org.geotools.data.postgis.VersionedPostgisDataStoreFactory.createDataStore(VersionedPostgisDataStoreFactory.java:141)
at org.catais.interlis.App.main(App.java:52)
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"av.changesets" does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1591)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1340)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at
org.geotools.data.postgis.VersionedPostgisDataStore.execute(VersionedPostgisDataStore.java:1383)
at
org.geotools.data.postgis.VersionedPostgisDataStore.checkVersioningDataStructures(VersionedPostgisDataStore.java:956)
... 4 more
regards
Stefan
mit freundlichem Gruss
Stefan Ziegler
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
