Justin, see also this Jira issue from February. If you upgrade the driver and fix this failure, please resolve the issue:
Support PostgreSQL 9 hex bytea output format to avoid massive data corruption https://jira.codehaus.org/browse/GEOT-4040 Kind regards, Ben. On 12/10/12 21:08, Justin Deoliveira wrote: > I would use a property to make this configurable. Indeed I ran into this > same problem when trying to run postgis tests against a postgresql 9.1 > database. The protocol for blobs has changed which caused those tests to > fail. Since we want to support both major versions of postgresql it > makes sense that this version is configurable. > > Anyways, what you can do is this. > > 1. Define a property in the root pom, with the default being the current > postgresql jdbc driver version. > > <properties> > <postgresql.jdbc.version>8.4-701.jdbc3</postgresql.jdbc.version> > </properties> > > 2. Update the dependency management entry. > > <dependency> > <groupId>postgresql</groupId> > <artifactId>postgresql</artifactId> > <version>${postgresql.jdbc.version}</version> > </dependency> > > 3. In imagemosaic-jdbc/pom.xml simply override the property. > > <properties> > <postgresql.jdbc.version>9.1-901-1.jdbc4</postgresql.jdbc.version> > </properties> > > -Justin > > On Fri, Oct 12, 2012 at 2:57 AM, <christian.muel...@nvoe.at > <mailto:christian.muel...@nvoe.at>> wrote: > > Long story for short. The postgis raster online test was broken and > the fix is to update the postgres driver version. The module will not > work with 8.x postgres drivers. > > The global pom contains > > <dependency> > <groupId>postgresql</groupId> > <artifactId>postgresql</artifactId> > <version>8.4-701.jdbc3</version> > </dependency> > > The imagemosaic-jdbc pom has to specify its own version. > > <dependency> > <groupId>postgresql</groupId> > <artifactId>postgresql</artifactId> > <!-- Overriding version number from parent POM. --> > <version>9.1-901-1.jdbc4</version> > <scope>test</scope> > </dependency> > > Perhaps we should update the version in the global POM ?. > Btw, our postgis jdbc driver is also not up to date. > > Cheers > Christian > > > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > > > > ------------------------------------------------------------------------------ > Don't let slow site performance ruin your business. Deploy New Relic APM > Deploy New Relic app performance management and know exactly > what is happening inside your Ruby, Python, PHP, Java, and .NET app > Try New Relic at no cost today and get our sweet Data Nerd shirt too! > http://p.sf.net/sfu/newrelic-dev2dev > _______________________________________________ > GeoTools-Devel mailing list > GeoTools-Devel@lists.sourceforge.net > <mailto:GeoTools-Devel@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/geotools-devel > > > > > -- > Justin Deoliveira > OpenGeo - http://opengeo.org > Enterprise support for open source geospatial. > -- Ben Caradoc-Davies <ben.caradoc-dav...@csiro.au> Software Engineer CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev _______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
