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]>: > 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 >
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users

