manifoldcf-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mario Bisonti (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CONNECTORS-1032) Can't crawl MySQL database tables
Date Wed, 17 Sep 2014 06:55:34 GMT

    [ https://issues.apache.org/jira/browse/CONNECTORS-1032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14136868#comment-14136868
] 

Mario Bisonti commented on CONNECTORS-1032:
-------------------------------------------

Thanks Karl.
You are right.
My apologies , because in the online help is written: "The "by name" option currently works
with all JDBC drivers in the list except for the MySQL driver. The "by label" works for the
current MySQL driver, and may work for some of the others as well. ..:"

Excuse me.
Thanks a lot.
Mario

> Can't crawl MySQL database tables
> ---------------------------------
>
>                 Key: CONNECTORS-1032
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-1032
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: JDBC connector
>            Reporter: Karl Wright
>            Assignee: Karl Wright
>         Attachments: screenshot-1.png, screenshot-2.png
>
>
> Against some indeterminate version of MySQL, the seeding query:
> {code}
> SELECT command_id AS $(IDCOLUMN) FROM icinga_commands
> {code}
> ... produces the following:
> Error: Bad seed query; doesn't return $(IDCOLUMN) column. Try using quotes around $(IDCOLUMN)
variable, e.g. "$(IDCOLUMN)".
> So does:
> {code}
> SELECT command_id AS "$(IDCOLUMN)" FROM icinga_commands
> {code}
> The first level of diagnosis will be to determine what column names are in fact being
returned.  IDynamicResultRow has the following method:
> {code}
>  public Iterator<String> getColumns();
> {code}
> ... which we will need to use to get at the column names.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message