在hibernate中引入proxool连接池

0 0

在hibernate中引入proxool连接池5

在hibernate中引入proxool连接池之后，系统运行报错No suitable driver found for proxool；我用的是hibernate的Annotation形式，检查过driverurl没有问题，修改过proxool.xml的编码，不管用，换过mysql的驱动包，不管用

这是我的proxool.xml的配置

<?xml version="1.0" encoding="UTF-8"?>
 <!--
   the proxool configuration can be embedded within your own application's.
   Anything outside the "proxool" tag is ignored.UTF-8
 -->
 <something-else-entirely>
   <proxool>
     <alias>DBProxool</alias>
     <driver-url>jdbc:mysql://172.16.113.53:3306/hibernate</driver-url>
     <driver-class>com.mysql.jdbc.Driver</driver-class>
     <driver-properties>
       <property name="user" value="root" />
       <property name="password" value="root" />
     </driver-properties>
     <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
     <house-keeping-sleep-time>90000</house-keeping-sleep-time>
     <simultaneous-build-throttle>20</simultaneous-build-throttle>
     <maximum-connection-count>100</maximum-connection-count>
     <minimum-connection-count>10</minimum-connection-count>
     <maximum-connection-lifetime>3600000</maximum-connection-lifetime>
   </proxool>
 </something-else-entirely>

这是我的hibernate.cfg.xml配置

<?xml version='1.0' encoding='utf-8'?>
<!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">DBProxool</property>
         <property name="hibernate.proxool.xml">proxool.xml</property>
         <property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
         <property name="hibernate.proxool.existing_pool">true</property>   
		
        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>

        <property name="hbm2ddl.auto">update</property>
		 <mapping class="com.hibernate.mlc.model.Category"/>
		  <mapping class="com.hibernate.mlc.model.Msg"/>
		  <mapping class="com.hibernate.mlc.model.Topic"/>
    </session-factory>

</hibernate-configuration>

这是系统报错

10:23:31,000  WARN org.hibernate.cfg.SettingsFactory:133 - Could not obtain connection to query metadata
java.sql.SQLException: No suitable driver found for proxool.DBProxool
	at java.sql.DriverManager.getConnection(DriverManager.java:602)
	at java.sql.DriverManager.getConnection(DriverManager.java:207)
	at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:75)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
	at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)
	at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
	at com.hibernate.mlc.model.HibernateQLTest.beforeClass(HibernateQLTest.java:25)
	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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
10:23:31,246  INFO org.hibernate.tool.hbm2ddl.SchemaUpdate:155 - Running hbm2ddl schema update
10:23:31,246  INFO org.hibernate.tool.hbm2ddl.SchemaUpdate:167 - fetching database metadata
10:23:31,247 ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate:175 - could not get database metadata

如果看到这个帖子的人，有知道的原因的，请给予小弟指点，小弟真诚求教

proxool Hiberante

2012年5月14日 10:49

mlc0202
11
0 0 2

1个答案按时间排序按投票排序

0 0

驱动jar包加入到classpath了么
还有proxool，你需要在启动的时候去注册他它的datasource
在web.xml里面加上这个

<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>

2012年5月15日 15:22