As part of getting these tests working, I am upgrading the geoserver oracle
dependancies to Oracle 12 / ojdbc7. Pull request here:
https://github.com/geoserver/geoserver/pull/1021
Note that GeoTools has already been updated to use ojdbc7.
Torben
On Wed, Apr 15, 2015 at 2:09 PM, Ben Caradoc-Davies <[email protected]>
wrote:
> 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
