that is a good idea! i will try that. i was thinking it might be
necessary to specify the schema at the top of the @Entity in the @Table
annotation. i haven't tried that yet but i will try the logging first
to see if it shows anything.
On 16/03/2018 10:17, Romain Manni-Bucau wrote:
maybe activate sql logging to check what is happening exactly (LogSql=true
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:46 GMT+01:00 Matthew Broadhead <[email protected]>
:
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>
