On 15 Jun 2004, Michel Thadeu said: > The problem is that the database changes (every time, outside the > webware) and the data shown in the Search are not changed. I have some > similar problem in another project, in this case, the database donīt > change every time but when I change it by using > SomeTable.get(x).set(...), some sectors of the page have the proper > data and some sections not. > > What can I do, please? Thanks for any help :)
You're right, your problem is caching. SQLObject caches any object that you retrieve from the database, or insert into the database. In the case where the database is getting modified externally, you have to turn off caching. There's an attribute you can set for your SQLObject class. From the documentation: _cacheValues: If set to False then values for attributes from the database won't be cached. So everytime you access an attribute in the object the database will be queried for a value. If you want to handle concurrent access to the database from multiple processes then this is probably the way to do so. You should also use it with transactions (it is not implied). It's kinda unfortunate that this is the solution, but there you are. Does anyone know if there's a way to update or retrieve multiple attributes with a single function call, so that when caching is disabled, it will only have to do one SQL query instead of one query per attribute? ------------------------------------------------------- This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss