Hi Sebastien,

Thanks for the quick response.

Can you please help us understand if we have another unique attribute in AD server that we can use to sync our HSQLDB.

Just to give you an idea on our requirement, please see reply from Clément OUDOT on "http://lists.lsc-project.org/pipermail/lsc-users/2015-October/002744.html";

Appreciate your help on this.

Regards,
Rachna Aggarwal

On Thursday 05 November 2015 03:34 AM, Sébastien Bahloul wrote:
Hi Rachna,

At this time LSC does not support such configuration where the pivot attribute is a binary value

Regards,

Sebastien BAHLOUL

2015-11-04 22:41 GMT+01:00 Rachna Aggarwal <[email protected] <mailto:[email protected]>>:

    Hi,

    We are using LSC to sync AD Server as the source service and
    HSQLDB as the destination service. We are facing an issue in using
    the objectGUID of AD Server as the pivot attribute.

    Since objectGUID is a binary attribute, we specified that
    attribute in binaryAttributes in lsc.xml. But when lsc tries to
    insert objectGUID in the hsql database, it gave error
    "org.hsqldb.HsqlException: incompatible data type in conversion".
    We then tried to change the datatype for objectGUID column to be
    VARBINARY/BLOB but then when lsc tried to execute the getPerson
    query for the objectGUID byte array value, it gave exception
    "java.sql.SQLDataException: data exception: invalid character
    value for cast".

    We debugged and found that the getBean() API of
    AbstractJdbcService calls getAttributesMap(attributes) which
    returns the value as String. It does not have any check for the
    value's type of byte array. We are not sure but maybe this is
    causing the issue.

    Can you please help us understand the issue here.

    Regards,
    Rachna Aggarwal
    _______________________________________________________________
    Ldap Synchronization Connector (LSC) - http://lsc-project.org

    lsc-users mailing list
    [email protected]
    <mailto:[email protected]>
    http://lists.lsc-project.org/listinfo/lsc-users



_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org

lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users

Reply via email to