OraTransplant

Day 2, 3, and 4 at OpenWorld

I thought the first day of OpenWorld with my own two presentations (here and here) was a busy one. How wrong could I have been… I’ve been to a couple of Oracle conventions by now and each time you get to now a few new people. That really adds up and by now you just walk around a convention like this and meet people you know every time. This means you spend a lot of time talking to a lot of people. That’s absolutely great and one of the most important reasons why I love attending these things. The only downside is that is leaves you little or no time to blog about what’s happening.

Between all the social activities (drinks, dinners, and even a sailing trip on the bay - thanks Hylke) I even managed to find some time for attending a couple of sessions. The first one was moving beyond project level SOA. The presentation talked about the difference between “Project-Level SOA”, “Infrastructure SOA” and “Enterprise SOA”. Many organizations, including ours, start with project oriented SOA. The presentation talked about “upgrading” this approach to Enterprise level SOA. They made a number of valid points, but I guess (hope) that things will be much easier for us. Many organizations are much bigger than ours and realizing Enterprise SOA can involve many business units and multiple system architects who think they know better. Our organization is much smaller and only has a single IT department and a single system architect. Hopefully this means we don’t have some of the common pitfalls when introducing SOA into an organization.

Another presentation I attended was on DICOM Medical Imaging with Database 11g. This was a very interesting one for me. We tried image manipulation in Database 10gR2 and found it to be very very slow. The Oracle people at this presentation assured me that many (if not all) of these problems should have been gone in 11gR1. So, it looks like I really need to give the database another change and give 11gR1 a test run. The session demonstrated that the database has support for DICOM images, and you can do some neat stuff with it (extract DICOM meta data, anonymize patient information, and many more)

I also attended a presentation by Shaun O’Brian, one of (the many) JDeveloper product managers at Oracle. He had some interesting things on SOA and BPEL. He went over some troubled scenarios and asked as what could be wrong with it. It’s hard to come up with the answer in a split second, but when he explained what went wrong I sure recognized some of them. We had the exact same problem where the new “auto-load-balance” feature of AppServer 10.1.3 caused requests to the beta-test environment to end up on the production environment and vice versa.

The final presentation I attended was on Oracle Coherence. One of the many products they acquired by acquisition. This is a very intriguing product. It’s true grid computing. To put it simply, it’s sort of a RAID cluster of memory shared over many machines. There’s one “cloud” of memory shared (and duplicated) over multiple servers. The servers could even be spread out over multiple locations using a WAN for redundancy. A program, whether it is .Net, Java, or something else, can read and write information in this cloud. It’s all optimized for extreme speed and throughput. This is the underlying technology for some of the busiest web sites out there. What to think about a game betting bookmaker that receives huge volume betting on the same game, or amazon.com and the likes. The Coherence cache also features delayed write back cache. So, your application can write something to the (in-memory = fast) cache very quickly. Your program can continue and rest assured the data is safe, since it is replicated over multiple machines. Coherence will write the information to a back end data store like a database at a later time when resources allow this.

If you’re into this high-volume stuff you should really have a look at Oracle Coherence. There was even talk that this would be the internal workings of the next release of Oracle’s Enterprise Service Bus (ESB) and BPEL. This is a very fast approach to multi-server computing of ESB and BPEL. Currently, these products rely on synchronization through the database. This is inherently slow. Why not have a grid of BPEL servers that all share the same state in real time. There are nice things to come…

Two years ago I was a bit disappointed after visiting OpenWorld 2005. There was a lot of marketing hype and sales presentations. For me, it was difficult to find real interesting technical presentations. This year, I did manage to get some real interesting presentations. Also, since then I know I a lot more people from the Oracel community and this is what makes these conventions worth while. It’s the combination of technically interesting presentations and socializing and meeting up with people you already know (and get to know some new).

That’s it for now. I’m still recovering from my jet lag. Hopefully I feel much better on Monday as I’m starting driving lessons for my motorcycle then.

Presenting on integrating Forms and JSF

Besides my first session on Forms to SOA yesterday, I also had my other presentation on integrating Forms and JSF. In the end I was very pleased with the session. I finished right on time and go some very positive feedback from the audience. In fact I had some follow up meetings yesterday and will have some more today with people interested in the technology. If you missed the session you can still take a look at the slides. Perry Pakull from Germany attended both of my session and blogged about it (in German).

