I have the following scenario:
- Oracle database without the space module.
- Application in JEE2 with the following architecture: -- Entity -- Persistence (DAO / JPA + JDBC) -- Business (BC) -- Vision (MB + JSF)
I have an entity called EQUIPMENT must have the attribute COORD. Persist this entity in the database is easy, I'll use JPA.
When I enter the system, it should use geolocation to determine the position of the equipment and check if its position is a certain radius from what is recorded in the database.
Which APIs should I use to do this type of query considering I do not have the space module of the Oracle?