i want to configure multiple datasources in Play framework 2.1 with jpa.
one is H2, and the other is Oracle.
so i added the code like this in application.conf:
db.default.driver=org.h2.Driver db.default.url="jdbc:h2:file:E:/myproject/setup/db/monitor" db.default.user=sa db.default.password=sa db.default.jndiName=DefaultDS jpa.default=defaultPersistenceUnit db.oracle.driver=oracle.jdbc.driver.OracleDriver db.oracle.url="jdbc:oracle:thin:@10.1.20.10:1521:prjct" db.oracle.user=LOG_ANALYSE db.oracle.password=LOG_ANALYSE db.oracle.jndiName=OracleDS jpa.oracle=ojdbcPersistenceUnit
i don't know how to assign for jpa.oracle
and give it a meaningless name. but it does not show any errors. should i change it and how?
the main problem is: how can i tell Play which entities are managed by default
datasource what others by the other, oracle
?
for example, class A, B's tables are in H2 and class C, D's tables are in oracle. what should i codding for these entities to assign the datasources?
I did not used this feature (yet) but you have to useone of the annotations on your Models:
Or when you query yourself you can alsow specify it as: