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