Not setting AutoCommit for database transaction
-----------------------------------------------
Key: GEOT-3295
URL: http://jira.codehaus.org/browse/GEOT-3295
Project: GeoTools
Issue Type: Bug
Affects Versions: 2.7-M3
Environment: OS: Windows XP 32-bit
Java: 1.6
Reporter: John Chaney
Having problems with uploading image mosaic data to a postgresql database with
an error being thrown describing a problem with autocommit. Below is my stack
trace.
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(AbstractJdbc2Connection.java:705)
at org.geotools.gce.imagemosaic.jdbc.Import.sqlCommit(Import.java:1025)
at
org.geotools.gce.imagemosaic.jdbc.Import.fillSpatialTable(Import.java:852)
at org.geotools.gce.imagemosaic.jdbc.Import.start(Import.java:397)
at org.geotools.gce.imagemosaic.jdbc.Toolbox.main(Toolbox.java:46)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
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
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
