Spring Framework + JPA and many database schemas

[Joao Zava]

I need to work with database schemas dynamically.

When a user will logging in the system, he will select an option that will say the schema that I need to use.

I'm using Spring + JPA

I have a pesistence.xml and my Spring configuration is:

  <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="persistenceUnitName" value="pu" />
    <property name="dataSource" ref="pooledDS"></property>
    <property name="jpaDialect">
      <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
    </property>
  </bean>

  <bean id="defDataSourceTarget" destroy-method="close"
    class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="org.postgresql.Driver" />
    <property name="url" value="jdbc:postgresql://localhost:5432/bd" />
    <property name="username" value="user" />
    <property name="password" value="pass" />
  </bean>

Anybody know how I do it?

Sorry by english and many thanks.