Chart fetching data from remote database.

SDG · Post by **SDG** » Fri May 15, 2009 10:52 am

Hello,

From the security perspective the client will not have direct access to the database. So how the chart should get the data from database.

Kindly provide me a sample program to acheive this.

Regards,
Dinesh.

Narcís · Post by **Narcís** » Fri May 15, 2009 11:02 am

Hi Dinesh,

You'll find an example at the live applet demo:

http://www.steema.com/products/teechart ... etDemo.htm

At Components->JDBC.

This demo (TeeChart.Features.jar) is also included with the installation.

SDG · Post by **SDG** » Fri May 15, 2009 11:44 am

We were able to run the same code and plot the data on chart. But problem here is the client (browser) system will not have access to database server system. So in this case how chart will fetch the data?

In case of sample code, it is a swing and it fetches data directly hitting to the database server system. What if the database server is not accessible or reachable?

Narcís · Post by **Narcís** » Fri May 15, 2009 1:46 pm

Hi SDG,

It's essential that the client has a connection to the server to be able to get data from it. Once this is achieved there are several ways of charting this data.

SDG · Post by **SDG** » Mon May 18, 2009 8:56 am

Hi Narcis,

Could you please mention those ways of charting data? This will help us in writing code.

Thanks and regards,
Veeranna Ronad.

Narcís · Post by **Narcís** » Mon May 18, 2009 9:04 am

Hi Veeranna,

Some of the options are using a JDBC connection as I told you before, you can manually read your database and populate series using add method, you can use XML source as in the example at Components -> XML import source, etc.