Update: Oracle permissions should be fixed. PostGIS 3D support added.
Oracle 3D support is still pending.
I have ran into an error where Oracle test data (Oracle_Data_ref_set.sql)
is expecting the TESTTBS tablespace to exist. Howver, this tablespace is
not created anywhere in the sql script, or elsewhere in the app-schema
tests. It is also not mentioned in any of the app-schema instructions (as
far as I can see). Is this someting that should be set up when setting up
the test databases (in which case I can add it to the documentation), or
should this be done in the app schema test code (and if so, where - in the
test set up or in the actual Oracle_Data_ref_set.sql file)?
We also seem to be getting an excessive number of errors for the postgis
tests, suggesting that something is still not set up correctly.
Thanks,
Torben
On Wed, Apr 22, 2015 at 3:48 PM, Jody Garnett <[email protected]>
wrote:
> 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
>>>>
>>>>
>>>
>>
>
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
