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.
Aug 13 16:24:22 - WARN - Error while looking for a specific entry with
id=test1 (com.ibatis.common.jdbc.exception.NestedSQLException:
--- 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
)
Aug 13 16:24:22 - WARN - Error while looking for a specific entry with
id=test2 (com.ibatis.common.jdbc.exception.NestedSQLException:
--- 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
)
Aug 13 16:24:22 - DEBUG - com.ibatis.common.jdbc.exception.NestedSQLException:
--- 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
com.ibatis.common.jdbc.exception.NestedSQLException:
--- 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
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:862)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
~[ojdbc6.jar:11.2.0.2.0]
at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
~[ibatis-sqlmap-2.3.4.726.jar:na]
... 11 common frames omitted
Aug 13 16:24:22 - DEBUG - com.ibatis.common.jdbc.exception.NestedSQLException:
--- 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
com.ibatis.common.jdbc.exception.NestedSQLException:
--- 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
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:862)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
~[ojdbc6.jar:11.2.0.2.0]
at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
~[ibatis-sqlmap-2.3.4.726.jar:na]
... 11 common frames omitted
Aug 13 16:24:22 - ERROR - Error while synchronizing ID {last_name=test2}:
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- 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
Aug 13 16:24:22 - DEBUG - org.lsc.exception.LscServiceException:
javax.naming.CommunicationException:
--- 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
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- 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
org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:294)
~[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: javax.naming.CommunicationException:
--- 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
... 6 common frames omitted
Aug 13 16:24:22 - ERROR - Error while synchronizing ID {last_name=test1}:
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- 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
Aug 13 16:24:22 - DEBUG - org.lsc.exception.LscServiceException:
javax.naming.CommunicationException:
--- 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
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- 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
org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:294)
~[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: javax.naming.CommunicationException:
--- 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
... 6 common frames omitted
Aug 13 16:24:22 - ERROR - All entries: 2, to modify entries: 0, successfully
modified entries: 0, errors: 2
<?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><?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
