Newbie question on functionality

JDJ · Post by **JDJ** » Fri Aug 11, 2006 4:41 pm

Hi, I've been searching for a charting tool and this looks perfect.

Before I buy the guide and try to make it work, maybe someone knows if this is possible.

Using Swing -
I need to query an Oracle database to get a recordset. The bar graph will be based on the recordset. Very simple graph.

Does JFreeChart read the data from a file or can JFreeChart use the recordset directly?

Next I need to refresh this process every hour.

Does this sound feasible with Swing + JFreeChart?

Any insights would be greatly appreciated.

JDJ.

oacis · Post by **oacis** » Mon Aug 14, 2006 7:50 am

Using Swing -
I need to query an Oracle database to get a recordset. The bar graph will be based on the recordset. Very simple graph.

Does JFreeChart read the data from a file or can JFreeChart use the recordset directly?

JFreeChart can read the data from the jdbc connection - have a look at org.jfree.data.jdbc.* for the Dataset classes.

you can also write your own to grab the resultset from the database and then populate whichever dataset you wish.

Next I need to refresh this process every hour.

Does this sound feasible with Swing + JFreeChart?

Not a big user of swing and JFreeChart, so I cannot give you too much insight. From memory it is possible.

JDJ · Post by **JDJ** » Mon Aug 14, 2006 8:48 pm

Thanks oacis!