Happy new year-2009


Posted by Hafed | Posted in personal | Posted on 31-12-2008

The end of the year 2008 is fast approaching so it is time for me to comment on what happened, good or bad, this last year.

First of all, I participated in a wonderful Oracle migration project which took most of the year to complete. I have been doing quite some programing with Java, Oracle forms and PL/SQL. In addition, I had to fix a number of issues with our application. This blog has been updated quite regularly with the issues and solutions I have put in place. I hope to continue doing that in the coming year.

Quite notably, I was able to design MouliForms and a number of javabeans. It has been an interesting journey and the best part is the team I worked with. They have been very helpful, competent and nice to work with.

The year 2008 started very well as far as I am concerned. I was teaching Oracle Forms and Designer to two groups of extremely talented students. I had fun teaching evenings even though I was also working full time during the day too.

Unfortunately, 2008 ended on a sorry note, at least for now :). Right after getting an excellent evaluation from my students, I was let go as a lecturer.

While I thought this was just a passing annoyance, my contract in my current work got cancelled on christmas eve right before the holidays.

Well, when things start to go wrong, you can’t help it but pause, reflect and then move on. What can you do?

I know things will improve. After the rain, there is always sunshine.

Finally I would like to wish everyone a healthy, joyful and very productive 2009.

Static Google Map image Javabean in Oracle Forms 10g


Posted by Hafed | Posted in Forms, oracle, PJCs/Javabeans | Posted on 30-12-2008

Here is an output for a Javabean that shows the image from a Static Google Map.

Static Google Map Javabean output-Oracle forms 10g

The example shown here is for the google headquarters. The user inputs the address info in the Forms module and the Javabean takes care of fetching the data from Google Maps.

The process is done in two steps. First step is converting the address into Latitude and longitude (HTTP Geocoding) and then the static map is obtained from Google based on this info.

I will post the javabean here very soon.

File Selection Dialog with Oracle Forms 10g (10.1.2): replacing some of webutil functionalities


Posted by Hafed | Posted in Forms, oracle, PJCs/Javabeans | Posted on 24-12-2008

When you have a directory with a complicated hierarchical structure (nested sub-floders), using webutil to browse the folder is inadequate. This is mainly due to the use of JFileChooser which is notoriously slow in this case.

Since most implementations use JInitiator, one way to circumvent this problem is to implement a bean that will make use of AWT FileDialog.

Based on the fileuploader bean found in the oracle forms 10g demos, I have implemented a bean that provides file selection.

This has been tested on Forms 10g 10.1.2 on IBM AIX. Please note that the bean was put together in about 10 hours in order to resolve this specific directory browsing and file selection.

Download jar, pll and installation doc

Update: Here is the FMB with the demo: fileupload.fmb

Migration is over and our Oracle Forms 10g application is now in production


Posted by Hafed | Posted in Forms, oracle | Posted on 05-12-2008

We passed the test and our application has now been in production for 5 days.

A lot has happened since we started the Oracle forms migration to 10g (both the Database and application were migrated to 10g).

Some minor glitches did happen when our users started using the new webforms but overall we are having positive feedback.

Preliminary comments are mostly  related to pop-up blockers on IE that did not behave as expected. Remember that to display reports from Forms, we use web.show_document and this one opens up the pdf.

Webutil is also causing some concerns especially with the FILE functionalities (see http://forums.oracle.com/forums/thread.jspa?threadID=834438&tstart=0)

But overall with close to 1200 modules, it is quite an achievement that we did not have major issues.