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 <matthew.broadhead@nbmlaw.co.uk>
> :
>
>> 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 <
>>> matthew.broadhead@nbmlaw.co.uk>
>>> :
>>>
>>> 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>
>>>>
>>>>