Java 在 ServletContext 资源 [/WEB-INF/spring-servlet.xml] 中定义名为“dataSource”的无效 bean 定义：
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21413616/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Java Invalid bean definition with name 'dataSource' defined in ServletContext resource [/WEB-INF/spring-servlet.xml]:
提问by user3158644
HI I'm following a youtube tutorial , https://www.youtube.com/watch?v=rdYQOqxq9F0Add,Edit,Delete,Search using Spring and Hibernate
嗨，我正在关注 youtube 教程，https://www.youtube.com/watch?v=rdYQOqxq9F0使用 Spring 和 Hibernate 添加、编辑、删除、搜索
getting this error,
得到这个错误，
ERROR: org.springframework.web.servlet.DispatcherServlet - Context initialization failed
org.springframework.beans.factory.BeanDefinitionStoreException: Invalid bean definition with name 'dataSource' defined in ServletContext resource [/WEB-INF/spring-servlet.xml]: Could not resolve placeholder 'jdbc.driverClassName'
file: jdbc.properties
文件：jdbc.properties
jdbc.dialect=org.hibernate.dialect.MySQLDialect
jdbc.databaseurl=jdbc:mysql://localhost:3306/StudentDB
jdbc.username=root
jdbc.password=admin
file:spring-servlet.xml
文件：spring-servlet.xml
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
p:location="/WEB-INF/jdbc.properties" />
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close" p:driverClassName="${jdbc.driverClassName}"
p:url="${jdbc.databaseurl}" p:username="${jdbc.username}" p:password="${jdbc.password}" />
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation">
<value>classpath:hibernate.cfg.xml</value>
</property>
<property name="configurationClass">
<value>org.hibernate.cfg.AnnotationConfiguration</value>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${jdbc.dialect}</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
</bean>
回答by Sotirios Delimanolis
You don't seem to have a property named jdbc.driverClassNamein your properties file.
您jdbc.driverClassName的属性文件中似乎没有命名的属性。
It should probably be
应该是
jdbc.driverClassName=com.mysql.jdbc.Driver
回答by JohnRose
you have committed mistake in these lines
你在这些方面犯了错误
p:driverClassName="${jdbc.driverClassName}"
p:url="${jdbc.databaseurl}" p:username="${jdbc.username}" p:password="${jdbc.password}"
compare your jdbc.properties file in your directory.
比较您目录中的 jdbc.properties 文件。
example jdbc.properties content:
示例 jdbc.properties 内容：
Dialect=org.hibernate.dialect.MySQLDialect// for jdbc use this. Driver=com.mysql.jdbc.Driver
Url=jdbc:mysql://localhost:3306/StudentDB
Username=root
Password=root
In ApplicationContext.xml, it should be like this
在ApplicationContext.xml中，应该是这样的
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource"
p:driverClassName="${Dialect}"
p:url="${Url}"
p:username="${Username}"
p:password="${Password}" />
