Home Articles Developing web-based spatial applications with Oracle JDeveloper 9i, Struts, Spatial and MapViewer

Developing web-based spatial applications with Oracle JDeveloper 9i, Struts, Spatial and MapViewer

Jayant Sharma and Liujian Qian
Spatial Products, Oracle New England Development Center
Nashua, NH 03062, USA
Email: [email protected], [email protected]

Abstract
Struts is an open source framework for building Web applications that integrates with J2EE technologies like Java Servlets, JavaServer Pages and JavaBeans. Struts enables Web application development which follow the Model-View-Controller (MVC) design paradigm. Oracle9i JDeveloper includes integrated Struts development. This paper describes how to build interactive spatial Web applications, using Jdeveloper and Struts, that present spatial and non-spatial deliver from an Oracle database server. The spatial data is stored and retrieved using Oracle Spatial, and rendered by MapViewer. We will use the Trading Community Architecture (TCA), which a subset of the underlying data model for the Oracle eBusiness Suite of applications, to illustrate how a location enabled web application could be built using the Oracle platform.

The paper briefly describes the TCA model, and how existing Oracle Location based technology can be combined with TCA to enable business data using spatial technology. It explains how locations for customers, prospects, sales offices, competitors, and sales and tax zones are represented and used in this model. Next it explains the use of Jdeveloper and Struts in building a web mapping application that lets a user visualize tax and sales zones, determine which customers are within a specified distance from a point on the map identified by a mouse click, and determine which sales or tax zone a user identified point lies within.