Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue with dvt components

2633702Jan 4 2016 — edited Jan 4 2016

Hello experts

I have an issue with a pieChart Components in my application: always i got No Data To Display,

the Problem here when i deploy the application in my integrated server(which comes with jdeveloper 12c ) it works fine,but when i deploy it in the production server it doesn't work even i'm using weblogic 12c also:

here an exemple:

nodata.PNG

this my code in the jsf:

<dvt:pieChart id="pieChart4" var="row" value="#{bindings.ClientNumber6.collectionModel}">

                        \<dvt:chartLegend id="cl4"/>

                        \<dvt:pieDataItem id="di4" value="#{row.number}" label="#{row.client}"/>

                    \</dvt:pieChart>

and this my function:

public List\<DepNumber> countRowParDepenFonctiondelannéeprecedente() {

    Date date = new Date();

    Calendar calendar = new GregorianCalendar();

    calendar.setTime(date);

    int anneEncour = calendar.get(Calendar.YEAR);

   int annePrec=anneEncour-1;

    String SannePrec = Integer.toString(annePrec);

    String annePrecString = SannePrec.substring(2, 4);

    Query query =

        em.createQuery("SELECT d.depId,COUNT(d.depId) FROM Dossier d   WHERE ( SUBSTRING(d.dateCreation, 7, 2)=:vr)" +

        "OR  (SUBSTRING(d.dateAppel, 7, 2)=:vr)group by d.depId order by d.depId ");

    query.setParameter("vr", annePrecString);

    List\<Object\[\]> rows = query.getResultList();

    List\<DepNumber> result = new ArrayList\<>(rows.size());

    for (Object\[\] row : rows) {

        result.add(new DepNumber((String) row\[0\], (Long) row\[1\]));

    }

    return result;

}

DepNumber : is an object which i created it not an entity.

i'm using jdeveloper 12.1.3.0.0 and weblogic 12c and oracle database 11g .

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2016
Added on Jan 4 2016
3 comments
286 views