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]
http://lists.lsc-project.org/listinfo/lsc-users
