-Original Message-
From: Jose María Zaragoza [mailto:demablo...@gmail.com]
Sent: Friday, December 13, 2013 2:33 PM
To: Tomcat Users List
Subject: Re: What if my database is unavailable at startup?
2013/12/13 Dames, Kristopher J kristopher.da...@mercy.net:
With
Barry,
You have testOnBorrow=true without a validation query. That means the
line is useless. Or as the docs say:* NOTE - for a true value to have any
effect, the validationQuery parameter must be set to a non-null string*
Best,
Alec
On Mon, Dec 16, 2013 at 10:07 AM, Propes, Barry L
-Original Message-
From: Tomcat Random [mailto:tomcat.ran...@gmail.com]
Sent: Monday, December 23, 2013 2:56 PM
To: Tomcat Users List
Subject: Re: What if my database is unavailable at startup?
Barry,
You have testOnBorrow=true without a validation query. That means the line is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Barry,
On 12/23/13, 4:14 PM, Propes, Barry L wrote:
-Original Message- From: Tomcat Random
[mailto:tomcat.ran...@gmail.com] Sent: Monday, December 23, 2013
2:56 PM To: Tomcat Users List Subject: Re: What if my database is
unavailable
-Original Message-
From: Howard W. Smith, Jr. [mailto:smithh032...@gmail.com]
Sent: Friday, December 13, 2013 4:23 PM
To: Tomcat Users List
Subject: Re: What if my database is unavailable at startup?
OP,
On Fri, Dec 13, 2013 at 2:24 PM, Dames, Kristopher J
kristopher.da...@mercy.net
On Dec 13, 2013, at 2:24 PM, Dames, Kristopher J kristopher.da...@mercy.net
wrote:
Hi,
I use tomcat 6
Which version specifically?
and have noticed if a database is not available when tomcat starts, tomcat
will not try to connect once the database becomes available. Tomcat must be
Daniel,
I use tomcat 6.0.32. Here is an example Resource tag:
Resource
accessToUnderlyingConnectionAllowed=false
auth=Container
defaultAutoCommit=true
defaultReadOnly=false
defaultSchema=x
driverClassName=oracle.jdbc.driver.OracleDriver
With testOnBorrow=true ( I think that is the default value in Tomcat
6 ) + validationQuery=SELECT 1 FROM DUAL , that should work
I've never used
maxOpenPreparedStatements=0
accessToUnderlyingConnectionAllowed=false
what are they for ?
2013/12/13 Dames, Kristopher J
On Dec 13, 2013, at 2:39 PM, Dames, Kristopher J kristopher.da...@mercy.net
wrote:
Daniel,
When you reply, please include the previous email and don't top post. Post
inline like me or at the bottom. This helps with the readability of this
thread and it's the convention that we follow on
With testOnBorrow=true ( I think that is the default value in Tomcat
6 ) + validationQuery=SELECT 1 FROM DUAL , that should work
So you are saying my configuration should work as-is to allow Tomcat to create
a database connection pool to a database that was unavailable when Tomcat was
2013/12/13 Dames, Kristopher J kristopher.da...@mercy.net:
With testOnBorrow=true ( I think that is the default value in Tomcat
6 ) + validationQuery=SELECT 1 FROM DUAL , that should work
So you are saying my configuration should work as-is to allow Tomcat to
create a database connection
I've never heard of these or seen these attributes either. What are they for?
-Original Message-
From: Jose María Zaragoza [mailto:demablo...@gmail.com]
Sent: Friday, December 13, 2013 2:10 PM
To: Tomcat Users List
Subject: Re: What if my database is unavailable at startup?
With
From: Propes, Barry L [mailto:barry.l.pro...@citi.com]
Subject: RE: What if my database is unavailable at startup?
I've never heard of these or seen these attributes either. What are they for?
maxOpenPreparedStatements=0
accessToUnderlyingConnectionAllowed=false
You could look in the doc:
-Original Message-
From: Dames, Kristopher J [mailto:kristopher.da...@mercy.net]
Sent: Friday, December 13, 2013 1:39 PM
To: Tomcat Users List
Subject: RE: What if my database is unavailable at startup?
Daniel,
I use tomcat 6.0.32. Here is an example Resource tag:
Resource
-Original Message-
From: Caldarale, Charles R [mailto:chuck.caldar...@unisys.com]
Sent: Friday, December 13, 2013 3:59 PM
To: Tomcat Users List
Subject: RE: What if my database is unavailable at startup?
From: Propes, Barry L [mailto:barry.l.pro...@citi.com]
Subject: RE: What if my
OP,
On Fri, Dec 13, 2013 at 2:24 PM, Dames, Kristopher J
kristopher.da...@mercy.net wrote:
I use tomcat 6 and have noticed if a database is not available when tomcat
starts, tomcat will not try to connect once the database becomes available.
Tomcat must be restarted to establish the database
can/should we assume that your URL is referencing a database on a different
machine, same network/intranet/LAN?
url=jdbc:oracle:thin:@x.y.com:1521:x
it seems as though OP is referencing a database somewhere on the 'internet'.
The database server is on the same network,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Dan,
On 12/13/13, 2:29 PM, Daniel Mikusa wrote:
On Dec 13, 2013, at 2:24 PM, Dames, Kristopher J
kristopher.da...@mercy.net wrote:
Hi,
I use tomcat 6
Which version specifically?
and have noticed if a database is not available when
18 matches
Mail list logo