You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by David Graham <dg...@hotmail.com> on 2002/10/15 17:02:29 UTC
[OT] WAS Connection Pool
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" <pe...@hotmail.com>
>Reply-To: "Struts Users Mailing List" <st...@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.)" <nh...@ford.com>
>>Reply-To: "Struts Users Mailing List" <st...@jakarta.apache.org>
>>To: "'Struts Users Mailing List'" <st...@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:
>><ma...@jakarta.apache.org>
>>For additional commands, e-mail:
>><ma...@jakarta.apache.org>
>>
>>--
>>To unsubscribe, e-mail:
>><ma...@jakarta.apache.org>
>>For additional commands, e-mail:
>><ma...@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:
><ma...@jakarta.apache.org>
>For additional commands, e-mail:
><ma...@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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: [OT] WAS Connection Pool
Posted by Kris Schneider <kr...@dotech.com>.
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 <dg...@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" <pe...@hotmail.com>
> >Reply-To: "Struts Users Mailing List" <st...@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.)" <nh...@ford.com>
> >>Reply-To: "Struts Users Mailing List" <st...@jakarta.apache.org>
> >>To: "'Struts Users Mailing List'" <st...@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:
> >><ma...@jakarta.apache.org>
> >>For additional commands, e-mail:
> >><ma...@jakarta.apache.org>
> >>
> >>--
> >>To unsubscribe, e-mail:
> >><ma...@jakarta.apache.org>
> >>For additional commands, e-mail:
> >><ma...@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:
> ><ma...@jakarta.apache.org>
> >For additional commands, e-mail:
> ><ma...@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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
--
Kris Schneider <ma...@dotech.com>
D.O.Tech <http://www.dotech.com/>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: [OT] WAS Connection Pool
Posted by Shekhar Jain <sh...@edgesoftinc.com>.
We were experiencing a ClassCastException because we were including the
jdbc2_0-stdext.jar file in our build. IBM support asked us to take that out
and things have worked smoothly since then. If this doesn't fix your problem
you might want to give a little more detail about the error you are getting.
Shekhar
-----Original Message-----
From: David Graham [mailto:dgraham1980@hotmail.com]
Sent: Tuesday, October 15, 2002 8:02 AM
To: struts-user@jakarta.apache.org
Subject: [OT] WAS Connection Pool
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" <pe...@hotmail.com>
>Reply-To: "Struts Users Mailing List" <st...@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.)" <nh...@ford.com>
>>Reply-To: "Struts Users Mailing List" <st...@jakarta.apache.org>
>>To: "'Struts Users Mailing List'" <st...@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:
>><ma...@jakarta.apache.org>
>>For additional commands, e-mail:
>><ma...@jakarta.apache.org>
>>
>>--
>>To unsubscribe, e-mail:
>><ma...@jakarta.apache.org>
>>For additional commands, e-mail:
>><ma...@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:
><ma...@jakarta.apache.org>
>For additional commands, e-mail:
><ma...@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:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>