OraNA :: Oracle News Aggregator

LewisC's An Expert's Guide to Oracle Technology Well, I have been using Oracle's new SQL Developer Data Modeler (OSDM) for a couple of months now. I've upgraded to beta 2. I have to say I really like it. I have given some feed back and the response ...

Tuesday at UKOUG saw me catching up on a few sessions but the key session today was the roundtable/open session "Apex, Forms, JDev: which tool". Generally these open session are not that well attended (maybe 10-15 people) but I counted over 40 people which was just awesome.

The idea of the session was really to address that commonest of questions: which tool do I use? There have been blog wars kicked off on the back of that exact question but today it was, a rational open discussion. Questions came up about:

Is Apex suitable for heavy data entry applications?
Customization of Apps with Forms, and in the future, JDev.
Is Forms really a viable option? Does it have a future.
Can you really migrate Forms or Java or Apex (or whether you should even try!)

Not surprising to me was that fact that the Apex, Forms and Jdev Oracle representatives felt very comfortable in where the "sweet spot" of their product was and how other tools are sometimes better. Its not always a binary choice of tool.

I'm hoping that some of you who were there might post your comments on the sessions but it felt like a great way of the Oracle tools community to discuss those burning questions about tools choice, and have the guidance of Oracle experts and customer alike.

First day at UKOUG saw plenty of packed sessions although it does seem that general conference numbers are down on previous years.

The first session I caught was Sten Vesterli doing his "Tools: What's Hot and What's not". Sten does a great presentation and I love how he limits the use of slides. I also loved his analogy of Oracle Tools developers in a raft asking which way they should go down the river. Great start to the day for people using Oracle Tools. If I do have one comment Sten, I'd personally say Swing is not as hot as you currently rate it.

The next session was Dana Singleterry from the Oracle Tools PM team who gave an introduction to JDeveloper and ADF. Dana did some nice easy-on-the-brain demos that give a nice idea of what kind of things you can do in JDev.

I then had two back to back sessions. The first was in one of the big auditoriums for "Forms: Features and Future" and we got about 120, which was a great turnout. Life in the old Forms yet!

It was then a quick dash to another hall to deliver "Redeveloping a Forms application using ADF". This is always an exciting presentation for me since its pretty much all demos. Again, a good turnout. I think we probably had about 70 people in the room.

Today we have a roundtable session on "Apex, JDev, Forms, SQL Dev: The choice is yours". So all those people who asked "which tool should I use", this is an essential session. You'll have Product Managers from each of these tools to pick their brains! Hey, maybe you might even see a fight break out ;o)

Event Date: December 11, 2008
Live Start Time: 10:00 AM PST / 1:00 PM EST
Live Event Duration: 1 hour

Don't miss the opportunity to listen to George Jacob Group Vice President, CRM Applications and Alok Pareek, VP of Technology, GoldenGate Software discuss how customers can successfully upgrade their Siebel environments with zero downtime and vastly improve transition success.
Register here

It's Monday morning and today I'm at the opening day of the premier UK Oracle Conference, UK OUG. I've got two presentations today; the first will be "Oracle Forms: Features and Future" where I will be talking about Forms 11g and integration with Web services and SOA. I then follow that with a presentation on "Building your business Services in Oracle ADF: A Case Study of Redevloping a Forms application" where I will be diving into ADF using an existing Forms application as a sample application which I will build, hopefully, infront of your eyes!

If you are coming along and are interested in Forms and/or Fusion/ADF then come along. I'm also hoping to check out Sten Vesterli's "An Overview of Oracle Development Tools", Dana Singleterry on "JDeveloper 11g: Where Do I start".

I was actually just browsing for one of Davids recent forensics papers to mention them in an answer to a question on my Oracle Security forum about how to delete data completely and whether it is actually possible without rebuilding....[Read More]

Posted by Pete On 27/11/08 At 02:05 PM

LewisC's An Expert's Guide to Oracle Technology Ok, I figured out how I am going to do this. I am making my book available three ways: print, ebook and html. For print, you can get it on amazon or through my e-store. It's $14.95 For ebook, you can g...

There was a question posted to my Oracle Security forum a week or so ago but i only got round to posting an answer the other day due to travelling a lot recently. The poster had an issue running my....[Read More]

Posted by Pete On 26/11/08 At 02:21 PM

LewisC's An Expert's Guide to Oracle Technology I am soliciting opinions here. First, though, some back story. Way back when, when I was first moving on the track to data modeler and architect, I was responsible for designing schemas and application...

