RE: db connection pool question [solved]

23, 2003 11:53 AM To: 'Struts Users Mailing List' Cc: Immel, Richard Subject: RE: db connection pool question [solved] Using the following in my DBCP Connection Pool solved my problem: driverClassName oracle.jdbc.pool.OracleConnectionPoolDataSource

RE: db connection pool question [solved]

nks, Matt > -Original Message- > From: mech [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 22, 2003 12:10 PM > To: 'Struts Users Mailing List' > Subject: RE: db connection pool question > > > I can't tell for Oracle, but for MySQL and the Stru

RE: db connection pool question

es my jdbc-driver to $CATALINA_HOME/common/lib and my-app.xml to $CATALINA_HOME/webapps and tomcat is ready to go! Matt > -Original Message- > From: mech [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 22, 2003 1:33 PM > To: 'Struts Users Mailing List' > Subje

RE: db connection pool question

c and shouldn't be webapp specific. Michael > -Original Message- > From: David Graham [mailto:[EMAIL PROTECTED]] > Sent: Mittwoch, 22. Januar 2003 20:40 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: db connection pool question > > > What is tri

RE: db connection pool question

sers Mailing List'" <[EMAIL PROTECTED]> Subject: RE: db connection pool question Date: Wed, 22 Jan 2003 20:09:55 +0100 I can't tell for Oracle, but for MySQL and the Struts Connection Pool you have to set some kind of "autoReconnect=true" for your connection url setup

RE: db connection pool question

bit tricky for deployment. Michael > -Original Message- > From: Raible, Matt [mailto:[EMAIL PROTECTED]] > Sent: Mittwoch, 22. Januar 2003 17:18 > To: 'Struts Users Mailing List' > Subject: RE: db connection pool question > > > After waiting 24 hours, I'

RE: db connection pool question

System.err.println("Connection attempt failed: " + e.getMessage()); } return pconn.getConnection(); } } > -Original Message- > From: Raible, Matt [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 22, 2003 10:18 AM >

RE: db connection pool question

2 AM > To: 'Struts Users Mailing List' > Subject: RE: db connection pool question > > > Actually, the solution that I had only works for MySQL. I'm > having the same problem with Oracle. Funny - I just posted a > message to the commons-user group asking this same

RE: db connection pool question

initialized"); } return mySelf; } public Connection getConnection () throws SQLException { return ds.getConnection(); } } > -Original Message- > From: Bradley G Smith [mailto:[EMAIL PROTECTED]] > Sent: 21 January 2003 19:17 > To: Struts Users Mailing List >

RE: db connection pool question

cc: Subject: RE: db connection pool question 21-01-03 09:43 Please resp

RE: db connection pool question

> 3) In general, I would like to ask what's the better > pratice to do web application initialization when > using Struts framework. i.e. init datasource, log4j > etc... So that I don't need to customize config for > tomcat, webshpere etc.. I can't claim "better" as I haven't tried anything else,

RE: db connection pool question

sers Mailing List > <[EMAIL PROTECTED]> > hoo.com> cc: > > > > Subject: RE: db connection pool question > > 21-

RE: db connection pool question

d.us> Subject: RE: db connection pool question

RE: db connection pool question

Thorsten Schäfer <[EMAIL PROTECTED]> cc: 21-01-03 09:13 Subject: R

Re: db connection pool question

tnsping sid/servicename ...is the actual way you test for a valid connection. if you can do a select, you already have a connection. >> "select 1 from dual" is the standard way to "ping" oracle for a valid connection. I would also recommend using Oracle's connection pool. It will do this

RE: db connection pool question

> cc: Subject: RE: db connection pool question 21-01-03 09

RE: db connection pool question

gt; > > -Original Message- > > From: Bradley G Smith [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 21, 2003 9:29 AM > > To: Struts Users Mailing List > > Cc: david chan; Struts Users Mailing List > > Subject: Re: db connection pool question > >

RE: db connection pool question

Hi, > I can supply and example struts configuration using Oracle's driver > connection pool driver. Or check the archives for this mailing list, as I > have posted it here. Search using my name or Oracle. Could you please post the example? I tried to search in the mailing lists but I'm getting th

Re: db connection pool question

D]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Cc: "david chan" <[EMAIL PROTECTED]>; "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 9:29 AM Subject: Re: db connection pool question > > "select 1 from d

RE: db connection pool question

M > To: Struts Users Mailing List > Cc: david chan; Struts Users Mailing List > Subject: Re: db connection pool question > > > > "select 1 from dual" is the standard way to "ping" oracle for a valid > connection. I would also recommend using Oracle

Re: db connection pool question

david chan <[EMAIL PROTECTED]> Subject: Re: db connection pool question 21-01-03 07:19

RE: db connection pool question

CRAP' FROM DUAL Thanks, Matt > -Original Message- > From: Pani, Gourav [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 7:58 AM > To: 'Struts Users Mailing List' > Subject: RE: db connection pool question > > > please look at the thread

Re: db connection pool question

On Tuesday, January 21, 2003, 9:56:09 AM, david wrote: dc> Hi, I am using a connection pool from dc> org.apache.commons.dbcp.BasicDataSourceFactory and the driver is dc> oracle.jdbc.driver.OracleDriver. It works great until if the dc> server idle for a few days, then the connection object seems d

RE: db connection pool question

003 9:56 AM To: Struts Users Mailing List Subject: db connection pool question Hi, I am using a connection pool from org.apache.commons.dbcp.BasicDataSourceFactory and the driver is oracle.jdbc.driver.OracleDriver. It works great until if the server idle for a few days, then the connection object see

db connection pool question

