• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Tomcat, db access & connection pool

 
Ranch Hand
Posts: 489
Eclipse IDE Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I am facing a strange issue with connection pooling using commons dbcp in a production environment.

This is the issue - one particular query returns an


SQLException No more data to read from socket,


after 10-15 minutes of startup. This query loads data for one page and that page blanks out after 10-15 minutes. All other pages (that are loaded by other queries) work just fine.

1. This is the only query that uses a join. All other queries in the application are simple selects.

2. Here's my context xml file


<Context path="/healthcheck" useNaming = "true" workDir="e:/healthcheck/work">
<Resource name="jdbc/healthcheck" auth="Container" type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver" url="url ortnumber:sid"
username="user" password="pwd" maxActive="25" maxIdle="15" maxWait="-1"/>
<Manager className="org.apache.catalina.session.StandardManager" pathname=""/>
</Contet>



3. The db is Oracle 8i. However I am using an ojbdc14.jar as the driver package. Is that a probable cause ?

4. A google search had the below to say


This error most likely occurs in applications that use a database connections pool. When the application checked out a connection that has been timed out or has been staled, and used it to connect to the database, this error occurs.



5. And finally, the worst part - it wokrs for me on my development box (both linux and windows), but then the db I connect to is 9i.

I am at wits end since I dont have access to the production db and dont know where to begin.

Any help will be greatly appreciated.

Thanks,
Ram.
 
Thanks tiny ad, for helping me escape the terrible comfort of this chair.
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic