manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cihad Guzel <cguz...@gmail.com>
Subject Re: Oracle JDBC Job Error
Date Tue, 07 Jan 2020 00:49:39 GMT
Hi,

I have debugged the MFC-2.15 codes and caught the problem.

JDBCConnector.java line:270

Object o = row.getValue(JDBCConstants.idReturnColumnName);

if (o == null)
  throw new ManifoldCFException("Bad seed query; doesn't return
$(IDCOLUMN) column.  Try using quotes around $(IDCOLUMN) variable,
e.g. \"$(IDCOLUMN)\", or, for MySQL, select \"by label\" in your
repository connection.");


The "row" object's value is "LCF__ID" -> this is a uppercase string

"JDBCConstants.idReturnColumnName" is "lcf__id" -> this is a lowercase string

So "o" object is null.

I think that Oracle returns the uppercase column name. It is not a
bug. How can I fix it? Should I update the seed query in the Query
tab? Should we change the code lines?

Regards,
Cihad Guzel


Cihad Guzel <cguzelg@gmail.com>, 5 Oca 2020 Paz, 20:14 tarihinde şunu yazdı:

> Hi,
>
> I try JDBC connector with Oracle (version: 11.2.0.4). I added to classpath
> ojdbc6.jar. My seed query as follows:
>
> "SELECT PERSONID AS $(IDCOLUMN) FROM PERSON"
>
> and I have an error as follow:
>
> "Error: Bad seed query; doesn't return $(IDCOLUMN) column. Try using
> quotes around $(IDCOLUMN) variable, e.g. "$(IDCOLUMN)", or, for MySQL,
> select "by label" in your repository connection."
>
> I have tried JDBC connector with MsSQL and Mysql. It has run successfully.
>
> How can I fix it?
>
> Regards,
> Cihad Guzel
>

Mime
View raw message