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:@db.sabanciuniv.edu: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@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