In the presentation I demonstrated how it is possible to seamlessly integrate Oracle Forms into a JSF web application. In fact, you can use the same technologies to integrate Forms in any other web technology. I started of with some introduction about Eurotransplant and myself, just to get a feeling of where our need to integrate Forms and JSF came from.

Eurotransplant decided to move from Forms to web development a number of years ago. The main reason being that the majority of our users are remote and infrequent users. Oracle Forms doesn’t fit these users very well. Forms is not as intuitive as users nowadays expect. They’ve gotten used to intuitive web applications.

So, we wanted to move to web development but we also had a large Forms application. We didn’t want to rewrite the entire Forms application in new web technology. That’s when my quest began for integrating both worlds. We wanted to be able to use web technology for all new developments while protecting our investment in Forms. From an end user perspective this would mean the end user can navigate between newly built web pages and traditional Oracle Forms in an easy manner. It must be possible to pass context/data and events from the web application into Oracle Forms and the other way around. It should be possible to pass the ID of the selected customer, order, etc. into Oracle Forms.

I demoed the end result of this integration in my presentation and will upload a movie of the same demo later this week or next week. Then I moved on explaining the underlying techniques used for this integration:

• Inbound JavaScript API which gives the ability to call into Forms from JavaScript, raising a Forms PL/SQL trigger and passing a payload
• Outbound JavaScript API which gives Forms the ability to execute a snippet of JavaScript
• A technology to eliminate the tradition 5-10 seconds startup time of the Forms applet. By using the legacy lifecycle cache only the very first web page in a session that embeds an Oracle Form gets the startup penalty of starting the applet. All subsequent pages that embed an Oracle Forms applet will reuse the (suspended) applet from the initial page.
• The OPTIONAL visual integration to remove a lot of the chrome from Oracle Forms: the menu, toolbar, statusbar, etc. With this approach the end user doesn’t notice she is using Oracle Forms. This can be a strategic advantage. It allows you to replace a web page that embeds an Oracle Forms with a true web page at a later stage without impact on the end users. This can be a major benefit to your and the way to a smooth and slow transition from Oracle Forms to JSF. You can just as easily skip this step and confront the end user with the full Oracle Forms applet with all bells and whistles. It’s whatever suits your needs better.
• Finally I had a slide on actually including the HTML in your web page to start the Forms applet. You should really use some sort of template for this as the legacy lifecycle cache demands that the applet declaration is 100% identical on each web page. Each web technology has its own way for using templates.

I finished of with a demo of the JSF Component Library I’ve created. This JSF Component Library hides all the required technology and complexity from the web page developer and the Forms developer. It’s as simple as adding a single JAR file to your JDeveloper project. Then you can drag-and-drop a Forms component onto your web page. Set some simple properties (name of the Form module file and dimensions of the applet area) and you’re done. Run your page and you have a web pages that embeds an Oracle Forms. You can just as easily drag-and-drop data control items onto the Form to pass the as parameter or drag-and-drop methods or actions onto the Form to enable the Form to initiate these JSF actions/navigation from PL/SQL. There’s a movie showing a similar demo.

I ended of with a small summary with some key points:

• You can use this technology as a smooth transition from Oracle Forms to a web technology. It allows to you replace Forms with true web pages one-form-at-a-time
• If you’re happy with Forms and have no need to migrate to web technology, you can just as easily use this technology to integrate Forms and your web applications. For example, you can have a web based portal that’s used by your call center agents and a link that leads to a page that embeds your existing Forms application to drill down to the details of the overview of the initial portal page.
• The JavaScript API is the key technology to get this integration working. This is a native Forms 11 feature, but I demonstrated this can also be added to existing versions of Oracle Forms by subclassing the Forms applet class and using a Pluggable Java Component in your Forms
• You can either build this integration yourself if you’ve got enough knowledge on HTML. Java, JavaScript, CSS and PL/SQL. For this look at previously published papers and guides.
• If you’re not comfortable building and maintaining all of this yourself, you could just as easily use our JSF Component Library and get started right away. I’ll be publishing more details on the library, including demos, as soon as possible. This week is fully packed with OpenWorld activities, so be sure to check back regularly.

My first presentation at OpenWorld

