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
