Re: Apache::DBI - Can two different connection handles have the same reference/address at different times?

[Jonathan Vanasco <suppressed>]

On May 7, 2007, at 10:40 PM, Foo JH wrote:

> My suspicion is that when you do a disconnect, the connection is  
> actually not released. That's the idea of connection pooling isn't it?
>
> You can confirm this by checking the number of connections stated  
> on your sql server after a call.

Apache::DBI overload disconnect, so you never really disconnect.

Apache::DBI caches based on EXACT connection params.  its not just  
the same host/db -- its the entirety of connection options  
( raiseerror , autocommit, etc )

so to answer your question:

	use Apache::DBI ;
	$db1= connect( A );
	$db2= connect( A );

will both use the same handle.

	use Apache::DBI ;
	$db1= connect( A );
	$db2= connect( A,B );

will both use different handles


// Jonathan Vanasco

| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - - - - -
| SyndiClick.com
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - - - - -
|      FindMeOn.com - The cure for Multiple Web Personality Disorder
|      Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - - - - -
|      RoadSound.com - Tools For Bands, Stuff For Fans
|      Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - - - - -