RE: connection pool problem (with Beta release)

[Johan Compagner]

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

RE: connection pool problem (with Beta release)

[Gogineni, Pratima]

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