RE: Database write delay?!?!?!?

2002-08-30 Thread Mike Jackson
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

Database write delay?!?!?!?

2002-08-29 Thread Josh G
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

Re: Database write delay?!?!?!?

2002-08-29 Thread Tim Funk
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

RE: Database write delay?!?!?!?

2002-08-29 Thread Sexton, George
Um... ... ... What database are you using? Do you have autocommit() turned on in your jdbc connection? -Original Message- From: Josh G [mailto:[EMAIL PROTECTED]] Sent: 28 August, 2002 11:47 PM To: Tomcat Users List Subject: Database write delay?!?!?!? Hi, After banging my

Re: Database write delay?!?!?!?

2002-08-29 Thread Josh McDonald
, can you tell me what it means? God help me, I was only nineteen. - Original Message - From: Sexton, George [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 11:18 PM Subject: RE: Database write delay?!?!?!? Um... ... ... What database are you

RE: Database write delay?!?!?!?

2002-08-29 Thread Mike Jackson
:[EMAIL PROTECTED]] 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

Re: Database write delay?!?!?!?

2002-08-29 Thread Josh G
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

Re: Database write delay?!?!?!?

2002-08-29 Thread Peter T. Abplanalp
-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

Re: Database write delay?!?!?!?

2002-08-29 Thread Josh G
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

Re: Database write delay?!?!?!?

2002-08-29 Thread Peter T. Abplanalp
-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