they are both mysql databases
On 16/03/2018 09:33, Romain Manni-Bucau wrote:
Hi,
this is the way to do, maybe check your system properties and database
configurations. With some DB you can need some more config (thinking to
oracle and schemas for instance)
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://rmannibucau.metawerx.net/> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book
<https://www.packtpub.com/application-development/java-ee-8-high-performance>
2018-03-16 9:23 GMT+01:00 Matthew Broadhead <[email protected]>
:
hi,
i just wrote an email to users@openjpa but there doesn't seem to be much
activity there.
do you know how to declare multiple persistence units? i created 2
persistence units inside persistence.xml but it seems to create the
entities from the second PU in the database of the first one. my
persistence.xml is like this. the operator tables get created inside the
file database
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd";
version="2.0">
<persistence-unit name="file">
<jta-data-source>file</jta-data-source>
<class>uk.me.kissy.file.entities.jpa.Box</class>
<class>uk.me.kissy.file.entities.jpa.Category</class>
<class>uk.me.kissy.file.entities.jpa.CqsReview</class>
<class>uk.me.kissy.file.entities.jpa.Department</class>
<class>uk.me.kissy.file.entities.jpa.Enclosure</class>
<class>uk.me.kissy.file.entities.jpa.Event</class>
<class>uk.me.kissy.file.entities.jpa.EventData</class>
<class>uk.me.kissy.file.entities.jpa.EventType</class>
<!-- <class>uk.me.kissy.file.entities.jpa.File</class> -->
<class>uk.me.kissy.file.entities.jpa.Log</class>
<class>uk.me.kissy.file.entities.jpa.Note</class>
<class>uk.me.kissy.file.entities.jpa.Payment</class>
<class>uk.me.kissy.file.entities.jpa.Price</class>
<class>uk.me.kissy.file.entities.jpa.Undertaking</class>
<class>uk.me.kissy.file.entities.jpa.UndertakingType</class>
<class>uk.me.kissy.file.entities.jpa.Workflow</class>
<properties>
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema(ForeignKeys=true)" />
</properties>
</persistence-unit>
<persistence-unit name="operator">
<jta-data-source>operator</jta-data-source>
<class>uk.me.kissy.file.entities.jpa.operator.Address</class>
<class>uk.me.kissy.file.entities.jpa.operator.Client</class>
<class>uk.me.kissy.file.entities.jpa.operator.Council</class>
<class>uk.me.kissy.file.entities.jpa.operator.Operator</class>
<class>uk.me.kissy.file.entities.jpa.operator.Posttown</class>
<class>uk.me.kissy.file.entities.jpa.operator.Wtr_auth</class>
</persistence-unit>
</persistence>
