hi,all

i am using hibernate in stateless session bean running in jboss-3.2.1_tomcat-4.1.24. It works very well however jboss always reports the following error :

08:45:37,983 INFO [CachedConnectionManager] Successfully closed a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@1ea25aa
java.lang.Exception: Stack Trace
at org.jboss.resource.connectionmanager.CachedConnectionManager.closeAll
(CachedConnectionManager.java:376)
at org.jboss.resource.connectionmanager.CachedConnectionManager.popMetaA
wareObject(CachedConnectionManager.java:199)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo
ke(CachedConnectionInterceptor.java:190)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Stat
elessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte
rceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep
torCMT.java:243)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:1
04)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.
java:117)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFacto
ryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessi
onContainer.java:322)
at org.jboss.ejb.Container.invoke(Container.java:674)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
nDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.jav
a:83)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.
java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:4
5)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessi
onInterceptor.java:100)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy37.getDeviceByLocation(Unknown Source)
at com.omnet.web.DeviceServlet.doGet(DeviceServlet.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
at com.omnet.web.SetEncodingFilter.doFilter(SetEncodingFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:256)

i have posted it before but got no answer :(


any suggestion is appreciated !

hi,sir

donot you encounter such a question ? jboss reports it at intervals :(

what should i do to clear it ?


thanks in advance !

Most likely you are either:
1) Calling one session bean from another; or
2) Not closing the Hibernate session prior to leaving the session bean

If #1, there is supposedly a way to configure JBoss to ignore this. But I don't use jboss and don't begin to understand why it reports this let alone how to perform the config. Here is a thread in which this is dicussed:http://forum.hibernate.org/viewtopic.php?p=504 Another option here would be to make sure that the session has a connection prior to making nested ejb call (the session lazily gets the jdbc connection only when its actually needed).

If #2, close the session.

thanks for your answer first.Here is our architecture:

servlet-------->SLSB---------->hibernate------------>MySQL


up to now the session beans donot call each other.The code snippet is as below:

public String getDevClass(String id) throws OMException
{
StringWriter result = new StringWriter();
Session sess = null;
try {
sess = sf.openSession();
Marshaller marshaller = new Marshaller(result);

com.omnet.bean.DevClass dc = (com.omnet.bean.DevClass)sess.load(com.omnet.bean.DevClass.class,
new Integer(id)
);
marshaller.marshal(dc);
sess.close(); //close it before return from any methods
}
catch(Exception e) {
throw new OMException(e);
}
return result.toString();
}

the SessionFactory is gotten as bebow:

public void setSessionContext(SessionContext sessionContext)
{
this.sessionContext = sessionContext;

Context ctx = null;
try {
ctx = new InitialContext();
sf = (SessionFactory) ctx.lookup("java:/hibernate/HibernateFactory");
}
catch (NamingException ex) {
ex.printStackTrace();
}
}

regards!

Two things:

1) If an excption were to occurr in this processing, the sess.close() call would never occur. Move this to a finally block. In that situation, it would cause JBoss to complain because you opened a JDBC connection during execution of this session bean which you then did not close.



2) What does constructor for Marshaller do?


Did you even try what was suggested in the post I pain-stakingly looked up for you?

ok, i will add finally block and hope jboss will not complain



Marshaller marshaller = new Marshaller(result);

Marshaller, which is from castor, is used to create xml data from java bean.The constructor does nothing but acccept a StringWriter used to write the xml result. After finishing marshalling i can get the xml from result.toString() call.


Of course !


thanks again ![/quote]