Hi,
I have tried a lot but unable to fix the getonefilter issue. Please suggest.
Lsc.xml contains:
<databaseSourceService>
<name>databaseConnectionService</name>
<connection reference="mySQL" />
<requestNameForList>getInetOrgPersonList</requestNameForList>
<requestNameForObject>getInetOrgPerson</requestNameForObject>
<requestNameForClean>getInetOrgPersonClean</requestNameForClean>
</databaseSourceService>
<ldapDestinationService>
<name>testad-dst-service</name>
<connection reference="testAD" />
<baseDn>dc=testrjil,dc=net</baseDn>
<pivotAttributes>
<string>cn</string>
</pivotAttributes>
<fetchedAttributes>
<string>cn</string>
<string>sAMAccountName</string>
<string>objectClass</string>
</fetchedAttributes>
<getAllFilter><![CDATA[(objectClass=inetOrgPerson)]]></getAllFilter>
<getOneFilter><![CDATA[(&(objectClass=inetOrgPerson)(cn={groupname}))]]></getOneFilter>
</ldapDestinationService>
cat sql-map-config.d/InetOrgPerson.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd";>
<sqlMap namespace="InetOrgPerson">
<select id="getInetOrgPerson" resultClass="java.util.HashMap"
parameterClass="java.util.Map">
Select
groupname,samaccountname
FROM group_info
</select>
<select id="getInetOrgPersonClean" resultClass="java.util.HashMap"
parameterClass="java.util.Map">
Select
pers."GROUPNAME" AS groupname
FROM group_info pers
WHERE pers."GROUPNAME" LIKE #groupname#
</select>
<select id="getInetOrgPersonList" resultClass="java.util.HashMap">
SELECT groupname
FROM group_info
</select>
</sqlMap>
And in DB:
mysql> select * from group_info;
+----+-----------+----------------+
| id | groupname | samaccountname |
+----+-----------+----------------+
| 1 | sqlgrp | sqltestgrp |
+----+-----------+----------------+
1 row in set (0.00 sec)
"Confidentiality Warning: This message and any attachments are intended only
for the use of the intended recipient(s).
are confidential and may be privileged. If you are not the intended recipient.
you are hereby notified that any
review. re-transmission. conversion to hard copy. copying. circulation or other
use of this message and any attachments is
strictly prohibited. If you are not the intended recipient. please notify the
sender immediately by return email.
and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure
no viruses are present in this email.
The company cannot accept responsibility for any loss or damage arising from
the use of this email or attachment."
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
