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

  • 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…

  • 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…

  • One kilometer from home

    On March the 23rd, after five weeks of COVID-19 lockdown, president Sanchez announced that Spain will begin easing restrictions. In this first attempt at  loosening measures across the country, children…