Oracle Maps in JDeveloper 11g - Perfectly Fits into Enterprise. In this post I will describe how spatial logic in JDeveloper 11g can be combined with traditional non-spatial operations. Before reading this post, I suggest to read my previous post - Oracle Maps in JDeveloper 11g - Even More Simple, I describe there how to develop and run basic Oracle Maps application. Sample application implements a form with a table for search results, however there is no traditional search parameters in this form. Search criteria is defined using Oracle Maps functionality. Based on this criteria, query in database is executed and table with results is refreshed. It also allowed to update rows available in results table, changes are reflected in generated map as well.
Oracle Maps in JDeveloper 11g - Even More Simple. With JDeveloper 11g we have standard support for Databound Geographic Maps. This means we don't need anymore to be GIS (Geographic Information System) specialists to enable Location-Based functionality in our enterprise applications. It sounds cool? Yes, but also it works :). It took for me 10 minutes (or little bit more) to develop sample application for this blog post.
Oracle Spatial and TopLink 11g. This spring I was blogging about Oracle Spatial object type oracle.spatial.geometry.JGeometry support in TopLink Essentials JPA - Oracle Spatial and TopLink Essentials JPA. But time dont wait, and we already have TopLink 11g that comes with Oracle JDeveloper 11g Technical Preview 2. In TopLink 11g support for JGeometry object type is much simplified and can be used in more convenient way. Developed sample application contains Model and ViewController projects. In Model part, TopLink 11g is used to build persistence layer. In ViewController part, User Interface is developed with ADF Faces Rich Client. In order to run developed sample application you need to have Oracle MapViewer demo dataset MVDEMO in your database. You can download dataset from OTN and install it into your database as separate schema.
Oracle Spatial and TopLink Essentials JPA. It seems Oracle Spatial functionality can be used successfully with TopLink Essentials JPA also. I have reviewed in detail Doug Clarke (Principal Product Manager for Oracle TopLink) post about how it looks in theory - Oracle Spatial using TopLink Essentials JPA. And, have implemented described steps in practice. I have faced some issues, but final result is successful.
Oracle Maps portlet in Oracle WebCenter. In this sample I have developed spatially enabled portlet with Oracle Maps functionality and included it into Oracle ADF View layer using Oracle WebCenter framework. So, with Oracle WebCenter you can use spatially enabled portlets directly in Oracle ADF.
Oracle Object Types in Oracle ADF. While browsing through OTN JDeveloper forum, I have found a question about how to use Oracle Spatial MDSYS.SDO_GEOMETRY object type with ADF BC. So, I have developed sample application, that shows how to use MDSYS.SDO_GEOMETRY object type in ADF BC applications. However, all principles described in this sample, can be applied when using other Oracle Object Types in your applications.
Oracle Maps and ADF Faces af:table component. If you are tired from tables with data and want to see where is your data really is - just try to use spatial functionality with ADF Faces. In this post I'm describing how to develop spatially enabled data table using Oracle ADF.
