Hi Jens,
I've had a look at the JDBC connector code, and can see no way it by itself
can get this messed up.
The column names are distinct:
>>>>>>
/** The name of the url return column */
public static String urlReturnColumnName = "lcf__url";
/** The name of the data return column */
public static String dataReturnColumnName = "lcf__data";
<<<<<<
The content result uses the right column:
>>>>>>
Object contents =
row.getValue(JDBCConstants.dataReturnColumnName);
<<<<<<
So that leaves more unusual explanations. For the MySQL JDBC connection,
have you selected "by label"? That's required for MySQL; without it the
column mappings may well be strange. Also, please make sure that the
version of the MySQL JDBC driver you are downloading is the correct one for
your MySQL version. If you use "ant make-deps" for that, please check the
version specified in the build.xml file (I think it's 5.1.18, but have a
look).
One more thing: does the URL that ES sees look right? or is it something
wacky too?
Thanks,
Karl
On Fri, Sep 19, 2014 at 4:55 AM, Jens Jahnke <[email protected]> wrote:
> Hi Karl,
>
> On Fri, 19 Sep 2014 04:43:02 -0400
> Karl Wright <[email protected]> wrote:
>
> KW> If you try indexing some small amount of file content through the same
> KW> output connection (using, say, the Filesystem connector), do you see
> the
> KW> same thing? I would bet so; if that's the case, something is clearly
> wrong
> KW> with either how your elasticsearch connector is configured, or there's
> a
> KW> bug.
>
> I've indexed a small windows share through the same output connector
> and they are indexed correctly.
>
> The content is also base64 encoded but I found out that it is
> searchable. Searching the jbcd indexed data for strings from the url
> shows matches which makes sense because the url column is indexed
> instead of the data column.
>
> But that still leaves me wondering why the url column is used as the
> indexed content for the jdbc connection. :-?
>
> Regards,
>
> Jens
>
> --
> 19. Scheiding 2014, 10:52
> Homepage : http://www.wegtam.com
>
> The way I understand it, the Russians are sort of a combination of evil
> and incompetence... sort of like the Post Office with tanks.
> -- Emo Philips
>
