Connection pooling reconnect problem

[Alper Sarı <al...@sabanciuniv.edu>]

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

Re: Connection pooling reconnect problem

[David Smith <dn...@cornell.edu>]

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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org