You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Josh G <jo...@gfunk007.com> on 2002/08/29 07:47:29 UTC
Database write delay?!?!?!?
Hi,
After banging my head against it all day, I've discovered that _somewhere_
between my servlet code and the filesystem, writes to the database are being
cached. However, reads are not coming from the cache. I'm getting around the
problem at the moment with a simple window.setTimeout in JS instead of
response.sendRedirect(), but this is inelegant and I'd like to lose it.
Has anybody else come across this problem? Is it something I'm doing wrong?
Please tell me it's something I'm doing wrong :-)
Baffled,
-Josh
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Database write delay?!?!?!?
Posted by Tim Funk <fu...@joedog.org>.
Wild guess, but it sounds like you are using a database pool and the
connections that perform updates are not doing commits. Depending on how
the connections are set up - other connections won't see the change
until a commit. (Or you change driver settings - don't ask me what they
are I don't know, I never had to worry about this)
Josh G wrote:
> Hi,
> After banging my head against it all day, I've discovered that _somewhere_
> between my servlet code and the filesystem, writes to the database are being
> cached. However, reads are not coming from the cache. I'm getting around the
> problem at the moment with a simple window.setTimeout in JS instead of
> response.sendRedirect(), but this is inelegant and I'd like to lose it.
>
> Has anybody else come across this problem? Is it something I'm doing wrong?
> Please tell me it's something I'm doing wrong :-)
>
> Baffled,
> -Josh
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Database write delay?!?!?!?
Posted by "Peter T. Abplanalp" <pt...@psaconsultants.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, Aug 30, 2002 at 09:32:49AM +1000, Josh G wrote:
> On Fri, 30 Aug 2002 9:22 am, Peter T. Abplanalp wrote:
> >
> > tired? i don't think that is tired. it still makes me chuckle;
> > although, i've heard that M$ has doubled their mean time to failure so
> > i suppose the updated version is to reboot once a day. ;-)
>
> Oh crap. My XP box at home stays up for weeks at a time, i only reboot when
> i'm messing with stuff and need to install a new/updated driver...
<pouring gasoline on the fire>
i once saw a funny signature once:
- ------------------------------------------------
| Your mouse has moved. |
| Windows must be restarted for the change to |
| take effect. |
| Reboot now? |
| [OK] |
- ------------------------------------------------
> Nah, OE doesn't thread... But Kmail threads nicely :-)
then is it the other way around? Outlook threads but OE doesn't? it
seems that some with the windows type attribution are threaded but
others aren't.
yes, kmail works nicely. so does mutt.
- --
Peter Abplanalp
Email: pta@psaconsultants.com
PGP: pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9brFNggA8sH0iRXQRAvxaAJ4qSgy2GPSDR5ZHq5kNj5V75fXSTgCfUhg2
7t7wb2pOJ7627QLgKqK8lxY=
=fHs/
-----END PGP SIGNATURE-----
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Database write delay?!?!?!?
Posted by Josh G <jo...@gfunk007.com>.
On Fri, 30 Aug 2002 9:22 am, Peter T. Abplanalp wrote:
>
> tired? i don't think that is tired. it still makes me chuckle;
> although, i've heard that M$ has doubled their mean time to failure so
> i suppose the updated version is to reboot once a day. ;-)
Oh crap. My XP box at home stays up for weeks at a time, i only reboot when
i'm messing with stuff and need to install a new/updated driver...
> <donning flame retardant suit>
>
> as an side and on a totally different note: does outlook express
> handle threading while outlook does not? how is that possible? i ask
> because it is annoying to me to be unable to thread some of the
> messages on this list. i like to have all my related emails together.
Nah, OE doesn't thread... But Kmail threads nicely :-)
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Database write delay?!?!?!?
Posted by "Peter T. Abplanalp" <pt...@psaconsultants.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, Aug 30, 2002 at 09:15:48AM +1000, Josh G wrote:
> On Fri, 30 Aug 2002 8:47 am, Mike Jackson wrote:
>
> > Are you using the JDBC-ODBC bridge? If so then I'd not worry about
> > the delayed writes, I'd worry about restarting your app often
> > (daily/weekly), and your database engine for that matter.
> >
>
> Feel like explaining that one? Is there a bug in the bridge? Or are you just
> giving me the tired old "it's on windows so reboot it twice a day" speech?
tired? i don't think that is tired. it still makes me chuckle;
although, i've heard that M$ has doubled their mean time to failure so
i suppose the updated version is to reboot once a day. ;-)
<donning flame retardant suit>
as an side and on a totally different note: does outlook express
handle threading while outlook does not? how is that possible? i ask
because it is annoying to me to be unable to thread some of the
messages on this list. i like to have all my related emails together.
- --
Peter Abplanalp
Email: pta@psaconsultants.com
PGP: pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9bqycggA8sH0iRXQRAkwRAJ4m7HWAuUKuyVA9RtwJNynrfJNn4gCfUE/R
v6ClcIeP9wYKvlmYcR+hDGw=
=xs8x
-----END PGP SIGNATURE-----
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Database write delay?!?!?!?
Posted by Mike Jackson <mj...@cdi-hq.com>.
There's either a memory leak or a connection leak in the
ODBC bridge. I'm not sure which. I have a site using sql
server w/jrun and prior to switching to a new interface
(other than the odbc-jdbc bridge) I was seeing my handles
increasing (and connections) but never subsiding. Eventually
after a day to a week I'd have to reboot to free up the
resources. And the machine would hang sometimes if I didn't
get to it first. What it depended on was how many people
had been booked in the system (it's a log for a jail). After
changing drivers to a pure jdbc sql server interface I haven't
had to reboot in a couple of monthes, and I don't have the
resource problems that I was having.
--mikej
-=-----
mike jackson
mjackson@cdi-hq.com
> -----Original Message-----
> From: Josh G [mailto:josh@gfunk007.com]
> Sent: Thursday, August 29, 2002 4:16 PM
> To: Tomcat Users List
> Subject: Re: Database write delay?!?!?!?
>
>
> On Fri, 30 Aug 2002 8:47 am, Mike Jackson wrote:
>
> > Are you using the JDBC-ODBC bridge? If so then I'd not worry about
> > the delayed writes, I'd worry about restarting your app often
> > (daily/weekly), and your database engine for that matter.
> >
>
> Feel like explaining that one? Is there a bug in the bridge? Or
> are you just
> giving me the tired old "it's on windows so reboot it twice a day" speech?
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Database write delay?!?!?!?
Posted by Josh G <jo...@gfunk007.com>.
On Fri, 30 Aug 2002 8:47 am, Mike Jackson wrote:
> Are you using the JDBC-ODBC bridge? If so then I'd not worry about
> the delayed writes, I'd worry about restarting your app often
> (daily/weekly), and your database engine for that matter.
>
Feel like explaining that one? Is there a bug in the bridge? Or are you just
giving me the tired old "it's on windows so reboot it twice a day" speech?
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Database write delay?!?!?!?
Posted by Mike Jackson <mj...@cdi-hq.com>.
Are you using the JDBC-ODBC bridge? If so then I'd not worry about
the delayed writes, I'd worry about restarting your app often
(daily/weekly), and your database engine for that matter.
--mikej
-=-----
mike jackson
mjackson@cdi-hq.com
> -----Original Message-----
> From: Josh McDonald [mailto:josh@gfunk007.com]
> Sent: Thursday, August 29, 2002 3:45 PM
> To: Tomcat Users List
> Subject: Re: Database write delay?!?!?!?
>
>
> Using jdbc->odbc->jet (don't bother telling me it wasn't my decision) -
> would this be a problem? Does it even support transactions?
>
> -Josh
>
> And can you tell me, doctor, why I still can't get to sleep?
> And why the Channel Seven chopper chills me to my feet?
> And what's this rash that comes and goes, can you tell me what it means?
> God help me, I was only nineteen.
> ----- Original Message -----
> From: "Sexton, George" <gs...@mhsoftware.com>
> To: "Tomcat Users List" <to...@jakarta.apache.org>
> Sent: Thursday, August 29, 2002 11:18 PM
> Subject: RE: Database write delay?!?!?!?
>
>
> > Um... ... ...
> >
> > What database are you using?
> >
> > Do you have autocommit() turned on in your jdbc connection?
> >
> > -----Original Message-----
> > From: Josh G [mailto:josh@gfunk007.com]
> > Sent: 28 August, 2002 11:47 PM
> > To: Tomcat Users List
> > Subject: Database write delay?!?!?!?
> >
> >
> > Hi,
> > After banging my head against it all day, I've discovered that
> _somewhere_
> > between my servlet code and the filesystem, writes to the database are
> being
> > cached. However, reads are not coming from the cache. I'm getting around
> the
> > problem at the moment with a simple window.setTimeout in JS instead of
> > response.sendRedirect(), but this is inelegant and I'd like to lose it.
> >
> > Has anybody else come across this problem? Is it something I'm doing
> wrong?
> > Please tell me it's something I'm doing wrong :-)
> >
> > Baffled,
> > -Josh
> >
> > --
> > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Database write delay?!?!?!?
Posted by Josh McDonald <jo...@gfunk007.com>.
Using jdbc->odbc->jet (don't bother telling me it wasn't my decision) -
would this be a problem? Does it even support transactions?
-Josh
And can you tell me, doctor, why I still can't get to sleep?
And why the Channel Seven chopper chills me to my feet?
And what's this rash that comes and goes, can you tell me what it means?
God help me, I was only nineteen.
----- Original Message -----
From: "Sexton, George" <gs...@mhsoftware.com>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Thursday, August 29, 2002 11:18 PM
Subject: RE: Database write delay?!?!?!?
> Um... ... ...
>
> What database are you using?
>
> Do you have autocommit() turned on in your jdbc connection?
>
> -----Original Message-----
> From: Josh G [mailto:josh@gfunk007.com]
> Sent: 28 August, 2002 11:47 PM
> To: Tomcat Users List
> Subject: Database write delay?!?!?!?
>
>
> Hi,
> After banging my head against it all day, I've discovered that _somewhere_
> between my servlet code and the filesystem, writes to the database are
being
> cached. However, reads are not coming from the cache. I'm getting around
the
> problem at the moment with a simple window.setTimeout in JS instead of
> response.sendRedirect(), but this is inelegant and I'd like to lose it.
>
> Has anybody else come across this problem? Is it something I'm doing
wrong?
> Please tell me it's something I'm doing wrong :-)
>
> Baffled,
> -Josh
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Database write delay?!?!?!?
Posted by "Sexton, George" <gs...@mhsoftware.com>.
Um... ... ...
What database are you using?
Do you have autocommit() turned on in your jdbc connection?
-----Original Message-----
From: Josh G [mailto:josh@gfunk007.com]
Sent: 28 August, 2002 11:47 PM
To: Tomcat Users List
Subject: Database write delay?!?!?!?
Hi,
After banging my head against it all day, I've discovered that _somewhere_
between my servlet code and the filesystem, writes to the database are being
cached. However, reads are not coming from the cache. I'm getting around the
problem at the moment with a simple window.setTimeout in JS instead of
response.sendRedirect(), but this is inelegant and I'd like to lose it.
Has anybody else come across this problem? Is it something I'm doing wrong?
Please tell me it's something I'm doing wrong :-)
Baffled,
-Josh
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>