求异常问题在哪里

[icodegarden]

这个异常问题在哪里啊？这个异常问题在哪里啊？这个异常问题在哪里啊？

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [applicationContext.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'password' threw exception; nested exception is java.lang.Error: Unresolved compilation problem:

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1396)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
at com.aryan.p2p.test.OOTest.testA(OOTest.java:15)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'password' threw exception; nested exception is java.lang.Error: Unresolved compilation problem:

at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:102)
at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:58)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1393)
... 36 more

[whos2002110]

applicationContext.xml 发出来看下

[浮云若水]

数据源配置有问题

[EEXXTTJJSS]

是不是password填错了？

[icodegarden]

<bean id="dataSource" name="dataSource" class="com.aryan.p2p.utils.EncryptDataSource" destroy-method="close"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/> <!-- <property name="url" value="jdbc:oracle:thin:@10.1.1.5:1521:orcl"/> <property name="url" value="jdbc:oracle:thin:@61.164.89.82:1521:orcl"/> --> <property name="url" value="jdbc:oracle:thin:@192.168.1.52:1521:orcl"/> <property name="username" value="padmin"/> <property name="password" value="cGFkbWlu"/> <!--初始化连接:连接池启动时创建的初始化连接数量,1.2版本后支持--> <property name="initialSize" value="10"/> <!--最大活动连接:连接池在同一时间能够分配的最大活动连接的数量, 如果设置为非正数则表示不限制,达到MaxActive后,池将不会再创建连接,而会等待其他使用者释放连接,默认为8 --> <property name="maxActive" value="220"/> <!-- 最大空闲连接:连接池中容许保持空闲状态的最大连接数量,超过的空闲连接将被释放,如果设置为负数表示不限制 ,默认8--> <property name="maxIdle" value="20"/> <!-- 最小空闲连接:连接池中容许保持空闲状态的最小连接数量,低于这个数量将创建新的连接,如果设置为0则不创建--> <property name="minIdle" value="10"/> <!-- 最大等待时间:当没有可用连接时,连接池等待连接被归还的最大时间(以毫秒计数),超过时间则抛出异常,如果设置为-1表示无限等待 --> <property name="maxWait" value="10000" /> <!-- SQL查询,用来验证从连接池取出的连接,在将连接返回给调用者之前.如果指定,则查询必须是一个SQL SELECT并且必须返回至少一行记录 <property name="validationQuery" value="SELECT 1 from PA_PROVINCE" />--> <!-- 是否在自动回收超时连接的时候打印连接的超时错误 --> <property name="logAbandoned" value="true" /> <!-- 是否自动回收超时连接 --> <property name="removeAbandoned" value="true" /> <!-- 超时时间(以秒数为单位),设置超时时间有一个要注意的地方,超时时间=现在的时间-程序中创建Connection的时间, 如果 maxActive比较大,比如超过100,那么removeAbandonedTimeout可以设置长一点比如180,也就是三分钟无响应的连接进行 回收, 当然应用的不同设置长度也不同 --> <property name="removeAbandonedTimeout" value="180" /> </bean> <!--<bean id="dataSource" name="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://svn.dataceo.com:3306/jiaxiaoyun"/> <property name="username" value="jiaxiaoyun"/> <property name="password" value="Zxasqw12@"/> </bean> --> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="configLocation"> <value>classpath:sqlmap/sql-map-config.xml</value> </property> <property name="dataSource"> <ref local="dataSource"/> </property> </bean> <!-- <bean id="freemarkerConfig" class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer"> <property name="templateLoaderPath" value="/WEB-INF/views/" /> <property name="freemarkerSettings"> <props> <prop key="template_update_delay">0</prop> <prop key="default_encoding">UTF-8</prop> <prop key="number_format">0.##########</prop> <prop key="datetime_format">yyyy-MM-dd HH:mm:ss</prop> <prop key="classic_compatible">true</prop> <prop key="template_exception_handler">ignore</prop> </props> </property> </bean> --> <!-- 定义事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager" p:dataSource-ref="dataSource" /> <!-- 创建一个切面 --> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="add*" propagation="REQUIRED" isolation="DEFAULT" /> <tx:method name="save*" propagation="REQUIRED" isolation="DEFAULT" /> <tx:method name="insert*" propagation="REQUIRED" isolation="DEFAULT" /> <tx:method name="del*" propagation="REQUIRED" isolation="DEFAULT" /> <tx:method name="delete*" propagation="REQUIRED" isolation="DEFAULT" /> <tx:method name="update*" propagation="REQUIRED" isolation="DEFAULT" /> <tx:method name="modify*" propagation="REQUIRED" isolation="DEFAULT" /> <tx:method name="edit*" propagation="REQUIRED" isolation="DEFAULT" /> <tx:method name="*" propagation="SUPPORTS" read-only="true" isolation="DEFAULT" /> </tx:attributes> </tx:advice> <context:component-scan base-package="com.aryan.p2p" /> <context:annotation-config/> <bean id="abstractDAO" abstract="true"> <property name="sqlMapClient" ref="sqlMapClient" /> </bean> <bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" /> <!-- 当Spring容器启动完成后执行下面的这个Bean --> <bean class="com.aryan.p2p.web.listener.ApplicationLoader"/> <aop:config> <aop:advisor pointcut="execution(* com.aryan.p2p.service..*.*(..))" advice-ref="txAdvice" /> </aop:config> <!-- 任务线程 --> <bean id="smsThread" class="com.aryan.p2p.thread.SmsThread"></bean> <!--定义目标bean和bean中的方法 --> <bean id="smsConfigJob" class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean"> <property name="targetObject"> <ref local="smsThread"/> </property> <property name="targetMethod"> <!-- 定时更新短信配置 --> <value>updateSMSConfig</value> </property> </bean> <!--定义触发的时间 --> <bean id="smsJob" class="org.springframework.scheduling.quartz.CronTriggerBean"> <property name="jobDetail"> <ref bean="smsConfigJob"/> </property> <property name="cronExpression"> <!-- 执行频率--> <value>0 0/5 * * * ?</value> </property> </bean> <!-- 管理触发器 --> <bean autowire="no" class="org.springframework.scheduling.quartz.SchedulerFactoryBean"> <property name="triggers"> <list> <ref local="smsJob"/> </list> </property> </bean> applicationContext.xml的配置 password没错

[icodegarden]

用pl/sql Developer 连接数据库 可以连上的

[icodegarden]

部署的时候就算换成连本地数据库 也不行

[whos2002110]

EncryptDataSource 这个是你们自己的类吧， 设置password属性的时候报错了， 你检查下

[丶浅]

看下在applicationContext.xml里，password写错了没有

[ZhongGuanYao]

spring的bean配置错误