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