com.sssw.rt.util.TableDataStore.checkClosed

[Bertus111]

Hi there,

Thanks in advance for your helpful hints.

My problem is my data access object.
I have a method "Execute" that handles all my SQL queries by using an Invoked DataSource object with an AgaData. This was implemented exactly like the documentation described.

This method works fine, until i have more than one user accessing my site. Then the following happens (presumably when a query is executed simultaneously) :

java.lang.IllegalStateException: The operation is not allowed because the data store has been closed.

at com.sssw.rt.util.TableDataStore.checkClosed(TableDataStore.java:3551)

at com.sssw.rt.util.TableDataStore.getColumnCount(TableDataStore.java:1439)

at com.sssw.rt.util.DataCursor.getPropertyCount(DataCursor.java:307)

at com.sssw.rt.util.AgoRowCursor.getPropertyCount(AgoRowCursor.java:392)

at com.sssw.rt.util.AgoData.getPropertyCount(AgoData.java:308)

at SystemMBasePackage.boDBMgr.Execute(boDBMgr.java:162)

I do close my resultsets when I am finished with them, and I`m sure i`ve done everything else by the book. Does anyone know what the problem could be or how I could prevent it from happening?

Thank you,
Bertus Viljoen

BTW. I`m using Silverstream 3.7.3 with SQL Server 2000.