Please sugest on Design Decisions

[jbossindia]

I have a project with following enviornment.

Jboss Seam, RichFaces, Hibernate, Ms-SQL, Jboss AS

Requirement

SaaS model - each client having seperate DB
Clustering Jboss AS across clients.

Current Status

Seam-Gen generated code.
Using EntityHome and EntityQuery as listeners.

Questions

How to implement ConnectionProvider for mapping each request to client-user specific DB.

Clustering: Should I user StatefulSessionBean(ConversationScoped) or continue EntityHome and EntityQuery (Both conversation Scope)

Should I use SMPC or EJB Container Managed one.Conversation scoped transactions?

[koenhandekyn.seamframework.org.handekyn.com]

Should I use SMPC or EJB Container Managed one.Conversation scoped transactions?

depends on the application flow, but SMPC come in realy realy handy.

first question: you can configure multiple entitymanagers in components.xml for example, you must than configure each entity with an extra annotation.

[damianharvey.damianharvey.gmail.com]

Or if you want to use one DB you could look into using Hibernate Filters and filter on the client id.

Cheers,

Damian