关于spring整合(JPA)hibernate3.3.2,proxool的问题！

Question

先贴一下异常：
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is java.lang.UnsupportedOperationException: The user must supply a JDBC connection
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:599)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy18.login(Unknown Source)
at com.accp.web.action.EmployeeAction.login(EmployeeAction.java:19)
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 com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:163)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:249)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.interceptCaused by: java.lang.UnsupportedOperationException: The user must supply a JDBC connection
at org.hibernate.connection.UserSuppliedConnectionProvider.getConnection(UserSuppliedConnectionProvider.java:54)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)
... 124 more服务器启动的时候没有任何问题，但是一旦程序里执行数据库操作的时候就会抱上面的错误，由于小弟初学java，这个问题也令我很纠结，完全不知道从哪里下手，下面我再把配置贴出来给大伙看一下，希望哪位路过的大侠能帮俺解决一下，感激不尽！<!--proxool配置--!>
<?xml version="1.0" encoding="UTF-8"?> 
<something-else-entirely>
<proxool>
<!-- 连接池的别名 -->
<alias>DBPool</alias>
<!-- proxool只能管理由自己产生的连接 -->
<driver-url>
jdbc:oracle:thin:@192.168.1.100:1521:Vote
</driver-url>
<!-- JDBC驱动程序 -->
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="jbit"/>
<property name="password" value="jbit"/>
</driver-properties> 
<!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回
收,超时的销毁 --> 
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<!-- 指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的
用户连接就不会被接受 --> 
<maximum-new-connections>20</maximum-new-connections>
<!-- 最少保持的空闲连接数 --> 
<prototype-count>5</prototype-count>
<!-- 允许最大连接数,超过了这个连接，再有请求时，就排在队列中等候，最大的
等待请求数由maximum-new-connections决定 --> 
<maximum-connection-count>100</maximum-connection-count>
<!-- 最小连接数 -->
<minimum-connection-count>10</minimum-connection-count>
</proxool> 
</something-else-entirely><!--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">
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  
  <filter>
   <filter-name>character</filter-name>
   <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
   <init-param>
   <param-name>encoding</param-name>
   <param-value>utf-8</param-value>
   </init-param>
  </filter>
  <filter-mapping>
   <filter-name>character</filter-name>
   <url-pattern>/*</url-pattern>
  </filter-mapping>
  
  <context-param>
   <param-name>contextConfigLocation</param-name>
   <param-value>classpath:applicationContext*.xml</param-value>
  </context-param>
  <!-- 根据默认配置文件来初始化spring容器，配置spring监听器 -->
  <listener>
   <listener-class>
   org.springframework.web.context.ContextLoaderListener
   </listener-class>
  </listener>
  <filter>
   <filter-name>struts2</filter-name>
   <filter-class>
   org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
   </filter-class>
  </filter>
  <filter-mapping>
   <filter-name>struts2</filter-name>
   <url-pattern>/*</url-pattern>
  </filter-mapping>
  
  <!-- 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/proxool.xml</param-value>
   </init-param>
   <load-on-startup>1</load-on-startup>
  </servlet>
  
  <servlet>
   <servlet-name>datasource_situation</servlet-name>
   <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
  </servlet>
   <servlet-mapping>   
        <servlet-name>datasource_situation</servlet-name>   
        <url-pattern>/datasource_situation</url-pattern>   
    </servlet-mapping>
  </web-app> <!-- applicationContext配置 sessionfactroy-->
<!-- proxool配置 -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">

<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.proxool.pool_alias">DBPool</prop>
<prop key="hibernate.proxool.xml">/WEB-INF/proxool.xml</prop>
<prop key="hibernate.proxool.existing_pool">true</prop>
</props>
</property>

<property name="annotatedClasses">
<list>
<value>com.accp.entity.ClaimVoucher</value>
<value>com.accp.entity.CheckResult</value>
<value>com.accp.entity.Account</value>
<value>com.accp.entity.Department</value>
<value>com.accp.entity.ClaimVoucherDetail</value>
<value>com.accp.entity.Positions</value>
<value>com.accp.entity.Employee</value>
<value>com.accp.entity.Dictionary</value>
<value>com.accp.test.Test1</value>
</list>
</property>
</bean>

代码就这些了，这个问题找了几天也不知道怎么回事，我在网上找了一下说是什么proxool没有加载，但还是不知道怎么解决，希望哪位高手能指点俺一下，实在是太感激了！

Answer 1

 java.lang.UnsupportedOperationException: The user must supply a JDBC connection是否是当前用户没有数据库层的权限？你分配几个权限上去，再看下呢？

Answer 2

权限没问题的，因为最开始我用datasource的时候就没有任何问题，但一加入了proxool就报了这个错误，很纠结啊！