Re: Question about persistent connection

Yes it will remain open. We're facing this problem right now with connections to MSSQL7. The Apache processes die (for a number of reasons), but the connections remain open 'sleeping' on the SQL7 side. At some point our connections fill up and we can't connect any more. There doesn't seem to be a way to kill the sleeping processes programmatically - we can either do it by hand from the console, or stop/start the server. MySQL has a variable you can set to close 'dead' connections after a certain amount of time - I think the default is 8 hours (!?!) Does Oracle have anything like that? You might want to set it to a couple minutes - any processes that die and leave an open connection should get taken care of this way then. Radu Filip wrote: > Hi! After I read about persistent connections, I still have a big > question: > > Supposing I have a website powered by a database (Oracle in my case). > First time a user visit my page, I open a connection to database. Then, I > preserve the connection opened passing connection descriptor using > sessions. When use logout, I close the connection. The qeustion is: if > user suddenly close the browser, will my connection remain opened (since > code that close it is not executed)? > > Could someone provide me (or tell me where I could find) a simple example > about persistent database connections? > > Thx, > Radu > > -- > Radu Filip > Network Administrator @CCTI | tuiasi.ro > radu@tuiasi.ro ccti@tuiasi.ro > http://socrate.tuiasi.ro/ u�u > 0o�����e�)��http://www.ccti.tuiasi.ro/ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- ========================== Michael Kimsal http://www.tapinternet.com 734-480-9961