Hi guys,

I'm facing a problem and don't rly know what I'm doing wrong. Scenario: I got serveral portlets deployed on my jBoss Portal 2.7.0 those are using hibernate to access a DB2 database, there is one servlet which provides a PDF generation this needs access to the database.

I'm managed to look up for the jndi bound Hibernate SessionFactory but sometimes, it doesn't appears evertime I get this exception

I'm not sure if switching my current_session_context_class to jta fix this problem?

17:32:37,059 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
17:33:06,358 ERROR [JDBCExceptionReporter] Connection is not associated with a managed connection.org.jboss.resource.ada
pter.jdbc.jdk5.WrappedConnectionJDK5@11a0267
17:33:06,362 INFO [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.GenericJDBCException: could not load an entity: [de.test.hibernate.P11000#72110]

Maybe someone could give me hand on this? Below are my datasource xml and my hibernate cfg

datasource.xml

<local-tx-datasource>
 <jndi-name>DB2-test</jndi-name>
 <connection-url>jdbc:as400://ip/SCHEMA1;extended dynamic=true;package=jbpkg;package cache=true;package library=jboss;errors=full</connection-url>
 <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
 <user-name>user</user-name>
 <password>pw</password>
 <min-pool-size>1</min-pool-size>
 <check-valid-connection-sql>SELECT current date FROM sysibm.sysdummy1 </check-valid-connection-sql>

 <metadata>
 <type-mapping>DB2/400</type-mapping>
 </metadata>

 </local-tx-datasource>

hibernate.cfg.xml

<hibernate-configuration>
 <session-factory name="java:GmDb2SessionFactory">

 <property name="hibernate.connection.driver_class">com.ibm.as400.access.AS400JDBCDriver</property>

 <property name="hibernate.connection.datasource">java:comp/env/jdbc/DB2-test</property>
 <property name="hibernate.connection.autocommit">false</property>
 <property name="hibernate.default_schema">MISDTA</property>
 <property name="hibernate.dialect">org.hibernate.dialect.DB2400Dialect</property>
 <property name="hibernate.connection.charset">UTF-8</property>
 <property name="hibernate.current_session_context_class">thread</property>
 <property name="hibernate.show_sql">false</property>
 <property name="hibernate.cache.provider_class">net.sf.ehcache.hibernate.EhCacheProvider</property>
 <property name="hibernate.cache.use_query_cache">true</property>
 <property name="hibernate.connection.release_mode ">after_statement</property>
<mapping resource="..." />
 </session-factory>
</hibernate-configuration>

Thanks in advance