Good points. My aim is to have threads across servers listen on the database for certain notify events (let's say "insert update"). That code I suppose can live outside of SQLObject.
Once that event is received in the listening thread, it can open a new connection to perform an object select. Or can SQLObject take an existing DB API connection object and use it for subsequent sessions? If it could, then its a nice way to bridge between stuff that can only be done outside SQLObject and then perform the cool stuff inside it, using the same connection. I'm still reading the docs, so apologies if its on there and I missed it so far. Darren On Tue, 2008-11-18 at 00:02 +0300, Oleg Broytmann wrote: > On Mon, Nov 17, 2008 at 08:54:48PM +0300, Oleg Broytmann wrote: > > On Mon, Nov 17, 2008 at 12:47:36PM -0500, Darren Govoni wrote: > > > I think I will try to do the listen/notify outside of SQLObject and then > > > fetch the objects using SQLObject. Should work. > > > > There could be a problem with transactions - opening a cursor outside of > > SQLObject gives you a different transaction. > > Oops, sorry - opening a new *connection* gives you a different > transaction. But that (opening a new connection) is what you have to do > anyway to work with the DB outside of SQLObject. Or you can try to use > a low-level DB API connection hiding in the SQLObject's DBConnection > class... > > Oleg. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
