Feed aggregator

New blade enclosure from Sun

Hampus Linden - Sun, 2007-06-10 11:34
Ever since Andy Bechtolsheim returned to Sun pretty much everything on the Sun x64 server line meet all expectations and then some. Sure, there has been the slight ethernet chipset problem, but generally the AMD kit has really kicked ass
Though some people where surprised to see first (new) blade offering from Sun, the 8000 series. A 4-socket blade offering when most of the market moved away from larger blade enclosures and focused on 2-socket systems. The 8000 still made good sense for larger customers like financial institutions and telcos. Server consolidation on a large level.

Now the other day Sun released a second (third actually, the 8000 comes in two models) blade offering. The 6000 series. It's a fairly basic 10U enclosure, 10 blade slots and the classic Ethernet modules. Not very exciting at first glance, I have to admit. Sounds like the PowerEdge 1955 box but not with the same high density (Dell can do 10 blades in 7U).
The thing cool about the 6000 enclosure is that it is not a Blade enclosure in the classic sense, it's not "stripped down computers in a box". It's actually 10 high capacity servers. It enclosure offers the same expandability as normal 1U servers.
All blade modules are dual socket, can take up to 16 DIMMS, four 2.5" SAS drives and even two PCI-e slots. That's right, normal PCI-e slots, no more proprietary on board FC-AL or Infiniband modules. Just slot in a couple of standard c-PCIe cards and off you go. No more opening up the blade to install modules.
Another new feature is a hardware RAID controller on-board (for good and bad indeed).
The whole enclosure is based around industry standards and open solutions.

In addition to all this cool stuff the real winner here is the selection of blades.
Sun offers no less than 3 blade types.
The t6300 UltraSPARC T1 blade,
the x6220 AMD blade and
the x6250 Intel Xeon blade
It's the first Intel Xeon (including quad-core procs) offering from Sun, with many more to come.

Watch Andy talk about the new box here.

Joe's Blog: Google Street View

Joe Fuda - Fri, 2007-06-08 13:00

Here's something cool. A new Google Maps feature called "Street View" is available for some streets. With it you can "virtually" walk down a road seeing actual street level photographs as you go. You can pan the image 360 degrees or zoom in and out as you please.

Here's a Google Maps Street View image of Marine World Parkway in front of Oracle's HQ buildings in Redwood Shored, CA. Click on the E or W arrows to travel along the road or click and hold the image then drag your mouse pointer to the right to see the fountain and more buildings.


Oracle Database Migration has reached the next level!

Donal Daly - Fri, 2007-06-08 04:24
SQL Developer 1.2 is now production and with it our new integrated migration workbench. Find out more information on OTN here. Over the last 6 months or so as I have talked about this new product, I used the tag line "Taking database migration to the next level", well... I think we are there now. We are the first database vendor to provide an integrated migration tool into a developers IDE with all of the resulting productivity benefits this brings.

The SQL Developer Migration Workbench is the tool to aid in the migration of third party databases onto the Oracle platform. This tool allows you to migrate your existing Microsoft Access, Microsoft SQL Server and MySQL databases (including schema objects, data and stored procedures/functions) to Oracle.

Features of this production release include:
  • Enhanced user interface - This release harnesses the enhanced GUI environment of SQL Developer and works seamlessly with other SQL Developer components. This means that users have one tool to browse third-party databases, migrate selected objects to Oracle and then work with them.
  • Existing SQL Developer users should find the Migration Workbench familiar and easy to use.
  • Quick Migration Wizard provides the easiest and quickest means of doing a database migration.
  • Step driven migration offers control at each stage of the migration process.
  • Fine grain migration support provides users with the ability to select specific objects for migration.
  • Least privilege migration - The ability to migrate objects from source to target without the need for dba rights. The workbench will migrate objects it has rights to view so does not require any special privileges to run.
  • Platform Supported:
    • Supports Microsoft Access versions 97, 2000, 2002/XP, 2003
    • Microsoft SQL Server 7, 2000, 2005
    • MySQL versions 3, 4, 5.
  • Parallel Online data move - The ability to move the data using a number of parallel connections for increased throughput.
  • Offline data move script generation - Generates scripts to allow for export of source data and import to target database of offline data move. We also support offline capture as well.
  • Language Translation Features - Supports translation of stored programs, procedures, functions, triggers, constraints and views defined in Transact SQL or Microsoft Access SQL.
  • Translation scratch editor - An interactive editing facility for Transact SQL and Microsoft Access SQL allowing for instant translation to PL/SQL or SQL. This editor supports both single-statement translation and translation of entire SQL scripts.
  • Translation difference viewer - Inline difference viewer for examining translated SQL. This viewer provides color coded side-by-side comparison of translated SQL to display semantic similarities between the source and translated code.
  • Any many more interesting features for you to find out about....