Are you coming to the UKOUG conference next week? On the Friday session you could attend a 2 hour masterclass delivered by yours truely and Duncan Mills on "How to become a Fusion Developer with no Java".
The aim of the masterclass is to focus on how far you can go and what you can achieve without having to get into the nuts and bolts of Java and the Java platform.

We'll be covering everything from building business services based on database tables, reusability, page design, task flows, drag and drop, popup dialogs, graphs and maps. And of course, you get to ask the people building ADF all those deep dive questions you always wanted to know!

I got an email from Jakub Wartak a few days ago but due to travelling last week in Sweden to teach my class " How to perform an Oracle database security audit " I have not had time to look....[Read More]

Posted by Pete On 24/11/08 At 05:54 PM

One of the most powerful features in new version of Oracle ADF is possibility of declarative creation JSF/ADF RC controls, in truth - extending and parameterizing existing componets to use them as libraries in other applications.
In my past projects I must write the same code for reapited functionalities again and again. One of them was operation "Remove new row" so as to user could resign from data inserted to a form but uncommitted. Obviously we have "Rollback" data control, but it clears row selection on the all iterators belongs to the same application module.

To be frank, I don't know why Oracle programmers didn't implement this mechanism as one of the default data contols for iterator, so - "nobody's perfect".
After creation new Generic project we need to add ADF Model Generic Runtime library - it's required to pass to component as attribute DCIteratorBinding class.

We also must create managed bean, define action for our button and next, bind this action to button. Source code for our command control should looks like below:


After packaging component to JAR file, we can add it to the main project. After this step it should appears in the Component Palette

The last step is to drag our component onto the page and using Expression Builder to bind an iterator to remove uncommitted data.

To know more about declarative creation components in ADF read:

How-to create declarative components and how-to bind them to ADF and PPR
How to Access Attributes of a Declarative Component from a Managed Bean
Fusion Developer's Guide - Reusing Application Components

Download JDeveloper 11G Workspace. After downloading change extension to ".zip" and unpack.

In the most of applications common requirement are dependent list boxes. In decribed example I created three lists

To obtain this, I created 4 read only View Objects with bind variables

Good practice is also enforce on user suitable order of selection - in this case: Country, Location, Department

It can be obtained using disabled and rendered attributes

Also, all of the listboxes should have own Value Change Listener to tell binding layer when invoke ExecuteWithParams method and clear next listbox

Download JDeveloper 11G Workspace. After downloading change extension to ".zip" and unpack.

LewisC's An Expert's Guide to Oracle Technology I've finally done it. Everyone seems to be having difficulties defining just exactly what cloud computing really is. I have it down to a single sentence: Cloud computing is using the internet to access...

Don't miss David Giammona's blog-opening post about the new ADF Declarative Debugger that we added to JDeveloper/ADF 11g just in time for the production release.

LewisC's An Expert's Guide to Oracle Technology My SQL book is now available for print. You can see it on my CreateSpace e-store. The book is SQL DML - SQL Starter Series Book 1. This is a book for beginners. It takes someone step by step through TC...

Packt is a publishing company. I will be reviewing one of their books here in the near future. They are doing a survey and anyone who responds can get 40% off any ebook in their inventory. I just wanted to pass this along. The survey is only 9 quest...

Presented by GoldenGate Software and Oracle Corporation
Event Date: December 11, 2008
Live Start Time: 10:00 AM PST / 1:00 PM EST
Live Event Duration: 1 hour

Speakers: Oracle’s Group Vice President for CRM Applications, George Jacob, is joined by certified partner GoldenGate Software’s Vice President of Technology, Alok Pareek.

Attendees will learn how to successfully upgrade to Siebel 8.0 with zero downtime and vastly improve transition success. This upgrade approach allows customers to more quickly realize the ROI of the latest release of Siebel particularly with the rising cost of ownership by staying on older versions.

To Register, click here

I've added example #136 that illustrates a technique for adding a custom item (checkbox, in this case) to a declaratively-defined LOV search form. The checkbox toggles whether or not a custom SQL predicate gets applied to the view object's query which is providing the list of valid values to pick in the LOV.

Well, I pretty much have the first book written. It is a SQL newbies guide called SQL Starter - DML. In it, I give the details about DML. I plan to follow on with two more in the starter series, Intro to Relational Databases and SQL Starter - DDL. I...