JDBCXYDataSet - Not enough valid columns where generated

A discussion forum for JFreeChart (a 2D chart library for the Java platform).
Locked
venkata
Posts: 6
Joined: Mon Aug 09, 2010 7:12 pm
antibot: No, of course not.

JDBCXYDataSet - Not enough valid columns where generated

Post by venkata » Mon Aug 09, 2010 7:20 pm

Hi,

I am using JDBCXYDataset, I am accessing a column, which has float variables as values.
But JDBCXYDataset is showing the error - Not enough valid columns where generated by query.

How can I resolve this?

Thanks.

Regards,
Venkata.

skunk
Posts: 1087
Joined: Thu Jun 02, 2005 10:14 pm
Location: Brisbane, Australia

Re: JDBCXYDataSet - Not enough valid columns where generated

Post by skunk » Mon Aug 09, 2010 8:15 pm

The javadoc contains the following
The sql query must return at least two columns. The first column will be the x-axis and remaining columns y-axis values.
Is your query returning at least 2 colummns?

venkata
Posts: 6
Joined: Mon Aug 09, 2010 7:12 pm
antibot: No, of course not.

Re: JDBCXYDataSet - Not enough valid columns where generated

Post by venkata » Mon Aug 09, 2010 8:44 pm

Thank you.
My query was returning only one column.
Now its working, Thank you.

And how can I change the date on x-axis.
My x-axis is date time stamp from database.

Thanks.

Regards,
Venkata.

Locked