I'm trying to compare table between Oracle 11g and DB2, but I encountered error when I run this:
C:\diffkit-0.9.0\eg>java -jar ../diffkit-app.jar -planfiles test18.plan.xml, test18.lhs.dbConnectionInfo.oracle.xml, test18.rhs.dbConnectionInfo.db2.xml
Please advise on where has gone wrong.
*****************************************************************************************************************
DiffKit home->C:\diffkit-0.9.0
dropin dir->C:\diffkit-0.9.0\dropin
no jar files in dropin dir
planfile(s)->[test18.plan.xml]
ERROR[19:57:31.173]{main}(DKApplication.main:135)-null
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'plan' defined in file [C:\diffkit-0.9.0\eg\test18.plan.xml]: Cannot resolve reference to bean 'lhsDBConnectionInfo' while setting bean property 'lhsDBConnectionInfo'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'lhsDBConnectionInfo' is defined
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1317) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1076) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:563) [diffkit-app.jar:na]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872) [diffkit-app.jar:na]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423) [diffkit-app.jar:na]
at org.diffkit.util.DKSpringUtil.getBean(DKSpringUtil.java:46) [diffkit-app.jar:na]
at org.diffkit.diff.conf.DKApplication.runPlan(DKApplication.java:164) [diffkit-app.jar:na]
at org.diffkit.diff.conf.DKApplication.main(DKApplication.java:115) [diffkit-app.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.7.0_80]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [na:1.7.0_80]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [na:1.7.0_80]
at java.lang.reflect.Method.invoke(Unknown Source) [na:1.7.0_80]
at com.jdotsoft.jarloader.JarClassLoader.invokeMain(JarClassLoader.java:571) [diffkit-app.jar:na]
at org.diffkit.diff.conf.DKLauncher.main(DKLauncher.java:29) [diffkit-app.jar:na]
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'lhsDBConnectionInfo' is defined
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:510) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1056) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:274) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) [diffkit-app.jar:na]
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322) [diffkit-app.jar:na]
... 21 common frames omitted
*****************************************************************************************************************
This is how my test18.plan.xml looks like:
<?xml version="1.0" encoding="UTF-8"?>
<bean id="plan" class="org.diffkit.diff.conf.DKMagicPlan">
<property name="lhsDBTableName" value="common_role" />
<property name="rhsDBTableName" value="common_role" />
<property name="lhsDBConnectionInfo" ref="lhsDBConnectionInfo" />
<property name="rhsDBConnectionInfo" ref="rhsDBConnectionInfo" />
<property name="sinkFilePath" value="./test18.sink.diff" />
</bean>
</beans>
*****************************************************************************************************************
This is test18.lhs.dbConnectionInfo.oracle.xml
<?xml version="1.0" encoding="UTF-8"?>
<bean id="lhsDBConnectionInfo" class="org.diffkit.db.DKDBConnectionInfo">
<constructor-arg index="0" value="oracle" />
<constructor-arg index="1" value="ORACLE" />
<constructor-arg index="2" value="oracledb" />
<constructor-arg index="3" value="192.168.205.100" />
<constructor-arg index="4" value="1521" />
<constructor-arg index="5" value="oracleadmin" />
<constructor-arg index="6" value="password" />
</bean>
</beans>
*****************************************************************************************************************
This is test18.rhs.dbConnectionInfo.db2.xml
<?xml version="1.0" encoding="UTF-8"?>
<bean id="rhsDBConnectionInfo" class="org.diffkit.db.DKDBConnectionInfo">
<constructor-arg index="0" value="db2" />
<constructor-arg index="1" value="DB2" />
<constructor-arg index="2" value="ibmdb" />
<constructor-arg index="3" value="192.168.205.100" />
<constructor-arg index="4" value="50000" />
<constructor-arg index="5" value="db2admin" />
<constructor-arg index="6" value="
password" />
</bean>
</beans>
*****************************************************************************************************************