JBOSS 下 hibernate 引入proxool连接池 出错问题
web.xml 配置如下:
hibernate.cfg.xml
配置如下:
proxool.xml 配置如下:
jboss-deployment-structure.xml 中配置相关jar
<module name="test.jdbc.oracle" />
出错信息如下:
Debug后,出错的代码行为
SESSION_FACTORY =(CONFIGURATION.configure().buildSessionFactory());
请问该如何修改配置
<servlet>
<servlet-name>Admin</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Admin</servlet-name>
<url-pattern>/proxool-admin.adm</url-pattern>
</servlet-mapping>
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.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="dialect">org.hibernate.dialect.OracleDialect </property>
<property name="jdbc.fetch_size">50</property>
<property name="jdbc.batch_size">25</property>
<property name="max_fetch_depth">2</property>
<property name="default_batch_fetch_size">24</property>
<property name="query.substitutions">
true 'Y', false 'N', yes 'Y', no 'N'
</property>
<property name="jdbc.use_streams_for_binary">true</property>
<property name="use_outer_join">true</property>
<property name="show_sql">false</property>
<property name="format_sql">true</property>
<property name="use_sql_comments">false</property>
<property name="generate_statistics">true</property>
<property name="hibernate.current_session_context_class">
thread
</property>
<property name="hibernate.connection.release_mode">
on_close
</property>
<mapping resource="mytest/Count.hbm.xml" />
</session-factory>
</hibernate-configuration>
proxool.xml 配置如下:
<?xml version="1.0" encoding="utf-8"?>
<something-else-entirely>
<proxool>
<alias>proxool.xml</alias>
<driver-url>jdbc:oracle:thin:@192.168.130.248:1521:TESTDB</driver-url>
<driver-class> oracle.jdbc.driver.OracleDriver </driver-class>
<driver-properties>
<property name="user" value="TEST2"/>
<property name="password" value="TEST2"/>
</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>
<maximum-active-time>900000</maximum-active-time>
<maximum-connection-lifetime>1200000</maximum-connection-lifetime>
</proxool>
</something-else-entirely>
jboss-deployment-structure.xml 中配置相关jar
<module name="test.jdbc.oracle" />
出错信息如下:
14:21:26,872 WARN [org.jboss.modules] (Finalizer) Failed to define class oracle.jdbc.pool.OraclePooledConnection in Module "test.jdbc.oracle:main" from local module loader @435a3a (roots: E:\jboss-as-7.1.1.Final-eclipse\modules): java.lang.LinkageError: Failed to link oracle/jdbc/pool/OraclePooledConnection (Module "test.jdbc.oracle:main" from local module loader @435a3a (roots: E:\jboss-as-7.1.1.Final-eclipse\modules))
at org.jboss.modules.ModuleClassLoader.defineClass(ModuleClassLoader.java:396)
at org.jboss.modules.ModuleClassLoader.loadClassLocal(ModuleClassLoader.java:243)
at org.jboss.modules.ModuleClassLoader$1.loadClassLocal(ModuleClassLoader.java:73)
at org.jboss.modules.Module.loadModuleClass(Module.java:517)
at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:182)
at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468)
at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456)
at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:423)
at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398)
at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120)
at java.lang.Class.getDeclaredMethods0(Native Method) [rt.jar:1.6.0_27]
at java.lang.Class.privateGetDeclaredMethods(Class.java:2427) [rt.jar:1.6.0_27]
at java.lang.Class.privateGetPublicMethods(Class.java:2547) [rt.jar:1.6.0_27]
at java.lang.Class.getMethods(Class.java:1410) [rt.jar:1.6.0_27]
Debug后,出错的代码行为
SESSION_FACTORY =(CONFIGURATION.configure().buildSessionFactory());
请问该如何修改配置
...全文
相关推荐
proxool连接池配置详解
### Proxool连接池配置详解#### 一、概述Proxool是一个开源的轻量级Java数据库连接池实现,其主要目标是替代常见的数据库连接池解决方案,如C3P0或DBCP,并且提供了更加灵活和易于配置的特性
hibernate.jar详解
**c3p0-0.8.4.5.jar**:C3P0是一个开源的JDBC连接池,它被Hibernate用作管理数据库连接的工具,提高了数据库访问的效率。4.
Hibernate Developer Guide
- **1.2.2 Proxool 连接池** - Proxool 是 Apache 的一个轻量级连接池实现,提供了一种简单的方式来管理和控制数据库连接。
最新 hibernate.4.1.6.Final devguide pdf版
Hibernate 支持多种连接池,如 c3p0、Proxool,甚至可以从应用服务器中通过 JNDI 获取连接,这极大地提高了应用程序的灵活性和可扩展性。
Hibernate框架全部jar包
**proxool-0.8.3.jar**:Proxool是一个JDBC连接池,它为应用程序提供了一个灵活的、易于使用的连接池解决方案。


