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