Torben, I could not find anything that might create the Oracle TESTTBS tablespace. It appears to be an undocumented requirement, perhaps a result of the database creation practices used by the corporate DBA team at the originating organisation (IIRC this was a dedicated test server). It might also be an artifact of Oracle tools.
Victor, do you remember having to request the creation of TESTTBS tablespace for Oracle reference data set tests? Or was it just there? Torben, please try creating the TESTTBS tablespace manually. If this works, we need to either update the documentation or the SQL. I can confirm that the app-schema-postgis-test tests are also failing. The root causes of the failures are concealed because many failures are occurring in xmlunit. - Please add -DquietTests=false to the maven command line to search for evidence. This will stop GeoServerBaseTestSupport from silencing loggers, which it does by default (quietTests is set to true in the top-level pom). - You might also find something in app-schema-postgis-test/target/surefire-tests that is not included in the Jenkins output. - Are you able to run the tests in Eclipse against the same database? This might give you console output that surefire does not capture. Kind regards, Ben. On 24/04/15 08:48, Torben Barsballe wrote: > 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 >>>>> >>>>> >>>> >>> >> > -- Ben Caradoc-Davies <[email protected]> Director Transient Software Limited <http://transient.nz/> New Zealand ------------------------------------------------------------------------------ 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
