I recently got geonde set up to use ssl when connecting to postgres, and
did manage to upload a few shapefiles and a raster.
This week, I get an java.io.IOException error when ever I try to upload a
shapefile.
28 Feb 08:30:52 ERROR [geoserver.rest] -
java.lang.RuntimeException: java.io.IOException: Error occurred creating
table
...
Caused by: java.io.IOException: Error occurred creating table
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:660)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:138)
at
org.geoserver.catalog.rest.DataStoreFileResource.handlePut(DataStoreFileResource.java:316)
... 71 more
Caused by: org.postgresql.util.PSQLException: Cannot commit when autoCommit
is enabled.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:705)
Nothing has changed. I have verified my datastore.xml file has the correct
information. I logged into postgres manually using the data in the
datastore.xml file and was able to create and drop tables with out error.
I made the db user a super user hoping it was a permission problem but it
was not.
The postgres log provides little insight as well.
LOG: database system is ready to accept connections
ERROR: table "UGB_2010" does not exist
CONTEXT: SQL statement "DROP TABLE public."UGB_2010""
PL/pgSQL function "dropgeometrytable" line 22 at EXECUTE statement
STATEMENT: SELECT DropGeometryTable ('UGB_2010')
I have restarted tomcat, apache, and postgres but the error persists.
Still kind of new to geonode/geoserver so I'm not sure where to go next
with debugging this.
--
--Markus Weltin
Programmer II
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
