Karl Wright created CONNECTORS-1032:
---------------------------------------
Summary: 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)
