Re: [SQLObject] SQLObject / FireBird / WebWare

[Randall R. <ra...@ra...>]

On Thursday, September 25, 2003, at 05:49 PM, Ian Sparks wrote:

> General questions :
>
> How do SQLObject models fit into Webware?
> Are there threading issues?
> Does it work like dbPool?
>
> If anyone has some simple (even pseudocode) examples that would be a 
> great
> help.

Well, I haven't run into any big issues yet, and I've
been building my latest app (a combination articles site
and shopping cart) with it.  On the other hand, I'm not
trying to store my servlets in the db or anything.  I
also haven't needed transactions yet, but expect to.

The two easy ways of getting around the caching (when
updating articles, etc) are creating any needed objects
in awake() and destroying them in sleep(), or just
restarting the appserver on changes that would be
cached by a servlet.  I do the latter.

For me, SQLObject has replaced the pooling built into
psycopg.  Just in time, too, as psycopg 2.0 will not
have it anymore. :)

If you can be more specific about something you'd like
to see an example of, I can just pull out some of my
current code (assuming I'm doing whatever you want to
see).

-- 
Randall Randall <ra...@ra...>
"When you advocate any government action, you must first
believe that violence is the best answer to the question
at hand." -- Allen Thornton