I had a similar problem but it wasn't for a servlet.
If this is the type 4 driver supplied by Oracle, it seems to only handle 50
uses per connection and then the connection blows up!
A use(age) is one transaction or query. Are you creating a new connection
per request or are you reusing the connection between service calls?
If your using a connection pool or wrinting one yourself, I suggest you set
the usages per connection to 50 for this particular driver so that after 50
it will recycle the connection. Try using another Oracle driver supplied
by a different vendor, this worked for me. I recomend type 2 or 3 drivers.
Good luck.
At 12:07 PM 5/27/99 -0400, you wrote:
>
>We are using the JDBCTHIN client to connect to an Oracle
>database from a servlet. We are having a high occurance of
>dropped connections. I was wondering if anyone else had a
>problem with losing connections to Databases.
>
>Thank you,
>Dan
>
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
