2 hyz95801 hyz95801 于 2013.12.12 10:32 提问

javaweb连不上数据库服务

两个不同的项目,部署在同一台服务器上面,数据库连接配置是一样的,为什么一个项目能够连上数据库,而另一个不能。在进行数据库查询的时候报:
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)

相关配置:
<?xml version="1.0" encoding="UTF-8"?>
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd" default-autowire="byName">

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="${jdbc.driverClassName}"/>
    <property name="url" value="${jdbc.url}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
</bean>


<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>

<bean id="log4jdbcInterceptor" class="net.sf.log4jdbc.DataSourceSpyInterceptor"/>

<bean id="dataSourceLog4jdbcAutoProxyCreator" class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
    <property name="interceptorNames">
        <list>
            <value>log4jdbcInterceptor</value>
        </list>
    </property>
    <property name="beanNames">
        <list>
            <value>dataSource</value>
        </list>
    </property>
</bean>`

`

另外,服务器IP有数据库服务器的授权,数据库链接池没有满。在本地(win7)启服务都可以,就是在服务器(linux)上不行。

麻烦大家有遇到过一样的问题的吗?

Csdn user default icon
上传中...
上传图片
插入图片