[
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)
