Primefaces charts from database

[jaltaie]

I've seen plenty of examples of how to create charts with static values (ordinary numbers). I have not seen many examples or any tutorials of how to write the necessary managed beans to create PF charts from a database. Would really appreciate any advice or guidance of where to obtain instructions for creating charts from databases. Google produced no results. Many thanks, J

[kukeltje]

There is also no example on the primefaces site for displaying a datatable with data from a database. Because that is basic java and should not pose andly difficulties for a regular java developer. Just use jpa2 for this.

[jaltaie]

It doesn't pose difficulties as such but it does require extensive utilization of mapping objects and there is more than one way to achieve this. What I'm asking for is 'Best practices' and the recommended methodologies to use. JPA2 is the norm of course but are there any specific recommendations? Thanks.

[kukeltje]

Well, google produced this https://www.google.com/search?q=primefa ... m+database

Lots of things to study. And what do mean by 'require extensive use of mapping objects'? The fact that you need a model? Tyen don't use pf charts but use plain jqplot with json or whatever. But remember for json you also need some 'mapping' so it is up to you

[jaltaie]

Thanks for the advice and for the other alternatives. Actually pf is simpler than I thought. From some of the examples I thought I needed complicated models using collections objects. I was simply able to adapt the generic boy/girl examples to a DAO service and got what I needed.