Chapter 10. Integrating Java Technologies with Oracle Spatial

Chapter 6, Implementing New Functions, Chapter 7, Editing, Transforming, and Constructing Geometries, and Chapter 8, Using and Imitating Linear Referencing Functions, outlined how to embrace and extend the standard functionality available with Oracle Locator and Spatial using PL/SQL. PL/SQL is a programming language that is native to Oracle. Oracle also supports the creation of Java stored procedures. This chapter explores the application of Java to spatial processing involving the SDO_GEOMETRY type.

In this chapter, we will cover the following topics:

• Why Java and Oracle Spatial?

• Available Java spatial technologies

• Matching requirements to source code project

• Strengths and limitations of using Java

• How to download, modify, compile, and install external libraries

• Calling an external method

• Converting an SDO_GEOMETRY object to a Java object

• Exposing JTS Topology Suite functionality:

  • One-sided buffers

  • Snapping geometries

• Building polygons...