Re: [Proxool-developer] Driver specific interfaces

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

Bill Horsman wrote:

>CHR,
>
>On Wed, 2004-03-24 at 09:44, Christian Nedreg=E5rd wrote:
>
> =20
>
>>A quick check on interface based JDBC implementations:
>>SQLServer: No
>>Sybase: Yes
>>postgreSQL: Yes
>>MySQL: No
>>DB2: No
>>   =20
>>
>
>What does that mean? A "no" means that the driver doesn't implement any
>driver specific interfaces?
>
> =20
>

It means that the implementations of Connection, Statement etc. does not=20
implement any vendor spesific interfaces.

>>...and then you have Oracle. Here the confusion is complete
>>   =20
>>
>
>Sounds par for the course.
>
> =20
>

Eh? You've reached the borders of my understanding of English mate ;)

>>We should certantly NOT deprecate DriverManager.getConnection and
>>friends.=20
>>   =20
>>
>
>Eh? How can we deprecate a JDK method? I'm confused.=20
>
>
> =20
>

Sorry. I meant ProxoolFacade.getDelegateConnection().

>>I am very uncertain wether this stuff is going to add value or
>>confusion. Please consider this again
>>   =20
>>
>
>It won't do any harm. If a public interface for the object is available
>it will be used. If it isn't then it behaves like it did before.
>
> =20
>
>>By the way; your example below won't work with the Oracle driver we
>>use (8.1.7.0.4).=20
>>OracleConnection is a class there...
>>   =20
>>
>
>Hmm. Well that's a shame. But just to be clear, it will "work" in as
>much as Proxool will behave itself. It just means that the cast won't
>work and you'll have to use ProxoolFacade.getDelegateConnection(). Which
>is probably what you meant.
> =20
>

It means that the cast might work when you are using one version of the=20
Oracle driver, and then break when you change driver version, wich will=20
be extremely confusing to the user.

>In summary: I think that exposing the public interfaces is still a good
>idea. It won't be as useful as I originally thought because not all
>drivers use public interfaces, but it's certainly a step forwards.
>
>
> =20
>

It's flabby (something that might work with a particular driver version=20
from a few of the vendors). I don't like flabby, but I won't veto this=20
either.

CHR

>
>-------------------------------------------------------
>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_id638&op=3Dclick
>_______________________________________________
>Proxool-developer mailing list
>Pro...@li...
>https://lists.sourceforge.net/lists/listinfo/proxool-developer
>
> =20
>