Hi I'm using SQLObject 0.7.1a on 2 multimaster replicated mysql servers to have both high availability and load balancing. I noticed coherency problems between mysql and the application. So I suspected the cache. I'm now trying to disable the cache by adding &cache= in the connection url. With the connection debug, I can't notice any behaviour change with or without this option. I can see that connection.doCache is set according to the url parameter, but no effect.
I can still see that sqlobject is fetching all data when doing a iterating a select. But not when accessing a multipleJoin. For the multiple join access to refetch the data I have to make a connection.cache.clear(), with or without the option. Same behaviour when doing a sqlclass.get(id), data is fetched only once also with or without the option. I can't see where is the action of connection.doCache. Can someone please explain? I also tried sqlmeta cacheValues to False, the it is catastrophic, because each column of a row is fetched one by one! How is it possible to have a behaviour not as agressive as cacheValues Thanks Sophana ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
