老问题,Hibernate连接池,在网上没找到对口的解决方案,在此求救
用的是MyEclipse开发,连接池是在Tomcat的server.xml中配置,如果采用JDBC的话一切正常,但只要换连接池就出现以下错误:
javax.servlet.ServletException: Cannot open connection
org.hibernate.exception.GenericJDBCException: Cannot open connection
数据库是Mysql4.1,驱动mysql-connector-java-5.0.4-bin.jar放在/common/lib下,因为用JDBC时一切正常,我怀疑应该是连接池的代码可能有误,server.xml中连接池代码是这样的:
<Context path="/SHLogin" docBase="F:\collection\MyEclipse\SHLogin\WebRoot" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/hibernate" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/hibernate">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>***</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/hibernate</value>
</parameter>
</ResourceParams>
</Context>
MyEclipse中配置的hibernate.cfg.xml如下:
<session-factory>
<property name="show_sql">true</property>
<property name="connection.datasource">java:comp/env/jdbc/hibernate</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<mapping resource="com/haxin/login/vo/Person.hbm.xml" />
</session-factory>
到底哪有错呢,请高手能帮我看看