急！！！！求大侠指点，请问这是什么错误，在线等...

Question

type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Cannot open connection
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause org.hibernate.exception.GenericJDBCException: Cannot open connection
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
org.jbpm.pvm.internal.tx.HibernateSessionResource.<init>(HibernateSessionResource.java:44)
org.jbpm.pvm.internal.wire.descriptor.HibernateSessionDescriptor.construct(HibernateSessionDescriptor.java:87)
org.jbpm.pvm.internal.wire.WireContext.construct(WireContext.java:487)
org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:466)
org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:455)
org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:429)
org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:339)
org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:704)
org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:132)
org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:123)
org.jbpm.pvm.internal.env.EnvironmentImpl.getFromCurrent(EnvironmentImpl.java:207)
org.jbpm.pvm.internal.env.EnvironmentImpl.getFromCurrent(EnvironmentImpl.java:196)
org.jbpm.pvm.internal.cmd.CheckDbCmd.execute(CheckDbCmd.java:44)
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
org.jbpm.pvm.internal.processengine.ProcessEngineImpl.checkDb(ProcessEngineImpl.java:152)
org.jbpm.pvm.internal.processengine.ProcessEngineImpl.<init>(ProcessEngineImpl.java:105)
org.jbpm.pvm.internal.cfg.ConfigurationImpl.instantiateProcessEngine(ConfigurationImpl.java:100)
org.jbpm.pvm.internal.cfg.ConfigurationImpl.buildProcessEngine(ConfigurationImpl.java:92)
org.jbpm.api.Configuration.getProcessEngine(Configuration.java:126)
com.hoteam.kaide.jbpm.service.FlowManagerFormImpl.<init>(FlowManagerFormImpl.java:31)
com.hoteam.kaide.jbpm.service.FlowManagerFormImpl.getInstance(FlowManagerFormImpl.java:24)
com.hoteam.kaide.jbpm.action.FlowAction.execute(FlowAction.java:22)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.sql.SQLException: org.logicalcobwebs.proxool.ProxoolException: Attempt to refer to a unregistered pool by its alias 'proxool1'
org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:109)
java.sql.DriverManager.getConnection(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:207)
org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:75)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
org.jbpm.pvm.internal.tx.HibernateSessionResource.<init>(HibernateSessionResource.java:44)
org.jbpm.pvm.internal.wire.descriptor.HibernateSessionDescriptor.construct(HibernateSessionDescriptor.java:87)
org.jbpm.pvm.internal.wire.WireContext.construct(WireContext.java:487)
org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:466)
org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:455)
org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:429)
org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:339)
org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:704)
org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:132)
org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:123)
org.jbpm.pvm.internal.env.EnvironmentImpl.getFromCurrent(EnvironmentImpl.java:207)
org.jbpm.pvm.internal.env.EnvironmentImpl.getFromCurrent(EnvironmentImpl.java:196)
org.jbpm.pvm.internal.cmd.CheckDbCmd.execute(CheckDbCmd.java:44)
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
org.jbpm.pvm.internal.processengine.ProcessEngineImpl.checkDb(ProcessEngineImpl.java:152)
org.jbpm.pvm.internal.processengine.ProcessEngineImpl.<init>(ProcessEngineImpl.java:105)
org.jbpm.pvm.internal.cfg.ConfigurationImpl.instantiateProcessEngine(ConfigurationImpl.java:100)
org.jbpm.pvm.internal.cfg.ConfigurationImpl.buildProcessEngine(ConfigurationImpl.java:92)
org.jbpm.api.Configuration.getProcessEngine(Configuration.java:126)
com.hoteam.kaide.jbpm.service.FlowManagerFormImpl.<init>(FlowManagerFormImpl.java:31)
com.hoteam.kaide.jbpm.service.FlowManagerFormImpl.getInstance(FlowManagerFormImpl.java:24)
com.hoteam.kaide.jbpm.action.FlowAction.execute(FlowAction.java:22)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.26 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.26

Answer 1

