Cannot resolve reference to bean 'lhsDBConnectionInfo' while setting bean property 'lhsDBConnectionInfo'

67 views
Skip to first unread message

Kelvin

unread,
Sep 26, 2016, 8:06:57 AM9/26/16
to diffkit-user
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>

*****************************************************************************************************************
Reply all
Reply to author
Forward
0 new messages