=oracle.jdbc.driver.OracleDriver
Thanks,
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 Struts Connection Pool
you have
Users Mailing List'
Cc: Immel, Richard
Subject: RE: db connection pool question [solved]
Using the following in my DBCP Connection Pool solved my problem:
parameter
namedriverClassName/name
valueoracle.jdbc.pool.OracleConnectionPoolDataSource/value
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 question.
I'll try adding the validationQuery parameter
();
}
}
-Original Message-
From: Raible, Matt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 10:18 AM
To: 'Struts Users Mailing List'
Subject: RE: db connection pool question
After waiting 24 hours, I'm still experiencing the same
problem with Oracle
and a connection pool (DBCP
-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'm still experiencing the same
problem with Oracle and a connection pool (DBCP) in Tomcat
: 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. Otherwise your connection pool will contain only stale
connections after
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 tricky about setting up a datasource in struts-config for
deployment
-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'
Subject: RE: db connection pool question
It's
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
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
dc
valueSELECT 'CRAP' FROM DUAL/value
/parameter
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 with subject Problem
: david chan
[EMAIL PROTECTED]
Subject: Re: db connection pool
question
21-01-03 07:19
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's connection
pool. It will
do this in the background. We have several
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 dual is the standard way to ping oracle for a valid
connection. I would also recommend using Oracle's connection pool. It will
do
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 the
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
select 1 from dual is the standard way to ping
oracle for a valid
connection. I would also recommend using Oracle's
Users Mailing List
[EMAIL PROTECTED]
hoo.com cc:
Subject: 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 in
'
chaefer.de [EMAIL PROTECTED]
cc:
21-01-03 09:13Subject: RE: db connection pool
question
Subject: RE: db connection pool
question
21-01-03 09:34
:
Subject: RE: db connection pool question
21-01-03 09:13
Please respond
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, but I
:
Subject: RE: db connection pool
question
21-01-03 09:43
23 matches
Mail list logo