Hi, I am using a connection pool from org.apache.commons.dbcp.BasicDataSourceFactory and the driver is oracle.jdbc.driver.OracleDriver. It works great until if the server idle for a few days, then the connection object seems broken with this error: begin error mesg === java.sql.SQLException:

Re: Connection pool question

t; >>Reply-To: Struts Users Mailing List <[EMAIL PROTECTED]> >>To: Struts Users Mailing List <[EMAIL PROTECTED]> >>Subject: RE: Connection pool question >> >>Jan, >> >>Struts, itself, does not (yet?) support JDNI lookups, although the >>Serv

Re: Connection pool question

> which Tomcat 4 does, as does any J2EE app server Well Craig, there where many of us who could not get it running with 4.0x The lookup was null! Some succeeded using 4.1x. Rainer -- To unsubscribe, e-mail: For additional commands, e-mail:

RE: Connection pool question

On Fri, 16 Aug 2002, Robert Taylor wrote: > Date: Fri, 16 Aug 2002 12:27:10 -0400 > From: Robert Taylor <[EMAIL PROTECTED]> > Reply-To: Struts Users Mailing List <[EMAIL PROTECTED]> > To: Struts Users Mailing List <[EMAIL PROTECTED]> > Subject: RE: Connectio

RE: Connection pool question

On Fri, 16 Aug 2002, Robert Taylor wrote: > Date: Fri, 16 Aug 2002 12:12:16 -0400 > From: Robert Taylor <[EMAIL PROTECTED]> > Reply-To: Struts Users Mailing List <[EMAIL PROTECTED]> > To: Struts Users Mailing List <[EMAIL PROTECTED]> > Subject: RE: Connection

Re: Connection pool question

rom: Robert Taylor [mailto:[EMAIL PROTECTED]] >>Sent: Friday, August 16, 2002 12:12 PM >>To: Struts Users Mailing List >>Subject: RE: Connection pool question >> >> >>Jan, >> >>Struts, itself, does not (yet?) support JDNI lookups, although the &

RE: Connection pool question

able to find it in the archives. robert > -Original Message- > From: Robert Taylor [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 16, 2002 12:12 PM > To: Struts Users Mailing List > Subject: RE: Connection pool question > > > Jan, > > Struts, itself, does

RE: Connection pool question

any others on this list know, or it is probably well documented in Tomcat. HTH, robert > -Original Message- > From: Jan Fetyko [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 16, 2002 9:32 AM > To: Struts Users Mailing List > Subject: Re: Connection pool question >

Re: Connection pool question

sed the "best practices way" of using data sources in Struts. You may > want to browser the archives. > > HTH, > > robert > > >>-Original Message- >>From: Howard Miller [mailto:[EMAIL PROTECTED]] >>Sent: Thursday, August 15, 2002 7:3

RE: Connection pool question

I may have answered my own question - if it aint broken don't fix it!! Howard -Original Message- From: Jacob Hookom [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:43 To: 'Struts Users Mailing List' Subject: RE: Connection pool question Well, you can also setu

RE: Connection pool question

- > From: Howard Miller [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 8:40 AM > To: 'Struts Users Mailing List' > Subject: RE: Connection pool question > > > Wow now I finally have to read "Design Patterns" as well!! - sorry > Singletons

RE: Connection pool question

40 AM | To: 'Struts Users Mailing List' | Subject: RE: Connection pool question | | Wow now I finally have to read "Design Patterns" as well!! - sorry | Singletons and suchlike currently over my head - twenty or so years | writing | mostly assembler and Pascal! | | Your

RE: Connection pool question

s Users Mailing List Subject: RE: Connection pool question Okay, but when you get a few cycles, take some time to learn about JNDI and datasources. It's very worth while. An alternative would be to create a single object which manages your connection pools; PoolManager. Give it some sta

RE: Connection pool question

ng List' > Subject: RE: Connection pool question > > > Thanks Robert, > > I must confess I don't get it. I was under the impression that > JNDI was just > an abstraction mechanism for looking up objects in a choice of > directories. > > The information

RE: Connection pool question

looked up in a "controller" database. HM -Original Message- From: Jacob Hookom [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:22 To: 'Struts Users Mailing List' Subject: RE: Connection pool question The main benefit is speed. To initialize a connection, you could

RE: Connection pool question

Jake | -Original Message- | From: Howard Miller [mailto:[EMAIL PROTECTED]] | Sent: Thursday, August 15, 2002 7:04 AM | To: 'Struts Users Mailing List' | Subject: RE: Connection pool question | | Thanks Robert, | | I must confess I don't get it. I was under the impression that

RE: Connection pool question

e too many half learnt technologies on the go!! (Brain melting!!) Regards, -Original Message- From: Robert Taylor [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 12:47 To: Struts Users Mailing List Subject: RE: Connection pool question Standardization: All servlet containers that support

RE: Connection pool question

ot; of using data sources in Struts. You may want to browser the archives. HTH, robert > -Original Message- > From: Howard Miller [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 7:33 AM > To: 'Struts Users Mailing List' > Subject: RE: Connection pool

RE: Connection pool question

ng List > Subject: RE: Connection pool question > > One solution might be to define several datasources in your > application/servlet container where each datasource corresponds to its > respective database. > Then use JNDI to access the datasources from your application. &g

RE: Connection pool question

mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 6:47 AM > To: '[EMAIL PROTECTED]' > Subject: Connection pool question > > Hi, > > Newbie, JDBC connection pool question: > > My application uses a central control database. This is ok, and I ca

Connection pool question

Hi, Newbie, JDBC connection pool question: My application uses a central control database. This is ok, and I can see how to use a connection pool for my application to access this. BUT... The application allows a user to recover data from a range of additional databases. That is the central