Hibernate version:
2.1.6
Mapping documents:
Code between sessionFactory.openSession() and session.close():
Full stack trace of any exception that occurs:
Name and version of the database you are using:
DB2 8.1
The generated SQL (show_sql=true):
Debug level Hibernate log excerpt:
Hi,
I have a question. What is the correct way to configure the isolation level?
Scenario: Hibernate, DB2, Websphere Studio 5.1.2
I have set it in the hibernate.cfg.xml
<!-- TRANSACTION_READ_COMMITTED 2 -->
<property name="hibernate.connection.isolation">2</property>
But I don't see any message related with the isolation level in the console when I start the servlet. So I think It is not setting such property.
I just see the folowing messages related with the configuration:
[11/16/04 9:04:50:625 CST] 5bab0e9f Environment I net.sf.hibernate.cfg.Environment Hibernate 2.1.6
[11/16/04 9:04:50:625 CST] 5bab0e9f Environment I net.sf.hibernate.cfg.Environment hibernate.properties not found
[11/16/04 9:04:50:635 CST] 5bab0e9f Environment I net.sf.hibernate.cfg.Environment using CGLIB reflection optimizer
[11/16/04 9:04:50:665 CST] 5bab0e9f Configuration I net.sf.hibernate.cfg.Configuration configuring from resource: /hibernate.cfg.xml
[11/16/04 9:04:50:665 CST] 5bab0e9f Configuration I net.sf.hibernate.cfg.Configuration Configuration resource: /hibernate.cfg.xml
[11/16/04 9:04:51:045 CST] 5bab0e9f Configuration I net.sf.hibernate.cfg.Configuration Mapping resource: Server.hbm.xml
::::
[11/16/04 9:04:54:400 CST] 5bab0e9f Configuration I net.sf.hibernate.cfg.Configuration Configured SessionFactory: null
:::
[11/16/04 9:04:54:580 CST] 5bab0e9f Dialect I net.sf.hibernate.dialect.Dialect Using dialect: net.sf.hibernate.dialect.DB2Dialect
[11/16/04 9:04:54:590 CST] 5bab0e9f SettingsFacto I net.sf.hibernate.cfg.SettingsFactory Maximim outer join fetch depth: 1
[11/16/04 9:04:54:590 CST] 5bab0e9f SettingsFacto I net.sf.hibernate.cfg.SettingsFactory Use outer join fetching: true
[11/16/04 9:04:54:610 CST] 5bab0e9f NamingHelper I net.sf.hibernate.util.NamingHelper JNDI InitialContext properties:{}
[11/16/04 9:04:55:211 CST] 5bab0e9f DatasourceCon I net.sf.hibernate.connection.DatasourceConnectionProvider Using datasource: jdbc/publishing
[11/16/04 9:04:55:221 CST] 5bab0e9f TransactionMa I net.sf.hibernate.transaction.TransactionManagerLookupFactory instantiating TransactionManagerLookup: net.sf.hibernate.transaction.WebSphereTransactionManagerLookup
[11/16/04 9:04:55:231 CST] 5bab0e9f TransactionMa I net.sf.hibernate.transaction.TransactionManagerLookupFactory instantiated TransactionManagerLookup
[11/16/04 9:05:22:330 CST] 5bab0e9f WSRdbDataSour I DSRA8203I: Database product name : DB2/NT
[11/16/04 9:05:22:360 CST] 5bab0e9f WSRdbDataSour I DSRA8204I: Database product version : 08.01.0005
[11/16/04 9:05:22:370 CST] 5bab0e9f WSRdbDataSour I DSRA8205I: JDBC driver name : IBM DB2 JDBC 2.0 Type 2
[11/16/04 9:05:22:370 CST] 5bab0e9f WSRdbDataSour I DSRA8206I: JDBC driver version : 08.01.0005
[11/16/04 9:05:22:751 CST] 5bab0e9f SettingsFacto I net.sf.hibernate.cfg.SettingsFactory Use scrollable result sets: true
[11/16/04 9:05:22:751 CST] 5bab0e9f SettingsFacto I net.sf.hibernate.cfg.SettingsFactory Use JDBC3 getGeneratedKeys(): false
[11/16/04 9:05:22:751 CST] 5bab0e9f SettingsFacto I net.sf.hibernate.cfg.SettingsFactory Optimize cache for minimal puts: false
[11/16/04 9:05:22:761 CST] 5bab0e9f SettingsFacto I net.sf.hibernate.cfg.SettingsFactory Default schema set to: db2admin
[11/16/04 9:05:22:761 CST] 5bab0e9f SettingsFacto I net.sf.hibernate.cfg.SettingsFactory echoing all SQL to stdout
[11/16/04 9:05:22:761 CST] 5bab0e9f SettingsFacto I net.sf.hibernate.cfg.SettingsFactory Query language substitutions: {}
[11/16/04 9:05:22:761 CST] 5bab0e9f SettingsFacto I net.sf.hibernate.cfg.SettingsFactory cache provider: net.sf.hibernate.cache.HashtableCacheProvider
[11/16/04 9:05:22:911 CST] 5bab0e9f Configuration I net.sf.hibernate.cfg.Configuration instantiating and configuring caches
[11/16/04 9:05:23:081 CST] 5bab0e9f SessionFactor I net.sf.hibernate.impl.SessionFactoryImpl building session factory
[11/16/04 9:05:24:864 CST] 5bab0e9f SessionFactor I net.sf.hibernate.impl.SessionFactoryObjectFactory Not binding factory to JNDI, no JNDI name configured
[11/16/04 9:05:24:864 CST] 5bab0e9f WebSphereTran I net.sf.hibernate.transaction.WebSphereTransactionManagerLookup WebSphere 5.1
::::
|