Results 1 to 2 of 2
  1. #1
    swwetb is offline Member
    Join Date
    Jan 2013
    Posts
    1
    Rep Power
    0

    Default WARN : 19:22:25 - SQL Error: 17143, SQLState: null

    Not sure why I am seeing this error occasionally. I copied it below.
    Thanks.

    WARN : 19:22:25 - SQL Error: 17143, SQLState: null
    ERROR : 19:22:25 - Connection validation failed : ORA-02396: exceeded maximum idle time,
    please connect again

    ERROR : 19:22:25 - (cdsar.dataobjects.entityobjects.ClsEntCtrlcard:61 )
    Cannot open connection
    org.hibernate.exception.GenericJDBCException: Cannot open connection
    at org.hibernate.exception.SQLStateConverter.handledN onSpecificException(SQLState
    Converter.java:126)
    at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:114)
    at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:6
    6)
    at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:5
    2)
    at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:449
    )
    at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:167)

    at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:142)
    at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:85)
    at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1354)
    at cdsar.dataobjects.entityobjects.AbstractEntityDao. select(AbstractEntityDao.jav
    a:48)
    at cdsar.dataobjects.ClsDataObjectCtrlcard.findRecord S2TCtrlcard2eci140(ClsDataOb
    jectCtrlcard.java:213)
    at cdsar.businessobjects.ClsbussProcessObjEci140.getC ontrolCard(ClsbussProcessObj
    Eci140.java:908)
    at cdsar.businessobjects.ClsbussProcessObjEci140.rele aseEnrollmentHoldseci140(Cls
    bussProcessObjEci140.java:518)
    at cdsar.businessobjects.ClsbussProcessObjEci140.proc essForReleasingEnrollmentHol
    dseci140(ClsbussProcessObjEci140.java:469)
    at cdsar.businessobjects.ClsbussProcessObjEci140.exec ute(ClsbussProcessObjEci140.
    java:443)
    at cdsar.servlets.RunBatch.executeBusinessProcess(Run Batch.java:64)
    at cdsar.servlets.RunBatch.doPost(RunBatch.java:47)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:763)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
    at com.evermind.server.http.ServletRequestDispatcher. invoke(ServletRequestDispatc
    her.java:713)
    at com.evermind.server.http.ServletRequestDispatcher. forwardInternal(ServletReque
    stDispatcher.java:370)
    at com.evermind.server.http.HttpRequestHandler.doProc essRequest(HttpRequestHandle
    r.java:871)
    at com.evermind.server.http.HttpRequestHandler.proces sRequest(HttpRequestHandler.
    java:453)
    at com.evermind.server.http.HttpRequestHandler.serveO neRequest(HttpRequestHandler
    .java:221)
    at com.evermind.server.http.HttpRequestHandler.run(Ht tpRequestHandler.java:122)
    at com.evermind.server.http.HttpRequestHandler.run(Ht tpRequestHandler.java:111)
    at oracle.oc4j.network.ServerSocketReadHandler$SafeRu nnable.run(ServerSocketReadH
    andler.java:260)
    at oracle.oc4j.network.ServerSocketAcceptHandler.proc ClientSocket(ServerSocketAcc
    eptHandler.java:234)
    at oracle.oc4j.network.ServerSocketAcceptHandler.acce ss$700(ServerSocketAcceptHan
    dler.java:29)
    at oracle.oc4j.network.ServerSocketAcceptHandler$Acce ptHandlerHorse.run(ServerSoc
    ketAcceptHandler.java:879)
    at com.evermind.util.ReleasableResourcePooledExecutor $MyWorker.run(ReleasableReso
    urcePooledExecutor.java:298)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: java.sql.SQLException: Connection validation failed : ORA-02396: exceeded maxi
    mum idle time, please connect again

    at oracle.oc4j.sql.spi.ConnectionHandle.throwSQLExcep tion(ConnectionHandle.java:6
    98)
    at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_validate (ConnectionHandle.java:680)
    at oracle.oc4j.sql.spi.OracleConnectionHandle.oc4j_va lidate(OracleConnectionHandl
    e.java:158)
    at oracle.oc4j.sql.ManagedDataSource.getConnection(Ma nagedDataSource.java:281)
    at oracle.oc4j.sql.ManagedDataSource.getConnection(Ma nagedDataSource.java:200)
    at oracle.oc4j.sql.ManagedDataSource.getConnection(Ma nagedDataSource.java:142)
    at oracle.oc4j.sql.ManagedDataSource.getConnection(Ma nagedDataSource.java:127)
    at org.hibernate.connection.DatasourceConnectionProvi der.getConnection(Datasource
    ConnectionProvider.java:92)
    at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:446
    )
    ... 27 more
    Caused by: java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect a
    gain

    at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:138)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:316)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:282)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 639)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:113)
    at oracle.jdbc.driver.T4CStatement.execute_for_descri be(T4CStatement.java:431)
    at oracle.jdbc.driver.OracleStatement.execute_maybe_d escribe(OracleStatement.java
    :1029)
    at oracle.jdbc.driver.T4CStatement.execute_maybe_desc ribe(T4CStatement.java:463)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1
    126)
    at oracle.jdbc.driver.OracleStatement.execute(OracleS tatement.java:1654)
    at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_validate (ConnectionHandle.java:664)
    ... 34 more
    INFO : 19:22:25 - (cdsar.dataobjects.entityobjects.ClsEntCtrlcard:67 )
    Done with select(..., ...)

  2. #2
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,193
    Rep Power
    19

    Default Re: WARN : 19:22:25 - SQL Error: 17143, SQLState: null

    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

Similar Threads

  1. null pointer error help!!
    By fakepics500 in forum New To Java
    Replies: 1
    Last Post: 07-16-2011, 02:57 PM
  2. help with with my null error
    By zhangster in forum New To Java
    Replies: 3
    Last Post: 03-20-2010, 12:32 AM
  3. Null Error
    By scoleman123 in forum New To Java
    Replies: 2
    Last Post: 09-19-2008, 04:04 PM
  4. SQL Error: 1064, SQLState: 42000
    By 82rathi.angara in forum JDBC
    Replies: 1
    Last Post: 06-14-2008, 06:56 PM
  5. Replies: 3
    Last Post: 08-01-2007, 04:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •