I wouldn't expect that behaviour at all. I've been using DB2 and haven't seen that happen. What leads you to believe that data isn't being persisted at the end of the transaction?

So, to restate what you said so I understand:

1. Using MySQL it appears that data is persisted correctly.

2. Using the Oracle Driver you see some caching occurring?

Can you provide the plan you are using that describes the database connections?

Ueberbach, Michael wrote:
hello all,

while testing some ejb-apps on geronimo I encountered a significant difference 
between different databases as connection pools.
Using a local MySQL database all transactions (inserting, updating etc) work 
well. Changing to a separate Oracle database the behaviour is different. 
Creating new Entity Beans will be done on geronimo but not written to the 
database until geronimo has been shut down. Im using a thin oracle jdbc driver 
and CMP.
Does anybody has any idea where to look after?

regards
Michael



Reply via email to