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
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
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
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
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
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'
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
>
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
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
>
cc:
Subject: RE: db connection pool
question
21-01-03 09:43
Please resp
> 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,
sers Mailing List
> <[EMAIL PROTECTED]>
> hoo.com> cc:
>
>
>
> Subject: RE: db connection pool question
>
> 21-
d.us> Subject: RE: db connection pool
question
Thorsten Schäfer
<[EMAIL PROTECTED]>
cc:
21-01-03 09:13 Subject: R
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
> cc:
Subject: RE: db connection pool
question
21-01-03 09
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
> >
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
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
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
david chan
<[EMAIL PROTECTED]>
Subject: Re: db connection pool
question
21-01-03 07:19
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
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
please look at the thread with subject "Problem with JDBC & Struts
Connection Pool (possible to recon nect?)". Matt Raible had a solution to
that by setting autoReconnect=true
-Original Message-
From: david chan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 9:56 AM
To: Struts
24 matches
Mail list logo