Torben, I have web access to ares Jenkins, but it would be great if you could set up the Jenkins build (perhaps called "geoserver-master-app-schema"?) as this would confirm that the instructions work, and we would then have more people who know about it. :-)
I am happy to help debug any problems. The instructions are here: http://docs.geoserver.org/latest/en/developer/programming-guide/app-schema/index.html To configure the fixtures we need to install postgis.properties and oracle.properties in ~/.geoserver and we hope ones identical to those in ~/.geotools will work (where ~ is the home directory of the build slave). You may need to add dbtype of postgis or oracle. The build procedure is: cd src/extension/app-schema mvn -nsu -Djava.awt.headless=true -Dtest.maxHeapSize=1024m -Dtest.maxPermSize=128m -Papp-schema-online-test clean test You could trigger this by the completion of geoserver-master. If using postgis 2.1 you also need to create two functions in the database: -- missing functions required for refdataset sql but removed in postgis 2.1 create or replace function public.ndims(g geometry) returns smallint as $$ begin return public.st_ndims(g); end; $$ language plpgsql immutable strict; create or replace function public.srid(g geometry) returns integer as $$ begin return public.st_srid(g); end; $$ language plpgsql immutable strict; 3D test support on PostGIS requires PostGIS 2 and an insert to add SRID 4979 (see the app-schema test guide). 3D support on Oracle requires SC40. Your link below is correct; in the manual you will find this deep link to the software buried in the instructions (see 3D section at the end). http://www.spatialdbadvisor.com/files/SC4O.zip You will likely need Rini's instructions to get SC4O to build (wsrv5 is a host name): https://www.seegrid.csiro.au/wiki/Infosrvices/AppSchemaTestDatabase I have copied Niels who implemented a lot of 3D functionality and tests. I am not blaming him, just identifying him as a possible alternative resource. :-) Phew! That is just about it. The fact that I am writing this email suggests that this section of the developer guide needs work; once you are happy with the new Jenkins job, you are best positioned to update the documentation, so please submit a pull request! More resources: Workaround for running without Oracle: https://jira.codehaus.org/browse/GEOS-6883 Reference data set: https://www.seegrid.csiro.au/wiki/Infosrvices/DataReferenceSet CSIRO build slave documentation: https://www.seegrid.csiro.au/wiki/Infosrvices/JenkinsGeoserverMasterTechnicalNotes Kind regards, Ben. On 16/04/15 05:36, Torben Barsballe wrote: > Ben - is this > <http://spatialdbadvisor.com/oracle_spatial_tips_tricks/280/announcing-the-spatial-companion-for-oracle-sc4o> > the spatial companion library we need? > > Thanks, > Torben > > On Wed, Apr 15, 2015 at 9:54 AM, Torben Barsballe < > [email protected]> wrote: > >> Hi Ben >> >> In yesterday's meeting, we discussed running automated app-schema tests. >> For now, lets run them against the same databases used for the geotools >> online database tests. >> >> You said you have a simple command that can run the app-schema tests in >> Jenkins? Do you have access to the ares Jenkins? If so, the database >> connection parameters for oracle and postgis can be found in the build >> configuration of the "geotool-master-online" job. Otherwise, do you want to >> send me the command, and I can set it up in Jenkins. >> >> I am fairly sure the Oracle DB does not have the "spatial companion" >> component needed for the 3d tests - I'll see what I can do about getting >> that installed. >> >> Torben >> > -- Ben Caradoc-Davies <[email protected]> Director Transient Software Limited <http://transient.nz> New Zealand ------------------------------------------------------------------------------ BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
