No suitable driver found for proxool.mysqlProxool

Question

web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 
xmlns="http://java.sun.com/xml/ns/javaee" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<filter>
<filter-name>strust2</filter-name>
<filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
</filter>
    <filter-mapping>
        <filter-name>strust2</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    <context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:bean.xml</param-value>
</context-param>

    <listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
 <!-- proxool配置 -->
 <servlet>   
        <servlet-name>ServletConfigurator</servlet-name>   
        <servlet-class>   
            org.logicalcobwebs.proxool.configuration.ServletConfigurator   
        </servlet-class>   
        <init-param>   
            <param-name>xmlFile</param-name>   
            <param-value>WEB-INF/classes/proxool.xml</param-value>   
        </init-param>   
        <load-on-startup>1</load-on-startup>   
  </servlet> 

  <welcome-file-list>
    <welcome-file>user_login.jsp</welcome-file>
  </welcome-file-list>
</web-app>

Answer 1

hibernate.cfg.xml<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration>
<session-factory>
<property name="hibernate.proxool.pool_alias">mysqlProxool</property>
<property name="hibernate.proxool.xml">WEB-INF/classes/proxool.xml</property>
<property name="hibernate.proxool.existing_pool">true</property>
<property name="show_sql">true</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.jdbc.batch_size">16</property>
<mapping resource="com/wuda/hibernate/table/users.hbm.xml"/>

</session-factory>
</hibernate-configuration>

Answer 2

proxool.xml<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>   
<proxool-config>   
     <proxool>   
         <alias>mysqlProxool</alias>   
         <driver-url>jdbc:mysql://localhost:3306/my_blog_01?characterEncoding=UTF-8</driver-url>   
         <driver-class>com.mysql.jdbc.Driver</driver-class>   
         <driver-properties>   
             <property name="user" value="root" />   
             <property name="password" value="123456" />   
         </driver-properties>   
         <house-keeping-sleep-time>90000</house-keeping-sleep-time>   
         <maximum-new-connections>20</maximum-new-connections>   
         <prototype-count>5</prototype-count>   
         <maximum-connection-count>100</maximum-connection-count>   
         <minimum-connection-count>10</minimum-connection-count>   
     </proxool> 
</proxool-config> 
</something-else-entirely>   

Answer 3

请尝试把proxool.xml
修改为<alias>proxool.mysqlProxool</alias>

Answer 4

proxool.xml是用什么格式保存的？会是编码的问题吗。

Answer 5

收回刚刚的回答,应该是无加载proxool的驱动
你在hibernate配置中加入下吧
hibernate.connection.driver_class
org.logicalcobwebs.proxool.ProxoolDriver
就可以了吧

Answer 6

<listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>改成如下形式：
<servlet>
  <servlet-name>contextConfigLocation</servlet-name>
  <servlet-class>
    org.springframework.web.context.ContextLoaderServlet
  </servlet-class>
  <load-on-startup>2</load-on-startup>
</servlet>因为contextConfigLocation要在proxool.xml加载之后加载。

Answer 7

因该不是这个吧。一个是servlet一个是listener

Answer 8

不行还是报No suitable driver found for proxool.proxool.mysqlProxool

Answer 9

ContextLoaderListener的作用是什么？是在服务启动时加载ApplicationContext的配置信息
而它是关联了ContextLoaderServlet，最终都是由ContextLoader去加载配置信息。但是添加了proxool.xml之后，就需要先加载proxool.xml，后加载ApplicationContext。
但listener不能实再这个顺序，所以改成servlet的形式；
而且load-on-startup属性要大于1,因为org.logicalcobwebs.proxool.configuration.ServletConfigurator已经是1了。

Answer 10

但是结果却提示如下：严重: ********** FATAL ERROR STARTING UP STRUTS-SPRING INTEGRATION **********
Looks like the Spring listener was not configured for your web app! 
Nothing will work until WebApplicationContextUtils returns a valid ApplicationContext.
You might need to add the following to web.xml: 
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
2012-6-9 19:41:58 com.opensymphony.xwork2.util.logging.commons.CommonsLogger error
严重: Dispatcher initialization failed
java.lang.NullPointerException
at com.opensymphony.xwork2.spring.SpringObjectFactory.getClassInstance(SpringObjectFactory.java:220)
at com.opensymphony.xwork2.config.providers.XmlConfigurationProvider.verifyResultType(XmlConfigurationProvider.java:530)
at com.opensymphony.xwork2.config.providers.XmlConfigurationProvider.addResultTypes(XmlConfigurationProvider.java:501)
at com.opensymphony.xwork2.config.providers.XmlConfigurationProvider.addPackage(XmlConfigurationProvider.java:457)
at com.opensymphony.xwork2.config.providers.XmlConfigurationProvider.loadPackages(XmlConfigurationProvider.java:275)
at org.apache.struts2.config.StrutsXmlConfigurationProvider.loadPackages(StrutsXmlConfigurationProvider.java:111)
at com.opensymphony.xwork2.config.impl.DefaultConfiguration.reloadContainer(DefaultConfiguration.java:204)
at com.opensymphony.xwork2.config.ConfigurationManager.getConfiguration(ConfigurationManager.java:66)
at org.apache.struts2.dispatcher.Dispatcher.init_PreloadConfiguration(Dispatcher.java:380)
at org.apache.struts2.dispatcher.Dispatcher.init(Dispatcher.java:424)
at org.apache.struts2.dispatcher.ng.InitOperations.initDispatcher(InitOperations.java:69)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.init(StrutsPrepareAndExecuteFilter.java:51)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:275)
at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:397)
at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:108)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3693)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4340)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

Answer 11

嗯，spring3好像不支持servlet启动ApplicationContext（我太傻了~~~）
那看来还要写回Listener方式。有个文章，看能帮助你不。
http://blog.sina.com.cn/s/blog_3d7407450100d7cs.html

Answer 12

问题已经解决参考：
http://blog.csdn.net/wuda236556254/article/details/7650031