Hi there, I'm running the pet store 1.0 via a connection
pool setup in WL 6.0 using JDriver and the OCI oracle
driver in WL 6.0
I've noticed that if I leave the connection pool sitting
over night and come back in the morning to access the
app I get the following
com.sun.estore.control.GeneralFailureException
- with nested exception:
[java.sql.SQLException: ORA-12571: TNS:packet writer failure]
at
com.sun.estore.catalog.model.CatalogImpl.getCategory(CatalogImpl.ja
:43)
at
jsp_servlet._productcategory._jspService(_productcategory.java:111)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStub
pl.java:213)
at
weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDisp
cherImpl.java:272)
at
weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDisp
cherImpl.java:183)
at com.sun.estore.taglib.InsertTag.doEndTag(InsertTag.java:67)
I cannot get a connection until I reset the connection
pool.
I was wondering do folks have their pools setup to
retest the connection validity? If so which table
are you hitting dual?
Clearly this looks like some kind of typical stale connection issue wtih my
connection pool.
I post to this list because I'm sure there's folk in here that have setup
Petstore with Oracle 8i.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
