当前位置:编程学习 > JAVA >>

急求解hibernate spring struts2 连接数据库sql server05出现问题。

后台报错如下:

INFO: Deploying web application directory D:\tomcat\apache-tomcat-7.0.32\webapps\Property
五月 07, 2013 6:01:16 下午 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
(0 ms) [Timer-0] WARN : com.mchange.v2.async.ThreadPoolAsynchronousRunner#run : com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@18f05ef -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
(19 ms) [Timer-0] WARN : com.mchange.v2.async.ThreadPoolAsynchronousRunner#run : com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@18f05ef -- APPARENT DEADLOCK!!! Complete Status: 
Managed Threads: 3
Active Threads: 3
Active Tasks: 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@95c278 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@12714d (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@ccafb6 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
Pending Tasks: 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@23fc17
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7b6cf4
Pool thread stack traces:
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)



hibernate.cfg.xml配置文件如下:

      <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
        <property name="connection.url">jdbc:jtds:sqlserver://localhost:1433;DatabaseName=proterty;SelectMethod=cursor</property>
        <property name="connection.username">sa</property>
        <property name="connection.password">pppttt</property>
                
        <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
                
        <!-- 用c3p0连接池,防止出现 rollback failed问题 -->
       <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<!--连接池的最小连接数--> 
<property name="hibernate.c3p0.min_size">5</property>
<!--最大连接数--> 
<property name="hibernate.c3p0.max_size">400</property>
<!--连接超时时间,1800-->
        <property name="hibernate.c3p0.timeout">1800</property>
        <!--statemnets缓存大小--> 
        <property name="hibernate.c3p0.max_statements">10</property>
        <!--每隔多少秒检测连接是否可正常使用  --> 
        <property name="hibernate.c3p0.idle_test_period">1000</property>
        <!--当池中的连接耗尽的时候,一次性增加的连接数量,默认为3--> 
        <property name="hibernate.c3p0.acquire_increment">5</property>
        <!-- 每次都验证连接是否可用 --> 
        <property name="hibernate.c3p0.validate">true</property>

        <!-- JDBC connection pool (use the built-in) <property name="connection.pool_size">30</property>-->
        <property name="current_session_context_class">thread</property>
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
        <property name="show_sql">true</property>
        <property name="hbm2ddl.auto">validate</property>
        


c3p0与jtds的jar包已导入。
求高手解答啊!! Hibernate Struts SQL Server Spring c3p0 --------------------编程问答-------------------- 自己先顶一个!! --------------------编程问答-------------------- 怎么没人回答我啊? --------------------编程问答--------------------  APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
你看这句话,意识是死锁。因为创建的线程时候,没有赋值!
检查一下你的线程! --------------------编程问答-------------------- 请参考我的基于spring,security,struts的开源项目
http://blog.csdn.net/shadowsick 
补充:Java ,  Java EE
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,