SYLVIE PALLUEL wrote:
I don't know if this can help you, but I made another test with an OQL pass-thru, and I get the new object before the commit phase.
It seems to me that using pass through SQL should only work if you are using autocommit. Are you using autocommit? What database are you using?
Is there something special to do to enable the OQL query to see the objects created inside the current transaction?
There's nothing special that needs to be done. Just as Patrick stated, OQL queries do not look at the cache before going to persistence. This is different from the db.load() method which actually does look at the cache first.
Bruce
--
perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
The Castor Project http://www.castor.org/
Apache Geronimo http://geronimo.apache.org/
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
