-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 
  Previous topic | Next topic 
Author Message
Uthra
 Post subject: ResultSet closed error using DB2 Datasource with WAS 5.1
PostPosted: Thu Jan 12, 2006 10:13 am 
Newbie

Joined: Mon Nov 28, 2005 5:08 pm
Posts: 3
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
Top
 Profile  
 
LORDs_diakonos
 Post subject:
PostPosted: Thu Jan 12, 2006 10:55 am 
Beginner
Beginner

Joined: Sun Dec 05, 2004 10:25 am
Posts: 23
which db2 jdbc driver are you using in your datasource? is it the jcc one?
Top
 Profile  
 
Uthra
 Post subject:
PostPosted: Thu Jan 12, 2006 11:03 am 
Newbie

Joined: Mon Nov 28, 2005 5:08 pm
Posts: 3
I am using a DB2 Universal JDBC Driver .

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
Top
 Profile  
 
LORDs_diakonos
 Post subject:
PostPosted: Thu Jan 12, 2006 11:17 am 
Beginner
Beginner

Joined: Sun Dec 05, 2004 10:25 am
Posts: 23
what class are u using fro your Driver class in your datasource
Top
 Profile  
 
Uthra
 Post subject:
PostPosted: Thu Jan 12, 2006 11:59 am 
Newbie

Joined: Mon Nov 28, 2005 5:08 pm
Posts: 3
com.ibm.db2.jcc.DB2ConnectionPoolDataSource
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.