[
https://issues.apache.org/jira/browse/CONNECTORS-1032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14135474#comment-14135474
]
Mario Bisonti commented on CONNECTORS-1032:
-------------------------------------------
Hi.
Compiling, I obtain the error:
cannot find symbol
System.out.println(" " + debugIter.next());
> 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
>
> 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)
