> > Are you saying the connection must be released for read-only operations? I > > am not understanding. Is there some danger to keeping a connection > > constantly open (so long as serial access is ensured)? > > > > The connection/DataSource handle could get timed out and PB show > unexpected behaviour. Could be a performance issue, hundered open > connections (each bean has a bean pool and each bean may have an open > connection). Your appServer connection pool could exhaust.
I see. I forgot about the bean pool. But the timeout issue could be dealt with easily enough. For instance, in MySQL, you can set an autoreconnect flag to have timed-out connection come alive on subsequent access. MIchael > regards, > Armin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
