Here is why:
>javap oracle.jdbc.OracleConnection | grep oracle
public interface oracle.jdbc.OracleConnection extends java.sql.Connection{
public abstract void registerTAFCallback(oracle.jdbc.OracleOCIFailover=
=2C java
.lang.Object) throws java.sql.SQLException=3B
public abstract oracle.jdbc.OracleConnection unwrap()=3B
public abstract void setWrapper(oracle.jdbc.OracleConnection)=3B
public abstract oracle.jdbc.internal.OracleConnection physicalConnectio=
nWith
in()=3B
public abstract oracle.jdbc.OracleSavepoint oracleSetSavepoint() =
throw
s java.sql.SQLException=3B
public abstract oracle.jdbc.OracleSavepoint oracleSetSavepoint(java.lan=
g.Str
ing) throws java.sql.SQLException=3B
public abstract void oracleRollback(oracle.jdbc.OracleSavepoint) =
throw
s java.sql.SQLException=3B
public abstract void oracleReleaseSavepoint(oracle.jdbc.OracleSavepoint=
)
throws java.sql.SQLException=3B
public abstract void registerConnectionCacheCallback(oracle.jdbc.pool.O=
racle
ConnectionCacheCallback=2C java.lang.Object=2C int) throws java.sql.S=
QLException=3B i agree..stick with OracleConnection for Oracle...all else u=
se java.sql.Connection
Martin=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.Ce message est confidentiel et=
peut =EAtre privil=E9gi=E9. Si vous n'=EAtes pas le destinataire pr=E9vu=
=2C nous te demandons avec bont=E9 que pour satisfaire informez l'exp=E9dit=
eur. N'importe quelle diffusion non autoris=E9e ou la copie de ceci est int=
erdite. Ce message sert =E0 l'information seulement et n'aura pas n'importe=
quel effet l=E9galement obligatoire. =C9tant donn=E9 que les email peuvent=
facilement =EAtre sujets =E0 la manipulation=2C nous ne pouvons accepter a=
ucune responsabilit=E9 pour le contenu fourni.
> From: jason.perrone@blueskytech.com
> To: users@tomcat.apache.org
> Date: Fri=2C 2 Dec 2011 14:39:11 -0600
> Subject: RE: Casting a Connection as an OracleConnection in Tomcat 7
>=20
> I might be able to do it as an SQL statement instead of using this driver=
method...=20
>=20
>=20
> -----Original Message-----
> From: Christopher Schultz [mailto:chris@christopherschultz.net]=20
> Sent: Friday=2C December 02=2C 2011 3:29 PM
> To: Tomcat Users List
> Subject: Re: Casting a Connection as an OracleConnection in Tomcat 7
>=20
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>=20
> Jason=2C
>=20
> On 12/2/11 3:23 PM=2C Jason Perrone wrote:
> > So=2C I can't cast the connection Tomcat returns as a=20
> > DelegatingConnection. DelegatingConnection is from Commons DBCP and=20
> > this connection is org.apache.tomcat.dbcp.dbcp.PoolableConnection. I=20
> > do not want to reference any Tomcat libraries directly because our=20
> > product is container agnostic. Any suggestions would be greatly=20
> > appreciated.
>=20
> Two thoughts:
>=20
> 1. Use reflection =3B)
>=20
> 2. Stop trying to cast to OracleConnection
>=20
> What do you need OracleConnection for=2C anyway?
>=20
> - -chris
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
> Comment: GPGTools - http://gpgtools.org
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>=20
> iEYEARECAAYFAk7ZNSgACgkQ9CaO5/Lv0PA8iACeIyzpkgEx7B49HKcx7ZquASYK
> UXEAnRAL4dcEPFENnatgp0WSJ+rQXMAN
> =3DAWRl
> -----END PGP SIGNATURE-----
>=20
> ---------------------------------------------------------------------
> To unsubscribe=2C e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands=2C e-mail: users-help@tomcat.apache.org
>=20
=
|