You're right the comment does not match the code any more, because after changing the query to
/*1*/ "select d from ProductDetail d where d.product.group=$1"
no exception is thrown.
the original select that results in a request timeout (because of a lock): /*2*/ "select count(*) from ProductDetail d where d.product.group=$1"
I thought it might be helpful to find the bug, if I told that the exception does not occur in a simplified form of the select:
/*3*/ "select count(*) from ProductDetail d where d.product=$1"
Of course that last query /*3*/ does not retrieve the objects I need, I just wanted to mention that the exception does not occur in simpler cases of the query.
The query /*1*/ is a real work-around the bug, but a bad one, because it might result in high network traffic where you only need an integer number.
I hope I could clarify the bug enough so you can localize it.
Regards, michael
At 18:55 10.09.2003 +0000, you wrote:
This one time, at band camp, michael simons said:
ms>submitted the bug as # 1403 ms> ms>some annotations: ms> ms>When you change the code to ms> ms>- - - snip - - - ms>qry = db.getOQLQuery ("select d from " ms>+ ProductDetail.class.getName() ms>+ " d where d.product.group=$1"); ms>qry.bind(pg); ms>results = qry.execute(); // !! This is where you get a request time out !! ms>_writer.println ("count = " + results.size()); ms>- - - snap - - - ms> ms>there's no lock no more and you get the result including the object ms>recently created. ms> ms>On the other hand the select works when you don't restrict by ms>"d.product.group" but only by product.
Michael,
I missed this message before I sent my reply. I don't understand your comments above. What do you mean that there is no lock? Also, the second comment doesn't match the code snippet. Please provide some additional detail.
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://incubator.apache.org/projects/geronimo.html
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
