Summary
The thrust of this chapter has been to show, in a step-by-step manner, how existing open source Java-based algorithms and solutions can be made available to enhance or compliment Oracle SDO_GEOMETRY based processing. The reasons why recourse to Java-based stored procedures should be considered were covered. The following were identified as the chief criteria for determining a core Java platform on which to build functionality, with JTS Topology Suite being chosen:
Common geometry type hierarchy
Conversion methods
A source of quality existing spatial algorithms
You were then shown how to download, compile, package, and load the required JTS source code into the Oracle database. Source code-based class development was covered as was the creating and loading via a single JAR file JTS. A PL/SQL package called SPatialEXtension (SPEX) was created that provided SQL access to the Java classes in the jar file. A number of JASPA and JTS based functions were documented with examples of how to use...
