throwing exceptions from JdbcXYDataset

[Ron Warshawsky]

Dear Mr. Gilbert ,

Can you please add option to throw exceptions from the JdbcXYDataset when SQL query is wrong (or can not be executed by any other reason).

I am trying to add option for the user to generate custom SQL chart and below statement is falling throught:

try {
xydataset.executeQuery(customSQL );
}
catch(Exception sqle ) {
SQLExceptionDialog(sqle);
}
}

// Error: java.sql.SQLException is "never thrown" in body of corresponding try statement

Thank you,

Ron Warshawsky

[Bryan]

Ron

Good suggestion. I have modified JdbcXYDataset and submitted to DG. At this stage the mod is to leave executeQuery as is, and to have another method processQuery which throws exceptions. This was done to maintain compability with existing code.

Bryan

[David Gilbert]

Hi Ron / Bryan,

Thanks Ron for the suggestion and Bryan for the code. I'll get the change incorporated for the next release.

Regards,

DG.

[Ron Warshawsky]

Hello Brian and DG,

Thanks a lot for adding this functionality.

Regards,

Ron Warshawsky

[Mala]

Hi Bryan, David,

Will this functionality be added to JdbcCategoryDataset as well?

Thanks.

Regards,

--mala--