上边是页面报错，这是控制台打印的错误：
信息: Initializing connection provider: org.hibernate.connection.ProxoolConnectionProvider
2012-7-13 16:03:02 org.hibernate.connection.ProxoolConnectionProvider configure
信息: Configuring Proxool Provider using existing pool in memory: proxool.proxool1
2012-7-13 16:03:02 org.hibernate.connection.ProxoolConnectionProvider configure
信息: autocommit mode: false
2012-7-13 16:03:02 org.hibernate.cfg.SettingsFactory buildSettings
警告: Could not obtain connection metadata
java.sql.SQLException: org.logicalcobwebs.proxool.ProxoolException: Attempt to refer to a unregistered pool by its alias 'proxool1'
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:109)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
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.buildSettings(Configuration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
at org.jbpm.pvm.internal.wire.descriptor.HibernateSessionFactoryDescriptor.construct(HibernateSessionFactoryDescriptor.java:62)
at org.jbpm.pvm.internal.wire.WireContext.construct(WireContext.java:487)
at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:466)
at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:455)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:429)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:339)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:704)
at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:154)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:711)
at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:132)
at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:123)
at org.jbpm.pvm.internal.wire.descriptor.HibernateSessionDescriptor.construct(HibernateSessionDescriptor.java:63)
at org.jbpm.pvm.internal.wire.WireContext.construct(WireContext.java:487)
at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:466)
at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:455)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:429)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:339)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:704)
at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:132)
at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:123)
at org.jbpm.pvm.internal.env.EnvironmentImpl.getFromCurrent(EnvironmentImpl.java:207)
at org.jbpm.pvm.internal.env.EnvironmentImpl.getFromCurrent(EnvironmentImpl.java:196)
at org.jbpm.pvm.internal.cmd.CheckDbCmd.execute(CheckDbCmd.java:44)
at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
at org.jbpm.pvm.internal.processengine.ProcessEngineImpl.checkDb(ProcessEngineImpl.java:152)
at org.jbpm.pvm.internal.processengine.ProcessEngineImpl.<init>(ProcessEngineImpl.java:105)
at org.jbpm.pvm.internal.cfg.ConfigurationImpl.instantiateProcessEngine(ConfigurationImpl.java:100)
at org.jbpm.pvm.internal.cfg.ConfigurationImpl.buildProcessEngine(ConfigurationImpl.java:92)
at org.jbpm.api.Configuration.getProcessEngine(Configuration.java:126)
at com.hoteam.kaide.jbpm.service.FlowManagerFormImpl.<init>(FlowManagerFormImpl.java:31)
at com.hoteam.kaide.jbpm.service.FlowManagerFormImpl.getInstance(FlowManagerFormImpl.java:24)
at com.hoteam.kaide.jbpm.action.FlowAction.execute(FlowAction.java:22)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)
2012-7-13 16:03:02 org.hibernate.dialect.Dialect <init>
信息: Using dialect: org.hibernate.dialect.Oracle9Dialect
2012-7-13 16:03:02 org.hibernate.dialect.Oracle9Dialect <init>

Answer 2

目测你的sql语句有问题，把你的sql语句拿出来去数据库连接工具里执行下。

Answer 3

看下你的sql语句，你的别名'proxool1'有问题，自己写一个连接测试类去测试下看你数据库通不通，如果是框架的话连接池那种地方一般都不会有问题，除非是你自己搭的框架。

Answer 4

是我自己搭的 原本是一个struts1.2+hibernate 的框架 我添加了JBPM4.4需要用到连接池 我不懂连接池  杯具中...

Answer 5

数据库连接打不开。
1.检查你的数据库服务打开木有
2.sql连接语句有木有写错

Answer 6

是连接池的配置问题...这个我还是看出来的，求高人指点  hibernate连接池我不会配

Answer 7

这是连接池的代码：<?xml version="1.0" encoding="UTF-8"?> <something-else-entirely>
<proxool> 
<alias>proxool1</alias>
<driver-url>
jdbc:oracle:thin:@localhost:1521:orcl
</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="jbmpdb" />
<property name="password" value="sduasp" />
<!-- 自动重连 -->
<property name="autoReconnect" value="true"/>
</driver-properties>

<!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁 -->
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<!-- 指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受(正式库10，测试库1) -->
<!-- Use of proxool.maximum-new-connections is deprecated. Use more descriptive proxool.simultaneous-build-throttle instead
<maximum-new-connections>20</maximum-new-connections>
-->
<!-- 最少保持的空闲连接数(正式库10，测试库1) -->
<prototype-count>1</prototype-count>
<!-- 连接池允许的最大连接数(正式库700，测试库10) -->
<maximum-connection-count>15</maximum-connection-count>
<!-- 连接池开启的最小连接数(正式库350，测试库5) -->
<minimum-connection-count>5</minimum-connection-count>
<!--  任一时刻，可以（同时）建立的最大连接数 -->
   <simultaneous-build-throttle>20</simultaneous-build-throttle>
<!-- 一个活动连接的最长时间15分钟，单位毫秒 -->
<maximum-active-time>900000</maximum-active-time>
<!-- 一个连接的最长活动时间4小时，单位毫秒 -->
<maximum-connection-lifetime>14400000</maximum-connection-lifetime>
<!-- 自动检查连接是否断掉开关 -->
<test-before-use>true</test-before-use>
<test-after-use>true</test-after-use>
<!-- 自动检查连接是否断的测试sql语句 -->
<house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>
</proxool>
</something-else-entirely>

Answer 8

hibernate连接池。在Myeclipse中配好数据源然后用hibernate就可以导出来配置啊 完全不需要再配什么了。

Answer 9

hibernate配置文件问题，还有spring中action bean的配置里没有把property配置完也会出现问题；你的是session没有创建，就是对数据库的连接有问题，检查配置文件

Answer 10

有的东西要改的，MYECLIPSE不可能全把你配置完，还有有的东西多余的是要去掉的