Debug through it and look what kind of rows are really selected from the db
the first time.
I have seen this behaviour many times but it was always a caching problem at
the browser site. Because the selected data was right the first time.
johan
> -----Original Message-----
> From: Gogineni, Pratima [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 16, 2001 2:11 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: connection pool problem (with Beta release)
>
>
>
> Okay another symptom - the problem persists even when i set the
> isolation to
> read_uncommitted.
>
> -----Original Message-----
> From: Gogineni, Pratima
> Sent: Tuesday, May 15, 2001 3:35 PM
> To: '[EMAIL PROTECTED]'
> Subject: connection pool problem (with Beta release)
>
>
> I have a very odd problem - I was hoping the symptoms sound familiar to
> someone on the list...
>
> I display a database table to the user in the jsp page
> the user can insert/delete or update into this table - this is sent to an
> action class that uses the struts connection pool and executes the
> appropriate sql statement
> After executing the sql statement I go back to jsp page that displays the
> data in the table.
>
> my problem is that I need to query the database twice before the
> new data is
> shown (for example if I add row#11). I see only 10 rows the first time I
> query the database after the insert statemetn is executed. The
> second time I
> query the database I get all 11 rows.
>
> I have autoCommit set to false. I call the commit() method on the
> connection
> after the insert statement is executed and I have the transaction
> isolation
> set to TRANSACTION_READ_COMMITTED.
>
> Another symptom is that I dont always see this problem - only in
> some runs,
> which leads me to suspect that this is a threading issue?
>
> Does anyone know what the problem could be / what I should check/lookout
> for?
>
> Thanks
> Pratima
>
> -----Original Message-----
> From: Roy Truelove [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 7:51 PM
> To: [EMAIL PROTECTED]
> Subject: Web design forum / listserv
>
>
> Hey guys,
>
> I'd like to know if anyone knows of a listserv / forum /
> newsgroup that
> deals solely with web application design philosophies, and not necessarily
> with their implementations. I read several lists (this one, Turbine, JSP,
> barracuda,) and most of the traffic is geared toward problems *using* the
> framework. A place where people could go and discuss things like MVCm2,
> push/pull etc. I believe would be very beneficial. If someone knows of a
> forum like this, please let me know.
>
> Thanks!
> -Roy
