.
>
> Agreed.
>
>> It's also strange that this only happens sporadically, and not
>> every time a new connection is being "birthed" by the system.
>
>> We've tried two different pooling technologies: DBCP and the new
>> Apache JDBC pooli
> From: Christopher Schultz [mailto:ch...@christopherschultz.net]
> Sent: Tuesday, January 13, 2015 1:05 PM
> To: Tomcat Users List
> Subject: Re: Occasional long wait for a JDBC connection
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA256
>
> Darren,
>
>
ing "birthed" by the system.
>
> We've tried two different pooling technologies: DBCP and the new
> Apache JDBC pooling on this server and both exhibit the same 15
> minute occasional wait.
The problem is with the driver and/or database, not with the
connection
f a validation query,
to each connection sitting idle in the pool.
- set maxAge to something less than the limit set by the firewall. If
using Tomcat's jdbc-pool (not sure if this is supported by other pools), it
will throw out connections older than this value (in ms).
- reconfigure you
this only happens sporadically, and not every time a
new connection is being "birthed" by the system.
We've tried two different pooling technologies: DBCP and the new Apache
JDBC pooling on this server and both exhibit the same 15 minute occasional
wait.
we've come across docum
On Tue, Jan 13, 2015 at 9:51 AM, Darren Davis
wrote:
> Recently we deployed our production application on a Tomcat 8.0.14 web
> server. We are using the Tomcat JDBC Connection pool against MySQL 5. Our
> web application uses Spring (3.2.11.RELEASE) /Hibernate (3.6.10.Final) for
>
Recently we deployed our production application on a Tomcat 8.0.14 web
server. We are using the Tomcat JDBC Connection pool against MySQL 5. Our
web application uses Spring (3.2.11.RELEASE) /Hibernate (3.6.10.Final) for
transaction management. We are using a Cent OS 6 linux server in the cloud
the
original validator. It’s a bit unintuitive to use the validator like that, but
I’m glad to have it working ☺
Thanks for your responses!
From: Filip Hanik [mailto:fi...@hanik.com]
Sent: woensdag 3 december 2014 19:47
To: Tomcat Users List
Cc: Iris Hupkens
Subject: Re: Tomcat JDBC connection pool
You should be able to run init SQL commands yourself in your custom
validator
https://tomcat.apache.org/tomcat-7.0-doc/api/org/apache/tomcat/jdbc/pool/Validator.html
On Wed, Dec 3, 2014 at 11:42 AM, Wes Clark wrote:
> These actions seems to incorrectly conflated in the code. I'd a
g'
Subject: Tomcat JDBC connection pool: Using initSql together with
validatorClassName
Hello,
I am using the Tomcat JDBC connection pool (version 7.0.55) as a stand-alone
library. The connection pool is configured with a custom validator class in
order to use the JDBC4 isValid method
Hello,
I am using the Tomcat JDBC connection pool (version 7.0.55) as a stand-alone
library. The connection pool is configured with a custom validator class in
order to use the JDBC4 isValid method for connection validation. I would also
like to use initSql to perform some preparation on all
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Christian,
On 11/28/14 7:57 AM, Christian wrote:
> reading tomcat 8.x documentation, I don't find anything about
> tomcat-dbcp. The use of tomcat-jdbc is described at [1]. Some of
> the disadvantages just apply for DBCP 1.x.
Hi,
reading tomcat 8.x documentation, I don't find anything about tomcat-dbcp. The
use of tomcat-jdbc is described at [1].
Some of the disadvantages just apply for DBCP 1.x.
Is the use of tomcat-jdbc still recommended compared to the repackaged DBCP 2.x
in tomcat-dbcp package?
Re
net/ipv4/tcp_fin_timeoutecho 15 >
> > /proc/sys/net/ipv4/tcp_fin_timeout
> >
> >
> > On Wed, Nov 5, 2014 at 7:36 AM, Daniel Mikusa
> wrote:
> >
> > > On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta
> > > wrote:
> > >
> > > >
On 6 November 2014 05:36, Vasily Kukhta wrote:
> I have received additional details - the application starts getting
> "java.sql.SQLException: Listener refused the connection with the following
> error: ORA-12519, TNS:no appropriate service handler found", although the
> amount of listeners in the
/tcp_fin_timeout
>
>
> On Wed, Nov 5, 2014 at 7:36 AM, Daniel Mikusa wrote:
>
> > On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta
> > wrote:
> >
> > > Hello all!
> > >
> > > I have developed an application using Tomcat JDBC pool. Eve
014 at 7:36 AM, Daniel Mikusa wrote:
> On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta
> wrote:
>
> > Hello all!
> >
> > I have developed an application using Tomcat JDBC pool. Everything is
> fine
> > except that the pool leaves hundreds of TCP connections in T
On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta wrote:
> Hello all!
>
> I have developed an application using Tomcat JDBC pool. Everything is fine
> except that the pool leaves hundreds of TCP connections in TIME_WAIT state,
>
I have to ask, but are you sure it's the pool? TC
Hello all!
I have developed an application using Tomcat JDBC pool. Everything is fine
except that the pool leaves hundreds of TCP connections in TIME_WAIT state,
which kills the server sooner or later... Could you please suggest what to
fix, my configuration is below:
PoolProperties
he current
potential for having the same stuff in both.
Thanks again
Vince
> -Original Message-
> From: Daniel Mikusa [mailto:dmik...@pivotal.io]
> Sent: 29 October 2014 17:10
> To: Tomcat Users List
> Subject: Re: NameNotFoundException: Name [jdbc/weblogin01b] is not
> b
On Wed, Oct 29, 2014 at 12:45 PM, wrote:
> Hello
> I'm having difficulty getting a JDBC DataSource using Tomcat 8.
>
> I want to define the JDBC details in server.xml so the database identified
> depends on the server and not the application. It will be beneficial for me
&
Hello
I'm having difficulty getting a JDBC DataSource using Tomcat 8.
I want to define the JDBC details in server.xml so the database identified
depends on the server and not the application. It will be beneficial for me if
the applications only need to know the JDBC name and not pas
Thanks, Neven.
It turns out the PostgreSQL JDBC driver does not implement the
setCatalog method, so this option is not available to me. However, I
went ahead and set up my own cache of connection pools (dataSource
instances) in a HashMap, and configured Jersey to persist this across
web
Thanks, Chris. To answer your suggestion first, differing
username/password didn't come into play, because I found that the
PostgreSQL JDBC driver does not implement the setCatalog method to
change databases on the fly in the first place. (Apparently this is
optional for JDBC d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Ric,
On 10/26/14 2:31 PM, Ric Bernat wrote:
> Thanks, Nevin. I certainly appreciate your deep treatment of my
> question/issue!
>
> I would like to ask for clarification about a point in your #2:
>
>> (2) CONTAINER-MANAGED CONNECTION POOL. (a) usi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Neven,
On 10/26/14 6:28 PM, Neven Cvetkovic wrote:
> Hey Ric,
>
> Here's another thing you could do:
> http://stackoverflow.com/questions/7195556/how-to-manage-connections-to-dynamically-created-databases
>
> If your databases are all on the same
Hey Ric,
Here's another thing you could do:
http://stackoverflow.com/questions/7195556/how-to-manage-connections-to-dynamically-created-databases
If your databases are all on the same db instance, but different
schema/database name, you could avoid connecting to the specific database
name, but ra
Thanks, Nevin. I certainly appreciate your deep treatment of my question/issue!
I would like to ask for clarification about a point in your #2:
> (2) CONTAINER-MANAGED CONNECTION POOL.
> (a) using container injection
>
> @Resource(name="")
> private DataSource datasource
>
> (b) tradition
om tomcat-pool):
http://people.apache.org/~schultz/ApacheCon%20NA%202014/Monitoring%20Apache%20Tomcat%20with%20JMX.pdf
Hope that helps,
- -chris
[1] http://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html#JMX
-BEGIN PGP SIGNATURE-
Version: GnuPG v1
Comme
cation). See more details here:
http://tomcat.apache.org/tomcat-7.0-doc/config/resources.html
On Tomcat, this is now implemented by Tomcat JDBC Connection Pool (
http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html) and has replaced
the older traditional Apache Commons DBCP project (
http://commons.
not sure that I
would be able to create JNDI declarations for just-created databases on the fly.
Ric
-Original Message-
From: Konstantin Kolinko [mailto:knst.koli...@gmail.com]
Sent: Saturday, October 25, 2014 3:25 PM
To: Tomcat Users List
Subject: Re: Tomcat 7 JDBC Connection Pool -
2014-10-26 1:49 GMT+04:00 Ric Bernat :
>> There is no such method to be called like on the above line.
>> "DataSource(PoolConfiguration)" is a constructor. To call a constructor you
>> need the keyword "new".
>
> My bad: I copied some code around and dropped the "new." You are quite right:
> I am
Saturday, October 25, 2014 1:44 PM
To: Tomcat Users List
Subject: Re: Tomcat 7 JDBC Connection Pool - question about usage from Java
code
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/25/2014 12:12 PM, Ric Bernat wrote:
> I am using Tomcat 7.0.53, and I am using Tomcat JDBC connection
urday, October 25, 2014 2:14 PM
To: Tomcat Users List
Subject: Re: Tomcat 7 JDBC Connection Pool - question about usage from Java code
2014-10-25 23:12 GMT+04:00 Ric Bernat :
> I am using Tomcat 7.0.53, and I am using Tomcat JDBC connection
> pooling to connect to multiple PostgreSQL (9.3) da
2014-10-25 23:12 GMT+04:00 Ric Bernat :
> I am using Tomcat 7.0.53, and I am using Tomcat JDBC connection pooling to
> connect to multiple PostgreSQL (9.3) databases. My application is a JAX-RS
> (Jersey) web server application that provides a set RESTful web services (no
> UI). My dat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/25/2014 12:12 PM, Ric Bernat wrote:
> I am using Tomcat 7.0.53, and I am using Tomcat JDBC connection
> pooling to connect to multiple PostgreSQL (9.3) databases. My
> application is a JAX-RS (Jersey) web server application that
> pr
I am using Tomcat 7.0.53, and I am using Tomcat JDBC connection pooling
to connect to multiple PostgreSQL (9.3) databases. My application is a
JAX-RS (Jersey) web server application that provides a set RESTful web
services (no UI). My data layer uses the Spring JdbcTemplate library.
First
On Fri, Oct 10, 2014 at 9:51 AM, Vasily Kukhta wrote:
> Hi friends,
>
> I have a question regarding the ability of Tomcat JDBC pool to reconnect
> automatically to a database in case of temporarily network failures.
>
> I'm developing a high-load application which uses
Hi friends,
I have a question regarding the ability of Tomcat JDBC pool to reconnect
automatically to a database in case of temporarily network failures.
I'm developing a high-load application which uses Oracle 11g database. It
may happen that the DB can become unavailable for several mi
> >
> > > -BEGIN PGP SIGNED MESSAGE-
> > > Hash: SHA256
> > >
> > > Todd,
> > >
> > > On 9/23/14 11:41 AM, Todd Chapman wrote:
> > > > My application uses the Tomcat JDBC pool. While using net
p 24, 2014 at 9:36 AM, Christopher Schultz <
> ch...@christopherschultz.net> wrote:
>
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA256
> >
> > Todd,
> >
> > On 9/23/14 11:41 AM, Todd Chapman wrote:
> > > My application uses the Tomcat JDBC pool. While using n
:36 AM, Christopher Schultz <
ch...@christopherschultz.net> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA256
>
> Todd,
>
> On 9/23/14 11:41 AM, Todd Chapman wrote:
> > My application uses the Tomcat JDBC pool. While using netstat and
> > tcpdump to di
uses the Tomcat JDBC pool. While using netstat and tcpdump
> to diagnose connection problems I noticed that the client side occasionally
> closes a DB connection and opens a new one. That is unexpected based on my
> configuration.
>
> poolProperties.setInitialSize(10);
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Todd,
On 9/23/14 11:41 AM, Todd Chapman wrote:
> My application uses the Tomcat JDBC pool. While using netstat and
> tcpdump to diagnose connection problems I noticed that the client
> side occasionally closes a DB connection and opens
Hi,
My application uses the Tomcat JDBC pool. While using netstat and tcpdump
to diagnose connection problems I noticed that the client side occasionally
closes a DB connection and opens a new one. That is unexpected based on my
configuration.
poolProperties.setInitialSize(10
> Next, you'd have to switch to tomcat-pool because commons-dbcp (the
> default CP in Tomcat) does not support obtaining pooled connections
> with credentials.
>
> Next, you remove the database name from the JDBC URL (or maybe change
> it to something everyone can access, like the
want to mark the
>>> connection for death is when a rollback fails with an
>>> exception. An example of this kind of error is a network
>>> error.
>>
>> Won't this happen automatically? If the network connection dies,
>> the server should auto-r
is a network error.
>
>Won't this happen automatically? If the network connection dies, the
>server should auto-rollback the transaction. The JDBC connection will
>fail due to the same reason and the pool will re-establish a new
>Connection. Are you sure you have to manage this yourse
;t this happen automatically? If the network connection dies, the
server should auto-rollback the transaction. The JDBC connection will
fail due to the same reason and the pool will re-establish a new
Connection. Are you sure you have to manage this yourself?
> We do this with:
>
to:ch...@christopherschultz.net]
Sent: Tuesday, August 12, 2014 8:28 PM
To: Tomcat Users List
Subject: Re: Question on Tomcat JDBC Connection Pool
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Wes,
On 8/12/14, 5:26 PM, Wes Clark wrote:
> (If the answer differs between Tomcat 7 and Tomcat 8, please not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Wes,
On 8/12/14, 5:26 PM, Wes Clark wrote:
> (If the answer differs between Tomcat 7 and Tomcat 8, please note
> that.)
>
> When a SQL exception occurs, often the database connection will be
> broken and should be evicted from the pool.
I'm inte
(If the answer differs between Tomcat 7 and Tomcat 8, please note that.)
When a SQL exception occurs, often the database connection will be broken and
should be evicted from the pool. In our code, we call this "marking the
connection for death". We do this because we don't want to set the
"te
lix.schumac...@internetallee.de]
Sent: Tuesday, July 22, 2014 11:07 PM
To: Tomcat Users List
Subject: Re: Tomcat JDBC Connection Pool initialization question
On 23. Juli 2014 01:20:27 MESZ, Wes Clark wrote:
>I want to initialized a new connection being added to the pool with
>more than
close() on the driver connection, if that yields an exception
if another thread is executing a query or not, depends on the driver itself.
See
http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html
On Wed, Jul 23, 2014 at 10:56 AM, Vasily Kukhta
wrote:
> So, it means that if the timeout is
on where the timeout occurs.
>
> If the timeout is triggered by the driver, because you hit the
> setQueryTimeout limit
>
> http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#setQueryTimeout(int)
> then yes, as per javadoc, it is up to the JDBC driver to throw an
>
Vasily, the exception depends on where the timeout occurs.
If the timeout is triggered by the driver, because you hit the
setQueryTimeout limit
http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#setQueryTimeout(int)
then yes, as per javadoc, it is up to the JDBC driver to throw an
all in that situation?
Than you!
2014-07-21 20:40 GMT+04:00 Daniel Mikusa :
> On Mon, Jul 21, 2014 at 11:05 AM, Vasily Kukhta
> wrote:
>
> > Hello, dear tomcat users!
> >
> > I am developing high-load application using tomcat jdbc connection pool
> and
> > O
On 23. Juli 2014 01:20:27 MESZ, Wes Clark wrote:
>I want to initialized a new connection being added to the pool with
>more than one SQL statement. I cannot see how to override the existing
>methods to do this. Has anyone done this, or have a suggestion for me?
Have you tried to separate them
I want to initialized a new connection being added to the pool with more than
one SQL statement. I cannot see how to override the existing methods to do
this. Has anyone done this, or have a suggestion for me?
cking all my
> application. To simulate long-running queries I have put the DB in
> QUIESCE state using ALTER SYSTEM QUIESCE RESTRICTED statement.
It's important to note that nothing in the JDBC driver will prevent a
/series/ of queries from taking more than 3 seconds. For example:
On Mon, Jul 21, 2014 at 11:05 AM, Vasily Kukhta
wrote:
> Hello, dear tomcat users!
>
> I am developing high-load application using tomcat jdbc connection pool and
> Oracle database. It is very important to ensure my app to have very small
> DB query timeouts (no longer than 3 seco
Hello, dear tomcat users!
I am developing high-load application using tomcat jdbc connection pool and
Oracle database. It is very important to ensure my app to have very small
DB query timeouts (no longer than 3 seconds) to prevent long-running
queries or database slowness from blocking all my
>
> On 6/19/14, 9:42 AM, Miroslav Nachev wrote:
> > Is it possible to configure JDBC-Pool for the following
> > functionality or I need to write my own interceptors and
> > Validator?
> >
> > - Retry N times to getConnection() for OnBorrow/OnConnect and
> >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Miro,
On 6/19/14, 9:42 AM, Miroslav Nachev wrote:
> Is it possible to configure JDBC-Pool for the following
> functionality or I need to write my own interceptors and
> Validator?
>
> - Retry N times to getConnection() for OnBorro
Hi All,
Is it possible to configure JDBC-Pool for the following functionality or I
need to write my own interceptors and Validator?
- Retry N times to getConnection() for OnBorrow/OnConnect and WhileIdle;
- Wait X ms between each Retry.
Are there any examples?
Regards,
Miro.
ary XA boiler plate, and
> > then calls XAConnection.getConnection() to get the
> > java.sql.Connection object that will be used for all of the
> > standard JDBC calls. If the application is using a connection pool,
> > then I think XAConnection.getConnection should NOT return t
t that will be used for all of the
> standard JDBC calls. If the application is using a connection pool,
> then I think XAConnection.getConnection should NOT return the
> physical connection, but a handle that when closed will return the
> connection to the pool.
That's clearly
XAConnection from an
XADataSource, it does all of the necessary XA boiler plate, and then calls
XAConnection.getConnection() to get the java.sql.Connection object that will be
used for all of the standard JDBC calls. If the application is using a
connection pool, then I think XAConnection.getConnection
> From: Christopher Schultz [mailto:ch...@christopherschultz.net]
> Subject: Re: PooledConnection.getConnection - Tomcat JDBC Pool
> On 3/25/14, 10:53 AM, Pierce, Jonathan D wrote:
> > In the Aries class, the expectation is that
> > XAConnection.getConnection().cl
, here.
> The reason I'm using the library outside of Tomcat is because I
> need a connection pooling library, and I'm running in an OSGi
> environment (not a Java Servlet Container). I came across
> tomcat-jdbc and after reading the documentation and doing some
> research i
I've created Bug 56310 for this issue.
Jonathan
-Original Message-
From: Pierce, Jonathan D
Sent: Tuesday, March 25, 2014 10:54 AM
To: Tomcat Users List
Subject: RE: PooledConnection.getConnection - Tomcat JDBC Pool
In the Aries class, the expectation is that
XAConnection.getConne
I'm using the library outside of Tomcat is because I need a
connection pooling library, and I'm running in an OSGi environment (not a Java
Servlet Container).
I came across tomcat-jdbc and after reading the documentation and doing some
research it seemed like an improved drop in re
>
>
Jonathan, Filip,
If it is a bug then my answer is way off the mark. I'm sorry. If it's not a
problem, could you explain, in this case, what acts as the connection pool
manager when the Tomcat jdbc pool library is used outside of Tomcat?
Best,
John
ing to use the tomcat jdbc pool library (outside of tomcat)
> along with the Apache Aries Transaction library in an OSGi environment
> to handle distributed transactions.
>
> One of the classes (XADataSourceEnlistingWrapper) provided by the
> Aries Transaction wrappers library is a
> If that is the case the tomcat jdbc
> pooling library handling the call incorrectly and its a bug.
>
I'd be suspect of this. Are you actually using *org.apache.tomcat.jdbc.pool*?
Since it's a Tomcat module it seems an odd choice to use outside of Tomcat.
http://docs.oracl
I am trying to use the tomcat jdbc pool library (outside of tomcat)
along with the Apache Aries Transaction library in an OSGi environment
to handle distributed transactions.
One of the classes (XADataSourceEnlistingWrapper) provided by the
Aries Transaction wrappers library is a DataSource
On Fri, Mar 7, 2014 at 11:21 AM, Christopher Schultz <
ch...@christopherschultz.net> wrote:
>
> Neven,
>
> On 3/5/14, 8:25 PM, Neven Cvetkovic wrote:
> > On Wed, Mar 5, 2014 at 3:15 PM, S Ahmed
> >>
> > Ahmed, thanks for asking this question - it is sometimes very
> > confusing with all different
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Martin,
On 3/6/14, 7:53 AM, Martin Gainty wrote:
>
>
>
>
>> From: neven.cvetko...@gmail.com Date: Wed, 5 Mar 2014 20:25:36
>> -0500 Subject: Re: understanding jdbc pool To:
>> users@tomcat.apache.org
>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Neven,
On 3/5/14, 8:25 PM, Neven Cvetkovic wrote:
> On Wed, Mar 5, 2014 at 3:15 PM, S Ahmed
> wrote:
>
>> Hi,
>>
>> With jdbc pool, is each socket connection in the pool handled by
>> a separate thread?
>&g
> From: neven.cvetko...@gmail.com
> Date: Wed, 5 Mar 2014 20:25:36 -0500
> Subject: Re: understanding jdbc pool
> To: users@tomcat.apache.org
>
> On Wed, Mar 5, 2014 at 3:15 PM, S Ahmed wrote:
>
> > Hi,
> >
> > With jdbc pool, is each socket conne
On Wed, Mar 5, 2014 at 3:15 PM, S Ahmed wrote:
> Hi,
>
> With jdbc pool, is each socket connection in the pool handled by a separate
> thread?
>
>
Ahmed, thanks for asking this question - it is sometimes very confusing
with all different kind of pools: connection pools
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Ahmed,
On 3/5/14, 3:15 PM, S Ahmed wrote:
> With jdbc pool, is each socket connection in the pool handled by a
> separate thread?
Why would a JDBC connection need a thread?
> Say you have 20 connections set to be open at minimum, does th
Hi,
With jdbc pool, is each socket connection in the pool handled by a separate
thread?
Say you have 20 connections set to be open at minimum, does that mean there
will be 20 threads? If not, then there is a degree of serialization then
right?
NDI entries here
>> https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howto.html
>>
>>
>>
You will notice there are two ways to configure your resource in Tomcat
>> container:
>>
>> (a) a global resource, so every deployed application will have
>> acc
ies here
> https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howto.html
>
> You will notice there are two ways to configure your resource in Tomcat
> container:
>
> (a) a global resource, so every deployed application will have access to
> the s
On Tue, Mar 4, 2014 at 2:56 PM, Charles Richard <
charle...@thelearningbar.com> wrote:
> On Tue, Mar 4, 2014 at 3:17 PM, Christopher Schultz <
> ch...@christopherschultz.net> wrote:
> > Can we still use Hibernate in our Spring application if we
> > > configure the Data Source through a context.xm
bet you have a WEB-INF directory directly
in your webapps/ directory, right?
We've got a WEB-INF folder in our appBase folder reference
(/ourpath/WEB-INF).
Sounds like you've got a mess on your hands.
I guess.
Move that into META-INF/context.xml, remove the
"docBase
have a element at all in your server.xml.
> It's a wonder that your application even works with a path of ""
> and a docBase of "". I'll bet you have a WEB-INF directory directly
> in your webapps/ directory, right?
>
>
>
>
> We
7;ve got a WEB-INF folder in our appBase folder reference
> (/ourpath/WEB-INF).
>
> Sounds like you've got a mess on your hands.
>
I guess.
>
> Move that into META-INF/context.xml, remove the "docBase"
> and "path" attributes, and then add a as a chil
e the "docBase"
and "path" attributes, and then add a as a child to
configure your DataSource. You'll also need to move your JDBC driver
from WEB-INF/lib into Tomcat's lib/ directory.
- -chris
-BEGIN PGP SIGNATURE-
Version: GnuPG v1
Comment: GPGTools - http:
:
Thanks,
Charles
On Tue, Mar 4, 2014 at 2:57 PM, Christopher Schultz <
ch...@christopherschultz.net> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA256
>
> Charles,
>
> On 3/4/14, 1:03 PM, Charles Richard wrote:
> > Hi,
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Charles,
On 3/4/14, 1:03 PM, Charles Richard wrote:
> Hi,
>
> I am testing the jdbc pool to replace the c3p0 pool we were using
> for our Tomcat connection pool. We are also using Spring 2.0 and
> Hibernate (and Tomcat 6).
>
&g
Hi,
I am testing the jdbc pool to replace the c3p0 pool we were using for our
Tomcat connection pool. We are also using Spring 2.0 and Hibernate (and
Tomcat 6).
When I put this in my hibernate-context.xml, our application is using the
jdbc pool and appears to work
On Mar 3, 2014, at 7:04 PM, Scott Dudley wrote:
>
> I'm using the Tomcat JDBC connection pool on apache-tomcat-7.0.30.
>
> My context xml resource name is as follows:
>
>
> When running under Tomcat, calling ConnectionPool.getName() from my custom
> Jd
I'm using the Tomcat JDBC connection pool on apache-tomcat-7.0.30.
My context xml resource name is as follows:
When running under Tomcat, calling ConnectionPool.getName() from my
custom JdbcInterceptor returns "Tomcat Connection Pool[1-992158371]".
Under JSE (a stand-alone ma
t;> you please clarify.
>
> $ for jar in $CATALINA_HOME/lib/*.jar \
> $PATH_TO_WEBAPP/WEB-INF/lib/*.jar \ ; do echo $jar ; unzip -v $jar
> | grep -i mysql ; done
>
> That ought to find it.
>
> I'm not sure why it would be auto-loaded... JDBC drivers don't
>
ALINA_HOME/lib/*.jar \
> $PATH_TO_WEBAPP/WEB-INF/lib/*.jar \
> ; do echo $jar ; unzip -v $jar | grep -i mysql ; done
>
> That ought to find it.
>
> I'm not sure why it would be auto-loaded... JDBC drivers don't
> auto-load themselves just because the
ment, can you please clarify.
$ for jar in $CATALINA_HOME/lib/*.jar \
$PATH_TO_WEBAPP/WEB-INF/lib/*.jar \
; do echo $jar ; unzip -v $jar | grep -i mysql ; done
That ought to find it.
I'm not sure why it would be auto-loaded... JDBC drivers don't
auto-load themselves just
Leo,
On 27.1.2014 18:17, Leo Medina wrote:
Can you please elaborate more as to what you meant by: "com.mysql.jdbc.Driver
must be present in one of your webapps. I'd expect
it to be in a JAR that has mysql in the name. If you don't need it remove
it." I meant that we don't have a mysql db. in
:24, Leo Medina wrote:
> > It's been a while since I installed tomcat and having some jdbc errors
> with
> > version 6.0.20.
>
> Time to upgrade.
>
> > We don't have a mysql.jdbc.driver
>
> com.mysql.jdbc.Driver must be present in one of your webapps. I&#x
301 - 400 of 1690 matches
Mail list logo
