Some people like to run WebChart demo application on Oracle database, while some other people may like to run WebChart demo application on MySQL database. Seems I have to write two WebChart demo applications, one for Oracle, another one for MySQL database.
I think I should not ask customer to use Oracle or MySQL, WebChart should support almost all major different database systems. It's possible now to define different SQLs for different databases, for example, we define the following SQLs as the data source of one WebChart page.
WEBCHART.QUERY_1=*
WEBCHART.QUERY_ORACLE_1=select
to_char(trade_month,'yyyy/mm') month ,
trade_count count
from trade_monthly_summary
where to_char(trade_month,'yyyy')='2008'
WEBCHART.QUERY_MYSQL_1=select
trade_month,
trade_count+0 as count
from trade_summary_monthly
where year(trade_month) = 2008
When connect to Oracle, it will run the SQL defined for the Oracle database, when connect to MySQL, it will run the SQL defined for the MySQL database. It's possible to create one demo application to work fine for both Oracle and MySQL, and other different types of databases.