tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Kilbride" <j...@kilbride.com>
Subject Re: JDBC Realm problem
Date Tue, 24 Apr 2001 01:04:14 GMT
Hi Andrew,

>From the mm.mysql docs:

Name: autoReconnect
Use: should the driver attempt to re-connect if the connection dies?
(true/false)
Default Value: false

I wouldn't have found this without your pointer, so thanks! I'll give it a
try and see what happens.

I'd love to see your connection pool implementation for JDBCRealm. Would you
be willing to send it to me outside the list?

Thanks,
--jeff

----- Original Message -----
From: "Andrew Robson" <andrewdrobson@netscapeonline.co.uk>
To: <tomcat-user@jakarta.apache.org>
Sent: Monday, April 23, 2001 5:56 PM
Subject: Re: JDBC Realm problem


> Hi Jeff,
>   I had exactly the same problem (with mm 2.0.2) and only
> solved it by customisng JDBCRealm to use database
> connection pooling. A bit heavy handed but might be
> a lot easier than trying to track potential driver problem if time is
> an issue. I have also seen a suggestinon on the list that adding
> autoreconnect=true to the database connection string solves
> the problem but I haven't tried it myself.
>
> andrew
>
> On Mon, 23 Apr 2001, you wrote:
> > Hi Ignacio,
> >
> > Thanks for the quick response! First, my apologies for the HTML format.
I
> > didn't realize I hadn't changed this machine...
> >
> > I'll try the 3.2.2 branch and see what happens. Any word on a final
release
> > for 3.2.2?
> >
> > I'm using the 2.0.4 drivers for MySQL, which seem to be the latest. Can
you
> > be more specific on why this relates to the driver? If so, I'll take a
look
> > at the driver code and see if I can locate the problem or recommend a
> > solution to the mm.mysql developer.
> >
> > On another note, I've seen discussions saying the mod_jk implementation
in
> > the 3.3 branch is implemented/optimized better than the mod_jk in 3.2.*.
Do
> > you recommend using the 3.3 mod_jk?
> >
> > Thanks,
> > --jeff
> >
> > ----- Original Message -----
> > From: "Ignacio J. Ortega" <nacho@siapi.es>
> > To: <tomcat-user@jakarta.apache.org>
> > Sent: Monday, April 23, 2001 3:31 PM
> > Subject: RE: JDBC Realm problem
> >
> >
> > > Hola Jeff:
> > >
> > > Some people has reported problems that lookclose to yours..no
solutions
> > > ... please test against latest code on CVS for 3.2 branch...3.3 code
(m2
> > > is known to be broken in auth ...get it from CVS until m3 arrives..)..
> > > or 4.0 Beta2...to give that problem another shake.. in different
> > > flavours of tomcat..to se if that makes a difference ( i dont believe
> > > that's wil be true but who knows ..)
> > >
> > > For me until now...with one more code review done after reading your
> > > message...this problem relates to the MySql JDBC Driver...so change
you
> > > Driver jar version to see if that makes a difference..
> > >
> > > Sorry for trying to augment your problems ... not solve them..:)))
> > >
> > > TIA.
> > >
> > > ( Please do not use HTML mail ....makes hard to chat, thanks)
> > >
> > > Saludos ,
> > > Ignacio J. Ortega
> --
>
>


Mime
View raw message