Thanks Torben that is great news.
--
Jody Garnett
On 22 April 2015 at 15:47, Torben Barsballe <[email protected]>
wrote:
> 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 <[email protected]>
> wrote:
>
>> Initial feedback is we should manage those versions in the
>> dependencyManagement section.
>>
>> --
>> Jody Garnett
>>
>> On 21 April 2015 at 15:09, Torben Barsballe <[email protected]>
>> 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 <[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
>>>
>>>
>>
>
------------------------------------------------------------------------------
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
