> Thanks. However, the following is an excert from my initsid.ora:
>
> shared_pool_size = 31457280 # INITIAL
> # shared_pool_size = 3500000
> # SMALL
> # shared_pool_size = 5000000
> # MEDIUM
> # shared_pool_size = 9000000
> # LARGE
>
> Does not this show that the share_pool_size is more than three times
> as big as LARGE?
Maybe you need to flush your pool: some posts suggests this.
> Actually the same test I run failed much earlier when using MySQL as
> my datasource. The test is simple, I have one entity bean and one
> session bean. I create 1000 bean instances and deletes them
> afterwards. When using Oracle, all bean instances get created, but
> none are destroyed. With MySQL only around 100 gets created.
in this case, you can change JBossCMP options to prefetch less rows: this
will reduce the size of the statement.
> I do not use any explicite transaction handling. Neither do I set any
> commit option (as this seems to be unavailable to set from XDoclet).
I think that commit option must be set in the Xdoclet descriptor inside ANT,
not directly in the files (but I may be wrong). As long as transaction are
concerned, the spec says that you *must* have a transaction when working
with 2.x entity beans. Just put your xdoclet descriptor to default to
"Required".
Cheers,
Sacha
-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
