Hi All,

I'm using JPA to persist data to a Postgres database. Being a web application I want that for each user which I register (is a private application) a separate schema is created in the database. The EJB layer was designed for a specific schema so is it possible to choose which schema to be used by EJB layer at login time?

To keep it short:

user one (in application) -> schema one (in Postgres)
user two -> schema two

setup at runtime during login.

Is this the right approach to get this functionality? Maybe this can be set from JBoss?

Thanks

I am not super strong with hibernate, but reading about Filters in Annotations API, it seems as though you Filter the table based on a variable. I haven't tested any of this but it is a theory. If the filter works you could change schema and table using the filter and setting table name schema.table.