A pointer, just in case someone run in the same issue.
Connection returned by WAS pool implements com.ibm.ejs.cm.proxy.OracleConnectionProxy, which in turns extends from
com.ibm.ejs.cm.proxy.ConnectionProxy. ConnectionProxy class has a method getPhysicalConnection(), which returns a Connection extending from OracleConnection which performs nicely with connected components.
Hope it can be helpful for someone else,
regards and thanks,
Adolfo.
From: Kris Schneider <[EMAIL PROTECTED]>
Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
To: Struts Users Mailing List <[EMAIL PROTECTED]>
Subject: Re: [OT] WAS Connection Pool
Date: Tue, 15 Oct 2002 14:27:32 -0400
All you can do with WLS is define the driver class. You can't define a data
source class to replace the one it uses internally. As for creating and binding
an instance of OracleConnectionCacheImpl, here are the basic steps:
OracleConnectionPoolDataSource ds =
new OracleConnectionPoolDataSource();
OracleConnectionCacheImpl cache =
new OracleConnectionCacheImpl(ds);
Context ctx = new InitialContext();
ctx.bind("jdbc/myDS", cache);
Of course, you'll need to configure the ds and cache objects appropriately.
Once the cache object is bound, you should be able to do the usual:
DataSource myDS = (DataSource)ctx.lookup("jdbc/myDS");
Connection conn = myDS.getConnection();
The difference is that you'll really be handed back Oracle implementation
classes instead of the app server's.
Quoting Adolfo Miguelez <[EMAIL PROTECTED]>:
> Firsly, thanks for your response:
>
> Yeah, I knew the issue appears also for WL. I have seem the problem quite
> complained in the web, but no the solution.
>
> Probably I will need to write and read.
>
> My employer want to use a pool managed by WAS itself. Preferably WAS pool,
> but it seems not possible. Is it possible to configure a different pool for
>
> WAS? e.g. Oracle pool? Have you tried it for WL?
>
> Any pointer to some way to proceed would be kindly appreciated. Absolutely
> lost, how to bind the OracleConnectionCacheImpl to JNDI and configure it, if
>
> possible, to WAS.
>
> Adolfo.
>
> >From: Kris Schneider <[EMAIL PROTECTED]>
> >Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
> >To: Struts Users Mailing List <[EMAIL PROTECTED]>
> >Subject: Re: [OT] WAS Connection Pool
> >Date: Tue, 15 Oct 2002 11:48:37 -0400
> >
> >If it works anything like WLS, you'll get an instance of a class that
> >implements Connection, but it won't be an instance of OracleConnection.
> >
> >Adolfo, do you want to read or write the structs/arrays?
> >
> >For reading, you should be able to use java.sql.SQLData to generically
> >handle
> >data retrieval. For writing, you may have to couple a bit more closely
> with
> >Oracle-specific classes. Oracle has a tool called JPublisher that can
> >generate
> >Java classes from SQL objects, collection types (e.g. varray), and PL/SQL
> >packages. It might be worth checking out, but it may tie you directly to
> an
> >Oracle-specific solution. That's not always a big issue, but just something
>
> >to
> >be aware of.
> >
> >Another option is to just create and configure an instance of
> >OracleConnectionCacheImpl within your app, bind it as a JNDI resource, and
>
> >just
> >use that as your connection pool.
> >
> >Quoting David Graham <[EMAIL PROTECTED]>:
> >
> > > What database driver class are you using? It seems like you should be
> >able
> > >
> > > to tell WAS to use the oracle db driver which would return
> > > OracleConnections.
> > >
> > > Dave
> > >
> > >
> > > >From: "Adolfo Miguelez" <[EMAIL PROTECTED]>
> > > >Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
> > > >To: [EMAIL PROTECTED]
> > > >Subject: RE: How to use datasource and db connection pooling in
> struts?
> > > >Date: Tue, 15 Oct 2002 14:58:46 +0000
> > > >
> > > >
> > > >Taking advantage of this thread. Has any of you had the experience of
> >using
> > >
> > > >a connection provided by the Websphere pool to handle connected
> >components,
> > >
> > > >i.e. Struct or ARRAY in Oracle.
> > > >
> > > >We are getting a ClassCastException since driver attempts to cast the
> > > >connection to an OracleConnection, and WAS pool provided connection
> >does
> > > >not implement OracleConnection since is a connection provided by IBM
> > > >classes. Any workaround? We are stuck with this issue.
> > > >
> > > >If you ask to IBM support they probably response you to use DB2 so not
> > > >really helpful. Any experience?
> > > >
> > > >TIA,
> > > >
> > > >Adolfo.
> > > >
> > > >>From: "Hajratwala, Nayan (N.)" <[EMAIL PROTECTED]>
> > > >>Reply-To: "Struts Users Mailing List"
> <[EMAIL PROTECTED]>
> > > >>To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]>
> > > >>Subject: RE: How to use datasource and db connection pooling in
> >struts?
> > > >>Date: Tue, 15 Oct 2002 10:42:13 -0400
> > > >>
> > > >>you can use commons-dbcp ... see
> > > >>http://jakarta.apache.org/commons/dbcp.html
> > > >>
> > > >>---
> > > >>- Nayan Hajratwala
> > > >>- Chikli Consulting LLC
> > > >>- http://www.chikli.com
> > > >>
> > > >>
> > > >>-----Original Message-----
> > > >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > >>Sent: Tuesday, October 15, 2002 10:40 AM
> > > >>To: [EMAIL PROTECTED]
> > > >>Subject: How to use datasource and db connection pooling in struts?
> > > >>
> > > >>
> > > >>Hi, there!
> > > >>
> > > >>How can I easily achieve database connection pooling (using a
> >datasource
> > > >>in one of the xml config files - btw. which one is it?)?
> > > >>I know there is some stuff in jakarta-commons.
> > > >>What I want to achieve is an easy to configure and highly efficient
> db
> > > >>connection pool that is available to all my action classes.
> > > >>
> > > >>Stef.
> > > >>
> > > >>--
> > > >>To unsubscribe, e-mail:
> > > >><mailto:[EMAIL PROTECTED]>
> > > >>For additional commands, e-mail:
> > > >><mailto:[EMAIL PROTECTED]>
> > > >>
> > > >>--
> > > >>To unsubscribe, e-mail:
> > > >><mailto:[EMAIL PROTECTED]>
> > > >>For additional commands, e-mail:
> > > >><mailto:[EMAIL PROTECTED]>
> > > >
> > > >
> > > >
> > > >
> > > >_________________________________________________________________
> > > >MSN Photos is the easiest way to share and print your photos:
> > > >http://photos.msn.com/support/worldwide.aspx
> > > >
> > > >
> > > >--
> > > >To unsubscribe, e-mail:
> > > ><mailto:[EMAIL PROTECTED]>
> > > >For additional commands, e-mail:
> > > ><mailto:[EMAIL PROTECTED]>
> > >
> > >
> > >
> > >
> > > _________________________________________________________________
> > > MSN Photos is the easiest way to share and print your photos:
> > > http://photos.msn.com/support/worldwide.aspx
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > > <mailto:[EMAIL PROTECTED]>
> > > For additional commands, e-mail:
> > > <mailto:[EMAIL PROTECTED]>
> > >
> > >
> >
> >
> >--
> >Kris Schneider <mailto:[EMAIL PROTECTED]>
> >D.O.Tech <http://www.dotech.com/>
> >
> >--
> >To unsubscribe, e-mail:
> ><mailto:[EMAIL PROTECTED]>
> >For additional commands, e-mail:
> ><mailto:[EMAIL PROTECTED]>
>
>
>
>
> <HTML>
> <HEAD>
> <TITLE>Adolfo's signature</TITLE>
> </HEAD>
> <BODY>
> <center><b><em>Adolfo Rodriguez Miguelez</em><b></center>
>
> </BODY>
> </HTML>
>
>
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
>
--
Kris Schneider <mailto:[EMAIL PROTECTED]>
D.O.Tech <http://www.dotech.com/>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
