Hi,
How do I use Apache Derby database to feed data to visualization
API ?
I am looking for the datasource url which is needed at -
var query = new google.visualization.Query(
'jdbc:derby://localhost:1527/C:/Program File .....);
Will it be a jbdc url ?
Has anyone successfully connected to Apace Derby database via
datasource URL ?
Thanks.
On Feb 13, 12:16 am, VizGuy <[email protected]> wrote:
> Hi!
>
> There are actually three ways I see to tackle this problem..
>
> 1. What you said, have the page created with javascript code with many
> dataTable.setCell()s
> 2. Have the page created with javascript code creating a datatable from
> JSON. See references and examples in
> :http://code.google.com/apis/visualization/documentation/reference.htm...
> 3. Implement a datasource, as defined
> inhttp://code.google.com/apis/visualization/documentation/dev/implement...
>
> If you indeed choose option 3, I'm afraid you will indeed need to handle all
> the reqId and other things defined
> here:http://code.google.com/apis/visualization/documentation/dev/implement...
> But you might choose to go with option 2, which is slightly simpler to
> implement. One disadvantage of this, is that users won't be able to
> configure other visualizations (or gadgets) based on your data.
>
> Option 1 is probably not for you. If you have automated code generation,
> usually option 2 is better. But if you like option 1, it's fine too :)
>
> Regards,
> VizGuy
>
>
>
> On Mon, Feb 9, 2009 at 2:10 PM, MartinOShea <[email protected]> wrote:
>
> > Hello
>
> > I'm a 'newbie' with the Google Visualization API but I wonder if
> > anyone can advise with an issue I have?
>
> > I'm working on a system where users will be able to generate various
> > visualisations from various datasets created from tables they upload.
> > And I want to use the Google Visualization API to create the
> > visualisations, i.e. bar charts, word clouds etc.
>
> > My application uses Java servlets and JSPs with a MySQL back-end
> > database. Now, as I see it, there are two ways for me to return data
> > from the database for use in the Google Visualization API Javascript:
>
> > The first is to read the data into a 2D-array on the server and pass
> > this to a JSP and construct the Javascript like this:
>
> > <%
> > for(int i = 1; i < rowcount; i++){
>
> > for(int j = 0; j<columncount; j++){
> > table[i][j] = (table[i][j]
> > ==null)?"":table[i][j];
> > out.print("data.setCell("+
> > (i-1)+", "+j+", '"+table[i][j]+"');");
> > }
> > }
>
> > %>
>
> > Or I can use my preference which is to use Google Visualization URLs
> > with JSON of the type:
>
> > var query = new google.visualization.Query(http://www.example.com/
> > mydatasource)
>
> > However, is it necessary to specify the reqID and sig fields at all?
>
> > Also, am I right in thinking that the reponse to this can be
> > constructed dynamically as a string containing the data in a servlet?
>
> > And that some encoding or decoding of URLs might be needed?
>
> > Thanks
>
> > Martin O'Shea.- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en
-~----------~----~----~----~------~----~------~--~---