Yesterday I presented both of my sessions at Oracle OpenWorld. In the morning I had a joined session with Jan Carlin, Forms product manager from Oracle. The session was titled “Oracle Forms: Strategy and the Road to SOA”. Jan started the session with some Forms strategy and an overview of what SOA is and how Forms can play a role in a Service Oriented Architecture.
Jan took questions during the sessions and there were quite a few. I’m still surprised how many people are not aware of Oracle’s Tools Statement of Direction. People are still hearing rumors and are thinking that Forms will be desupported very soon. Some were quite surprised that a version 11 of Forms is forthcoming. In fact version 11 will have some critical new features to integrate Forms with other technologies. For me the two most important ones are the ability to react to Advanced Queuing events from Forms and the new JavaScript API to Forms 11. In fact, these plans were already announced by Oracle in Jun 2006. Read that article for a more detailed description of new Forms 11 features.

Jan’s talk and the associated questions took a bit longer than expected. This left me only 20 minutes for my part of the presentation. I still think I got most of the points across to the audience. I talked about Eurotransplant’s path from Forms to a Service Oriented Architecture. This started with the move of most business logic out of Forms and into the database. The next critical step was the upgrade form client server Forms to web based Oracle Forms a number of years ago. At the end of our path to SOA was the introduction of Java web based development and lately the introduction of BPEL.

There were quite a few questions at the end of my session. For me, that’s a good thing as it indicated people were truly interested and they didn’t run of as soon as they could. Quite a few people approached me after the session for specific questions. In the end this took so long we had to be kicked out of the room since the next session was about to start. For me, this was a very successful session and hopefully the audience has the same opinion.

Session on integrating Forms and JSF moved to a bigger room

My session in integrating Oracle Forms and JSF has been moved to a bigger room. It was overbooked by 50%, so Oracle decided to move it to a room twice its size. So, if you are interested in attending this session and couldn’t register before, please try again.

The session will show the concepts used by Eurotransplant to integrate Oracle Forms and JSF. This enables you to embed Oracle Forms in any web application with full passing of context and events between the two technologies. It also eliminates the normal Forms applet startup time which would prevent a user quickly switching from Forms to JSF in a normal application. The session even shows a fully functional JSF Component Library to hide all the necessary technology from both the Forms developer and the JSF page developer. It’s a matter of drag-and-drop a Form and its parameters from the Component Palette to your JSF page in JDeveloper.

OGh Visie article on Oracle OpenWorld

I’ve written a Dutch article for the magazine of the OGh (Oracle UserGroup Holland) about my visit to Oracle OpenWorld 2005 in San Francisco. Perhaps it’s a bit late, but the OGh only publishes a magazine twice a year.

The new issue of the magazine should be out soon.

Jonas Jacobi on JSF

By far the most interesting session I attended today was “Everything you need to know about JavaServer Faces and ADF Faces” by Jonas Jacobi. He gave a nice overview of the standard JavaServer Faces (JSF) and Oracle’s ADF Faces which mainly offer a lot of extra JSF compliant components.

I really encourage you to have a look at the JSF site on OTN. Have a special look at the link where Jonas introduces ADF Faces. You can find this link in the “Meet the experts” box at the right hand top corner. It’s a 49 minute webinar on JSF and shows a neat example of the rich internet applications (RIA) you will be able to build with (future releases of) ADF Faces. Jonas shows a file explorer that he also showed today in the session. It gives a good idea of what will be possible with ADF Faces.

Throughout Oracle OpenWorld I’ve seen several demos of Oracle Bank, a demo application showing some great features of ADF Faces and how rich a thin client can be. I couldn’t find a viewlet of this on OTN (yet), so I will at least show a picture of the screen. You can click on the pic for a larger view, or even download the original picture. There where a lot of impressive things in this demo: sliders, you can collapse en expand entire “frames” (you can see the upper search frame collapsed, the middle select frame expanded and the bottom complete frame collapsed), selecting another row in the table automatically refreshed the graph, a very slick look-and-feel and much, much more.

The other two session I went to were less interesting. One gave an overview of the new features in Application Server 10gR3 and most of it were things I already knew although I heard a couple of minor new things. The other session was a real disaster and not very useful. Today we also had the keynote by Larry Ellison and I mus say that I had expected a bit more from that. Not that it was bad and not that I know what I was expection but it was all a bit tame. Perhaps that’s what they have to do when there is so much at stake.