We have also prepared a number of online demos (viewlets) so you can see this new tool in action. Check them out on OTN here.

I am very proud of what my team has achieved with this release. A lot of work over the past year has gone into it. This is only the beginning, expect further innovative releases from the database tools team in the future.

I would like to thank our early adopters who provided some very constructive feedback. Hopefully you see the results of your feedback in this production release.

Transformations: Numbers to Words (New SQL Snippets Tutorial)

Joe Fuda - Thu, 2007-06-07 16:00
Two new techniques for converting numbers into words have been added to SQL Snippets. Unlike the ubiquitous Julian based solution (which uses the J and JSP format models) the new SQL Snippets techniques use the fractional second format models FFn and FFSP. Using fractional second models produces solutions that, unlike the Julian solution, can handle the numbers 0, 1,721,058 to 1,721,423, and those greater than 5,373,484 without errors or elaborate workarounds.

Start OC4J with user thread option

Wijaya Kusumo - Wed, 2007-06-06 03:07
When starting an OC4j using datasource, this error may arise: "Javax.naming.NamingException: Not in an application scope - start Orion with the -userThreads switch if using user-created threads" Solution: If using stand alone OC4J, start it with -userThreads parameter. For example: java -jar oc4j.jar -userThreads If using Oracle Application server, add the oc4j.userThreads=true parameter to <

Checking Oracle Application Server version

Wijaya Kusumo - Wed, 2007-06-06 02:35
I was trying to find the exact version of Oracle Application Server installed months ago. A simple task, but may not be straight forward if you don't know where to find it. .. After searching for a while, the fastest way to find it is to check the installation report. You can find it at: <ORACLE_HOME>/install/readme.txt As a bonus, it also shows where is the exact URL to the Enterprise Manager

Who likes JDeveloper and who pooh-poohs?

John Stegeman - Tue, 2007-06-05 06:22

Jan Vervecken started a recent thread on the OTN JDeveloper Forum entitled, “The forgotten Java IDE?” It’s quickly garnered a lot of replies (57 at the current count!). It’s lead me to do some thinking and some researching around the Web.

To paraphrase both Blondie aka “the man with no name” (Clint Eastwood) and Tuco (Eli Wallach) as they were wont to say in my all-time favorite movie, “There are two types of people in the world my friend, those who like JDeveloper, and those who pooh-pooh it.” Well, the world is more complex than that, but it seems to be the case that a given person either loves JDeveloper, or thinks it’s completely useless and irrelevant. Can both types of people be talking about the same thing?

In my experience on the OTN forums, at Java One, and from reading blogs and other Internet posts, I’ve been able to create some stereotypes of the two types of people, and gain some insight into the “why” of the stereotypes.

People who like JDeveloper tend to:

  • Already be Oracle customers
  • Have experience with 4GL languages, especially Oracle Forms
  • Use Oracle’s Application Development Framework (ADF)
  • Like the integrated SOA development tools in JDeveloper

People who pooh-pooh JDeveloper tend to:

  • Think of themselves as “hard-core” java programmers or “java gurus”
  • Dislike anything “proprietary,” and thus tend to discount ADF
  • Really like open source, “free” things (although, as a sidebar, my friend always used to say, “if it’s free, I can’t afford it”)

People who have traditionally used Oracle’s (quite good) 4GL tools like Oracle Forms tend to be able to jump right in to ADF, with some training of course, and work in JDeveloper in a familiar paradigm. For them, learning Java/J2EE in the context of doing a JDeveloper/ADF project, tends to be, “teach me the syntax” and, “learn the ADF framework.” All of the J2EE complexity is hidden under the covers of the ADF framework for these folks.

The hard-core java guys, on the other hand, want to fiddle with every bit and byte. Now, in my opinion, JDeveloper can do this just as well, if not better, than the other IDE’s out there (Eclipse, Netbeans, IntelliJ, etc); however, most of these folks already have an established IDE preference, and changing IDE’s is something that requires a conscious effort and reason to change. Thus, even though I really like JDeveloper, and think it’s a world-class IDE, and would like more people to use it (selfish reasons, I guess – I want to ensure that Oracle will always be putting lots of effort into new releases), I would say to this group of people, “keep using whatever you are using.” If you want a nice productive database development environment, or a nice BPEL development environment, come on over and take a look. Heck, I’d be willing to bet that most of the hard-core guys, if they would be willing to take an honest look at ADF, would find that there are some good things there for them.

As to which type of person am I… I’ve got some characteristics of both. I’ve done some Oracle Forms (mostly Forms 2.3 and Forms 3.0!) programming in my life. I actually got my start doing more hard-core C/C++ programming and did “hard-core” java before I got into ADF; so I guess I don’t fit the stereotypes I’ve laid out here.


Way Cooler: PCA and Visualization - Linear Algebra in the Oracle Database 2

