topografico copy

Adding Oracle support for 52N-SOS server

We have been collaborating with 52º North the last months. Precisely, we have been working on the Oracle support for the new release of the Sensor Observation Service server: 52N-SOS 4.0 [1].

The problem we were facing was that the last stable version (52N-SOS 3.2.0) is not capable of get the sensor data from Oracle databases and Oracle was a requirement of our customer, so moving the data to PostgreSQL was not an option.

We also knew that a new version was being actively developed by the 52º North community and that it was using Hibernate to access data. So we decided that our goal was to cooperate with the 52º North community to get Oracle working via Hibernate.

We put our hands to work and we implemented the Oracle database access, including some generic test data creation that we shared with PostgreSQL. Right now this part is being rebuilt on top of our first implementation.

Aside from implementing the Oracle database access and share some code with the PostgreSQL part, we also improved a little the error messages for the installation process and the test client.

Finally, we produced some documentation to build and install Oracle and the 52N-SOS 4.0 server with support for it. You can check this instructions in the official 52º North website [2][3].

This work was financed by the Barcelona Port Authority as part of their Sensor Observation Service deployment.

[1] https://wiki.52north.org/bin/view/SensorWeb/SensorObservationServiceIV
[2] https://wiki.52north.org/bin/view/SensorWeb/SensorObservationServiceIVDocumentation#Oracle_support
[3] https://wiki.52north.org/bin/view/SensorWeb/SensorObservationServiceIVDocumentation#Oracle_installationWe have been collaborating with 52º North the last months. Precisely, we have been working on the Oracle support for the new release of the Sensor Observation Service server: 52N-SOS 4.0 [1].

The problem we were facing was that the last stable version (52N-SOS 3.2.0) is not capable of get the sensor data from Oracle databases and Oracle was a requirement of our customer, so moving the data to PostgreSQL was not an option.

We also knew that a new version was being actively developed by the 52º North community and that it was using Hibernate to access data. So we decided that our goal was to cooperate with the 52º North community to get Oracle working via Hibernate.

We put our hands to work and we implemented the Oracle database access, including some generic test data creation that we shared with PostgreSQL. Right now this part is being rebuilt on top of our first implementation.

Aside from implementing the Oracle database access and share some code with the PostgreSQL part, we also improved a little the error messages for the installation process and the test client.

Finally, we produced some documentation to build and install Oracle and the 52N-SOS 4.0 server with support for it. You can check this instructions in the official 52º North website [2] [3].

This work was financed by the Barcelona Port Authority as part of their Sensor Observation Service deployment.

[1] https://wiki.52north.org/bin/view/SensorWeb/SensorObservationServiceIV
[2] https://wiki.52north.org/bin/view/SensorWeb/SensorObservationServiceIVDocumentation#Oracle_support
[3] https://wiki.52north.org/bin/view/SensorWeb/SensorObservationServiceIVDocumentation#Oracle_installation

Do you have a project idea and want to turn it into reality? We would like to hear from you, tell us about it

The facts define us

  • Real-time public transportation visualization

    https://vimeo.com/540079821/ Real-time visualization for the Barcelona metro and bus services Since 2016, Geomatico has been working with the Barcelona public transport agency (Transports Metropolitans de Barcelona, ​​TMB) for GIS development…

  • Civil works monitoring using satellite imagery and machine learning

    Using up-to-date satellite imagery is nowadays mandatory to the decision-making process in many areas: agriculture, environment, water resources … Checking present and historical views of a site can be of…

  • Customised GIS training for your sector

    Our experience tells us that the best way to consolidate knowledge and have your staff effectively integrate GIS as a daily tool is through customised courses for your business. Generalist…

  • 9 years with Barcelona Natural Science Museum

    Geolocation is a key attribute for activity in a natural science museum since cartography is present in almost all its fields of activity: collections, research, publications, exhibitions, etc. The collaboration…