Oracle Forms File drag and drop javaBean

I created a JavaBean that implements a “dropbox” in Oracle Forms.
It can be downoaded from the PJC/JavaBean library of Francois Degrelle.

When dropping one or more files on it, Forms receives the path and filename of it.
In the following example video the JavaBean is used to upload a file to the database.
For the uploading part I used Webutil.

 

 

Oracle Open World, build your schedule

As Oracle Open World is coming closer, it’s time to build your schedule…
Be prepared because there are so many choices.

So, here are some presentations I’m interested in and planning to attend.

Of course there’s my own presentation on monday.

  • Session: What’s Your Choice for Oracle Forms: Modernize, Upgrade, Integrate, or Migrate? (session id 08262)
  • Time and place: Monday, 12:30 PM, Marriott Marquis – Golden Gate A

When you are a developer working with Oracle Forms or an IT manager and have an Oracle Forms application, this is probably the session you should attend when you have questions about the future of Oracle Forms.
Together with Grant Ronald(Group Product Manager in Oracle’s Application Development Tools Division) we’re going to show you the possibilities of Oracle Forms in the future, not only with a presentation, but also with customer cases and demos.

What else is interesting on OOW:

  • ADF Enterprise Methodology Group (EMG) Sunday: 6 tracks about one subject: ADF
  • Presentations by Grant Ronald: starting with ADF?  Check his sessions and look how “easy” you can develop in ADF.
  • Four Ways to Transition from Oracle Forms to Oracle ADF by Wilfred van der Deijl(Monday, 03:30 PM, Marriott Marquis – Golden Gate A)
  • Reaching Out from PL/SQL by Lucas Jellema(Tuesday, 10:15 AM, Marriott Marquis – Salon 7)
  • Spend Some Quality Time on Your Oracle ADF Application by Aino Andriessen(Thursday, 12:00 PM, Marriott Marquis – Golden Gate A)
  • More interested in database(programming)?  Tom Kyte and Steven Feuerstein are “must see” presenters.

Oracle Forms 11g and Google maps integration

In last years blog post about Forms 11g Javascript integration I explained how you could call the Google Maps API from forms using JavaScript.

I captured that testcase using screentoaster.
It seems that this tool has disappeared and all the recorded sessions with it.

So, here’s a new video on youtube of this Google Map Integration, now in a demo application.
The Form is embedded in a HTML page witch contains a Google Map.

Seminar: “What’s your choice for Oracle Forms” – recap

A great turnout for the seminar: more than 40 interested attendees, a mix audience of IT managers, project managers and developers.
Hof ter Delft was a nice location!

Grant Ronald, Oracle Senior Group Product Manager for the development tools division, opened the seminar with a keynote presentation.
He started with the Oracle Statement of Direction: Oracle has no plans to desupport Forms and Reports.
After this he gave an high level overview of what is possible with an Oracle Forms application: modernize, upgrade, integrate and migrate.
Grant ended with an overview of ADF.

My session was next, same subject as Grant, but a bit deeper into detail with demos and customer cases.
I showed how you could modernize an application using Pluggable Java Components and JavaBeans.
Upgrade will bring you some nice features, eg. javascript integration and external events in 11g.
Those new features were shown in the integration demo, together with web service calls from Forms.
I ended with migration:  reasons to migrate, strategy(eg. a customer case of  redesign/rebuild in Apex), tools that  can be used(eg. JHeadstart ), …
One lesson: migration is not an easy path…

The following session walked this path of migration, the one of a phased migration.
Wilfred van er Deijl(Commit Consulting)presented OraFormsFaces.
A presentation about where OraFormsFaces can fit in and how it works.
When you choose for a migration and you don’t want a big bang, OraFormsFaces can help you in doing new development in a new technology(eg. Oracle ADF) and keep your Forms investment.
OraFormsFaces let you integrate a form in a webapplication and passes info between those two technologies.

To show that OraFormsFaces works with other technologies, Tom Bauwens(SmartApps) showed the integration of Oracle Forms with Eclipse RCP using OraFormsFaces.

After a nice lunch Grant Ronald gave an introduction training to ADF:

  • Building ADF Business Components
  • Business validation
  • Shaping your data
  • Application Flow
  • Building UI pages

This really showed the power of ADF to Forms developers.


PL/SQL Challenge V2

For over a year I play every day the PL/SQL Challenge, as I mentioned already in previous posts.

Today there’s version 2 of the website.
You can read about it on the PL/SQL Challenge blog.
Great effort of Steven Feuerstein and his team!

So, if you want to test your PL/SQL knowledge, compete against collegues/other PL/SQL programmers or you want to know/learn more about PL/SQL… Check it out!

iAdvise Seminar: What’s your choice for Oracle Forms?

There are a lot of questions about the future of Oracle Forms and applications that were built in Oracle Forms.
During this seminar we will answer these questions and give an overview of the (possible) future of such applications.

The seminar will kick off with a keynote by Grant Ronald, about the Oracle Forms strategy.
Next we show the following possibilities: modernize, upgrade, integrate and migrate.

To end the morning session we will show how change can go nice and smooth.

After lunch Grant Ronald will give an introduction to Oracle ADF Development:

  • Building ADF Business Components
  • Business Validation
  • Shaping your data
  • Application Flow
  • Building UI pages

Attendees of the afternoon session “Introduction to Oracle ADF” will receive a copy of the book “The Quick Start Guide to Fusion Development” by Grant Ronald!

When: Monday, June 6 2011
Where: http://www.hofterdelft.be (Ekeren – Antwerp)
More info

PL/SQL Challenge first anniversary

One year ago Steven Feuerstein launched a competition called “The Pl/SQL Challenge“.
The idea was to let Oracle PL/SQL developers test their knowledge, learn and win prices by taking a daily quiz.

The format seems to be a success: every day more than 1000 PL/SQL developers test their knowledge about the language, in total more than 5800 users from 119 countries… a worldwide success!

But it does not stop with doing a quiz, a lot of questions(and answers) are discussed on the blog.
And those discussions can also lead to something, like an enhancement request for the PL/SQL language  by Bryn Llewellyn(PL/SQL Product Manager at Oracle).

Steven did a great job with the PL/SQL Challenge and it seems like it keeps on rolling: version 2 of the website is coming up with even more challenges for SQL and APEX.

To Steven and his team of reviewers and developers: thanks for the nice quizzes and keep up te great work!
To all players: have fun and good luck!