Hi John, I am the module maintainer. Scanning through the source code I see the problem. The import utility relies on a non autocommit connection but does not call setAutoCommit(false) if necessary.
This is a bug in the geotools library for 2.6.x and trunk. Could you open a geotools JIRA issue and assign it to me ?. If you are unsure, I can do this for you. Which version do you use ?. I can package a new jar file and send it to you directly. Cheers Christian Quoting "Chaney, John H" <[email protected]>: > 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 > > > > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ 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
