Thanks very much, Ian, all gt-jdbc-postgis online tests now pass for me: [INFO] BUILD SUCCESS https://www.youtube.com/watch?v=r13riaRKGo0
If you are testing against postgres 9.3 or 9.4 and encounter LOB problems, you may need to: alter database YOUR_DATABASE_NAME set bytea_output = 'escape'; See: https://osgeo-org.atlassian.net/browse/GEOT-4040 https://osgeo-org.atlassian.net/browse/GEOT-5008 This problem may not affect ares if it is using an older posgres. I always set passwd and password in jdbc fixture properties files as there are fixtures that use one and fixtures that use the other. I have just updated geotools-master-online on ares to include both for all database fixtures and kicked the build. Kind regards, Ben. On 13/06/15 01:32, Ian Turton wrote: > OK I think I've caught all the TimeZone related problems - just waiting on > Jenkins to diasagree with me :-) > > I now have local LOB/CLOB failiures which aren't on Jenkins - may be a > 9.3/9.4 issue ? And connection issues with JNDI > > Unable to obtain connection: Cannot create PoolableConnectionFactory > (The server requested password-based authentication, but no password > was provided.) > > Which I can't reproduce but may be a fixture issue on ares, I think it > needs password and passwd set in the fixture file. > > Ian > > On Thu, Jun 11, 2015 at 2:56 PM Ian Turton <[email protected]> wrote: > >> Seems that some of the udt tests expect the result to be in GMT and since >> the laptop I was using yesterday is in GMT I didn't notice :-( >> >> I'm trying to work out what it's testing so I can fix it. >> >> Ian >> >> On Thu, 11 Jun 2015 12:44 pm Ben Caradoc-Davies <[email protected]> wrote: >> >>> Ian, >>> >>> Maven 3.2.5, OpenJDK 7 (7u79-2.5.5-1), postgresql-9.4 (9.4.3-1) on >>> debian/sid amd64. My timezone is NZST. >>> >>> Many of the failures display timestamps that are a day and an hour >>> different from expected. >>> >>> $ mvn -version >>> Apache Maven 3.2.5 (12a6b3acb947671f09b81f49094c53f426d8cea1; >>> 2014-12-15T06:29:23+13:00) >>> Maven home: /home/ben/java/maven >>> Java version: 1.7.0_79, vendor: Oracle Corporation >>> Java home: /usr/lib/jvm/java-7-openjdk-amd64/jre >>> Default locale: en_GB, platform encoding: UTF-8 >>> OS name: "linux", version: "4.0.0-1-amd64", arch: "amd64", family: "unix" >>> >>> Kind regards, >>> Ben. >>> >>> On 11/06/15 17:20, Ian Turton wrote: >>>> Are you running with mvn or eclipse? I tested with mvn and it was >>> correctly >>>> tearing down the DB and connections. >>>> >>>> Ian >>>> >>>> On Thu, 11 Jun 2015 2:59 am Ben Caradoc-Davies <[email protected]> >>> wrote: >>>> >>>>> Ian, >>>>> >>>>> after PR 872 was merged I now get several failures. >>>>> https://github.com/geotools/geotools/pull/872 >>>>> >>>>> I am using postgres 9.4. >>>>> >>>>> Failed tests: >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testEndedBy:162->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:76 >>>>> expected:<1> but was:<0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testTemporalJoin:196->JDBCTemporalFilterOnlineTest.assertDatesMatch:86 >>>>> expected:<2009-06-27 15:12:41.0> but was:<2009-06-28 15:12:41.0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testAfter:98->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:86 >>>>> expected:<2009-06-27 15:12:41.0> but was:<2009-06-28 15:12:41.0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testEnds:154->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:76 >>>>> expected:<1> but was:<0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testBegunBy:146->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:76 >>>>> expected:<1> but was:<0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testAfterInterval:107->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:86 >>>>> expected:<2009-09-28 16:54:23.0> but was:<2009-09-29 17:54:23.0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testTContains:178->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:86 >>>>> expected:<2009-01-14 12:10:12.0> but was:<2009-01-15 13:10:12.0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testBefore:117->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:86 >>>>> expected:<2009-01-14 12:10:12.0> but was:<2009-01-15 13:10:12.0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testBegins:138->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:76 >>>>> expected:<1> but was:<0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testDuring:170->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:86 >>>>> expected:<2009-01-14 12:10:12.0> but was:<2009-01-15 13:10:12.0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testBeforeInterval:126->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:86 >>>>> expected:<2009-01-14 12:10:12.0> but was:<2009-01-15 13:10:12.0> >>>>> >>>>> >>>>> >>> PostgisTemporalFilterOnlineTest>OnlineTestCase.run:123->JDBCTemporalFilterOnlineTest.testTEquals:185->JDBCTemporalFilterOnlineTest.assertDatesMatch:70->JDBCTemporalFilterOnlineTest.assertDatesMatch:86 >>>>> expected:<2009-01-14 12:10:12.0> but was:<2009-01-15 13:10:12.0> >>>>> >>>>> Kind regards, >>>>> >>>>> -- >>>>> Ben Caradoc-Davies <[email protected]> >>>>> Director >>>>> Transient Software Limited <http://transient.nz/> >>>>> New Zealand >>>>> >>>> >>> >>> -- >>> Ben Caradoc-Davies <[email protected]> >>> Director >>> Transient Software Limited <http://transient.nz/> >>> New Zealand >>> >> > -- Ben Caradoc-Davies <[email protected]> Director Transient Software Limited <http://transient.nz/> New Zealand ------------------------------------------------------------------------------ _______________________________________________ GeoTools-Devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
