not logged on?

[suresh pulapally]

we developed a web application and deployed successfully,when users are connecting to application some times its showing error(error code is 500).we created connection pool with default values to access database.
the log file which is below shows an error


####<17-May-05 10:14:16 BST> <Error> <HTTP> <btg058145> <btg058145> <ExecuteThread: '8' for queue: 'default'> <kernel identity> <> <101017> <[ServletContext(id=3609626,name=jspsample,context-path=/jspsample)] Root cause of ServletException>

java.sql.SQLException: ORA-01012: not logged on

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1892)
at oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Protocol.java:955)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2659)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2832)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at weblogic.jdbc.pool.PreparedStatement.executeQuery(PreparedStatement.java:53)
at com.mbt.HeaderControl.doPost(HeaderControl.java:84)
at com.mbt.HeaderControl.doGet(HeaderControl.java:31)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1075)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:418)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:306)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5517)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:685)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3156)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2506)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:234)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:210)

[changed subject from "hi gurus," to something more descriptive]
[ May 16, 2005: Message edited by: Jeanne Boyarsky ]

[Shailesh Chandra]

It seems you are using reference of a connection that is closed by database.

make sure that you are dealing properly with connections in your Connection Pool

Shailesh

[Shailesh Chandra]

Just for clarification...

since you are using weblogic so are you using weblogic's connection pool or you have created your own

Shailesh

[suresh pulapally]

thanks,
we are using weblogic connection pool.

[Shailesh Chandra]

Are you caching connection somewhere in your code ?


Suresh : Just an advice that use reasonable subject for you your posts, It is observed most of your post start with subject 'hi gurus' which would even make difficult for you if you want to have look on your previous posts
recently bear has changed the subject of your post in JSP forum


Shailesh
[ May 16, 2005: Message edited by: Shailesh Chandra ]