Just aside: I’m not really an Applications type of guy. I’m more from a custom development background. This means I do not express a lot of interest in all the JD Edwards/Peoplesoft/Oracle EBS things going on at OpenWorld. However, I did notice a truck running up and down the street before the Moscone center all day. Could it be that Microsoft is being nervous?

Visit the Hands-On Labs!

I made a mistake in my previous posting that might just give even more confusion. I used the name Demogrounds in stead of Hands-On Labs. What I wanted to say:

Just a quick note to the other visitors of Oracle OpenWorld: you really should visit the Hands-On Labs. They are quite well hidden on the ground floor of Moscone West (the third building where you registered). The Hands-On Labs are really worth while and you can get your hands on all sorts of Oracle technologies.

A unique opportunity that unfortunately is a bit hard to find.

CAB meeting and bloggers dinner

Tuesday was a packed day. After a full day of sessions at OpenWorld I had a meeting of the Customer Advisory Board for Development Tools and a dinner of the bloggers or orablogs.

I thought the CAB meeting was a great thing. It was my first time since I only recently joined the CAB but I understood from the meeting this was the first meeting ever or at least the first in a long time. We all agreed we should have these things more often at the various big Oracle events and we will setup other communications like regular webcasts and a CAB only listserv.

It was an informal gathering of about 15 customers giving detailed feedback to Oracle on their product strategy. Most of us were coming from a Designer and/or Forms background. Most of the customers present are also working with JDeveloper, but that doesn’t say they’re all dropping Forms. You see a lot of customers (like ourselves) doing both. I guess it’s great for Oracle product management to get this direct kind of feedback. For me, it’s a great way to get a bit more insight on where Oracle is going with its tools and hopefully can even influence their direction (a bit).

As soon as the meeting left, Sue Harper, Steve Muench and I rushed over from the CAB meeting to the bloggers dinner Mark Rittman had organized. and which Brian Duff already blogged about. What a great way to meet a couple of the bloggers. I forgot to make any pictures but I guess Mark did so I’ll try to get his. And since I’m very bad in remembering names I’ll ask him to put names with the picture so I can make a stunning impression next year when I meet them and still remember their names (after a quick glance at the picture )

Update 21-sep-2005: See Mark’s weblog for the pictures. As always I managed to get in a picture with some weird looking face while eating…

Day two (Tuesday) at Oracle OpenWorld

On Monday I had some great sessions about the future of Forms and new developments in Server Technology as you could have seen in other blog entries. Yesterday (Tuesday) I had three more sessions. The first one was on Oracle Business Rules, the second one on creating your own portlets for Portal and the last one on SOA patterns and methodologies.

The last one wasn’t really what I expected from it. I’m a type of guy that’s looking for in depth technical advice, a couple of examples or demo’s and perhaps a view of what’s coming in next versions. This session was more the kind of stuff they teach you at university and where it’s hard for me to see where it fits my practical needs. I guess that’s always the risk on these large conferences where you have to pick on out of 25 parallel sessions. There is a very short description in the conference guide and from that you have to guess what the session will be like.

The session about portlets was more interesting. For me it was basically the first time I had a real look at Oracle Portal and I must say I liked it. That’s also why I select some sessions, to get a quick glimpse of what other Oracle products have to offer me. They did an introduction to portlets and showed how to create a portlet for an existing Struts/JSP application. Basically you’re creating a new view layer (JSP pages) by copying the original JSP pages, removing all branding and other stuff you don’t want in the (small) portlet and replace the Struts tags with PDK-Struts (Portal Development Kit) tags that basically do the same but make sure that a click on a link or button doesn’t refresh the entire window and makes you jump our of the portal. In stead these special PDK-Struts tags make sure you stay within the portlet.

The session I started the day with was on Oracle Business Rules a new part of Oracle Fusion Middleware and already available as a preview release download. It all looked very promising but a bit immature. A lot of things were “coming in a next version” and to me that’s always a sign you might want to wait one or two more versions before jumping on. I guess the real test will be when Oracle Apps division picks it up in their products towards Project Fusion. However, it still looked promising enough to investigate further once I’m back. In a next version they will support decision tables and that’s exactly what we’ve been thinking about for our donor allocation schemes.

