Re: [Geoserver-devel] App-Schema online tests (take 2)

2016-05-19 Thread Ben Caradoc-Davies
Torben and Mike, my understanding is that SC4O is used only for 3D WKT parsing to set up the app-schema Oracle 3D test fixture. I expect that 3D geometries will work without it for app-schema, as they do for simple features. The problem is getting them into Oracle. I have submitted a web form

[Geoserver-devel] App-Schema online tests (take 2)

2016-05-19 Thread Torben Barsballe
Hello Ben Mike has been taking a look at setting up SC40 on the Oracle database used by ares for online tests, so that we can get the app-schema oracle tests working. He has found that SC

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

2016-03-28 Thread Niels Charlier
Hi Torben, Let me know which errors remain after you set up the 3D support. Regards Niels On 24-03-16 21:56, Torben Barsballe wrote: We are again trying to get 3D Geometry support on the Oracle test database. Consequently, I have re-enabled the oracle test fixture and the Oracle integration

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

2016-03-24 Thread Torben Barsballe
We are again trying to get 3D Geometry support on the Oracle test database. Consequently, I have re-enabled the oracle test fixture and the Oracle integration test on ares, so expect a few more build failure messages on the mailing list. FOr oracle, we appear to be getting a couple of legitimate t

[Geoserver-devel] App-Schema online tests and Maven update

2015-06-16 Thread Torben Barsballe
For GEOS-7092, the app schema oracle tests have been disabled. The app-schema-online build now passes! Tangentially related, Maven 3.2.5 and Maven 3.3.3 have been added to the ares Jenkins configuration, and can be enabled by setting the maven version for the "Invoke top level maven targets" build

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

2015-05-12 Thread Torben Barsballe
Hi Neils Oracle tests are going fine so far, there has been a bit of a delay since the DBA who manages the Oracle DB we are using has been out for the last couple weeks. The only real question I had was about the TESTTBS tablespace - based on the errors we are getting from the app-schema tests it

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

2015-05-12 Thread Niels Charlier
Hello Torben, Sorry for my late response. Picking up after a holiday. The oracle online tests are not so straight-forward to set up. Can I be of any assistance or have you sorted it out in the meantime? Regards Niels On 24-04-15 01:50, Torben Barsballe wrote: Excellent, good to know we are ma

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

2015-04-23 Thread Ben Caradoc-Davies
On 24/04/15 11:50, Torben Barsballe wrote: > Excellent, good to know we are making progress. > When I go through and update the documentation, I'll make these points a > bit more clear, rather than just showing up as an example. That would be much appreciated. > SC4O hasn't been added yet, so I t

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

2015-04-23 Thread Torben Barsballe
Excellent, good to know we are making progress. When I go through and update the documentation, I'll make these points a bit more clear, rather than just showing up as an example. SC4O hasn't been added yet, so I think that is why you are seeing that error. Torben On Thu, Apr 23, 2015 at 4:15 PM

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

2015-04-23 Thread Ben Caradoc-Davies
Torben, app-schema-postgis-test passed on Jenkins. I had a quick look and I think the only remaining failures are for Oracle (app-schema-oracle-test and Oracle reference data set tests in app-schema-test). [Correction: I added dbtype=postgisng (the one works for me locally).] I will be very in

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

2015-04-23 Thread Ben Caradoc-Davies
Correction: I added dbtype=postgisng (the one works for me locally). On 24/04/15 11:15, Ben Caradoc-Davies wrote: > I have added dbtype=postgis to the Jenkins pre-build script. -- Ben Caradoc-Davies Director Transient Software Limited New Zealand

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

2015-04-23 Thread Ben Caradoc-Davies
Aha! Oh, this sucks horribly, but the good news is that I had a peek into the Jenkins pre-build script and I can reproduce the failures locally against my own database and I think I have fixed them for you: (1) For both database types, both "password" and "passwd" are required. I have added "p

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

2015-04-23 Thread Torben Barsballe
I took a look the actuall test script (Oracle_Data_ref_set.sql) extracted from the test data jar, and it references the TESTTBS tablespace frequently, without ever creating it, so it seems like an undocumented requirement. I'll try and get that tablespace added to the Oracle DB. I've added -Dquiet

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

2015-04-23 Thread Ben Caradoc-Davies
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

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

2015-04-23 Thread Torben Barsballe
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 el

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

2015-04-22 Thread Jody Garnett
Thanks Torben that is great news. -- Jody Garnett On 22 April 2015 at 15:47, Torben Barsballe 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

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

2015-04-22 Thread Torben Barsballe
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 wrote: > Initial feedback is we should

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

2015-04-21 Thread Jody Garnett
Initial feedback is we should manage those versions in the dependencyManagement section. -- Jody Garnett On 21 April 2015 at 15:09, Torben Barsballe wrote: > As part of getting these tests working, I am upgrading the geoserver > oracle dependancies to Oracle 12 / ojdbc7. Pull request here: > ht

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

2015-04-21 Thread Torben Barsballe
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-Davie

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

2015-04-15 Thread Ben Caradoc-Davies
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 probl

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

2015-04-15 Thread Torben Barsballe
Ben - is this the spatial companion library we need? Thanks, Torben On Wed, Apr 15, 2015 at 9:54 AM, Torben Barsballe < tbarsba...@boundlessgeo.com> wrote: > Hi Ben > > In yesterday's me

[Geoserver-devel] App-Schema online tests

2015-04-15 Thread Torben Barsballe
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? I