Oracle Forms Modernisation at Oracle Open World 2010

This year we’re able to give another Oracle Forms Modernisation seminar at Oracle Open World 2010 … YIPIE !!!

We will be discussing the different aspects a Forms Customer needs to take into account when wanting to uplift the existing Forms Applications. Different scenario’s could range from modernisation to upgrade, integrate and last of all migrate if this has been a strategic decision in the company’s business plan.

1st of June we’re already giving a sneak preview of these different scenario’s to our benelux customers … and looking at the number of attendees it’s already a succes.

In other words … stay tuned and make sure you’re present at the Oracle Forms Modernisation seminar at OOW 2010.

Patch for SQL Developer 2.1 released

Just noticed that a patch is released for SQL Developer 2.1. From the Oracle website:

Oracle SQL Developer 2.1.1 is a patch release to SQL Developer 2.1, which was released in December 2009. This patch release resolves a number of the issues raised and addresses a few additional feature requests raised on the SQL Developer Exchange.

You can download it here.

XMLTYPE column larger THAN 4000 bytes => ORA-19011

When you try to convert an xml file, which has a tag that contains for example one or more pdf files, into an XMLTYPE object, you will get the following error:
ORA-19011: CHARACTER string BUFFER too small

This error will be thrown because the content of a tag of an XMLTYPE is limited to 4000 bytes(this problem should be solved in 11g).
I have developed a solution/workaround for this.

Continue reading

ODTUG 2009 – Jam Session

During the ODTUG conference a lot of interesting presentations and session were given regarding different aspects, such as:
  • Forms Modernization (Forms 2.0, Forms 11g, …)
  • Apex (Case studies, Apex & reporting, Apex for mobile applications, …)
  • ADF 11g (Fusion development using ADF 11g and rich client components, Package based development using ADF BC, …)
  • Integration (web services, ESB, BPEL, usage of a canonical datamodel, best practices when talking about security, development, …)
  • Finance (Hyperion, Essbase, …)
  • Data Integration (OWB, ODI, …)

Besides these sessions we also had the time to have our own little jam session …

In other words, the conference was a great learning experience and we had a lot of fun as well ;o)

Oracle 4 Newbies: thé Powerday

After our ‘Oracle for Newbies’ seminar, we invited all attendees for a Powerday. The participants would get the opportunity to try out everything we had shown in the seminar. Last Monday we started our Powerday with 11 curious attendees.

The ‘half a day’ – Powerday consisted of 3 parts: 1) the installation of Oracle Express Edition and an upgrade to the last Oracle Application Express version, 2) building a wizard driven application and 3) building and modifying manually some apex functionality.

For the installation part, we asked every attendee to bring his own portable. We planned to have the software successfully installed on every pc in one hour. And yes, they all did it. After 1 hour and 10 minutes, everybody had an Oracle database with Apex 3.1 up and running!

For the second part, we gave a demo on how to create a wizard-based application. Now it was up to them! We provided some excel sheets with the data. Starting from these excel sheets, thanks to the ease of Oracle Application Express, they managed to create the Oracle data model, fill the tables with the excel data and create a web application to do all possible data manipulation. And again… One hour later, they all had their first own Apex application up and running.

In the last part of our Powerday, we did some more advanced and ‘not so wizard-driven’ stuff like modifying or adding some functionality in the application, implementing blob functionality (upload and download of images), implementing security (authorization) and lots of other nice things. Not only ‘we’ did all this, at the end of the day, they all had these features implemented in their application.

All participants were enthusiast, and hopefully we convinced them to start using Oracle and Apex.

The developers’ voice

As you all (should) know, begin this month, there was the event of the year for Java developers, Devoxx. This year they changed their name from JavaPolis to Devoxx to strengthen the voice for Java developers. But I don’t think that the name changed any of its popularity. Instead, they had more attendees compared to last year.

As a rookie, I had the privilege to go to Devoxx and explore the Java world, looking at the new and shiny technologies that will conquer the world! The first university day, I was very interested in the web development sessions I had the chance to attend sessions about JPA and Flex. Each session lasted for 3 hours (although some people didn’t wait that long :) ). The day ended with a very interested JSF on Rails session, presented by Lucas Jellema.

On the second university day, I had the chance to look at Seam in action. The author of the book (with the same title), Dan Allen, presented in a very detailed way the possibilities of Seam. Sometimes he went too far in details that some of my fellow attendees began to dream of Seam (with their eyes closed). After an energetic lunch, I went to the Filthy Rich Clients session by Romain Guy and Chet Haase.

It was a very interesting session given in a very entertaining way. Both speakers really knew how to catch the audience’s attention. They explained us how we can improve the look and feel of our applications so that both user and developer can really enjoy themselves when using/building an application.

After the performance of a beatboxer that surely woke us up, the third and most astonishing day began! First, Stephan Janssen (the man behind Devoxx), gave us a brief summary of the previous days and passed the microphone to the Java FX team. This team presented a state of the art new technology and showed it to the crowd in an amazing demo! They made a video puzzle where the player had to put the pieces back in the right order, with the video still playing! Magnificent!

As the people of this beautiful presentation of JavaFx ended,the people of IBM were the next ones in line to tell us more about these strange portals at every entry. It was an RFID-project so that the Devoxx team was able to register statistics throughout the entire week. So next year, the speakers with the least amount of attendees will be removed from the list :)

At the end of a 10-minute break, it was our turn again. I went to a session about Software estimation presented by a passionate Italian, Giovanni Asproni. He was really able to keep everyone’s attention with his live examples and his enthusiasm. After a hacking session (by Sebastian Deleersnyder of OWASP) and the feel of Scala there was Oracle’s Frank Nimphius who presented the latest features of JDeveloper 11g in combination with Oracle’s ADF.

These three days were to most amazing days for me as a rookie Java developer. I could never imagine that there were so many different products on the market that are all Java based. A special thanks to the whole Devoxx team! If you have any interest in Java development, I hope to see you next year @ Devoxx!

Bjorn Ongenae
iAdvise consultant