Marcos Campos - Mon, 2007-06-04 12:05
This post shows how to implement Principal Components Analysis (PCA) with the UTL_NLA package. It covers some of the uses of PCA for data reduction and visualization with a series of examples. It also provides details on how to build attribute maps and chromaticity diagrams, two powerful visualization techniques.This is the second post in a series on how to do Linear Algebra in the Oracle Marcoshttp://www.blogger.com/profile/14756167848125664628noreply@blogger.com6
Categories: BI & Warehousing

New Oracle and .NET beta available now!

Christian Shay - Sun, 2007-06-03 23:06
A major beta release is available now for ODP.NET as well as Oracle Developer Tools for Visual Studio .NET. This 11g beta release also marks the first release of a new product, Oracle Providers for ASP.NET. I've written a new white paper (with lots of screen shots) that illustrates the new Visual Studio enhancements. Keep an eye on this blog in the weeks ahead as I will be writing articles explaining how to take advantage of some of the new features such as ASP.NET code generation and User-Defined Type (UDT) support...

We also have some new Oracle by Example walkthroughs that can help get you started:
Oracle by Example: Building ASP.NET Web Applications with ODT
Oracle by Example: Building .NET Applications Using ODT

Here's a summary of the new features:

Oracle Developer Tools for Visual Studio .NET New Features:

  • Visual Studio 2005 integration with Server Explorer, Data Sources Window, Dataset Designer, TableAdapter Configuration Wizard and more
  • Improved ASP.NET web developer support
  • Oracle Database script project to provide source control of Oracle scripts
  • SQL script editor
  • Built in support for executing SQL*Plus scripts
  • Explain plan support
  • Integration with Query Designer
  • New designer for granting/revoking privileges on schema objects
  • User-Defined Types: Create, explore, modify UDTs; custom class code generation for .NET applications
  • Data Window and Query Window enhancements

  • Oracle Data Provider for .NET:

  • Instant Client Support: Smaller ODP.NET client installation
  • User-Defined Types: Map Oracle objects and collections to .NET custom types and support REFs to object types
  • Process Database Down Events: ODP.NET automatically frees connections of a downed Data Guard instance
  • Windows-Authenticated User Connection Pooling: Windows-authenticated connections can now be pooled.
  • Connection Pool Performance Counters: Monitor connection pool status

  • Oracle Providers for ASP.NET:

  • Membership Provider: Stores and retrieves registered user information in the Oracle database
  • Role Provider: Stores and retrieves user role information in the Oracle database
  • Site Map Provider: Stores and retrieves site map information in the Oracle database
  • Session State Provider: Stores and retrieves session state information in the Oracle database
  • Profile Provider: Stores and retrieves user profile information in the Oracle database
  • Web Events Provider: Stores and retrieves ASP.NET health monitoring event information in the Oracle database
  • Web Parts Personalization Provider: Stores and retrieves personalization data in the Oracle database
  • Cache Dependency Provider: Automatically invalidates ASP.NET cached data based on changes made to the base data in the Oracle database
  • Exception Handling in BPEL

    Peeyush Tugnawat - Sun, 2007-06-03 14:47

    I did not realize that its been a while since I posted anything on my blog. Well we all get busy once in a while and that was the case with me as I got really busy with my current project. The good thing is I have few things to share that came out of my experience working with BPEL.

    For exception handling, I learned that the function called ora:getFaultAsString was missing from the bpel designer (10.1.3) and it was not returning the detailed information about the fault. There are two patches that can help on this issue 5672007 & 5841736.


    SQL Interview Questions

    Robert Vollman - Sun, 2007-06-03 11:59
    You pick up the candidate's resume and it proudly proclaims "SQL Expert: 10 Years." Your boss trusts you, as the technical expert on the team, to participate briefly in the interview to gauge this individual's knowledge of SQL. Where to begin?I have asked literally hundreds of different questions during interviews over the past decade. Some were simple questions that were nevertheless Robert Vollmanhttp://www.blogger.com/profile/08275044623767553681noreply@blogger.com30

    Conditionally showing fields based upon attribute value part deux

    John Stegeman - Sun, 2007-06-03 08:59

    This is the second in a two-part series showing how to conditionally show/hide fields based upon the value of another field. In case you haven’t read the first part, start here.

    As we left before the commercial break, we had just set up the navigation links between our emplist and empedit pages. Let’s first fix up the “Edit” and “New Employee” buttons on the emplist page so that clicking them will take us to the edit page. To do this is really quite simple. For the edit button, select the button using either the visual editor or the structure window; then, use the property inspector to set the Action property to “edit,” which is the navigation case you created. There’s even a drop-down list in the property inspector – JDeveloper knows about the navigation cases, and thus can give you a drop-down list. Now, just do the same thing for the “New Employee” button; in this case, at run-time, the action listener (which creates the new employee record) will fire first, and then the action property causes the navigation case “edit” to fire, taking you to the empedit page.

    Now, let’s create the skeleton of the empedit page. First, ensure empedit.jspx is shown in the visual editor. Then, in the data control palette, drag MyEmpView1 to the empedit.jspx page and drop it. In the pop-up menu, select “Forms” and then “ADF Form” from the sub-menu. Ensure the “Include Submit Button” checkbox is selected and click “OK.”

    Let’s next add a commit button to the page so that the changes can be saved to the database. In the data control palette, expand the AppModuleDataControl and then expand the “operations” folder from the data control – be sure it’s the AppModuleDataControl’s operations folder, and not the MyEmpView1’s. If you have the correct one, you’ll see Commit and Rollback operations. Drag the commit operation and drop it on to the empedit.jspx page next to the submit button. In the pop-up menu, choose “ADF Command Button.” Finally, select the “Commit” button and use the property inspector to set the Action property to “returntolist.” This will make clicking the commit button take us back to the list page as well as committing the data to the database.

    Now, we’ve got a basic working application. Let’s test it; right-click the emplist.jspx page in the applications navigator and choose “run.” You should see an (empty) list of employees. Click the “New Employee” button, fill in some values, and click commit. You can also test editing an employee you create (use the “submit” button to submit changes and make ADF enable the commit button). For now, create at least two employees, one with emptype of “H” and one with emptype of “S.” Here’s what my emplist.jspx looks like after I did that:

    There’s a lot more we should to to make this a real application (adding a “Cancel” button, for example), but I’ll leave that to you. What we really want to show now is how to make the Salary field hidden (and set to null in the database) when the employee type is “hourly” and make the Hourly Rate field hidden (and set to null in the database) when the employee type is “salaried.” There are a number of ADF Faces controls we could use to implement this (they all start with “ShowOne”), but for this example, let’s use a ShowOneRadio.

    In the Component Palette, ensure the ADF Faces Core components are showing and locate the ShowOneRadio. Drag it to the empedit page and drop it between the Emptype and Salary fields (it’s easiest if you use the Structure window). Use the property editor to change the label to “Employee Type.” You should now have something that looks like this:

    The “ShowOne” components work by having “ShowDetail” components as their children. So, locate the ShowDetail component in the Component Palette and drag one to the af:showOneRadio you just created; again, it’s easiest if you use the Structure window to ensure you are dropping it on the right component. Use the property inspector to change the Text property to “Hourly.” Then, repeat the same process to create another ShowDetail component with its text set to “Salaried.” When you are done, the Structure should look something like this:

    The next step is to put the Salary and HourlyRate fields into the appropriate ShowDetail component. To do this, just use the structure window to drag the Salary’s af:inputText component to the “Salaried” showDetailItem and the Hourly Rate’s af:inputText component to the “Hourly” showDetailItem. Your structure now should look like this:

    If you run the application now, you’ll see that clicking the Hourly or Salaried radio buttons automatically hide/show the appropriate fields; however, the value of the EMPTYPE field doesn’t have anything to do with the radio buttons at this point. We’ll need to write some code to make that part work.

    The code that you will write needs to be in a java class known as a “managed bean.” We’ll let JDeveloper create the managed bean for us. If you click one of the af:showDetailItem components and look in the Property Inspector, you’ll see a property called the “Disclosure Listener.” This is where we will write our Java code (for you experts out there, yes, the af:showOneRadio has an attribute change listener that is a better place for the code, but for some reason, it does not fire correctly in JDev To create the managed bean, select the Hourly showDetailItem in the Structure window and then click in the blank field next to “DisclosureListener” in the Property Inspector. You should see a button appear with an elipsis (…) in the label – click this button. You’ll get a dialog that looks like this:

    Click the “New…” button to create a new managed bean. Use “empedit_bean” for both the name and class and leave the scope set at request:

    After clicking “OK”, click the “New…” button next to the Method drop-down list. Provide a method name of “hourly_disclosed” and click “OK.” The dialog now looks like this:

    Click “OK” in the managed bean window. You should see a new tab at the top of the editor for the empedit_bean.java file that was just created. The code looks like this:

    import oracle.adf.view.faces.event.DisclosureEvent;
    public class empedit_bean
     public empedit_bean()
    public void hourly_disclosed(DisclosureEvent disclosureEvent)
     // Add event code here...

    Let’s add some simple code to the disclosure listener so that we can see how it works. Change the hourly_disclosed method so that it looks like this:

    public void hourly_disclosed(DisclosureEvent disclosureEvent)
    if (disclosureEvent.isExpanded())
    System.out.println(“The hourly type was selected”);
    System.out.println(“The hourly type was not selected”);

    Now, let’s create a disclosure listener for the Salary radio button. Just type this code into the editor:

    public void salaried_disclosed(DisclosureEvent disclosureEvent)
    if (disclosureEvent.isExpanded())
    System.out.println(“The salaried type was selected”);
    System.out.println(“The salaried type was not selected”);

    Finally, go back to the empedit.jspx page and select the af:showDetailItem for Salaried. In the property inspector, click the elipsis-button next to the DisclosureListener property and pick the empedit_bean managed bean and salaried_disclosed method:

    Now, when you run the application and click the Hourly and Salaried radio buttons, you should see a pair of messages in the log window for each click. This shows us that our code is running correctly. We now just have two steps remaining. The first is to make the value in the database field EMPTYPE determine which radio button is selected. This is really quite simple. If you go back to the empedit.jspx page and select the “Hourly” af:showDetailItem, you’ll notice a property in the property inspector called “Disclosed,” which is set to false. What we will do is to use an Expression Language (EL) expression to set the item to be disclosed if the value of the EMPTYPE field in the database is “H.” To do so, click the Disclosed property in the inspector. You should see the “Bind to data” button become available in the property inspector toolbar – it looks like this:

    Click the Bind to data button; this displays JDeveloper’s EL editor. In the editor, expand the ADF Bindings folder, then the bindings container. You should see an attribute binding for “Emptype.” Finally, expand that binding and double-click on the InputValue property. The Expression builder should now look like this:

    Complete the expression by typing so that it reads:

    #{bindings.Emptype.inputValue == “H”}

    Remember before when we set the default value of the field EMPTYPE to “H?” This is so we didn’t have to code for the special NULL case here, although it’s not too difficult. Now, repeat the same process for the Salaried af:showDetailItem, except the “disclosed” property should be:

    #{bindings.Emptype.inputValue == “S”}

    At this point, if you run your application and edit the two employees you created earlier (one hourly and one salaried), you should see the correct radio button selected and the correct field shown.

    We now just have some cosmetic issues to clean up (we still have the EMPTYPE field on the screen) and one remaining problem: clicking the Hourly and Salaried radio buttons do not change the value of the EMPTYPE field – we haven’t written the code to make this happen yet. Let’s start by getting rid of the EMPTYPE field. If you just click on the EMPTYPE af:inputText and delete it, it will also delete the binding in the underlying page definition, which will make our page break, because we use that binding. Here’s a little trick that I use to avoid this behavior. Before you delete the af:inputText item, open the page definition for empedit.jspx by right-clicking in an empty area of the empedit.jspx page and choosing Go to Page Definition. Now, you can go back to the empedit.jspx page and delete the EMPTYPE field. Now, just switch back to the page definition and close it, answering “no” when prompted to save changes.

    The last item remaining is to set the value of the EMPTYPE field as we click the radio buttons for Hourly and Salaried employees. This code will go into the disclosure listeners. Let’s code a simple utility method into our backing bean that will allow us to set the employee type, and we can call that utility method from the disclosure listeners. For good measure, let’s also NULL out the salary for hourly employees and null out the hourly rate for salaried employees. I provide the code here with no explanation; this is pretty straightforward JSF code at this point:

    private void setEmpType(String type)
    FacesContext ctx = FacesContext.getCurrentInstance();
    Application app = ctx.getApplication();
    ValueBinding bind = app.createValueBinding("#{bindings.Emptype.inputValue}");
    bind.setValue(ctx, type);

    if (“S”.equals(type))
    bind = app.createValueBinding(“#{bindings.Hourlyrate.inputValue}”);
    bind = app.createValueBinding(“#{bindings.Salary.inputValue}”);

    bind.setValue(ctx, null);

    Now, it’s simply a matter of fixing up the disclosure listeners to look like this:

    public void hourly_disclosed(DisclosureEvent disclosureEvent)
    if (disclosureEvent.isExpanded())


    public void salaried_disclosed(DisclosureEvent disclosureEvent)
    if (disclosureEvent.isExpanded())

    There we are…. there are lots of little things that can be cleaned up and made more robust, but that’s the technique.

    Conditionally showing fields based upon attribute value

    John Stegeman - Sun, 2007-06-03 06:22

    A recent post on the OTN JDeveloper Forum asks how to hide/show fields on an ADF Faces page depending upon the value of another attribute. I’ve concocted a simple example to show the technique I used in a recent project to accomplish this.

    The business case in the example is quite simple: we want to create a page to allow us to create and edit employee information. There are two types of employees: salaried employees and hourly employees. Salaried employees earn a yearly salary regardless of how many long hours they work (sounds familiar), whereas hourly employees earn an hourly rate for each hour they work. Our database table looks like this:

    create table my_emp
    (empno number not null primary key,
    emptype varchar2(1) not null,
    salary number,
    hourlyrate number);

    On our employee edit screen, we want to show the salary field if the employee type is “S” (for salaried) and show the hourlyrate field if the employee type is “H”. In both cases, the field that does not apply to the particular employee should be hidden AND should be automatically set to null in the database. We’ll also create a typical list screen that lets us browse through the employees and select one to edit, and also to create new employees.

    I will walk quickly through the preliminary steps, and slow down later on to show the details. This example should work with any of the point releases of JDeveloper 10g R3 (10.1.3.x).

    To get started, use your favorite tool (SQL*Plus, SQL Developer, JDeveloper, etc) to create the table as shown above. Then, in JDeveloper, create a database connection to the database/account that owns the table you created. Finally, create a new application, selecting the “Web Application [JSF, ADF BC]” template in the directory of your choice:

    In your newly created application, you should have two projects – “Model” and “ViewController.” The next step is to create some ADF Business Components for the my_emp table. In this example, we’ll just create some basic stuff (a single Entity Object, a default editable View Object, and a default Application Module). To do this, right-click the Model project and choose “New…” In the dialog that appears, choose “ADF Business Components” in the categories pane and “Business Components from Tables” in the items pane:

    You’ll be prompted to initialize your project for business components. Pick the connection you created earlier (and the SQL flavor and type map if you are not using an Oracle database) and click “OK.” Now, you’ll quickly walk through the wizard to create the default business components. Click “Next” to dismiss the welcome screen, if it is shown. On the next screen, type “my_emp” in the name filter and press “Query” to display the table you created earlier; use the shuttle controls to add the MY_EMP table to the selected list:

    Click “Next” to display the “Updatable View Objects” page of the wizard; use the shuttle controls to add the MyEmp Entity Object to the selected list:

    From here on out, we will just be taking the defaults for the wizard, so you can click “Finish.” If you’d like to see the steps one-by-one, you can click “Next” on each page to see them. Once you are done, you will have a single Entity Object called “MyEmp,” an updatable View Object called “MyEmpView,” and an Application Module called “AppModule,” which has MyEmpView in its data model. You can see these objects by expanding the folders under the Model project in the Applications Navigator. To make things a bit easier down the road, let’s set a default for the employee type to “H” for hourly. To do this, double-click on the MyEmp entity object. In the dialog that appears, expand the Attributes tree on the left side and click the “EmpType” attribute. Now, in the right pane, enter “H” into the default value field and press “OK” when done:

    That’s it for the data model; in real life, you’d of course give some nice attribute names, display hints, etc, etc, but I’ll leave that to you. The next step for this exercise is to create the JSF pages. We will first create a simple list-type page that lists the employees and allows us to select an employee to edit or to create a new employee. To do this, right-click the “ViewController” project and select “New…” In the dialog that appears, select “JSF” from the categories pane and JSF JSP from the items pane. Click “Next” to dismiss the welcome page, if it is shown; this will display the “JSP File” step of the wizard. Let’s call our page “emplist.jspx” Make sure the “JSP Document” radio button is selected for the document type:

    Click “Next” to display the component binding page. As we do not need component bindings, click “Next” to display the tag libraries page. Ensure that you have the 4 libraries selected as shown here:

    Now, you can click “Finish” to complete the wizard. While we are at it, follow the same steps to create an “empedit.jspx” page. Now, let’s finish the emplist page – it’s the simpler of the two. To create an ADF Faces table, go to the Data Control Palette window in JDeveloper. You should see a single data control called “AppModuleDataControl.” Expand the data control, and you’ll find your single view object, “MyEmpView1.” Ensure that you have the emplist.jspx page open in the visual editor and drag the “MyEmpView1” view object on to the emplist.jspx page. In the pop-up menu that appears, select the “Tables” menu and then the “ADF Read-only” table from the sub-menu. Ensure that you click the “Enable Selection” checkbox and click “OK.” You’ll now see the af:table added to your page. If you run the page now, you’ll see an empty table because there are no rows in the database.

    Next, let’s add “Edit” and “New Employee” buttons to the page. First, get rid of the “Submit” button that JDeveloper created for you automatically by selecting it and hitting the Delete key. The “Edit” button that we are going to add must be inside of the af:tableSelectOne object that exists inside of the “selection” facet of the table. My preferred way to drag-and-drop components is to use the structure window in JDeveloper, because it gives me the most precision. So, expand the items in the structure window until you get to the af:tableSelectOne object (you can also click on the radio buttons in the “Select” column of the table to do this automatically):

    Now, find the Control Palette window in JDeveloper. Select “ADF Faces Core” from the drop-down at the top of the palette and find the “CommandButton” component. Drag this component and drop it into the af:tableSelectOne on your page. If you’ve done it correctly, you’ll se an af:commandButton inside of the af:tableSelectOne in the structure window, and your page will look like this:

    Use the Property Inspector window of JDeveloper to change the text of the button to “Edit.” Now, let’s add the “New Employee” button. Because the “New Employee” button does not require an employee to be selected first, it doesn’t belong in the selection facet of the table, but the “actions” facet. First, make sure that you can see the actions facet in JDeveloper’s structure window; secondly, in the Data Control Palette, expand the AppModuleDataControl, the EmpView1, and the Operations folder. Find the “Create” operation and drag it into the actions facet, using the structure window. In the pop-up window that appears when you release the mouse, select ADF Command Button. You can now use the property inspector to change the text of the command button to “New Employee.”

    Now, without going into a long explanation of why (read the docs if you must), we need to change the binding on the “New Employee” button from the “Create” action to “CreateInsert.” To do this, right-click in a blank area of the emplist.jspx page and choose “Go To Page Definition.” Using the structure window, expand the bindings folder and double-click on the “Create” binding. In the window that appears, change the action from “Create” to “CreateInsert:”

    Now, save and close the page binding. The final piece of work we need to do on this page is to set up some navigation cases so that we can navigate back and forth between the list and edit pages. I’m not going to walk through all of the steps here (a quick read of the docs should set you in the right direction). Create two navigation cases, one going from emplist.jspx to empedit.jspx called “edit” and one going from empedit.jspx to emplist.jspx called “returntolist.” Here’s what my faces-config.xml navigation diagram looked like after this step:

    Wow – this is more steps than I thought…. continued in part deux.


    Fairlie Rego - Sat, 2007-06-02 08:25
    There are so many new views in 10G that you begin to wonder if many of them are
    actually populated correctly. For example there are quite a few bugs with some of the DBA_HIST* views not being populated correctly. One such view DBA_HIST_TBSPC_SPACE_USAGE is notorious for incorrect values .But the view DBA_HIST_FILEMETRIC_HISTORY which supposedly stores alerts only for 7 days does not even seem to be getting populated.

    So on a database

    SQL> select count(*) from dba_hist_filemetric_history;


    If you have a look at the definition of the view from catawrvw.sql

    create or replace view DBA_HIST_FILEMETRIC_HISTORY
    select fm.snap_id, fm.dbid, fm.instance_number,
    fileid, creationtime, begin_time,
    end_time, intsize, group_id, avgreadtime, avgwritetime,
    physicalread, physicalwrite, phyblkread, phyblkwrite
    from wrm$_snapshot sn, WRH$_FILEMETRIC_HISTORY fm
    where sn.snap_id = fm.snap_id
    and sn.dbid = fm.dbid
    and sn.instance_number = fm.instance_number
    and sn.status = 0

    SQL> select count(*) from WRH$_FILEMETRIC_HISTORY;


    I have tried various ways to get this base table populated but
    am not sure when information is flushed to WRH$_FILEMETRIC_HISTORY.
    This behaviour is also consistent in

    Returning into clause and post statement triggers

    Jornica - Fri, 2007-06-01 17:04

    If you are using RETURNING INTO clauses with DML statements and you are also using (post statement) triggers then you should be aware of the following caveat where the values of the RETURNING INTO do not match the column values.

    To show this behavior, set up a small test case first. A table t1 with one column c1 with an after insert statement trigger, modifying the c1 column.

    SQL> CREATE TABLE t1(c1 VARCHAR2(10));

    Table created.

    2 BEGIN
    3 UPDATE t1
    4 SET c1 = 'TRIGGER';
    5 END;
    6 /

    Trigger created.

    Insert a row in t1 and return the new value of c1 into bind variable c1.

    2 /

    1 row created.

    And inspect the contents of the table and the value of the bind variable.

    SQL> SELECT c1 "column",
    2 :c1 "bind"
    3 FROM t1
    4 /

    column bind
    ---------- ----------

    1 row selected.

    As expected the value of column c1 is TRIGGER. The value is the bind variable is SQLPLUS. This value is set before the after statement trigger starts.

    Although this code is not production code, you might notice this behavior in production code as well: I discovered this behavior hidden in a mutating table workaround.

    Access Migration Tutorial

    Donal Daly - Thu, 2007-05-31 13:33
    Are you considering migrating that Microsoft Access application to Oracle Application Express? Well read on...

    Hopefully you are aware of Oracle SQL Developer and that we have redeveloped the Migration Workbench and integrated it tightly with Oracle SQL Developer. An early adopter version of this is available now and will be production very soon. More of that in a subsequent post.

    With Oracle Application Express 3.0 we introduced the Application Migration Workshop to assist with migrating your Access Forms & Reports. When I talk about this solution, I get asked do we have a step by step guide or methodology for such migrations. So, we have produced a migration tutorial to address this and have published it on OTN.

    We have taken the Microsoft Access sample application, Northwind Traders and migrated it to Oracle Application Express. The tutorial covers this in step by step detail. Following this tutorial would be a useful exercise for any user that wishes to undertake migrating their applications from Microsoft Access to Oracle Application Express. We have called the converted application Southwind Wholesalers. :-)

    You can see it running on apex.oracle.com and we have also provided it as a packaged application so you can examine it in detail.

    Run system commands from Oracle with PL/SQL

    Hampus Linden - Wed, 2007-05-30 15:55
    I friend of mine asked if it was possible to show the exact Linux kernel version on an Oracle server without actually having shell access to the server.
    He had full access to Oracle with sysdba/dba roles etc, but not SSH.
    I've seen some versions of executing system commands from Java but never really liked the idea of invoking Java for something simple like that.

    One way I thought of would be to use dbms_scheduler to execute a job with an executable job_typ. The first problem was to find a way to actually return the standard output from the execution to Oracle.
    Ok, so my 'hack' here is a stored procedure (entirely in PL/SQL) that creates a job with dbms_scheduler; calling /bin/sh as the executable and hands it a temporary script to execute. In the script I have a simple redirect to a temporary spool file and then the procedure simply reads and outputs the content of the file. It's a bit of a hack but at least it gets the job done and doesn't use Java.
    I haven't drilled down on what kind of permissions you need to actually use the procedure but I suspect it's quite a lot.
    The temporary spool file handling in my example is quite poor, but works. :)
    A word of warning as usual when using PL/SQL, this code example is a proof of concept. It needs *loads' of error catching etc. in order to be production ready, use with caution.

    Example of use:
    oracle@htpc:~$ rsqlplus hlinden/password as sysdba

    SQL*Plus: Release - Production on Wed May 30 21:55:06 2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Connected to:
    Oracle Database 10g Enterprise Edition Release - 64bit Production
    With the Partitioning, OLAP and Data Mining options

    SQL> set serveroutput on
    SQL> @system_run

    Procedure created.

    SQL> exec system_run('ls -l /home/oracle/bin');
    total 12
    -rwxr-xr-x 1 oracle dba 797 Nov 5 2006 backup_controlfile.sh

    PL/SQL procedure successfully completed.

    SQL> exec system_run('uname -a');
    Linux htpc 2.6.20-15-generic #2 SMP Sun Apr 15 06:17:24 UTC 2007 x86_64 GNU/Linux

    PL/SQL procedure successfully completed.

    And here is the procedure code:
    CREATE OR REPLACE PROCEDURE system_run(cmd IN varchar2)
    script_file varchar2(40) := 'my-temp-script.sh';
    script_data varchar2(4000);
    MyFile utl_file.file_type;
    d varchar2(4000);
    dump_file varchar2(40) := '/tmp/my-temp-file.dat';
    dump_type utl_file.file_type;
    -- Open file
    MyFile := utl_file.fopen('TMP',script_file,'w');
    -- Write data to file
    script_data := '#!/bin/bash' || chr(10) || cmd||'>'||dump_file;
    utl_file.put_line(MyFile, script_data, FALSE);
    -- Close file
    -- Purge old logs, no fun anyway
    -- Execute script
    -- The job is created as disabled as
    -- we execute it manually and will
    -- drop itself once executed.
    job_name => 'TEST',
    job_type => 'EXECUTABLE',
    job_action => '/bin/bash',
    number_of_arguments => 1,
    start_date => SYSTIMESTAMP,
    enabled => FALSE);
    dbms_scheduler.set_job_argument_value('TEST', 1, '/tmp/'||script_file);
    -- Wait for the job to be executed
    -- usually done within 1 second but
    -- I set it to 2 just in case.
    -- Open the output file and
    -- print the result.
    dump_type := utl_file.fopen('TMP',dump_file,'r');
    when others then
    end loop;
    -- Clean up our temp files
    utl_file.fremove('TMP', script_file);
    utl_file.fremove('TMP', dump_file);

    Multirow Inserts

    Robert Vollman - Mon, 2007-05-28 12:36
    While attempting to insert several rows into a table in our Oracle database, a colleague dutifully copied the exact ANSI/ISO SQL standard syntax for his purposes. Guess what happened?INSERT INTO table (column1, column2)VALUES (value1, value2), (value1, value2);ERROR at line 1:ORA-00933: SQL command not properly endedUnlike some other databases (DB2, PostgreSQL, MySQL), Oracle doesn't support Robert Vollmanhttp://www.blogger.com/profile/08275044623767553681noreply@blogger.com7


    Robert Baillie - Mon, 2007-05-28 12:02
    And to follow on from the last post... my current personal bests: I figure if I keep them here, at least I'll always know where they are! 5km Run23:44 (Battersea Park, 'Beat the Baton' 28/05/07) 10km Run53:23 (Hyde Park, 'Run London' 08/10/06) Half Marathon2:17:49 (Redcar, 'Tees Valley Half Marathon' 12/03/06) Rubik's cube57 seconds


    Subscribe to Oracle FAQ aggregator