On 31 Mar 2008, at 00:14, Kevin Brown wrote:
Any problems with a managed datasource pointing to Oracle or MySQL ?
Shouldn't be -- write a threadsafe client with a shared connection
and you
should be fine. Most relational database systems already tolerate
multiple
parallel queries on a shared connection (and I know for a fact that
MySQL
and Oracle both do), so I don't see a likely issue here.
When you say threadsafe client does that mean a client in the same
JVM or a remote client (I am being dumb :) ) ?
Does Shindig implement its own transaction monitor (like Jackrabbit
does), so that 1 shared connection is used concurrently by multiple
request transactions ?
or by shared connection do you mean a connection that is used by 1
request transaction, and returned to a pool to be re-used by the
next.... but during the request transaction is used to perform
multiple overlapping SQL queries ?
Guice is cooool, I wanted an excuse to try it.
Thanks
Ian
