Basic features for the IDE- Oracle notes designer


Posted by Hafed | Posted in Forms, oracle, Wiki | Posted on 28-12-2005

I am working on the features to be included on the IDE. Checking, I found several interesting open source packages. The closest to what I envision for the code generator is middlegen(

Now, for the notes feature itself, I came across which I found on the oracle otn section (migrating Lotus notes apps to J2EE, That’s exactly what I think is the closest to a Forms, views paradigm for an Oracle-notes application.

As far as the IDE is concerned, it is going to be a Java Swing based interface. For the time-being, I am checking Sun Netbeans ( and Oracle Jdeveloper.

At any rate, I don’t want to get too deep in extra features at this point. The basic point is to get an MVC application with the capability to display Views and Forms.

What about a Development tool à la Lotus Designer


Posted by Hafed | Posted in Forms, oracle | Posted on 09-12-2005

Is there any Oracle extension or a development tool for Oracle that works the same way as Lotus Designer.
Basically, a tool that allows the quick setup of an interface with views on the left pane and a list of documents (records) on the right side. Actions in this case will be related to triggers.
This can be done with Oracle Forms but it is quite tedious. Did anyone come across such a tool ?
I am aware of most of the Oracle development tools (Oracle Designer-Forms- HTML DB etc …) but I still did not come across such a tool.
Most likely, JDeveloper will allow such a setup but this will require a significant programming load.
Lotus notes is amazing as far as the presentation of data is concerned. Anyone with a basic understanding of document management can quicly setup a visual interface that can present the data within the documents in a very easy to understand format. What is most important is that the end user can quickly start working on the documents within the Notes database.
Oracle still does not have this capability as far as I know and if anyone can point to a similar tool, it would help a lot.

Random thoughts and Tips about ORACLE Tools


Posted by Hafed | Posted in oracle | Posted on 09-12-2005

I had to start somewhere but after gathering a huge amount of links, tips and documents about Oracle Tools, I believe it is about time for me to start putting these into paper (oops… I meant a blog).
My primary interests for the time being are Forms and Designer 6i/9i. I teach both courses at a College in Montreal, Quebec- Canada.
While I experimented with Oracle JDeveloper in 2004, I did not have a chance to do a thorough review of the product at that time. This week, I downloaded the latest version and I plan to put it to work in the coming few weeks.
I am thinking about preparing some lecture slides for JDeveloper, similar to the ones we have for FORMS. I checked the book Oracle JDeveloper 10g Handbook by Avrom Roy-Faderman, Peter Koletzke, Paul Dorsey. It is a thick book but seems to be really concise.