proxool调试的问题!5天了,所有论坛都问了,晕!!!
出错信息如下:
5468 [http-8080-Processor25] INFO proxool.ProxoolFacade - Proxool 0.8.3 (14-Dec-2003 16:06)
5531 [http-8080-Processor25] INFO connection.ProxoolConnectionProvider - Configuring Proxool Provider to use pool alias: proxool.DBPool
5531 [http-8080-Processor25] INFO connection.ProxoolConnectionProvider - autocommit mode: false
6172 [http-8080-Processor25] INFO cfg.SettingsFactory - RDBMS: MySQL, version: 5.0.27-community-nt
6172 [http-8080-Processor25] INFO cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
6234 [http-8080-Processor25] INFO dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
6250 [http-8080-Processor25] INFO transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
6265 [http-8080-Processor25] INFO transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
6406 [http-8080-Processor25] INFO cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
6406 [http-8080-Processor25] INFO cfg.SettingsFactory - Automatic session close at end of transaction: disabled
6406 [http-8080-Processor25] INFO cfg.SettingsFactory - JDBC batch size: 15
6406 [http-8080-Processor25] INFO cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Scrollable result sets: enabled
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Connection release mode: auto
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Maximum outer join fetch depth: 2
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Default batch fetch size: 1
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Generate SQL with comments: disabled
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Order SQL updates by primary key: disabled
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
6422 [http-8080-Processor25] INFO ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Query language substitutions: {}
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Second-level cache: enabled
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Query cache: disabled
6422 [http-8080-Processor25] INFO cfg.SettingsFactory - Cache provider: org.hibernate.cache.EhCacheProvider
6437 [http-8080-Processor25] INFO cfg.SettingsFactory - Optimize cache for minimal puts: disabled
6437 [http-8080-Processor25] INFO cfg.SettingsFactory - Structured second-level cache entries: disabled
6453 [http-8080-Processor25] INFO cfg.SettingsFactory - Echoing all SQL to stdout
6453 [http-8080-Processor25] INFO cfg.SettingsFactory - Statistics: disabled
6453 [http-8080-Processor25] INFO cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
6453 [http-8080-Processor25] INFO cfg.SettingsFactory - Default entity-mode: pojo
6515 [http-8080-Processor25] INFO impl.SessionFactoryImpl - building session factory
6531 [http-8080-Processor25] WARN config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/D:/tomcat/webapps/bookstoressh/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
7203 [http-8080-Processor25] INFO impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
7203 [http-8080-Processor25] INFO cfg.Configuration - configuring from resource: /hibernate.cfg.xml
7203 [http-8080-Processor25] INFO cfg.Configuration - Configuration resource: /hibernate.cfg.xml
7218 [http-8080-Processor25] INFO cfg.Configuration - Reading mappings from resource: com/gzzl/struts/Customer.hbm.xml
7250 [http-8080-Processor25] INFO cfg.HbmBinder - Mapping class: com.gzzl.struts.Customer -> customer
7250 [http-8080-Processor25] INFO cfg.Configuration - Configured SessionFactory: null
7250 [http-8080-Processor25] INFO connection.ConnectionProviderFactory - Initializing connection provider: org.hibernate.connection.ProxoolConnectionProvider
7250 [http-8080-Processor25] INFO connection.ProxoolConnectionProvider - Configuring Proxool Provider using JAXPConfigurator: MyDb.xml
7265 [http-8080-Processor25] FATAL connection.ProxoolConnectionProvider - Proxool Provider unable to load JAXP configurator file: MyDb.xml
org.logicalcobwebs.proxool.ProxoolException: Parsing failed.
at org.logicalcobwebs.proxool.configuration.JAXPConfigurator.configure(JAXPConfigurator.java:91)
at org.logicalcobwebs.proxool.configuration.JAXPConfigurator.configure(JAXPConfigurator.java:107)
at org.hibernate.connection.ProxoolConnectionProvider.configure(ProxoolConnectionProvider.java:120)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at com.gzzl.struts.CustomerDAO.getSessionFactory(CustomerDAO.java:37)
MYDb.xml内容:
<?xml version= "1.0 " encoding= "UTF-8 "?>
<proxool>
<alias> DBPool </alias>
<driver-url> jdbc:mysql://localhost:3306/bookstoressh </driver-url>
<driver-class> com.mysql.jdbc.Driver </driver-class>
<driver-properties>
<property name= "user " value= "root "/>
<property name= "password " value= "111 "/>
</driver-properties>
<house-keeping-test-time> select CURRENT_DATE </house-keeping-test-time>
<maximum-active-time> 60000 </maximum-active-time>
<maximum-connection-count> 100 </maximum-connection-count>
<minimum-connection-count> 10 </minimum-connection-count>
</proxool>
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 ">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name= "hibernate.connection.provider_class "> org.hibernate.connection.ProxoolConnectionProvider
</property>
<property name= "hibernate.proxool.pool_alias "> DBPool </property>
<property name= "hibernate.proxool.xml "> MyDb.xml </property>
<property name= "show_sql "> true </property>
<property name= "dialect "> org.hibernate.dialect.MySQLDialect </property>
<mapping resource= "com/gzzl/struts/Customer.hbm.xml " />
</session-factory>
</hibernate-configuration>
重点是:MyDb.xml已经被读取了,我尝试更改了数据库的密码,就无法访问数据库了.
但是一直PArsing Failed,不知道为什么????经常有人问这个问题,就没有解决过.郁闷!!!
[解决办法]
没有用过，只能猜测：
1.由于密码是数字，是不是密码的问题？
2.你文件名写错没？MYDb.xml这个不知道是你手误还是……
最后帮你顶下。
------解决方案--------------------
是不是MYDb.xml文件的路径不对啊
[解决办法]
在hibernate.cfg.xml中加入
<property name= "proxool.pool_alias "> pool1 </property>
<property name= "proxool.xml "> ProxoolConf.xml </property>
<property name= "connection.provider_class "> net.sf.hibernate.connection.ProxoolConnectionProvider </property>
然后，在和hibernate.cfg.xml同一个目录下，加一个ProxoolConf.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. -->
<something-else-entirely>
<proxool>
<alias> pool1 </alias>
<!--proxool只能管理由自己产生的连接-->
<driver-url> jdbc:mysql://localhost:3306/struts?useUnicode=true&characterEncoding=GBK </driver-url>
<driver-class> org.gjt.mm.mysql.Driver </driver-class>
<driver-properties>
<property name= "user " value= "root "/>
<property name= "password " value= "8888 "/>
</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>
并在classespath中加入proxool-0.8.3.jar
[解决办法]
你的hibernate.cfg.xml文件中
<property name= "hibernate.connection.provider_class "> org.hibernate.connection.ProxoolConnectionProvider
</property>
name改为 "connection.provider_class " 就没问题了
结帖给分！呵呵！
[解决办法]
也用proxool,不清楚你的问题！
帮你顶
[解决办法]
用了1年,还没碰过这个异常
[解决办法]
你把MyDb的内容全部放到cfg下面吧
不要另起xml了
[解决办法]
我没碰到过这种问题，只能帮你顶帖咯
[解决办法]
我也碰到了这个问题，有点莫名其妙啊
http://community.csdn.net/Expert/TopicView3.asp?id=5450291
[解决办法]
支持一下楼主
[解决办法]
同样问题啊，我用junit测试的,插入数据的时候是正常的,但是testSelect的时候就出现这个错误
[解决办法]
同样问题，紧急求解！！！
[解决办法]
我地妈啊~谁看谁晕啊~
[解决办法]
不能解析的原因之一是 你在 你的 MyDb.xml 里面加入了 <!-- 注释 -->
把它去掉. 相信就能把问题给解决掉的.
------解决方案--------------------
http://www.5ijavabook.cn/book.do?method=BookContent&id=240
看看这篇文章吧
我想这应该可以解决这个问题，我曾和你有一样的情况！
很简单，看了就知道了
更多:http://www.5ijavabook.cn
[解决办法]
Proxool Provider unable to load JAXP configurator file: MyDb.xml
你怎么就知道MyDb.xml 文件加载进来了，这句不是提示没加载成功吗？
[解决办法]
用过一次，看看也没有看出什么问题
[解决办法]
连接池这么多，为什么一定要用proxool
