Hi Sabastien,
Thanks for your reply.
I fixed that issue. I had a comma in the select queries.
However, I see below error now. I have also changed the log level to
"TRACE".
09:16:10,699 |-INFO in ch.qos.logback.classic.LoggerContext[default] -
Could NOT find resource [logback-test.xml]
09:16:10,701 |-INFO in ch.qos.logback.classic.LoggerContext[default] -
Found resource [logback.xml] at [file:/opt/lsc-2.0.2/bin/logback.xml]
09:16:10,702 |-WARN in ch.qos.logback.classic.LoggerContext[default] -
Resource [logback.xml] occurs multiple times on the classpath.
09:16:10,702 |-WARN in ch.qos.logback.classic.LoggerContext[default] -
Resource [logback.xml] occurs at [file:/opt/lsc-2.0.2/bin/logback.xml]
09:16:10,702 |-WARN in ch.qos.logback.classic.LoggerContext[default] -
Resource [logback.xml] occurs at
[jar:file:/opt/lsc-2.0.2/lib/lsc-core-2.0.2.jar!/logback.xml]
09:16:10,962 |-INFO in
ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute
not set
09:16:10,991 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
09:16:11,003 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
Naming appender as [CONSOLE]
09:16:11,072 |-INFO in
ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Pushing
component [layout] on top of the object stack.
09:16:11,168 |-WARN in ch.qos.logback.core.ConsoleAppender[CONSOLE] - This
appender no longer admits a layout as a sub-component, set an encoder
instead.
09:16:11,168 |-WARN in ch.qos.logback.core.ConsoleAppender[CONSOLE] - To
ensure compatibility, wrapping your layout in LayoutWrappingEncoder.
09:16:11,168 |-WARN in ch.qos.logback.core.ConsoleAppender[CONSOLE] - See
also http://logback.qos.ch/codes.html#layoutInsteadOfEncoder for details
09:16:11,170 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction
- Setting level of ROOT logger to TRACE
09:16:11,170 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction -
Attaching appender named [CONSOLE] to Logger[ROOT]
Aug 14 09:16:12 - DEBUG - Loading XML configuration from:
/opt/lsc-2.0.2/bin/lsc.xml
Aug 14 09:16:12 - DEBUG - going to scan these urls:
jar:file:/opt/lsc-2.0.2/lib/lsc-core-2.0.2.jar!/
Aug 14 09:16:13 - INFO - Reflections took 1028 ms to scan 1 urls,
producing 60 keys and 226 values
Aug 14 09:16:13 - DEBUG - Importing XML schema file:
schemas/lsc-core-2.0.xsd
Aug 14 09:16:14 - INFO - Logging configuration successfully loaded from
/opt/lsc-2.0.2/bin/logback.xml
Aug 14 09:16:14 - INFO - LSC configuration successfully loaded from
/opt/lsc-2.0.2/bin/
Aug 14 09:16:14 - DEBUG - Reading sql-map-config.xml from
file:/opt/lsc-2.0.2/bin/sql-map-config.xml
Aug 14 09:16:15 - INFO - Starting sync for MySyncTask
Aug 14 09:16:16 - DEBUG - Synchronizing MySyncTask for {last_name=test1}
Aug 14 09:16:16 - ERROR - Error while synchronizing ID {last_name=test1}:
java.lang.NullPointerException
Aug 14 09:16:16 - DEBUG - java.lang.NullPointerException
java.lang.NullPointerException: null
at java.lang.String$CaseInsensitiveComparator.compare(String.java:1217)
~[na:1.6.0_33]
at java.lang.String$CaseInsensitiveComparator.compare(String.java:1211)
~[na:1.6.0_33]
at java.lang.String.compareToIgnoreCase(String.java:1258) ~[na:1.6.0_33]
at
org.lsc.beans.BeanComparator.calculateModificationType(BeanComparator.java:128)
~[lsc-core-2.0.2.jar:na]
at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:718)
[lsc-core-2.0.2.jar:na]
at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:673)
[lsc-core-2.0.2.jar:na]
at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:643)
[lsc-core-2.0.2.jar:na]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[na:1.6.0_33]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[na:1.6.0_33]
at java.lang.Thread.run(Thread.java:662) [na:1.6.0_33]
Aug 14 09:16:16 - ERROR - All entries: 1, to modify entries: 0,
successfully modified entries: 0, errors: 1
Thansk,
Rakesh.
Thanks,
Rakesh.
On Wed, Aug 14, 2013 at 3:15 AM, Sébastien Bahloul <
[email protected]> wrote:
> Hi Rakesh,
>
> This is an untested use case, but it should work. Can you put the DEBUG
> verbosity in logback.xml ?
>
> By the way, are you sure to use the same queries for both databases ?
>
> Regards,
>
> Sebastien BAHLOUL
> IAM / Security specialist
> Ldap Synchronization Connector : http://lsc-project.org
> Blog : http://sbahloul.wordpress.com/
>
>
> 2013/8/13 rakesh pothugunta <[email protected]>
>
>> Hi,
>>
>> I am trying to sync the data between two oracle databases and I am
>> getting the below error. Please find the error file, LSC file and
>> inetorgPerson xml file. I would greatly appreciate if someone can help me
>> with the issue.
>>
>> I am using LSC for the first time. I think I missed some configuration.
>>
>> Error:
>>
>> The error occurred in
>> file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.
>> --- The error occurred while applying a parameter map.
>> --- Check the getInetOrgPerson-InlineParameterMap.
>> --- Check the statement (query failed).
>> --- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
>>
>> at
>> com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
>> ~[ibatis-sqlmap-2.3.4.726.jar:na]
>> at
>> com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
>> ~[ibatis-sqlmap-2.3.4.726.jar:na]
>> at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
>> ~[ibatis-sqlmap-2.3.4.726.jar:na]
>> at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
>> ~[ibatis-sqlmap-2.3.4.726.jar:na]
>> at
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
>> ~[ibatis-sqlmap-2.3.4.726.jar:na]
>> at
>> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
>> ~[ibatis-sqlmap-2.3.4.726.jar:na]
>> at
>> org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:245)
>> ~[lsc-core-2.0.2.jar:na]
>> at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:672)
>> [lsc-core-2.0.2.jar:na]
>> at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:643)
>> [lsc-core-2.0.2.jar:na]
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>> [na:1.6.0_33]
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>> [na:1.6.0_33]
>> at java.lang.Thread.run(Thread.java:662) [na:1.6.0_33]
>> Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
>>
>>
>>
>> Thanks,
>> Rakesh.
>>
>> _______________________________________________________________
>> Ldap Synchronization Connector (LSC) - http://lsc-project.org
>>
>> lsc-users mailing list
>> [email protected]
>> http://lists.lsc-project.org/listinfo/lsc-users
>>
>>
>
<?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><?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></mainIdentifier>
<defaultDelimiter>;</defaultDelimiter>
<defaultPolicy>FORCE</defaultPolicy>
<conditions>
<changeId>false</changeId>
</conditions>
</propertiesBasedSyncOptions>
</task>
</tasks>
</lsc>_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
