架构是struts+hibernate+spring,应用服务器用的是tomcat,数据库用的是mysql,
把opensessioninview以过滤器的形式配置在了web.xml,一开始配置在上下文
<Context path="" docBase="C:\tomcat\webapps\ROOT" reloadable="false">
<Resource
name="jdbc/aaaaDB"
type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
username="aaaa"
password="aaaa"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="10"
maxWait="15000"
maxActive="50"
url="jdbc:oracle:thin:@10.0.0.3:1521:orcl"/>
</Context>
hibernate.cfg.xml
<property name="connection.datasource">
java:comp/env/jdbc/aaaaDB
</property>
<!-- dialect for Oracle (any version) -->
<property name="dialect">
net.sf.hibernate.dialect.Oracle9Dialect
</property>
<property name="hibernate.connection.provider_class">
net.sf.hibernate.connection.DatasourceConnectionProvider
</property>
在spring里配置sessionFactory利用classpath引用hibernate.cfg.xml
当把上下文的DBCP连接池去掉,改成配置到hibernate.cfg.xml
<property name="connection.pool.size">2</property>
<property name="statement_cache.size">25</property>
<property name="jdbc.fetch_size">50</property>
<property name="jdbc.batch_size">30</property>
<property name="show_sql">true</property>
<property name="connection.provider_class">net.sf.hibernate.connection.DBCPConnectionProvider</property>
<property name="dbcp.maxActive">100</property>
<property name="dbcp.whenExhaustedAction">1</property>
<property name="dbcp.maxWait">120000</property>
<property name="dbcp.maxIdle">10</property>
<property name="dbcp.ps.maxActive">100</property>
<property name="dbcp.ps.whenExhaustedAction">1</property>
<property name="dbcp.ps.maxWait">120000</property>
<property name="dbcp.ps.maxIdle">100</property>
在运行中会报opensessioninview不能打开hibernate session.应该如何解决那.
把opensessioninview以过滤器的形式配置在了web.xml,一开始配置在上下文
<Context path="" docBase="C:\tomcat\webapps\ROOT" reloadable="false">
<Resource
name="jdbc/aaaaDB"
type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
username="aaaa"
password="aaaa"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="10"
maxWait="15000"
maxActive="50"
url="jdbc:oracle:thin:@10.0.0.3:1521:orcl"/>
</Context>
hibernate.cfg.xml
<property name="connection.datasource">
java:comp/env/jdbc/aaaaDB
</property>
<!-- dialect for Oracle (any version) -->
<property name="dialect">
net.sf.hibernate.dialect.Oracle9Dialect
</property>
<property name="hibernate.connection.provider_class">
net.sf.hibernate.connection.DatasourceConnectionProvider
</property>
在spring里配置sessionFactory利用classpath引用hibernate.cfg.xml
当把上下文的DBCP连接池去掉,改成配置到hibernate.cfg.xml
<property name="connection.pool.size">2</property>
<property name="statement_cache.size">25</property>
<property name="jdbc.fetch_size">50</property>
<property name="jdbc.batch_size">30</property>
<property name="show_sql">true</property>
<property name="connection.provider_class">net.sf.hibernate.connection.DBCPConnectionProvider</property>
<property name="dbcp.maxActive">100</property>
<property name="dbcp.whenExhaustedAction">1</property>
<property name="dbcp.maxWait">120000</property>
<property name="dbcp.maxIdle">10</property>
<property name="dbcp.ps.maxActive">100</property>
<property name="dbcp.ps.whenExhaustedAction">1</property>
<property name="dbcp.ps.maxWait">120000</property>
<property name="dbcp.ps.maxIdle">100</property>
在运行中会报opensessioninview不能打开hibernate session.应该如何解决那.