The only comment I have on OpenWorld is the number and length of keynote speeches and the fact there is nothing else you can do at the same time. No sessions going on and most of the times the exhibition and demo grounds are also closed. To me, most keynote speeches are just too much marketing stuff by the larger sponsors of the event. Well they probably paid big bucks to sponsor this event, so they do deserver some attention.

OpenWorld: Project Raptor – watch out TOAD

Oracle released an Early Access version of project Raptor. This made much of the following article obsolete as you can now see for yourself.

I just attended a session about new developments by the Server Technologies’ Database Division. One of the most interesting things (for me) was the short demo of project Raptor. This is the long awaited visual tool for database development. It could be a real competitor for the well known TOAD product from Quest. They did a short demo in which you could view and alter all the known database objects. The also showed some PL/SQL development features including code formatting and a powerful debugger. The session was also about other new developments in database 10gR2 and coming releases. This mean there was only a couple of minutes to demo project Raptor but it was really interesting. A lot of people approached the speaker afterwards to ask about Raptor.

It looked very familiar to me (knowing JDeveloper). It doesn’t require an Oracle client, just as JDeveloper. It’s just a matter of unzipping and start running. Looking at the screen it looks like it just makes a JDBC connection. It’s based on the JDeveloper framework but it is much more powerful then the existing database and PL/SQL editing features in JDeveloper. As I understood it will eventually replace the current database and PL/SQL editing in JDeveloper in some feature release. But before that, project Raptor will be offered as a standalone product on OTN. Due to all the new regulations Oracle people cannot give estimated delivery dates other then “this fiscal year”. For Oracle that means before May 31st 2006, but the speaker told me he expects it on OTN very soon.

I used my digital camera to make some photos of the demoed screens. The unfortunate thing is that I forgot to bring my USB cable to the Moscone center, so I can’t upload the pictures before this evening. Check back again to see the screenshots.

Some of the other things discussed in the session were Oracle Secure Backup, Patch distribution by Enterprise Manager Grid control 10gR2, TimesTen in-memory database, XQuery, Transparent data encryption, HTML-DB and two new security features: AuditVault and DataVault.

To me, TimesTen and AuditVault were the most interesting as they seemed to target actual business problems we are having right now. I’ll have to look into both technologies when I’m back at the office. I guess attending OpenWorld will take more then just the one week I’m here. I get the feeling I have a couple of weeks work when I get back in checking out all the new stuff I discover here.

PS. On a more personal note: congratulations to my wife for our second wedding anniversary. Couldn’t think of a better/more romantic way to celebrate it than to be on my own in San Francisco visiting a tech conference

Update 19-sep-2005 18:30: I’ve just returned to my hotel room to connect my digital camera to my laptop and upload the pictures. I didn’t want to use my flash when making the pictures during the session so I needed quite a long shutter time. Unfortunately that made the first picture kind of blurry. Nonetheless I will post all three pictures below. You can click on any of the pictures to get a bit larger view.

If you want to get the full size images, you can find them here, here and here.

The first screenshot is the blurry one but you can (hardly) see the tree control showing all database objects and the code editor for stored PL/SQL. The second shot shows the context menu including the Format SQL option for code formatting. The third and final shot shows the debugger in action. You can see all variables in the lower right corner. By the way: hovering over a variable in the code editor will show its value as a tooltip. You can also see the debug console at the lower end of the screen and the call stack in the lower left. I must say Raptor looked very promising for the five minutes we got to look at it. Let’s hope Oracle will show it at the demogrounds later this week and for the screenshots Brian has promised.

I’m off to the OTN underground event. Check back tomorrow for more updates on OpenWorld.

Update 21-sep-2005: Raptor was just briefly demoed during the keynote of Chuck Rozwat. Unfortunately I was watching the keynote in an overflow room where the screen is too small to make any good pics. If anyone attended the keynote in the big room and made some usable pics, you can contact me to put them up here.
I’ll have a look at Raptor at the HTML DB demoground myself, but I doubt they will let me near it with a camera

Update 22-sep-2005: Brian Duff has just published some real screenshots for project Raptor. These actually have some detail compares to mu blurry pictures.

Update 31-dec-2005: Added a comment at the top of the article about the release of an Early Access version of project Raptor.