I have application which is using Hibernate 3.2.5 and Spring 2.5 to connect to DB2 9.5 database.
Hibernate configuration is described in my Spring configuration file, so i am using Spring to get Hibernate Session Factory.
All transactions are managed declaratively through Spring AOP API (not through AspectJ annotations, all configuration is in XML file).
My application has a performance problem: beginning a Hibernate transaction takes a lot of time:
As you can see from the log file, just opening JDBC connection to begin Hibernate transaction takes more than two seconds!
Part of my Spring application context is described below:
Does anybody know, is there any way to make Spring & Hibernate to work faster? Maybe i must add something to Spring configuration file?
If somebody faces the same issue, stop using com.ibm.db2.jcc.DB2SimpleDataSource, because it doesn't support conection pooling. Use C3P0 instead to keep a pool of active JDBC connections, which can be used by Hibernate to begin transactions.