Re: [Proxool-developer] Driver specific interfaces

[<chr...@em...>]

Oh.
I might have been a bit naive to the usability of this :(

A quick check on interface based JDBC implementations:
SQLServer: No
Sybase: Yes
postgreSQL: Yes
MySQL: No
DB2: No

...and then you have Oracle. Here the confusion is complete, with 
definitions changing from version to version from class to interface 
etc. In some versions interfaces from the "internal" package is used, in 
some versions not.

We should certantly NOT deprecate DriverManager.getConnection and friends.

I am very uncertain wether this stuff is going to add value or 
confusion. Please consider this again.

By the way; your example below won't work with the Oracle driver we use 
(8.1.7.0.4).

OracleConnection is a class there...

CHR



Bill Horsman wrote:

>Hi all,
>
>Just an update for everyone. Following Bertrand's recommendation, I've
>changed the ProxyFactory so that when we proxy a connection or a
>statement we also implement the same public interfaces as the original
>object. The upshot of this is that you can now do:
>
>  Connection c = DriverManager.getConnection(url, properties);
>  OracleConnection oc = (OracleConnection) c;
>
>This means we can probably deprecate the old
>ProxoolFacade.getDelegateConnection and getDelegateStatement methods. I
>say "probably" because the new proxy solution only works for interfaces.
>All well written drivers should be written to interfaces but if anyone
>is using a connection object that provides public methods that aren't
>declared in an interface then they won't be accessible. I'm tempted to
>live with that limitation.
>
>Remember, exposing the delegate connection is a weakness since it allows
>people to close the delegate instead of the proxy thereby not returning
>it to the pool.
>
>All this is uncommitted at the moment. Committing very soon.
>
>- Bill
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: IBM Linux Tutorials
>Free Linux tutorial presented by Daniel Robbins, President and CEO of
>GenToo technologies. Learn everything from fundamentals to system
>administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
>_______________________________________________
>Proxool-developer mailing list
>Pro...@li...
>https://lists.sourceforge.net/lists/listinfo/proxool-developer
>
>  
>