struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adolfo Miguelez" <pell...@hotmail.com>
Subject Re: [OT] WAS Connection Pool
Date Tue, 15 Oct 2002 16:21:24 GMT
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 <kris@dotech.com>
>Reply-To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
>To: Struts Users Mailing List <struts-user@jakarta.apache.org>
>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 <dgraham1980@hotmail.com>:
>
> > 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" <pelly69@hotmail.com>
> > >Reply-To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
> > >To: struts-user@jakarta.apache.org
> > >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.)" <nhajratw@ford.com>
> > >>Reply-To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
> > >>To: "'Struts Users Mailing List'" <struts-user@jakarta.apache.org>
> > >>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: Stefan.Landro@swisscom.com [mailto:Stefan.Landro@swisscom.com]
> > >>Sent: Tuesday, October 15, 2002 10:40 AM
> > >>To: struts-user@jakarta.apache.org
> > >>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:struts-user-unsubscribe@jakarta.apache.org>
> > >>For additional commands, e-mail:
> > >><mailto:struts-user-help@jakarta.apache.org>
> > >>
> > >>--
> > >>To unsubscribe, e-mail:
> > >><mailto:struts-user-unsubscribe@jakarta.apache.org>
> > >>For additional commands, e-mail:
> > >><mailto:struts-user-help@jakarta.apache.org>
> > >
> > >
> > >
> > >
> > >_________________________________________________________________
> > >MSN Photos is the easiest way to share and print your photos:
> > >http://photos.msn.com/support/worldwide.aspx
> > >
> > >
> > >--
> > >To unsubscribe, e-mail:
> > ><mailto:struts-user-unsubscribe@jakarta.apache.org>
> > >For additional commands, e-mail:
> > ><mailto:struts-user-help@jakarta.apache.org>
> >
> >
> >
> >
> > _________________________________________________________________
> > MSN Photos is the easiest way to share and print your photos:
> > http://photos.msn.com/support/worldwide.aspx
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <mailto:struts-user-unsubscribe@jakarta.apache.org>
> > For additional commands, e-mail:
> > <mailto:struts-user-help@jakarta.apache.org>
> >
> >
>
>
>--
>Kris Schneider <mailto:kris@dotech.com>
>D.O.Tech       <http://www.dotech.com/>
>
>--
>To unsubscribe, e-mail:   
><mailto:struts-user-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: 
><mailto:struts-user-help@jakarta.apache.org>




<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:struts-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:struts-user-help@jakarta.apache.org>


Mime
View raw message