JdbcXYDataset cannot plot data over one day

[atom]

Hi

I am plotting time series data from a database using JdbcXYDataset. So I have my x values as time and the y values as value1

x= time <------------- over Monday Tuesday and so on

11 am 1pm 3pm 8pm 10 am 11am 2pm

y= value1

10 20 30 10 23 21 35

When I plot this I get my graph plots reprinted. So JFreeChart thinks

11 am 1pm 3pm 8pm 10 am 11am 2pm

Is one day when in fact it is time over two days how can I tell it to plot data over different days


Regards
AM

[David Gilbert]

I'm not completely familiar with the JdbcXYDataset class, but looking through the code it looks like it will accept DATE, TIME and TIMESTAMP values (among others) for the x-axis. I think DATE and TIMESTAMP should span multiple days, but if you are using TIME then there won't be any way for JFreeChart to know what day the value falls on.

Regards,

DG.

[atom]

Thanxs David