Where is the not connected to oracle? If your application looks the data
source in JNDI and asks for a new connection you keep getting not connected?
Have you kept trying to connect for a while?
I do seem to remember people complaining about timeouts in the Oracle JDBC
driver (are you using their latest Type 4 one?) so I am not surprised. I
would think that the connections in the pool may have timed out, but that
once you exhaust them (not sure how to do that because the pool needs to
know they are bad, but perhaps just executing sql on them does that) you
should get good connections out of the pool. Does this work?
Cheers
-----Original Message-----
From: Budi Prawira [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 8:18 PM
To: JRun-Talk
Subject: RE: Oracle connection lost every morning.....
> What do you mean by "...it has lost its connection to the
> Oracle database
> server?"
in the morning we always get 'not connected to oracle'. the application
worked fine the previous night. so we always need to restart jrun.
thx,
Budi
(jacky's colleague)
> -----Original Message-----
> From: Jacky Soeryana [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 8:53 AM
> To: JRun-Talk
> Subject: Oracle connection lost every morning.....
>
>
> Dear all,
>
> Every morning we have to restart JRun server because it has lost its
> connection to the Oracle database server. I don't have any
> database shutdown
> during the night.
>
> I am implementing the Oracle connection pooling by using this class
> oracle.jdbc.pool.OracleConnectionCacheImpl.
> My datasource is bound to InitialContext.
>
> My guess is probably because it is the connections pool, so
> when there is no
> connection request anymore it frees up the resources and close the
> connection.
>
> So is there any other reason why the database connectivity is lost?
>
>
> Kindly share your solution.
>
>
> Regards,
> Jacky
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
