Re: Using join

[asgallant]

Ideally, you would query a data source that supports table joins and have it done server-side.  If that's not an option, the API's join method will work, but you could see considerable slowdown when joining large data sets.

On Monday, June 11, 2012 6:12:39 AM UTC-4, John Maris wrote:

What is the best solution for joining 2 different db tables when quering the datasource service?

In the future these tables might get really big.

[John Maris]

I'm trying to create an Axis2 web service to create the data source
using standard jdbc.
I only need the DataTable object from the visualization library, to
easily create the data source table. But axis2 keep throwing this

org.apache.axis2.AxisFault: Property 'columnCells' in bean class
'com.google.visualization.datasource.datatable.DataTable'is not
readable.

on this code

DataTable dt = new DataTable();
dt.addColumn(new ColumnDescription("column1", ValueType.TEXT,
"column1"));

Can i use the library in a not httpservlet extended java class?

On 11 Ιούν, 18:57, asgallant <drew_gall...@abtassoc.com> wrote:
> Ideally, you would query a data source that supports table joins and have

> it done server-side.  If that's not an option, the API's join<https://developers.google.com/chart/interactive/docs/reference#google...>method will work, but you could see considerable slowdown when joining