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

Reply via email to