[kepler-dev] I am getting error

[Matt Jones]

Hi Rajan,

By all appearances, you are passing an invalid query string to the
Database Query actor.  You are passing the string 'query', when you
should be passing a query that explicitly references your database
schema -- for example, if you had a table named 'people' people with
attributes 'name' an age, your query might be:

SELECT name, age FROM people

If you have configured proper database connection parameters (such as
username and password) then you should be able to get the query
results with the workflow you show.

Matt

On Wed, Feb 18, 2009 at 6:48 PM, Rajan Saminathan
<rajan.saminathan at mimos.my> wrote:
> Dear Sir,
>
>
>
>            I was connected with MySQL database using  Open database
> connection and Display. I am getting error while  using database query.
>
>
>
>           Please any one let me know. How to retrieve the  field data from
> Mysql  database using kepler. I am facing this error past three days.
>
>
>
>
>
>
>
>
>
> With Regards,
>
>            Rajan S.
>
>
>
> ------------------------------------------------------------------
> -
> -
> DISCLAIMER:
>
> This e-mail (including any attachments) may contain confidential
> information.
> If you are not the intended recipient, you are hereby notified that any
> dealing,
> review, distribution, printing, copying or use of this e-mail is
> strictly prohibited.
> If you have received this email in error, please notify the sender or
> MIMOS Berhad
> immediately and delete the original message. Opinions, conclusions and
> other
> information in this e-mail that do not relate to the official business
> of MIMOS Berhad
> and/or its subsidiaries shall be understood as neither given nor
> endorsed by MIMOS
> Berhad and/or its subsidiaries and neither MIMOS Berhad nor its
> subsidiaries accepts
> responsibility for the same. All liability arising from or in connection
> with computer
> viruses and/or corrupted e-mails is excluded to the fullest extent
> permitted by law.
>
> _______________________________________________
> Kepler-dev mailing list
> Kepler-dev at kepler-project.org
> http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-dev
>
>



-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Matthew B. Jones
Director of Informatics Research and Development
National Center for Ecological Analysis and Synthesis (NCEAS)
UC Santa Barbara
jones at nceas.ucsb.edu                       Ph: 1-907-523-1960
http://www.nceas.ucsb.edu/ecoinfo
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~