  | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
  | | | -none- | -none- 2007-09-05 - By David Smith
Back Add a validationQuery attribute to your <Resource ... /> definition with a very basic query like "select 1". That'll test your connections on borrow and re-create them as necessary.
--David
Alper Sar? wrote: > Dear All, > > We have configured a portal system on Linux. In our system we uses > connection pooling to connect to different databases. One of them is > Oracle 9i. We have a problem with reconnection to the database. > When the database restart tomcat can't establish connection to them or > don't try to connect. > > Our configuration is like below; > > *System: *Linux RH AS 3 > > *Servlet container:* Tomcat 5.5.23 > > *Oracle driver jar name is:* ojdbc14.jar* > * > *Contex:* > > <Context> > <WatchedResource>WEB-INF/web.xml</WatchedResource> > <Resource name="jdbc/sabanci_portlet" username="xx" password="yy" > driverClassName="oracle.jdbc.OracleDriver" > url="jdbcracle:thin:@(protected):99:xyz" auth="Container" > type="javax.sql.DataSource" maxActive="100" maxIdle="30" > maxWait="10000" /> > </Context> > > *Catalina log:* > > No more data to read from socket > FROM 'service.hr.rehberbilgilerim.RehberBilgilerimList. java' in > getCalisanBilgilerim > No more data to read from socket > FROM 'service.hr.leave.LeaveList.java' in getLeaveYear > Sep 2, 2007 11:21:18 AM org.apache.catalina.core.ApplicationDispatcher > invoke > SEVERE: Servlet.service() for servlet jsp threw exception > java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 > > What do you think the problem is? > > Thank you very much > > Alper SARI > Sabanci University > > > >
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ To start a new topic, e-mail: users@(protected) To unsubscribe, e-mail: users-unsubscribe@(protected) For additional commands, e-mail: users-help@(protected)
|
|
 |