Hi:
I am trying to import data into my PostgreSQL/PostGIS database using the
JDBC image import tool. I get the following error when it tries to
commit to the database.
It looks like it has a problem with the configuration of my database
server but I cannot find a place to disable autoCommit. Any thoughts
would be greatly appreciated.
Java -jar %geotools%gt-imagemosaic-jdbc-2.6.4.jar import -config
map.xml -spatialTNPrefix tileosm -tileTNPrefix tileosm -dir
C:/data_nv/Nevada/vegas2 -ext tif
Oct 13, 2010 5:20:59 PM org.geotools.gce.imagemosaic.jdbc.Import logInfo
INFO: Truncating table : tileosm_0
Oct 13, 2010 5:20:59 PM org.geotools.gce.imagemosaic.jdbc.Import logInfo
INFO: Number of tiles to import: 7
Oct 13, 2010 5:21:00 PM org.geotools.gce.imagemosaic.jdbc.Import logInfo
INFO: Inserted tile vegas2_01_01.tif : 1/7
Oct 13, 2010 5:21:00 PM org.geotools.gce.imagemosaic.jdbc.Import logInfo
INFO: Inserted tile vegas2_01_02.tif : 2/7
Oct 13, 2010 5:21:00 PM org.geotools.gce.imagemosaic.jdbc.Import logInfo
INFO: Inserted tile vegas2_01_03.tif : 3/7
Oct 13, 2010 5:21:00 PM org.geotools.gce.imagemosaic.jdbc.Import logInfo
INFO: Inserted tile vegas2_01_04.tif : 4/7
Oct 13, 2010 5:21:00 PM org.geotools.gce.imagemosaic.jdbc.Import logInfo
INFO: Inserted tile vegas2_01_05.tif : 5/7
Oct 13, 2010 5:21:00 PM org.geotools.gce.imagemosaic.jdbc.Import logInfo
INFO: Inserted tile vegas2_01_06.tif : 6/7
Oct 13, 2010 5:21:00 PM org.geotools.gce.imagemosaic.jdbc.Import logInfo
INFO: Inserted tile vegas2_01_07.tif : 7/7
org.postgresql.util.PSQLException: Cannot commit when autoCommit is
enabled.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connect
ion.java:705)
at
org.geotools.gce.imagemosaic.jdbc.Import.sqlCommit(Import.java:1025)
at
org.geotools.gce.imagemosaic.jdbc.Import.fillSpatialTable(Import.java:85
2)
at
org.geotools.gce.imagemosaic.jdbc.Import.start(Import.java:397)
at
org.geotools.gce.imagemosaic.jdbc.Toolbox.main(Toolbox.java:46)
Thank you,
John Chaney
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
