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]>
