天天看點

org.springframework.jdbc.CannotGetJdbcConnectionException

[size=large]1,問題現象[/size]

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root '@'localhost' (using password: YES))

org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:195)

org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)

com.knowledge.data.dao.imp.ContentDAOImp.queryContent(ContentDAOImp.java:13)

com.knowledge.data.service.imp.ContentServiceImp.queryContent(ContentServiceImp.java:20)

com.knowledge.data.action.ContentAction.queryContent(ContentAction.java:39)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

java.lang.reflect.Method.invoke(Method.java:597)

[table]

||

[/table][size=large]2,問題分析[/size]

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"

destroy-method="close" scope="singleton">

<property name="driverClassName" value="com.mysql.jdbc.Driver" />

[color=red]<property name="url" value="jdbc\:mysql\://localhost\:3306/knowledge" />[/color] <property name="username" value="root" />

<property name="password" value="root" />

</bean>

多了“\”

[size=large]3,問題解決方法[/size]去掉“\”