java - 无法在 Spring 应用程序中获得与 MySQL 的 JDBC 连接

Question

我在 Spring 中有以下数据库配置:

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
            <property name="url" value="jdbc:dburl" />
            <property name="driverClassName" value="com.mysql.jdbc.Driver" />
            <property name="username" value="username" />
            <property name="password" value="passworf" />
            <property name="removeAbandoned" value="true" />
            <property name="initialSize" value="3" />
            <property name="maxActive" value="5" />
        </bean>

从数据库加载属性值的附加配置。

<bean id="config1" class="org.apache.commons.configuration.DatabaseConfiguration">
        <constructor-arg type="javax.sql.DataSource" ref="dataSource" />
        <constructor-arg index="1" value="tablename1" />
        <constructor-arg index="2" value="columnname" />
        <constructor-arg index="3" value="columnvalue" />
    </bean>

    <bean id="configFactory1"
        class="org.springmodules.commons.configuration.CommonsConfigurationFactoryBean">
        <constructor-arg ref="config1" />
    </bean>

    <!-- DB Properties Initialization -->
    <bean id="configurationPlaceHolder1"
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="ignoreUnresolvablePlaceholders" value="false"/>
        <property name="properties" ref="configFactory1" />
    </bean>

    <bean id="config2" class="org.apache.commons.configuration.DatabaseConfiguration">
        <constructor-arg type="javax.sql.DataSource" ref="dataSource" />
        <constructor-arg index="1" value="tablename2" />
        <constructor-arg index="2" value="columnname" />
        <constructor-arg index="3" value="columnvalue" />
    </bean>

    <bean id="configFactory2"
        class="org.springmodules.commons.configuration.CommonsConfigurationFactoryBean">
        <constructor-arg ref="config2" />
    </bean>

    <!-- DB Properties Initialization -->
    <bean id="configurationPlaceHolder2"
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="ignoreUnresolvablePlaceholders" value="false"/>
        <property name="properties" ref="configFactory2" />
    </bean>

DAO 配置出现问题:

    <!-- DAO Bean which is causing issue -->
    <bean id="problematicBean" class="com.example.ProblematicDAOImpl" scope="singleton">
      <property name="dataSource"  ref="dataSource" />    
    </bean>

当我开始应用程序时，我被困在以下行:

    17 Feb 2014 15:39:58,981 -  main - DEBUG - 
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:691)  - 
Executing prepared SQL query
            17 Feb 2014 15:39:58,983 -  main - DEBUG - 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:625)  - 
Executing prepared SQL statement [ SQL STATEMENT ]  


17 Feb 2014 15:39:59,000 -  main - DEBUG -
 org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110)  
- Fetching JDBC Connection from DataSource

此行之后，应用程序挂起并且不响应。它也不会抛出异常。

我做了以下检查:

• 增加maxActive值。
• 增加initialSize值。
• 已检查- SQL STATEMENT于 Query Browser 被处决。

** 更新 **

我进一步调试了代​​码，代码卡在org.springframework.jdbc.core.JdbcTemplate中的@line 642对于方法org.springframework.jdbc.core.JdbcTemplate.execute(PreparedStatementCreator, PreparedStatementCallback<T>)

代码行如下:

if (this.nativeJdbcExtractor != null) {
                psToUse = this.nativeJdbcExtractor.getNativePreparedStatement(ps);
            }
            T result = action.doInPreparedStatement(psToUse);//Hangs at this line
            handleWarnings(ps);
            return result;

Answer 1

我给你了।我自己解决了。我使用 NamedParameterJdbctemplate 来调用不带任何参数的查询。在 spring api 中执行准备好的语句时，此挂起。我将其切换到 JdbcTempalte 类。效果很好。