User (Legacy) Posted October 24, 2004 Report Share Posted October 24, 2004 We have the ChartFX for Java product. The handling of dates in ChartFX does not appear to work properly. I create a resultset in JDBC which returns 5 rows of test data. select Weight, Returns, Performance, ProcessDate from .... the data types are java.sql.BigDecimal, java.sql.BigDecimal, java.sql.BigDecimal, java.sql.Date and the dates run from 26 Sep 2003 to 30 Sep 2003 If I set the DataTypes in chartFX as follows series 0 = DataType.VALUE series 1 = DataType.VALUE series 2 = DataType.VALUE series 3 = DataType.LABEL The dates all start from 31 Dec 1899 - nothing like the real data. If I remove the format setting then the labels are 1 2 3 4 5 If I set the DataTypes in chartFX as follows series 0 = DataType.VALUE series 1 = DataType.VALUE series 2 = DataType.VALUE series 3 = DataType.XVALUE The graph is not laid out properly, i.e. all data appears to be squashed into one line at x axis point 0. Any assistance appeciated. Cheers - Colin -- Colin McFarlane Director http://www.incito.com Inspired Business Solutions Tel: +44 (0) 131 556 4300 Mob: +44 (0) 795 070 9875 Link to comment Share on other sites More sharing options...
Software FX Posted October 25, 2004 Report Share Posted October 25, 2004 Hi Colin, this issue has been fixed in the latest service pack, you can get it here: http://support.softwarefx.com/cfxjava/. Regards, GA Software FX, Inc. "colin-mcfarlane" <colin-mcfarlane@supanet.com> wrote in message news:OJ0rRbduEHA.3108@webserver3.softwarefx.com... > We have the ChartFX for Java product. The handling of dates in ChartFX > does > not appear to work properly. > > I create a resultset in JDBC which returns 5 rows of test data. > select Weight, Returns, Performance, ProcessDate from .... > the data types are > java.sql.BigDecimal, java.sql.BigDecimal, java.sql.BigDecimal, > java.sql.Date > and the dates run from 26 Sep 2003 to 30 Sep 2003 > > If I set the DataTypes in chartFX as follows > series 0 = DataType.VALUE > series 1 = DataType.VALUE > series 2 = DataType.VALUE > series 3 = DataType.LABEL > The dates all start from 31 Dec 1899 - nothing like the real data. If I > remove the format setting then the labels are 1 2 3 4 5 > > If I set the DataTypes in chartFX as follows > series 0 = DataType.VALUE > series 1 = DataType.VALUE > series 2 = DataType.VALUE > series 3 = DataType.XVALUE > The graph is not laid out properly, i.e. all data appears to be squashed > into one line at x axis point 0. > > Any assistance appeciated. > > Cheers - Colin > > > -- > Colin McFarlane > Director > http://www.incito.com > Inspired Business Solutions > Tel: +44 (0) 131 556 4300 > Mob: +44 (0) 795 070 9875 > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.