[Building Sakai] DB Service and Spring

[Dunstall, Christopher]

Hi all,

I was wondering if someone can help me get my head around this. Spring is starting to do me in...

The BasicSqlService is loaded via Spring and can be injected into another bean.

If a Sakai tool's own DB service obtains the BasicSqlService from the component manager (as a singleton), and borrows a connection from the data source, is this connection directly related to the session even though the BasicSqlService is shared to the entire VM?

In other words, if user A enters the tool, and gets the DB service, will their actions SHARE the same connection spawned by user B who's already logged into the tool?

Thanks,

Chris Dunstall | Solutions Developer
Enterprise Information Management Solutions (EIMS)
Division of Information Technology | Charles Sturt University | Bathurst, NSW

Ph: 02 63384818 | Fax: 02 63384181