Charts in JDeveloper 10.1.3

With JDeveloper 11g you have many out of the box JSF graph components but too bad this isn't the case in JDeveloper 10.1.3. In this blog I will show you how you can have free graphs components and use it in 10.1.3.
First we need to download Chartcreator this is JSF tag library which works on jfreechart. With these two jars we can make the following charts pie ring timeseries xyline polar scatter xyarea xysteparea xystep bubble candlestick boxandwhisker highlow histogram wind bar stackedbar linearea stackedarea gantt waterfall

Here are some examples with ADF.




Add chartcreator as taglib to your project.
And add jfreechart and jcommon libraries to this project. We don't need the other libraries

Add the JSF chart component to your ADF page

             <chart:chart id="ChartTimeseries"
                          datasource="#{backing_chart.timeDataset}"
                          type="timeseries" is3d="true" antialias="true"
                          title="Timeseries" xlabel="year"
                          ylabel="Total" height="300" width="300"/>
             <chart:chart id="chartLine" datasource="#{backing_chart.dataset2}"
                          type="line" is3d="true" antialias="true"
                          title="Line" xlabel="year"
                          ylabel="Total" height="300" width="500"/>

We need a backing bean to provide the charts with data. Create and add a backing bean to the faces-config.xml

<?xml version="1.0" encoding="windows-1252"?>
<!DOCTYPE faces-config PUBLIC
 "-//Sun Microsystems, Inc.//DTD JavaServer Faces Config 1.1//EN"
 "http://java.sun.com/dtd/web-facesconfig_1_1.dtd">
<faces-config xmlns="http://java.sun.com/JSF/Configuration">
 <managed-bean>
   <managed-bean-name>backing_chart</managed-bean-name>
   <managed-bean-class>nl.ordina.view.backing.Chart</managed-bean-class>
   <managed-bean-scope>request</managed-bean-scope>
   <managed-property>
     <property-name>bindings</property-name>
     <value>#{bindings}</value>
   </managed-property>
 </managed-bean>
 <application>
   <default-render-kit-id>oracle.adf.core</default-render-kit-id>
 </application>
 <lifecycle>
   <phase-listener>oracle.adf.controller.faces.lifecycle.ADFPhaseListener</phase-listener>
 </lifecycle>
</faces-config>

The chart backing bean code

package nl.ordina.view.backing;

import oracle.adf.model.binding.DCBindingContainer;
import oracle.adf.model.binding.DCIteratorBinding;

import oracle.jbo.Row;
import oracle.jbo.RowSetIterator;
import oracle.jbo.domain.Number;

import org.jfree.data.category.DefaultCategoryDataset;
import org.jfree.data.general.DefaultPieDataset;
import org.jfree.data.time.TimeSeries;
import org.jfree.data.time.TimeSeriesCollection;
import org.jfree.data.time.Year;

public class Chart {
    private DCBindingContainer bindings;
    private DefaultPieDataset pieDataSet;
    private DefaultCategoryDataset dataset2;

    public DefaultPieDataset getPieDataSet() {
        return pieDataSet;
    }

    public DefaultCategoryDataset getDataset() {

        DefaultCategoryDataset dataset = new DefaultCategoryDataset();
        pieDataSet = new DefaultPieDataset();
        DCBindingContainer bc = getBindings();
        if (bc != null) {
            DCIteratorBinding normIter = 
                bc.findIteratorBinding("DepartmentEmployeesCountIterator");

            RowSetIterator rsi = normIter.getRowSetIterator();
            String[] attNames = rsi.getRowAtRangeIndex(0).getAttributeNames();

            int departmentIdNum = 0;
            int totalNum = 0;

            for (int j = 0; j < attNames.length; j++) {
                if (attNames[j].equalsIgnoreCase("DepartmentId")) {
                    departmentIdNum = j;
                } else if (attNames[j].equalsIgnoreCase("Total")) {
                    totalNum = j;
                }
            }

            for (int i = 0; i < rsi.getRowCount(); i++) {
                Row currentRow = rsi.getRowAtRangeIndex(i);
                Object[] attValues = currentRow.getAttributeValues();
                Number departmentIdValue = (Number)attValues[departmentIdNum];
                Number totalValue = (Number)attValues[totalNum];

                pieDataSet.setValue(departmentIdValue.toString(), 
                                    totalValue.toDouble(totalValue.getBytes()));
                dataset.addValue(totalValue.toDouble(totalValue.getBytes()), 
                                 "Employees", departmentIdValue.toString());
            }
        }
        return dataset;
    }

    public DefaultCategoryDataset getDataset2() {
        return dataset2;
    }

    public TimeSeriesCollection getTimeDataset() {

        dataset2 = new DefaultCategoryDataset();
        TimeSeries s1 = new TimeSeries("Year", Year.class);

        DCBindingContainer bc = getBindings();
        if (bc != null) {
            DCIteratorBinding normIter = 
                bc.findIteratorBinding("EmployeeHireYearIterator");

            RowSetIterator rsi = normIter.getRowSetIterator();
            String[] attNames = rsi.getRowAtRangeIndex(0).getAttributeNames();

            int yearNum = 0;
            int totalNum = 0;

            for (int j = 0; j < attNames.length; j++) {
                if (attNames[j].equalsIgnoreCase("Year")) {
                    yearNum = j;
                } else if (attNames[j].equalsIgnoreCase("Total")) {
                    totalNum = j;
                }
            }

            for (int i = 0; i < rsi.getRowCount(); i++) {
                Row currentRow = rsi.getRowAtRangeIndex(i);
                Object[] attValues = currentRow.getAttributeValues();
                String yearValue = (String)attValues[yearNum];
                Number totalValue = (Number)attValues[totalNum];

                s1.add(new Year(new Integer(yearValue)), 
                       totalValue.toDouble(totalValue.getBytes()));

                dataset2.addValue(totalValue.toDouble(totalValue.getBytes()), 
                                  "Employees", yearValue.substring(2));


            }
        }
        TimeSeriesCollection dataset = new TimeSeriesCollection();
        dataset.addSeries(s1);
        return dataset;
    }

    public void setBindings(DCBindingContainer bindings) {
        this.bindings = bindings;
    }

    public DCBindingContainer getBindings() {
        return bindings;
    }
}

Here you have my example project which works on the HR demo database schema