Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hi
I am using Hibernate 3 with WAS 5.1 . I do not have any problems when i connect using DBURL/uname and password. When i configured a data source and attempted to connect this is the error message I see. It seems like Hibernate was able to detect the datasource and its parameters but is unable to retrieve any data ... Any thoughts on this ?
These are the properties i have enabled:
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<property name="cglib.use_reflection_optimizer">false</property>
<property name="dialect">org.hibernate.dialect.DB2Dialect</property>
<property name="session_factory_name">HibernateSessionFactory</property>
<property name="transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">org.hibernate.transaction.WebSphereTransactionManagerLookup</property>
<property name="connection.datasource">jdbc/test</property>
Stack Trace:
----------------
[1/12/06 9:04:21:224 EST] 76126b34 DatasourceCon I org.hibernate.connection.DatasourceConnectionProvider Using datasource: jdbc/test
[1/12/06 9:04:22:285 EST] 76126b34 WSRdbDataSour I DSRA8203I: Database product name : DB2/6000
[1/12/06 9:04:22:335 EST] 76126b34 WSRdbDataSour I DSRA8204I: Database product version : SQL08015
[1/12/06 9:04:22:335 EST] 76126b34 WSRdbDataSour I DSRA8205I: JDBC driver name : IBM DB2 JDBC Universal Driver Architecture
[1/12/06 9:04:22:345 EST] 76126b34 WSRdbDataSour I DSRA8206I: JDBC driver version : 2.3.63
[1/12/06 9:04:22:536 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory RDBMS: DB2/6000, version: SQL08015
[1/12/06 9:04:22:536 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory JDBC driver: IBM DB2 JDBC Universal Driver Architecture, version: 2.3.63
[1/12/06 9:04:22:636 EST] 76126b34 Dialect I org.hibernate.dialect.Dialect Using dialect: org.hibernate.dialect.DB2Dialect
[1/12/06 9:04:22:676 EST] 76126b34 TransactionFa I org.hibernate.transaction.TransactionFactoryFactory Transaction strategy: org.hibernate.transaction.JTATransactionFactory
[1/12/06 9:04:22:696 EST] 76126b34 NamingHelper I org.hibernate.util.NamingHelper JNDI InitialContext properties:{}
[1/12/06 9:04:22:706 EST] 76126b34 TransactionMa I org.hibernate.transaction.TransactionManagerLookupFactory instantiating TransactionManagerLookup: org.hibernate.transaction.WebSphereTransactionManagerLookup
[1/12/06 9:04:22:716 EST] 76126b34 TransactionMa I org.hibernate.transaction.TransactionManagerLookupFactory instantiated TransactionManagerLookup
[1/12/06 9:04:22:716 EST] 76126b34 TransactionMa I org.hibernate.transaction.TransactionManagerLookupFactory instantiating TransactionManagerLookup: org.hibernate.transaction.WebSphereTransactionManagerLookup
[1/12/06 9:04:22:716 EST] 76126b34 TransactionMa I org.hibernate.transaction.TransactionManagerLookupFactory instantiated TransactionManagerLookup
[1/12/06 9:04:22:716 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Automatic flush during beforeCompletion(): disabled
[1/12/06 9:04:22:716 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Automatic session close at end of transaction: disabled
[1/12/06 9:04:22:726 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Scrollable result sets: enabled
[1/12/06 9:04:22:736 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory JDBC3 getGeneratedKeys(): disabled
[1/12/06 9:04:22:736 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Connection release mode: null
[1/12/06 9:04:22:736 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Maximum outer join fetch depth: 1
[1/12/06 9:04:22:736 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Default batch fetch size: 1
[1/12/06 9:04:22:736 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Generate SQL with comments: disabled
[1/12/06 9:04:22:746 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Order SQL updates by primary key: disabled
[1/12/06 9:04:22:746 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[1/12/06 9:04:22:766 EST] 76126b34 ASTQueryTrans I org.hibernate.hql.ast.ASTQueryTranslatorFactory Using ASTQueryTranslatorFactory
[1/12/06 9:04:22:766 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Query language substitutions: {no='N', true=1, yes='Y', false=0}
[1/12/06 9:04:22:766 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Second-level cache: enabled
[1/12/06 9:04:22:766 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Query cache: disabled
[1/12/06 9:04:22:766 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Cache provider: org.hibernate.cache.EhCacheProvider
[1/12/06 9:04:22:786 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Optimize cache for minimal puts: disabled
[1/12/06 9:04:22:786 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Structured second-level cache entries: disabled
[1/12/06 9:04:22:836 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Echoing all SQL to stdout
[1/12/06 9:04:22:836 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Statistics: disabled
[1/12/06 9:04:22:836 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Deleted entity synthetic identifier rollback: disabled
[1/12/06 9:04:22:836 EST] 76126b34 SettingsFacto I org.hibernate.cfg.SettingsFactory Default entity-mode: pojo
[1/12/06 9:04:22:986 EST] 76126b34 SessionFactor I org.hibernate.impl.SessionFactoryImpl building session factory
[1/12/06 9:04:23:026 EST] 76126b34 Configurator W net.sf.ehcache.config.Configurator No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: wsjar:file:/C:/work/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
[1/12/06 9:04:26:041 EST] 76126b34 SessionFactor I org.hibernate.impl.SessionFactoryObjectFactory Factory name: HibernateSessionFactory
[1/12/06 9:04:26:041 EST] 76126b34 NamingHelper I org.hibernate.util.NamingHelper JNDI InitialContext properties:{}
[1/12/06 9:04:26:051 EST] 76126b34 SessionFactor I org.hibernate.impl.SessionFactoryObjectFactory Bound factory to JNDI name: HibernateSessionFactory
[1/12/06 9:04:26:051 EST] 76126b34 SessionFactor W org.hibernate.impl.SessionFactoryObjectFactory InitialContext did not implement EventContext
[1/12/06 9:04:26:061 EST] 76126b34 WebSphereTran I org.hibernate.transaction.WebSphereTransactionManagerLookup WebSphere 5.1
[1/12/06 9:04:26:061 EST] 76126b34 SessionFactor I org.hibernate.impl.SessionFactoryImpl Checking 0 named queries
[
[1/12/06 9:04:27:493 EST] 76126b34 SystemOut O Hibernate: select emp0_.emp_id as emp1_0_, emp0_.emp_name as emp2_2_0_ from emp emp0_ where emp0_.emp_id=?
[1/12/06 9:04:27:833 EST] 76126b34 JDBCException W org.hibernate.util.JDBCExceptionReporter SQL Error: -99999, SQLState: null
[1/12/06 9:04:27:843 EST] 76126b34 JDBCException E org.hibernate.util.JDBCExceptionReporter Invalid operation: result set closed
[1/12/06 9:04:27:883 EST] 76126b34 SystemOut O Error finding emp info
org.hibernate.exception.GenericJDBCException: could not execute query
Login
FAQ
Search
