Re: iPlanet & Oracle connection problem

"C. Marjollet" wrote:

> Hi all,
>
> I have a very strange problem in our application. I use Oracle 8i,
> iPlanet Application Server 6.5, iPlanet Web Server 4.0 and JDBC thin
> driver on the same machine.
>
> Most of the requests go fine, but very few of them fail. In the log
> file of the application, I can see 2 errors which occur when I want to
> open a connection to the server :
> - SQLException - Invalid URL: Driver type not specified
> - SQLException - Exception d'E/S: The Network Adapter could not
> establish the connection
>
> Morever, the client window displays an incomplete html page when the
> error occurs.

Hi. I'm betting this has nothing to do with Oracle's operating mode. My first bet is a non-thread-safe code path, such as a servlet/JSP that uses JDBC objects that are instance or class variables. All JDBC objects used in a servlet etc, should be method-level objects so that multiple threads running the same method get their own objects.
Joe Weinstein at BEA

PS: Of course it could always be the iPlanet stuff. We could help clean that out. ;-)

>
>
> The Oracle Server is running in "Dedicated Mode" and my idea is to
> switch it into "MTS Mode", but I'm to sure it will resole all or part
> the problem.
>
> Could you give me your expert opinions about this ?
> Has anybody ever dealt with this twisted problem ?
>
> Thanks by advance
Received on Tue Feb 25 2003 - 10:28:29 CST