Re: [Geoserver-devel] App-Schema online tests

[Torben B. <tba...@bo...>]

Updated to use dependencyManagement for version.
Merged to master
AppSchema tests are running now. Currently tracking down a permissions
issue with Oracle. PostGIS and Oracle 3D support is still pending.

Torben

On Tue, Apr 21, 2015 at 3:48 PM, Jody Garnett <jod...@gm...>
wrote:

> Initial feedback is we should manage those versions in the
> dependencyManagement section.
>
> --
> Jody Garnett
>
> On 21 April 2015 at 15:09, Torben Barsballe <tba...@bo...>
> wrote:
>
>> 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 <be...@tr...>
>> 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 <
>>>> tba...@bo...> 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 <be...@tr...>
>>> 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
>> Geo...@li...
>> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>>
>>
>