I am a newbie to Flex. 

I am using Flex, BlazDS, Tomcat 6, MySQL 5.1 for the project I am working on.

When more that one users access the database concurrently (which has over 800 
records), it throws an error message sying "No operations allowed after 
statement closed".  I know this issue has been addressed before, but none of 
the solutions seems to be working for me.  


If it is accessed by one user at a time, it works alright.  I am using the 
connection pooling.  Please see the resource setting for the connection pooling 
I am using below.  

<Resource 
name="jdbc/DSMDB" 
auth="Container" 
type="javax.sql.DataSource" 
maxWait="10000" 
maxActive="1500"
maxIdle="300" 
removeAbandoned="true" 
removeAbandonedTimeout="10000" 
logAbandoned="true" 
username="root" 
password="emergent" 
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/jjrr?autoReconnect=true"/>

please help me to fix this issue.  I really appreciate your time.

Thanks
Simon

Reply via email to