>
>
>
> Message: 1
> Date: Tue, 28 Feb 2012 10:03:50 -0800
> From: Markus Weltin <mwel...@pdx.edu>
> Subject: [Geoserver-users] Error occurred creating table
> To: Geoserver-users@lists.sourceforge.net
> Message-ID:
> <CAGKVb_KYXg9BZwwmXP+aCWTei=kyzvkk2i1xvtawuszos_p...@mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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
>
As it turned out the fix was to down grade my jdbc postgres driver from
postgresql-9.1-901.jdbc4.jar to postgresql-8.4-703.jdbc3.jar. After a
tomcat restart everything seemed to work as expected.
-Markus Weltin
------------------------------------------------------------------------------
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users