Announcement Announcement Module
Collapse
No announcement yet.
Loosing Oracle connection Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Loosing Oracle connection

    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

  • #2
    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.

    Comment

    Working...
    X