[
https://issues.apache.org/jira/browse/CONNECTORS-1032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14135606#comment-14135606
]
Karl Wright commented on CONNECTORS-1032:
-----------------------------------------
Hi Mario,
The JDBC driver version is specified in build.xml.
You can try downloading the right mysql jdbc driver and that might change
things. What's happening is that the "AS xxx" clause is not manifesting in the
JDBC set return column names for MySQL with this driver and MySQL version.
Instead we're getting the original column name. There may be an alternate name
available, I will see.
> 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)
