Oracle Developer Tools and PlatformsBig data Tools and platforms, Oracle Developer tools (Forms, Reports, APEX)

The 0.12 release is now available and can be downloaded from the sourceforge page.

I will be making a special page for this bean here on degenio.com. In the meantime, let me know of any special features you would like to see in this bean.

In version 0.13, I will be adding other languages and polylines.

If I have time, I will get Rhino to work with the gmap form module and from there use Google map with directions. So, within the form module, you should be able to get directions from point A to point B.

Special, special: Today, March Friday 13th (what a coincidence!) is the last day for the PJC competition. We have a heated race over there and it should be a very close call. If you did not vote, please go here and VOTE

Here is an update to the static google map. I have added the following:

• User can now enter address info using only latitude and longitude
• User can zoom in and zoom out using a popup menu on the image itself
• User can pan (vertical and horizontal) in either directions.
• Some minor changes to the class structure. Now using Mercator projections for panning.

In order to better manage this project, I will upload everything on sourceforge this week.

Here is a screenshot:

Here is an update with the files for implementing a javabean that displays a static google map for a given location.

In a number of back-end applications, users as well as entities are registered with their address information. In some cases, it is desired to provide a visual representation of this address information.
A free service that is provided by Google allows us to obtain the map for a given address as well as additional info such as directions from a given point to this address.

This is a bit difficult to implement in Oracle Forms 10g since the Google API is based on Javascript. In those cases where Javascript is blocked or not possible, Google provides another service which is called Google Static maps.

What this service provides is a static image of the map based on the address information. This can be sufficient in a number of Forms applications.

In this note, we provide a javabean that will display the static map in addition to the latitude and longitude corresponding to the address provided by the user (or fetched from a table).

First, we will use the Google Maps HTTP geocoding service to retrieve the latitude and longitude. Then, we use this data to fetch the static map from the Google static map service.

This javabean can be used either with the SUN JRE or Oracle Jinitiator. It has been tested with Jinitiator 1.3.1.22 and 1.3.1.29.

Download the jar, java file, sample FMB and the technical note

Please note that the javabean has also been submitted to the Pluggable Java Component & JavaBean ‘s library website maintained by Francois Degrelle.