[eclipselink-users] manually generating tables after switching postgresq

[Dominik Dorn <dominik.dorn@xxxxxxxxx>]

Hello,

for an university assignment we _have to_ place multiple instances
of a schema into the same postgresql database.

I'm using EclipseLink 2.0.2 and I'm trying to do it like this, but I'm stuck

        EntityManagerFactoryImpl factory = (EntityManagerFactoryImpl)
Persistence.createEntityManagerFactory("RestPersistenceUnit");

        EntityManager em = factory.createEntityManager(); // this
triggers table creation the first time, but fails as there is no
schema selected

        em.getTransaction().begin();
        em.createNativeQuery("CREATE SCHEMA test123;").executeUpdate();
        em.createNativeQuery("SET SEARCH_PATH TO test123;").executeUpdate();
        em.getTransaction().commit();

// i hoped the following code would now again trigger table creation,
but it doesn't
        factory.close();
        System.out.println("\n\n\n\n\n\nnew");

        factory = (EntityManagerFactoryImpl)
Persistence.createEntityManagerFactory("RestPersistenceUnit");
        em = factory.createEntityManager();


        SchemaManager schemaManager = new
SchemaManager(factory.getServerSession());

        schemaManager.outputDDLToDatabase(); // this doesnt work either


the persistence.xml looks like this:
    <persistence-unit name="RestPersistenceUnit">
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
        <class>com.dominikdorn.tuwien.evs.rest.domain.Rack</class>
        <class>com.dominikdorn.tuwien.evs.rest.domain.Item</class>
        <class>com.dominikdorn.tuwien.evs.rest.domain.Placement</class>
        <properties>
            <property name="javax.persistence.transactionType"
value="RESOURCE_LOCAL" />
            <property name="javax.persistence.jdbc.driver"
value="org.postgresql.Driver" />
            <property name="javax.persistence.jdbc.url"
value="jdbc:postgresql://127.0.0.1:5432/evs"/>
            <property name="javax.persistence.jdbc.user" value="evs"/>
            <property name="javax.persistence.jdbc.password" value="evs10"/>
            <property name="eclipselink.target-database" value="POSTGRESQL" />
            <!--<property name="eclipselink.ddl-generation"
value="create-tables" />-->
            <property name="eclipselink.ddl-generation"
value="drop-and-create-tables" />
            <property name="eclipselink.create-ddl-jdbc-file-name"
value="create.sql"/>
            <property name="eclipselink.drop-ddl-jdbc-file-name"
value="drop.sql"/>
            <property name="eclipselink.ddl-generation.output-mode"
value="both"/>
        </properties>
    </persistence-unit>

So basically what I need to do is:
1. create a new "schema" with a specific name
2. set the search_path to this schema
3. let eclipselink create the tables on the connection where the
search_path was altered.
4. use the specified search_path for every EntityManager created from
the Factory

the problem I'm facing:

EclipseLink tries to create the tables when I call
emf.createEntityManager(); which
fails because there is no schema selected.

The code above may be completely wrong.. its just my naive try to get it working
after a lot of googling and finally sniffing around in the sourcecode
and attaching
a debugger.


Any help greatly appreciated!


Thanks a lot!

Kind regards,
Dominik
-- 
Dominik Dorn
http://dominikdorn.com