The Forms and Reports-Service-Installation from an assistant fails, and it was an issue with the apache-configuration,
check if the host you are installing has an DNS-Suffix.
If not uninstall of the server, giving a Suffix and reinstalling let the installation work
I could not find an possibility to install it without an DNS-Suffix.

phpbb simple machines forum Some time ago i needed a forum software and took a look at the open-source-community. There were a lot of forums out there the most used is phpBB. The installation worked fine and everything was fine. The only thing was that there was no file upload/download function within the forum.

But after googeling around for a while i found a common mod for implementing this functionality. The installation of the mod was a damned hard thing, i had to edit about 20 files. Alternatively you could install already patched files, but the problem was that my forum was already installed and configrured, and so i would have to reconfigure it.... But after that it worked.

Some weeks after launching the forum a new version was released. Nothing big, so i followed the installations-instructions and they said that i had to reinstall all mods.... damn... the other possibility was to patch the files automatically. It took me a long time to install this patch. After some more weeks another patch was sent, and i realized that the mainenance of this forum costs a lot of time.

The next problem that occured was when my provider called me, some script tried to cheat around in my account. The vulnerability was.... phpBB... so i shut down the forum. But there were a lot of people that wanted to have access to the old messages, so i began to look to an alternative forum, and came across the Simple Machines Forum (SMF). I know this forum because Joomla, my favourite CMS is using it.

So i gave it a try, and installed it, it looked fine, easy to install easy to maintain, with the possibility to install and unistall mods automatically, very fast and very good looking :-)

And by accident i  came across an migration-script from phpBB to SMF, and also gave it a try.... and could not believe it, the users, rights, threads, forums, attachments!!! were migrated and still working! My forum is up again and enhanced with several mods like a chat-mod and other nice features.

I can just recommend this software. 

Timers are an programmatic construct to do something after a certain period of time. You construct them with "CREATE_TIMER" and do the Events in the WHEN-TIMER-EXPIRED trigger. 

If you are discussing about do's and don'ts in forms and webforms the statement is posted "Don't you timers in webforms because they cause lot of network-traffic. If you ask why you are told "because they are implemented on the middle-tier (application-server)".

So, i began to think about a simple java-bean to workaround this bad forms-behaviour, and took a look at some forums and in metalink. My result is, that there is no reason NOT TO USE TIMERS in webforms.

Timers in Webforms are implemented as Java-routine on the client-tier, and not on the Application-Server. That means if a timer expires in the WEB the Java-Web-Client has to go to the Application-Server and ask what to do. In the Client-Server-Environment he wouldn't have to go to the Application-Server because the complete application-logic is on the client. Seems to be that there is more traffic? We have to take a closer look to explain that.

Two examples:

Some unexperienced Newbie wrote a very very naughty program called "Clock" this clock is an text-item in forms and counts up the time every second. Let's take a look what network-traffic we have in the WEB and in Client/Server (C/S).

example with timer that fires every second

We can see that Webforms and also C/S-Forms have to go to the database (webforms via Application-Server) to get the Sysdate. That means, there is almost the same amount of traffic.

In the next example we check every hour if the user worked more than 10 hours at this day. If yes we display an annoying-message that tells him to go home.

example with timer that fires every minute 

In this example the condition is checked one time in an hour, and if it is true an timer is fired every minute that pops up an alert-message. You can see, that there every minute Webforms has to go to the Application-Server but C/S-Forms does not have to make any network-traffic. But simple packet one time in a minute, if you are surfing in the internet you cause more traffic in one minute than the timer in one hour! Also in some whitepapers from Oracle they say, that you can use timer if you don't fire them in less than one minute or 30 seconds. Of course in some other papers they also tell "don't use timers".


The difference between PJC (Pluggable Java Components) and Java Beans in Forms

PJC extend the functionality of already implemented objects like buttons, text-fields, radio-groups etc.
Java Beans can contain every Java-Program. That means if you need to implement a super-text-field, that
automatically changes the color every 10 seconds (very useful) then you would implement an PJC.
If you implement an calendar or Slider-Control then you would implement a Java-Bean.

In Java a class that extends a Text-Field (=PJC) would look like this...

public class ColorField extends VTextField{

A Java-Bean would look like this

public class SuperCalendar extends VBean{

Communication to the class can be done with "SET_CUSTOM_PROPERTY" from forms.
If you want to communicate with Forms you have to "dispatch" an event like this:

ID fpropNoString = ID.registerProperty("ERR_NO_STRING_PASSED");
CustomEvent vCustomEvent = new StdEvent(pHandler, fpropNoString);

But JUST Java-Beans are able to dispatch events! PJC are not able to dispatch events, that shall be
implemented in future releases. I thinkt that is a big disadvantage of PJCs.

With Image Release 2 there is the possibility to install the Forms and Reports standalone. I did such an installation, and was prepared to work several days until i get know errors and everything works. My Results, it took me 2 hours to setup and configure and complete Webforms-Environmend. Oracle did a lot with the usability of the installation. There is also an EnterpriseManager automatically installed with this version, what means you can administrate Forms, Webcache, Reports by an graphic user-interface without needing to know where the formsweb.cfg or the default.env is located.

Really Cool! Laughing

If you get an ORA-00932 within Forms6i on an Oracle10g Database, you have to path your Forms-Environment. Reason is that there were changes from Database 9 to 10 with the BLOBs.

If you ever wanted to know how fast the databases are in relation to each other, take a look at this site. There are a lot of comparisons between the vendors and also on different hardware, very interesting.

Many of the Oracle-Freaks out there have worked with the demo-schema SCOTT and created their first statements with this one? Did you know that SCOTT, was the first Oracle-Employees, and tiger (schema password) was his cat?

Bruce Scott without tiger 


That's a picture from scott i found....

The Oracle Developer Suite 10gR2 was released a short time ago, and i thought there are no troubles to migrate from 10gR1 to 10gR2, but there are. Oracle Developer Suite 10g Release 1 is an enhanced version of the Oracle 9.x Developer Suite, you can see that by the version-number 9.0.4. That means the forms have to be recompiled, and there is a huge change in Reports. Reports until 10gR1 were 6i Reports. With 10gR2 they are fully reloaded. Image

I was testing my Oracle-Express, and think it is a really cool piece of software. The installation process was easy and simple, like an simple program. Everything was working fine, the right services were started. After installing you have some icons in the Start-Menu with which you can start and stop your database. There are also some links to Help-Forums and Documentation, and the most important the link to the Database-Homepage.


The Database-Homepage allows you to maintain the complete database with an simple HTML-Layout. But it is not just important for DBAs, there is also the possibility to develop new applications with HTML/DB, an genious Oracle-Product with which you can develop working database-applications within minutes!

Working with Oracle Express

 You can

  • administrate users
  • create/browse Databse-Objects like Tables, Views, Stored Procedures....
  • import/export data
  • monitor and administrate the database
  • build applications

I think this is a very good and simple to use and FREE possibility for small and medium applications. You also have the possibility to upgrade to every "bigger" Oracle-Version if necessary, for example the Standard-Edition One etc.

Logo Oracle Express


The name is Express, but has nothing to do with the old desupported OLAP-Tool from Oracle. This database is for free up to 4G of Userdata and one processor. I think less than 10% of the databases will need more than this. The installation was fine and worked without any troubles. The installation-file has just 150MB. And there are all features for what i like Oracle so much like PL/SQL, possibility to integrate Java in the database, WebSupport etc. Surprised. I will test it and post my results here.