No suitable driver found for proxool.mysqlProxool

成一粒 2012-06-09 03:01:20
程序能够正常运行。但是tomcat启动的时候就汇报No suitable driver found for proxool.mysqlProxool错误
错误信息如下：

警告: Could not obtain connection metadata
java.sql.SQLException: No suitable driver found for proxool.mysqlProxool
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:168)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:435)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:409)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:537)
at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:180)
at org.springframework.beans.factory.annotation.InjectionMetadata.injectFields(InjectionMetadata.java:105)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessAfterInstantiation(CommonAnnotationBeanPostProcessor.java:289)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:959)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:671)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:610)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:431)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:409)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:537)
at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:180)
at org.springframework.beans.factory.annotation.InjectionMetadata.injectFields(InjectionMetadata.java:105)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessAfterInstantiation(CommonAnnotationBeanPostProcessor.java:289)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:959)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
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)
网上找了很多例子配置因该没问题。

...全文
1057 19 打赏 收藏 转发到动态 举报
写回复
用AI写文章
19 条回复
切换为时间正序
请发表友善的回复…
发表回复
u012147800 2014-04-28
  • 打赏
  • 举报
 回复
引用 17 楼 wuda236556254 的回复:
问题已经解决参考： http://blog.csdn.net/wuda236556254/article/details/7650031
这个里面的东西我不是看的很明白，我能问你点问题么
u012147800 2014-04-28
  • 打赏
  • 举报
 回复
我也遇到了同样的问题，求教啊。。。
成一粒 2012-06-10
  • 打赏
  • 举报
 回复
再刷新一次
成一粒 2012-06-10
  • 打赏
  • 举报
 回复
问题已经解决参考：
http://blog.csdn.net/wuda236556254/article/details/7650031
成一粒 2012-06-09
  • 打赏
  • 举报
 回复
求解决!
brightyq 2012-06-09
  • 打赏
  • 举报
 回复
嗯，spring3好像不支持servlet启动ApplicationContext（我太傻了~~~）
那看来还要写回Listener方式。

有个文章，看能帮助你不。
http://blog.sina.com.cn/s/blog_3d7407450100d7cs.html
成一粒 2012-06-09
  • 打赏
  • 举报
 回复
求解释别沉了
成一粒 2012-06-09
  • 打赏
  • 举报
 回复
[Quote=引用 11 楼 的回复:]
引用 9 楼 的回复:
引用 7 楼 的回复:
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

改成如下形式：
<servlet>
<servlet-name>contextConfigLocation</se……
[/Quote]

但是结果却提示如下：

严重: ********** 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)
brightyq 2012-06-09
  • 打赏
  • 举报
 回复
[Quote=引用 9 楼 的回复:]
引用 7 楼 的回复:
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

改成如下形式：
<servlet>
<servlet-name>contextConfigLocation</servlet-name>
……
[/Quote]
ContextLoaderListener的作用是什么？是在服务启动时加载ApplicationContext的配置信息
而它是关联了ContextLoaderServlet，最终都是由ContextLoader去加载配置信息。

但是添加了proxool.xml之后，就需要先加载proxool.xml，后加载ApplicationContext。
但listener不能实再这个顺序，所以改成servlet的形式；
而且load-on-startup属性要大于1,因为org.logicalcobwebs.proxool.configuration.ServletConfigurator已经是1了。
成一粒 2012-06-09
  • 打赏
  • 举报
 回复
[Quote=引用 4 楼 的回复:]
请尝试把proxool.xml
修改为<alias>proxool.mysqlProxool</alias>
[/Quote]
不行还是报No suitable driver found for proxool.proxool.mysqlProxool
成一粒 2012-06-09
  • 打赏
  • 举报
 回复
[Quote=引用 7 楼 的回复:]
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

改成如下形式：
<servlet>
<servlet-name>contextConfigLocation</servlet-name>
<serv……
[/Quote]

因该不是这个吧。一个是servlet一个是listener
成一粒 2012-06-09
  • 打赏
  • 举报
 回复
[Quote=引用 6 楼 的回复:]
收回刚刚的回答,应该是无加载proxool的驱动
你在hibernate配置中加入下吧
hibernate.connection.driver_class
org.logicalcobwebs.proxool.ProxoolDriver
就可以了吧
[/Quote]

添加了还是不行。报同样的错误
brightyq 2012-06-09
  • 打赏
  • 举报
 回复
<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加载之后加载。
游一游走一走 2012-06-09
  • 打赏
  • 举报
 回复
收回刚刚的回答,应该是无加载proxool的驱动
你在hibernate配置中加入下吧
hibernate.connection.driver_class
org.logicalcobwebs.proxool.ProxoolDriver
就可以了吧
brightyq 2012-06-09
  • 打赏
  • 举报
 回复
proxool.xml是用什么格式保存的？会是编码的问题吗。
游一游走一走 2012-06-09
  • 打赏
  • 举报
 回复
请尝试把proxool.xml
修改为<alias>proxool.mysqlProxool</alias>
成一粒 2012-06-09
  • 打赏
  • 举报
 回复
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>
成一粒 2012-06-09
  • 打赏
  • 举报
 回复
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>
成一粒 2012-06-09
  • 打赏
  • 举报
 回复 


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>
Proxool连接池使用方法
Proxool连接池使用方法 首先, 你要把下载 proxool 的 lib 下面所有的 jar 文件, 放到 WEB-INF/lib 下面, 另外, 把你的 jdbc driver 也放到相同的 lib,
proxool mysql 驱动,No suitable driver found for proxool.mysqlProxool解决思路
当前位置:我的异常网» J2EE»No suitable driver found for proxool.mysqlProxooNo suitable driver found for proxool.mysqlProxool解决思路www.myexceptions.net网友分享于：2013-08-16浏览：1185次No suitable driver found for pro...
SSH2+proxool 出现No suitable driver found for proxool.mysqlProxool
SSH2+proxool 出现No suitable driver found for proxool.mysqlProxool 首先我们要明确使用的是SSH2框架，然而Struts2是基于filter实现的那么在启动proxool的时候就不能够在用servlet来启动了！ 于是我们就想到在初始化web容器的时候怎么让他一开始就加载呢？ 我们查...
proxool连接池： No suitable driver found for proxool.shide
使用proxool连接池时：报错误No suitable driver found for proxool.shide的原因：     ①、WEB-INF目录下的lib中没有proxool连接池jar驱动包。(容易发现的原因)     ②、WEB-INF目录下没有web.xml配置文件或者在web.xml配置文件中对proxool数据库连接池的配置不正确。应该如下配置：(这个原因也较容易发现)...
使用proxool 连接池:No suitable driver found for proxool
使用proxool连接池时：报错误No suitable driver found for proxool.shide的原因：     ①、WEB-INF目录下的lib中没有proxool连接池jar驱动包。(容易发现的原因)     ②、WEB-INF目录下没有web.xml配置文件或者在web.xml配置文件中对proxool数据库连接池的配置不正确。应该如下配置：(这个原因也较容易发现)...
Java EE

67,515

社区成员

225,878

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章