Re: [castor-dev] Castor / Tomcat: Query doesn't return expected results in Tomcat. (URGENT!)

[Low Heng Sin]

It seems like some of your variable are being garbage collected by the vm, make sure all of your variable are of the correct scope ( especially the OQLQuery object ).   Regards, Low Heng Sin ( [EMAIL PROTECTED] ) -----Original Message----- From: Artur Matos [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 5:33 To: [EMAIL PROTECTED] Subject: [castor-dev] Castor / Tomcat: Query doesn't return expected results in Tomcat. (URGENT!) Dear all,   I'm having several problems using Castor integrated with Tomcat.   I have a servlet that runs a OQL query and shows the results of that query. There seems to be some problem with Castor because my query always returns diferent results: Some times, it returns 1 object, all the objects, or, the most frequent, none watsoever. (I can see this behavior by reloading the generated page with my browser. Each time I reload the page, i get a different result).   If I run this in a standalone program, i obtain the desired results, so I suspect this is some kind of problem with Tomcat. Also, because of the unpredectied behavior, i suspect this may also be some kind of Thread problem. Can anyone help me?   PS: I'm using castor 0.93 with a mysql database.       Thanks,   Artur Matos ([EMAIL PROTECTED])