Return-Path: 
 <dev-return-11476-apmail-manifoldcf-dev-archive=manifoldcf.apache.org@manifoldcf.apache.org>
X-Original-To: apmail-manifoldcf-dev-archive@www.apache.org
Delivered-To: apmail-manifoldcf-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 43E851134B
	for <apmail-manifoldcf-dev-archive@www.apache.org>;
 Wed, 17 Sep 2014 06:55:34 +0000 (UTC)
Received: (qmail 89694 invoked by uid 500); 17 Sep 2014 06:55:34 -0000
Delivered-To: apmail-manifoldcf-dev-archive@manifoldcf.apache.org
Received: (qmail 89643 invoked by uid 500); 17 Sep 2014 06:55:34 -0000
Mailing-List: contact dev-help@manifoldcf.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@manifoldcf.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@manifoldcf.apache.org>
List-Post: <mailto:dev@manifoldcf.apache.org>
List-Id: <dev.manifoldcf.apache.org>
Reply-To: dev@manifoldcf.apache.org
Delivered-To: mailing list dev@manifoldcf.apache.org
Received: (qmail 89536 invoked by uid 99); 17 Sep 2014 06:55:34 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 Sep 2014 06:55:34 +0000
Date: Wed, 17 Sep 2014 06:55:34 +0000 (UTC)
From: "Mario Bisonti (JIRA)" <jira@apache.org>
To: dev@manifoldcf.apache.org
Message-ID: <JIRA.12741757.1410868885000.53049.1410936934007@Atlassian.JIRA>
In-Reply-To: <JIRA.12741757.1410868885000@Atlassian.JIRA>
References: <JIRA.12741757.1410868885000@Atlassian.JIRA>
 <JIRA.12741757.1410868885587@arcas>
Subject: [jira] [Commented] (CONNECTORS-1032) Can't crawl MySQL database
 tables
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


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