Hi,

I had some preformance issues with my production environment. So I tried some things. I am in doubt about hibernate configuration.

Environment:
Tomcat 4-1-29

begin webapps/myapp.xml
----------------------------------------------------------------------------------
<Context path="/rinoceronte" swallowOutput="true" docBase="rinoceronte.war" debug="0">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="rinoceronte." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/rinoceronte" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/rinoceronte">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>net.sourceforge.jtds.jdbc.Driver</value>
</parameter>
<parameter>
<name>defaultAutoCommit</name>
<value>false</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:jtds:sqlserver://localhost:1433/TatilDesign</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
</Context>
----------------------------------------------------------------------------------
end webapps/myapp.xml

begin hibernate.cfg.xml (some of it)
----------------------------------------------------------------------------------
<session-factory>
<property name="connection.datasource">java:comp/env/jdbc/rinoceronte</property>
<property name="use_outer_join">true</property>
<property name="show_sql">false</property>
<property name="dialect">net.sf.hibernate.dialect.SybaseDialect</property>
<property name="transaction.factory_class">net.sf.hibernate.transaction.JDBCTransactionFactory</property>

<property name="dbcp.maxActive">100</property>
<property name="dbcp.whenExhaustedAction">1</property>
<property name="dbcp.maxWait">60000</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">60000</property>
<property name="dbcp.ps.maxIdle">100</property>
<property name="connection.provider_class">net.sf.hibernate.connection.DatasourceConnectionProvider</property>
<property name="connection.pool_size">1</property>
<property name="statement_cache.size">25</property>
----------------------------------------------------------------------------------
end hibernate.cfg.xml

hibernate version 2.1.2

I am not sure about <property name="connection.datasource">java:comp/env/jdbc/rinoceronte</property>

Is this correct? Is it accordingly to myapp.xml??

What about connection.pool_size, connection.provider_class and statement_cache.size? I am not sure if I have to declare these. Are these values ok? Production env is about 100 havy users (intranet app).

Any suggestions to performance gain?

Tks
Felipe

Felipe,

I am using Resin 2.1.12 with Hibernate 2.1.2 and using the Resin Connection pool with Hibernate in the following manner.

hibernate.cfg.xml



The corresponding connection pool in the resin.conf is as follows:


I control the connection pool size and the idle time in this configuration. Do you have something similar to this in the application server you are using?

Hi,

tks for the reply.

I am not very familiar with these JNDI and data source configurations. So I used some I found on the net.

I am using only Tomcat web conteiner, and no app server. My soubt is: will hibernate use tomcats config to get info about pool size and so on, or will it use hiberntae.cfg.xml config to get the same info?

in myapp.xml, there is:


and my hibernate.cfg.xml is:


See that there is maxActive config in both. Wich one will be used?

Tks
Felipe

If you are using a JNDI Datasource, you should probably remove pool related configurations from your hibernate.cfg.xml file. That will ensure that Hibernate hands off connection related issues to your Datasource. To be honest with you, I have never researched what would happen if both had these configurations. But I can safely say that if you leave them in your Datasource mapping instead of the hibernate.cfg.xml, they will get used properly.

when I start my tomcat, log is as follow:



The last line shows SessionFactoryObjectFactory:82 - no JNDI name configured.
So I am actually not sure if I am using JNDI or not.
myapp.xml showed above does not configure JNDI datasource?