Hi,
I am trying to synchronize the data between two databases. I don't see any
error in the logs. However it is not writing data to destination. It tell
me that " attribute is in force status and will not be written to
destination". I have added the attributes to "forcevalues" . I have also
attached the lsc file and intetorgperson file,
Below is debug message it writes:
Aug 14 10:32:37 - INFO - Reflections took 829 ms to scan 1 urls, producing
60 keys and 226 values
Aug 14 10:32:37 - DEBUG - Importing XML schema file:
schemas/lsc-core-2.0.xsd
Aug 14 10:32:38 - INFO - Logging configuration successfully loaded from
/opt/lsc-2.0.2/bin/logback.xml
Aug 14 10:32:38 - INFO - LSC configuration successfully loaded from
/opt/lsc-2.0.2/bin/
Aug 14 10:32:38 - DEBUG - Reading sql-map-config.xml from
file:/opt/lsc-2.0.2/bin/sql-map-config.xml
Aug 14 10:32:38 - INFO - Starting sync for MySyncTask
Aug 14 10:32:39 - DEBUG - Synchronizing MySyncTask for {last_name=test1}
Aug 14 10:32:39 - DEBUG - In object "test1": List of attributes considered
for writing in destination: [first_name, last_name]
Aug 14 10:32:39 - DEBUG - In object "test1": Attribute "first_name" is in
FORCE status
Aug 14 10:32:39 - DEBUG - In object "test1": Attribute "first_name" will
not be written to the destination
Aug 14 10:32:39 - DEBUG - In object "test1": Attribute "last_name" is in
FORCE status
Aug 14 10:32:39 - DEBUG - In object "test1": Attribute "last_name" will
not be written to the destination
Aug 14 10:32:39 - DEBUG - Entry "test1" will not be written to the
destination
Aug 14 10:32:39 - INFO - All entries: 1, to modify entries: 0,
successfully modified entries: 0, errors: 0
Thanks,
Rakesh.
<?xml version="1.0" ?>
<lsc xmlns="http://lsc-project.org/XSD/lsc-core-2.0.xsd"; revision="0">
<connections>
<databaseConnection>
<name>src-jdbc</name>
<url>jdbc:oracle:thin:@idmlab.com:1521/ORCL.world</url>
<username>system</username>
<password>idmLab123</password>
<driver>oracle.jdbc.OracleDriver</driver>
</databaseConnection>
<databaseConnection>
<name>dest-jdbc</name>
<url>jdbc:oracle:thin:@192.168.56.101:1521/ORCL.world</url>
<username>system</username>
<password>idmLab123</password>
<driver>oracle.jdbc.OracleDriver</driver>
</databaseConnection>
</connections>
<audits/>
<tasks>
<task>
<name>MySyncTask</name>
<bean>org.lsc.beans.SimpleBean</bean>
<databaseSourceService>
<name>MySyncTask-src</name>
<connection reference="src-jdbc"/>
<requestNameForList>getInetOrgPersonList</requestNameForList>
<requestNameForObject>getInetOrgPerson</requestNameForObject>
<requestNameForNextId>getNextInetOrgPersonId</requestNameForNextId>
<requestNameForClean>getInetOrgPersonClean</requestNameForClean>
</databaseSourceService>
<databaseDestinationService>
<name>postgresql-src-service</name>
<connection reference="dest-jdbc" />
<requestNameForList>getInetOrgPersonList</requestNameForList>
<requestNameForObject>getInetOrgPerson</requestNameForObject>
<requestsNameForInsert><string>insertInetOrgPerson</string></requestsNameForInsert>
<requestsNameForUpdate><string>updateInetOrgPerson</string></requestsNameForUpdate>
<requestsNameForDelete><string>deleteInetOrgPerson</string></requestsNameForDelete>
</databaseDestinationService>
<propertiesBasedSyncOptions>
<mainIdentifier>srcBean.getMainIdentifier()</mainIdentifier>
<defaultDelimiter>,</defaultDelimiter>
<defaultPolicy>FORCE</defaultPolicy>
<conditions>
<create>true</create>
<update>true</update>
<delete>false</delete>
<changeId>false</changeId>
</conditions>
<dataset>
<name>objectClass</name>
<policy>FORCE</policy>
<forceValues>
<string>"first_name"</string>
<string>"last_name"</string>
</forceValues>
<delimiter>,</delimiter>
</dataset>
</propertiesBasedSyncOptions>
</task>
</tasks>
</lsc>
<?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="getInetOrgPersonList">
<select id="getInetOrgPersonList" resultClass="java.util.HashMap" parameterClass="java.util.Map">
Select
last_name
FROM testperson
</select>
<select id="getInetOrgPerson" resultClass="java.util.HashMap" parameterClass="java.util.Map">
select
last_name,
first_name
FROM testperson
where last_name=#last_name#
</select>
<select id="getInetOrgPersonClean" resultClass="java.util.HashMap"
parameterClass="java.util.Map">
SELECT last_name
FROM testperson
where last_name = #last_name#
</select>
<insert id="insertInetOrgPerson" parameterClass="java.util.Map">
INSERT INTO TESTDEST
( last_name,first_name)
VALUES ( #last_name#, #first_name# )
</insert>
<update id="updateInetOrgPerson" parameterClass="java.util.Map">
UPDATE TESTDEST
SET ln = #last_name#, fn = #first_name#
WHERE last_name= #last_name#
</update>
<delete id="deleteInetOrgPerson" parameterClass="java.util.Map">
DELETE FROM TESTDEST
WHERE last_name= #last_name#
</delete>
</sqlMap>_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
