Loosing Oracle connection

[subich]

Hi all, I have a problem with my application.
I use WLS 8.1, Spring, Oracle 8i, Hibernate.

My problem is that after a long time my application loose his database connection and give an exception. I use the local configuration for my datasource.
this is the stack trace

<27-août-2004 10 h 52 min 02 s CEST> <Error> <HTTP> <s-sj-dell06> <radon> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<WLS Kernel>> <> <BEA-101020> <[ServletContext(id=22321742,name=wtold,context-path=/wtold)] Servlet failed with Exception
org.springframework.jdbc.UncategorizedSQLException : (Hibernate operation): encountered SQLException [Connexion interrompue]; nested exception is java.sql.SQLException: Connexion interrompue
java.sql.SQLException: Connexion interrompue
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:269)
at oracle.jdbc.driver.OracleConnection.privatePrepare Statement(OracleConnection.java:945)
at oracle.jdbc.driver.OracleConnection.prepareStateme nt(OracleConnection.java:852)
at net.sf.hibernate.impl.BatcherImpl.getPreparedState ment(BatcherImpl.java:257)
at net.sf.hibernate.impl.BatcherImpl.getPreparedState ment(BatcherImpl.java:232)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStat ement(BatcherImpl.java:65)
at net.sf.hibernate.loader.Loader.prepareQueryStateme nt(Loader.java:779)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java :265)
at net.sf.hibernate.loader.Loader.doQueryAndInitializ eNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.j ava:911)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.j ava:931)
at net.sf.hibernate.loader.EntityLoader.load(EntityLo ader.java:59)
at net.sf.hibernate.loader.EntityLoader.load(EntityLo ader.java:51)
at net.sf.hibernate.persister.EntityPersister.load(En tityPersister.java:419)
at net.sf.hibernate.impl.SessionImpl.doLoad(SessionIm pl.java:2117)
at net.sf.hibernate.impl.SessionImpl.doLoadByClass(Se ssionImpl.java:1991)
at net.sf.hibernate.impl.SessionImpl.load(SessionImpl .java:1920)
at org.springframework.orm.hibernate.HibernateTemplat e$3.doInHibernate(HibernateTemplate.java:224)
at org.springframework.orm.hibernate.HibernateTemplat e.execute(HibernateTemplate.java:176)
at org.springframework.orm.hibernate.HibernateTemplat e.load(HibernateTemplate.java:222)
at org.ec.sj.wtold.dao.hibernate.PanelHibernateDao.ge tPanelById(PanelHibernateDao.java:23)
at org.ec.sj.wtold.service.WtoFacadeImpl.getPanelById (WtoFacadeImpl.java:57)
at org.ec.sj.wtold.controller.WtoldAppController.hand leRequest(WtoldAppController.java:37)
at org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter.handle(SimpleControllerHandlerAda pter.java:45)
at org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:485)
at org.springframework.web.servlet.FrameworkServlet.s ervice(FrameworkServlet.java:322)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run(ServletStubImpl.java:971)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:402)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:305)
at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :6350)
at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppServletContext.java:3635)
at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestImpl.java:2585)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)

I use the getHibernateTemplate() to obtain my properties and hibernate session.
I think it's a configuration problem with my bean or transaction.
So if someone can help me, it will so good

thanks in advance
kind regards

[subich]

Ok I found the problem... it was caused by a db server reboot
I work for a big service and I don't know that database was backup during the night and the server was shutting down.