You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by "Hildebrand, Nils, 232" <Ni...@bamf.bund.de> on 2010/11/24 17:06:39 UTC
[dbcp] Trying to replace Tomcat 5.5 dbcp with original dbcp
Hi,
I am trying to track down a problem propably related to DBCP 1.3.
For details see https://issues.apache.org/bugzilla/show_bug.cgi?id=50326
To get further I need to replace dbcp 1.3 - as supplied with Tomcat
5.5.30 or 5.5.31 with the original.
I a first step I would like to upgrade to dbcp 1.4 if then my error
still persists, I will donwgrade to dbcp 1.2.x if then the error is gone
I will open a bug report for dbcp.
Is there a short howto how to accomplish the task of exchanging the
Tomcat dbcp with a different version?
>From what I until now know I presume:
- change conf/server.xml DB-Resource-Secation factory attribute
- put some jar-files into common/lib (which ones?)
- perhaps delete some tomcat-included dbcp-files (which ones?)
Somewhere I read something about some security settings, too that will
have to be changed to allow access to the new jars (where and how)?
Kind regards
Nils
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org
Re: [dbcp] Trying to replace Tomcat 5.5 dbcp with original dbcp
Posted by Mark Thomas <ma...@apache.org>.
On 26/11/2010 08:59, Hildebrand, Nils, 232 wrote:
> I did the upgrade to 1.4 (and to
> commons-pool-1.5.5) -
> and as you suspeced - the error remains.
>
>>> Is there a short howto how to accomplish the task of exchanging the
>>> Tomcat dbcp with a different version?
>> Not that I recall. Plenty of places for you to create one
>> (Tomcat wiki, Commons wiki) once you have the steps figured out.
>
> What about the DBCP-FAQ?
> How can I add the procedure to it?
http://wiki.apache.org/commons/DBCP
It is a wiki so you can create an account and start editing. I'd suggest
a new page for this procedure linked from the FAQ.
> Now the next step is a downgrade to dbcp 1.2.x - do I have to downgrade
> commons-pool for that step, too?
You should be fine with pool 1.5.5 but there are a number of known
deadlock / sync / performance issues with DBCP 1.2.2 that using pool
1.5.5 won't completely eliminate.
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org
RE: [dbcp] Trying to replace Tomcat 5.5 dbcp with original dbcp
Posted by "Hildebrand, Nils, 232" <Ni...@bamf.bund.de>.
Hi Mark,
> [...]
> > For details see
> > https://issues.apache.org/bugzilla/show_bug.cgi?id=50326
> >
> > To get further I need to replace dbcp 1.3 - as supplied with Tomcat
> > 5.5.30 or 5.5.31 with the original.
>
> Don't waste your time. The code is identical just in a
> different package. Using DBCP 1.3 directly isn't going to help.
Right - I went straight to 1.4 - with Tomcat 5.5.31.
> > I a first step I would like to upgrade to dbcp 1.4 if then my error
> > still persists, I will donwgrade to dbcp 1.2.x if then the error is
> > gone I will open a bug report for dbcp.
>
> That is worth doing although I'd be amazed if the upgrade to
> 1.4 helps since apart from adding some JDBC4 methods, DBCP
> 1.3 and DBCP 1.4 are identical.
Again you are right. I did the upgrade to 1.4 (and to
commons-pool-1.5.5) -
and as you suspeced - the error remains.
> > Is there a short howto how to accomplish the task of exchanging the
> > Tomcat dbcp with a different version?
> Not that I recall. Plenty of places for you to create one
> (Tomcat wiki, Commons wiki) once you have the steps figured out.
What about the DBCP-FAQ?
How can I add the procedure to it?
> > From what I until now know I presume:
> >
> > - change conf/server.xml DB-Resource-Secation factory attribute
> Correct.
> > - put some jar-files into common/lib (which ones?)
> commons-dbcp and commons-pool for the version you want to
> use. Use the latest pool (1.5.5)
Yes - this seems to be the complete procedure.
> > - perhaps delete some tomcat-included dbcp-files (which ones?)
> No need.
>
> > Somewhere I read something about some security settings,
> too that will
> > have to be changed to allow access to the new jars (where and how)?
> No need. Tomcat grants full permissions to all JARs in lib/
Now the next step is a downgrade to dbcp 1.2.x - do I have to downgrade
commons-pool for that step, too?
Kind regards
Nils
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org
Re: [dbcp] Trying to replace Tomcat 5.5 dbcp with original dbcp
Posted by Mark Thomas <ma...@apache.org>.
On 24/11/2010 16:06, Hildebrand, Nils, 232 wrote:
> Hi,
>
> I am trying to track down a problem propably related to DBCP 1.3.
>
> For details see https://issues.apache.org/bugzilla/show_bug.cgi?id=50326
>
> To get further I need to replace dbcp 1.3 - as supplied with Tomcat
> 5.5.30 or 5.5.31 with the original.
Don't waste your time. The code is identical just in a different
package. Using DBCP 1.3 directly isn't going to help.
> I a first step I would like to upgrade to dbcp 1.4 if then my error
> still persists, I will donwgrade to dbcp 1.2.x if then the error is gone
> I will open a bug report for dbcp.
That is worth doing although I'd be amazed if the upgrade to 1.4 helps
since apart from adding some JDBC4 methods, DBCP 1.3 and DBCP 1.4 are
identical.
> Is there a short howto how to accomplish the task of exchanging the
> Tomcat dbcp with a different version?
Not that I recall. Plenty of places for you to create one (Tomcat wiki,
Commons wiki) once you have the steps figured out.
> From what I until now know I presume:
>
> - change conf/server.xml DB-Resource-Secation factory attribute
Correct.
> - put some jar-files into common/lib (which ones?)
commons-dbcp and commons-pool for the version you want to use. Use the
latest pool (1.5.5)
> - perhaps delete some tomcat-included dbcp-files (which ones?)
No need.
> Somewhere I read something about some security settings, too that will
> have to be changed to allow access to the new jars (where and how)?
No need. Tomcat grants full permissions to all JARs in lib/
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org