[CONNECTORS-1032] Can't crawl MySQL database tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Component/s: JDBC connector
• Assignee: Karl Wright
• Reporter: Karl Wright
• Created: 16/Sep/14 12:01
• Updated: 17/Sep/14 06:55
• Resolved: 16/Sep/14 17:50

Description

Against some indeterminate version of MySQL, the seeding query:

SELECT command_id AS $(IDCOLUMN) FROM icinga_commands

... produces the following:

Error: Bad seed query; doesn't return $(IDCOLUMN) column. Try using quotes around $(IDCOLUMN) variable, e.g. "$(IDCOLUMN)".

So does:

SELECT command_id AS "$(IDCOLUMN)" FROM icinga_commands

The first level of diagnosis will be to determine what column names are in fact being returned. IDynamicResultRow has the following method:

 public Iterator<String> getColumns();

... which we will need to use to get at the column names.