Re: openjpa multiple persistence units

[Matthew Broadhead]

i found it
true

On 22/10/2018 19:14, Matthew Broadhead wrote:
eclipse IDE is complaining if i have multiple persistence units and 
they contain classes with the same name.  e.g.

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">
    
        db1
db1Unmanaged
        com.test.entities.jpa.db1.Test
        
            
        
    
    
        db2
db2Unmanaged
        com.test.entities.jpa.db2.Test
        
            
        
    

is eclipse right or can i ignore the error?

openjpa multiple persistence units

[Matthew Broadhead]

eclipse IDE is complaining if i have multiple persistence units and they 
contain classes with the same name.  e.g.

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">
    
        db1
db1Unmanaged
        com.test.entities.jpa.db1.Test
        
            
        
    
    
        db2
db2Unmanaged
        com.test.entities.jpa.db2.Test
        
            
        
    

is eclipse right or can i ignore the error?

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

2018-03-19 11:44 GMT+01:00 Matthew Broadhead :

> thanks Romain, that works
>
> 1. wouldn't both units need buildschema if you wanted to build them
> automatically?  or is it only necessary to declare on one?  if so shouldn't
> it be a child of persistence not persistence-unit?
>

both need it


>
> 2. i never defined non jta before.  why do you need a jta and non jta?
> yes it would be better if it defaults to create them automatically for
> multiple PU
>

openjpa uses the nonjtadatasource to do the ddl (it is outside jta scope)

this is the case in tomee since I know the project so at least 7 years and
this is why we cant break it now - cause this default is used


>
> 3. again i assumed exclude-unlisted-classes to be the default because
> eclipse requires that entities are listed in persistence.xml, although it
> seems that really may not be the case and they are scanned


no, it is not the default, default is to scan.


>
>
> On 18/03/2018 18:50, Romain Manni-Bucau wrote:
>
>> Not sure I get the reproducer logic:
>>
>> 1. both units have buildSchema
>> 2. both units don't define a non jta datasource so openejb will create one
>> copying the first datasource and reuse the auto created non jta datasource
>> for the second one leading to use the same connection for both ("as
>> expected" even if i agree this is not the best default we picked)
>> 3. you dont deactivate jpa scanning so you find all tables anyway
>>
>> here is how to fix it:
>> https://gist.github.com/rmannibucau/57fd014e30ca003d62700348355dc647
>>
>>
>>
>>
>> Romain Manni-Bucau
>> @rmannibucau  |  Blog
>>  | Old Blog
>>  | Github <
>> https://github.com/rmannibucau> |
>> LinkedIn  | Book
>> > high-performance>
>>
>> 2018-03-17 18:44 GMT+01:00 Matthew Broadhead <
>> matthew.broadh...@nbmlaw.co.uk
>>
>>> :
>>> i made a reproducer here https://github.com/chongma/openjpa-reproducer.
>>> it might be enough to show the problem but if not let me know.
>>>
>>> it worked fine at the beginning using the standard archetype.
>>>
>>> adding the second pu seems to stop it from "view books present" (not
>>> persisting?)
>>> 
>>> bookshelfDatabase
>>> openJpaReproducer.entities.Bookshelf
>>>  
>>>  >> value="buildSchema(ForeignKeys=true)"/>
>>>  
>>>  
>>>
>>> logs show second table being created.  presumably in the book-pu because
>>> nothing has triggered bookshelf-pu?
>>> /*C1*/SET SCHEMA SYSTEM_LOBS
>>> INSERT INTO BLOCKS VALUES(0,2147483647,0)
>>> COMMIT
>>> /*C21*/SET SCHEMA PUBLIC
>>> CREATE TABLE Book (bookId INTEGER NOT NULL, bookTitle VARCHAR(255),
>>> PRIMARY KEY (bookId))
>>> CREATE TABLE Bookshelf (bookshelfId INTEGER NOT NULL, bookshelfTitle
>>> VARCHAR(255), PRIMARY KEY (bookshelfId))
>>> CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID TINYINT NOT NULL, SEQUENCE_VALUE
>>> BIGINT, PRIMARY KEY (ID))
>>> INSERT INTO OPENJPA_SEQUENCE_TABLE VALUES(0,1)
>>> COMMIT
>>> DELETE FROM OPENJPA_SEQUENCE_TABLE WHERE ID=0
>>> INSERT INTO OPENJPA_SEQUENCE_TABLE VALUES(0,51)
>>> COMMIT
>>> /*C11*/SET SCHEMA PUBLIC
>>> INSERT INTO BOOK VALUES(1,'asasas')
>>> COMMIT
>>> INSERT INTO BOOK VALUES(2,'dfdfd')
>>> COMMIT
>>> INSERT INTO BOOK VALUES(3,'lplplp')
>>> COMMIT
>>>
>>>
>>>
>>> On 17/03/2018 09:31, Matthew Broadhead wrote:
>>>
>>> ok will do

 On 17/03/2018 09:28, Romain Manni-Bucau wrote:

 Can you prepare a sample on github re1dy to compile/run (with hsqldb
> maybe)?
>
> Le 17 mars 2018 09:18, "Matthew Broadhead" <
> matthew.broadh...@nbmlaw.co.uk>
> a écrit :
>
> it is exactly the same.  still creating the tables in first db. here is
>
>> section from catalina
>>
>> 17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1]
>> org.apache.tomee.catalina.TomcatWebAppBuilder.init
>> - localhost -> /file
>> ...
>> 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
>> org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
>> resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to
>> Resource(id=jdbc/MySQL)
>> 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
>> org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
>> resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to
>> Resource(id=jdbc/MySQL)
>> 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
>> org.apache.openejb.config.AutoConfig.deploy Configuring
>> PersistenceUnit(name=file)
>> 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
>> org.apache.openejb.config.AutoConfig.deploy Configuring
>> PersistenceUnit(name=operator)
>> 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
>> org.apache.openejb.config.AppInfoBuilder.build 

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

thanks Romain, that works

1. wouldn't both units need buildschema if you wanted to build them 
automatically?  or is it only necessary to declare on one?  if so 
shouldn't it be a child of persistence not persistence-unit?


2. i never defined non jta before.  why do you need a jta and non jta?  
yes it would be better if it defaults to create them automatically for 
multiple PU


3. again i assumed exclude-unlisted-classes to be the default because 
eclipse requires that entities are listed in persistence.xml, although 
it seems that really may not be the case and they are scanned


On 18/03/2018 18:50, Romain Manni-Bucau wrote:

Not sure I get the reproducer logic:

1. both units have buildSchema
2. both units don't define a non jta datasource so openejb will create one
copying the first datasource and reuse the auto created non jta datasource
for the second one leading to use the same connection for both ("as
expected" even if i agree this is not the best default we picked)
3. you dont deactivate jpa scanning so you find all tables anyway

here is how to fix it:
https://gist.github.com/rmannibucau/57fd014e30ca003d62700348355dc647




Romain Manni-Bucau
@rmannibucau  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-17 18:44 GMT+01:00 Matthew Broadhead 
a écrit :

it is exactly the same.  still creating the tables in first db. here is

section from catalina

17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1]
org.apache.tomee.catalina.TomcatWebAppBuilder.init
- localhost -> /file
...
17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to
Resource(id=jdbc/MySQL)
17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to
Resource(id=jdbc/MySQL)
17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.deploy Configuring
PersistenceUnit(name=file)
17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.deploy Configuring
PersistenceUnit(name=operator)
17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
org.apache.openejb.config.AppInfoBuilder.build Enterprise application
"/Users/matthewbroadhead/eclipseWS/case-management/.metadata
/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file" loaded.
17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.Assembler.createApplication
Assembling app: /Users/matthewbroadhead/eclips
eWS/case-management/.metadata/.plugins/org.eclipse.wst.
server.core/tmp0/wtpwebapps/file
17-Mar-2018 09:10:53.551 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate

PersistenceUnit(name=file, provider=org.apache.openjpa.pe
rsistence.PersistenceProviderImpl) - provider time 49ms
17-Mar-2018 09:10:53.589 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate

PersistenceUnit(name=operator, provider=org.apache.openjpa.pe
rsistence.PersistenceProviderImpl) - 

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

Not sure I get the reproducer logic:

1. both units have buildSchema
2. both units don't define a non jta datasource so openejb will create one
copying the first datasource and reuse the auto created non jta datasource
for the second one leading to use the same connection for both ("as
expected" even if i agree this is not the best default we picked)
3. you dont deactivate jpa scanning so you find all tables anyway

here is how to fix it:
https://gist.github.com/rmannibucau/57fd014e30ca003d62700348355dc647




Romain Manni-Bucau
@rmannibucau  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-17 18:44 GMT+01:00 Matthew Broadhead :

> i made a reproducer here https://github.com/chongma/openjpa-reproducer.
> it might be enough to show the problem but if not let me know.
>
> it worked fine at the beginning using the standard archetype.
>
> adding the second pu seems to stop it from "view books present" (not
> persisting?)
> 
> bookshelfDatabase
> openJpaReproducer.entities.Bookshelf
> 
>  value="buildSchema(ForeignKeys=true)"/>
> 
> 
>
> logs show second table being created.  presumably in the book-pu because
> nothing has triggered bookshelf-pu?
> /*C1*/SET SCHEMA SYSTEM_LOBS
> INSERT INTO BLOCKS VALUES(0,2147483647,0)
> COMMIT
> /*C21*/SET SCHEMA PUBLIC
> CREATE TABLE Book (bookId INTEGER NOT NULL, bookTitle VARCHAR(255),
> PRIMARY KEY (bookId))
> CREATE TABLE Bookshelf (bookshelfId INTEGER NOT NULL, bookshelfTitle
> VARCHAR(255), PRIMARY KEY (bookshelfId))
> CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID TINYINT NOT NULL, SEQUENCE_VALUE
> BIGINT, PRIMARY KEY (ID))
> INSERT INTO OPENJPA_SEQUENCE_TABLE VALUES(0,1)
> COMMIT
> DELETE FROM OPENJPA_SEQUENCE_TABLE WHERE ID=0
> INSERT INTO OPENJPA_SEQUENCE_TABLE VALUES(0,51)
> COMMIT
> /*C11*/SET SCHEMA PUBLIC
> INSERT INTO BOOK VALUES(1,'asasas')
> COMMIT
> INSERT INTO BOOK VALUES(2,'dfdfd')
> COMMIT
> INSERT INTO BOOK VALUES(3,'lplplp')
> COMMIT
>
>
>
> On 17/03/2018 09:31, Matthew Broadhead wrote:
>
>> ok will do
>>
>> On 17/03/2018 09:28, Romain Manni-Bucau wrote:
>>
>>> Can you prepare a sample on github re1dy to compile/run (with hsqldb
>>> maybe)?
>>>
>>> Le 17 mars 2018 09:18, "Matthew Broadhead" <
>>> matthew.broadh...@nbmlaw.co.uk>
>>> a écrit :
>>>
>>> it is exactly the same.  still creating the tables in first db. here is
 section from catalina

 17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1]
 org.apache.tomee.catalina.TomcatWebAppBuilder.init
 - localhost -> /file
 ...
 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
 org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
 resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to
 Resource(id=jdbc/MySQL)
 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
 org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
 resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to
 Resource(id=jdbc/MySQL)
 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
 org.apache.openejb.config.AutoConfig.deploy Configuring
 PersistenceUnit(name=file)
 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
 org.apache.openejb.config.AutoConfig.deploy Configuring
 PersistenceUnit(name=operator)
 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
 org.apache.openejb.config.AppInfoBuilder.build Enterprise application
 "/Users/matthewbroadhead/eclipseWS/case-management/.metadata
 /.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file" loaded.
 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
 org.apache.openejb.assembler.classic.Assembler.createApplication
 Assembling app: /Users/matthewbroadhead/eclips
 eWS/case-management/.metadata/.plugins/org.eclipse.wst.
 server.core/tmp0/wtpwebapps/file
 17-Mar-2018 09:10:53.551 INFO [localhost-startStop-1]
 org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate

 PersistenceUnit(name=file, provider=org.apache.openjpa.pe
 rsistence.PersistenceProviderImpl) - provider time 49ms
 17-Mar-2018 09:10:53.589 INFO [localhost-startStop-1]
 org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate

 PersistenceUnit(name=operator, provider=org.apache.openjpa.pe
 rsistence.PersistenceProviderImpl) - provider time 38ms
 17-Mar-2018 09:10:53.637 INFO [localhost-startStop-1]
 org.apache.openejb.assembler.classic.JndiBuilder.bind
 Jndi(name=FileTimerLocalBean) --> Ejb(deployment-id=FileTimer)
 ...

 On 16/03/2018 22:36, Romain Manni-Bucau wrote:

 Can you try 

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

i made a reproducer here https://github.com/chongma/openjpa-reproducer.  
it might be enough to show the problem but if not let me know.


it worked fine at the beginning using the standard archetype.

adding the second pu seems to stop it from "view books present" (not 
persisting?)


bookshelfDatabase
openJpaReproducer.entities.Bookshelf
    
    value="buildSchema(ForeignKeys=true)"/>

    
    

logs show second table being created.  presumably in the book-pu because 
nothing has triggered bookshelf-pu?

/*C1*/SET SCHEMA SYSTEM_LOBS
INSERT INTO BLOCKS VALUES(0,2147483647,0)
COMMIT
/*C21*/SET SCHEMA PUBLIC
CREATE TABLE Book (bookId INTEGER NOT NULL, bookTitle VARCHAR(255), 
PRIMARY KEY (bookId))
CREATE TABLE Bookshelf (bookshelfId INTEGER NOT NULL, bookshelfTitle 
VARCHAR(255), PRIMARY KEY (bookshelfId))
CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID TINYINT NOT NULL, SEQUENCE_VALUE 
BIGINT, PRIMARY KEY (ID))

INSERT INTO OPENJPA_SEQUENCE_TABLE VALUES(0,1)
COMMIT
DELETE FROM OPENJPA_SEQUENCE_TABLE WHERE ID=0
INSERT INTO OPENJPA_SEQUENCE_TABLE VALUES(0,51)
COMMIT
/*C11*/SET SCHEMA PUBLIC
INSERT INTO BOOK VALUES(1,'asasas')
COMMIT
INSERT INTO BOOK VALUES(2,'dfdfd')
COMMIT
INSERT INTO BOOK VALUES(3,'lplplp')
COMMIT


On 17/03/2018 09:31, Matthew Broadhead wrote:

ok will do

On 17/03/2018 09:28, Romain Manni-Bucau wrote:
Can you prepare a sample on github re1dy to compile/run (with hsqldb 
maybe)?


Le 17 mars 2018 09:18, "Matthew Broadhead" 


a écrit :


it is exactly the same.  still creating the tables in first db. here is
section from catalina

17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1]
org.apache.tomee.catalina.TomcatWebAppBuilder.init
- localhost -> /file
...
17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to
Resource(id=jdbc/MySQL)
17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to
Resource(id=jdbc/MySQL)
17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.deploy Configuring
PersistenceUnit(name=file)
17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.deploy Configuring
PersistenceUnit(name=operator)
17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
org.apache.openejb.config.AppInfoBuilder.build Enterprise application
"/Users/matthewbroadhead/eclipseWS/case-management/.metadata
/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file" loaded.
17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.Assembler.createApplication
Assembling app: /Users/matthewbroadhead/eclips
eWS/case-management/.metadata/.plugins/org.eclipse.wst.
server.core/tmp0/wtpwebapps/file
17-Mar-2018 09:10:53.551 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate 


PersistenceUnit(name=file, provider=org.apache.openjpa.pe
rsistence.PersistenceProviderImpl) - provider time 49ms
17-Mar-2018 09:10:53.589 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate 


PersistenceUnit(name=operator, provider=org.apache.openjpa.pe
rsistence.PersistenceProviderImpl) - provider time 38ms
17-Mar-2018 09:10:53.637 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.JndiBuilder.bind
Jndi(name=FileTimerLocalBean) --> Ejb(deployment-id=FileTimer)
...

On 16/03/2018 22:36, Romain Manni-Bucau wrote:

Can you try setting non jta datasources? Duplicate the jta 
definition and
just set jtamanaged to false and size to solthing small. Guess it 
is the

issue

Le 16 mars 2018 19:49, "Matthew Broadhead" 

a écrit :

this is the bit just after all the webapp deployment, and the relevant

webapp deployment is in this gist https://gist.github.com/chongm
a/948a4a369c1f9eae9406a99b60f0472e
16-Mar-2018 15:41:29.068 INFO [main] sun.reflect.DelegatingMethodAc
cessorImpl.invoke
Server startup in 104519 ms
16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1]
org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers 
Chain

of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified.
OpenWebBeansELResolverComparator@43bde3b9 and the result order is
[org.apache.myfaces.el.unified.resolver.implicitobject.Impli
citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELR
esolver@420a4ab9,
org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40,
org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd, 


org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

Hi! This is the ezmlm program. I'm managing the
users@tomee.apache.org  mailing list.

I'm working for my owner, who can be reached
atusers-ow...@tomee.apache.org.

No information has been provided for this list.

--- Administrative commands for the users list ---

I can handle administrative requests automatically. Please
do not send them to the list address! Instead, send
your message to the correct command address:

To subscribe to the list, send a message to:
   

To remove your address from the list, send a message to:
   

Send mail to the following for info and FAQ for this list:
   
   

Similar addresses exist for the digest list:
   
   

To get messages 123 through 145 (a maximum of 100 per request), mail:
   

To get an index with subject and author for messages 123-456 , mail:
   

They are always returned as sets of 100, max 2000 per request,
so you'll actually get 100-499.

To receive all messages with the same subject as message 12345,
send a short message to:
   

The messages should contain one line or word of text to avoid being
treated as sp@m, but I will ignore their content.
Only the ADDRESS you send to is important.

You can start a subscription for an alternate address,
for example"john@host.domain", just add a hyphen and your
address (with '=' instead of '@') after the command word:

Re: [openjpa] multiple persistence units

[A Z]

Could someone please reply to me with the email address

to unsubscribe from the email list, please?



From: Romain Manni-Bucau <rmannibu...@gmail.com>
Sent: Saturday, 17 March 2018 7:28 PM
To: users@tomee.apache.org
Subject: Re: [openjpa] multiple persistence units

Can you prepare a sample on github re1dy to compile/run (with hsqldb maybe)?

Le 17 mars 2018 09:18, "Matthew Broadhead" <matthew.broadh...@nbmlaw.co.uk>
a écrit :

> it is exactly the same.  still creating the tables in first db. here is
> section from catalina
>
> 17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1]
> org.apache.tomee.catalina.TomcatWebAppBuilder.init
> - localhost -> /file
> ...
> 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
> org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
> resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to
> Resource(id=jdbc/MySQL)
> 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
> org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
> resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to
> Resource(id=jdbc/MySQL)
> 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
> org.apache.openejb.config.AutoConfig.deploy Configuring
> PersistenceUnit(name=file)
> 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
> org.apache.openejb.config.AutoConfig.deploy Configuring
> PersistenceUnit(name=operator)
> 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
> org.apache.openejb.config.AppInfoBuilder.build Enterprise application
> "/Users/matthewbroadhead/eclipseWS/case-management/.metadata
> /.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file" loaded.
> 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
> org.apache.openejb.assembler.classic.Assembler.createApplication
> Assembling app: /Users/matthewbroadhead/eclips
> eWS/case-management/.metadata/.plugins/org.eclipse.wst.
> server.core/tmp0/wtpwebapps/file
> 17-Mar-2018 09:10:53.551 INFO [localhost-startStop-1]
> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate
> PersistenceUnit(name=file, provider=org.apache.openjpa.pe
> rsistence.PersistenceProviderImpl) - provider time 49ms
> 17-Mar-2018 09:10:53.589 INFO [localhost-startStop-1]
> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate
> PersistenceUnit(name=operator, provider=org.apache.openjpa.pe
> rsistence.PersistenceProviderImpl) - provider time 38ms
> 17-Mar-2018 09:10:53.637 INFO [localhost-startStop-1]
> org.apache.openejb.assembler.classic.JndiBuilder.bind
> Jndi(name=FileTimerLocalBean) --> Ejb(deployment-id=FileTimer)
> ...
>
> On 16/03/2018 22:36, Romain Manni-Bucau wrote:
>
>> Can you try setting non jta datasources? Duplicate the jta definition and
>> just set jtamanaged to false and size to solthing small. Guess it is the
>> issue
>>
>> Le 16 mars 2018 19:49, "Matthew Broadhead" <matthew.broadh...@nbmlaw.co.u
>> k>
>> a écrit :
>>
>> this is the bit just after all the webapp deployment, and the relevant
>>> webapp deployment is in this gist https://gist.github.com/chongm
>>> a/948a4a369c1f9eae9406a99b60f0472e
>>> 16-Mar-2018 15:41:29.068 INFO [main] sun.reflect.DelegatingMethodAc
>>> cessorImpl.invoke
>>> Server startup in 104519 ms
>>> 16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1]
>>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
>>> of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified.
>>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
>>> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
>>> citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELR
>>> esolver@420a4ab9,
>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40,
>>> org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd,
>>> org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
>>> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
>>> org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,
>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
>>> 16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1]
>>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
>>> of EL resolvers for Faces sorted with: org.apache.myfaces.el.unified.
>>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
>>> [org.apache.myfaces.el.unified.resolver.implicitobj

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

ok will do

On 17/03/2018 09:28, Romain Manni-Bucau wrote:

Can you prepare a sample on github re1dy to compile/run (with hsqldb maybe)?

Le 17 mars 2018 09:18, "Matthew Broadhead" 
a écrit :


it is exactly the same.  still creating the tables in first db. here is
section from catalina

17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1]
org.apache.tomee.catalina.TomcatWebAppBuilder.init
- localhost -> /file
...
17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to
Resource(id=jdbc/MySQL)
17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to
Resource(id=jdbc/MySQL)
17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.deploy Configuring
PersistenceUnit(name=file)
17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
org.apache.openejb.config.AutoConfig.deploy Configuring
PersistenceUnit(name=operator)
17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
org.apache.openejb.config.AppInfoBuilder.build Enterprise application
"/Users/matthewbroadhead/eclipseWS/case-management/.metadata
/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file" loaded.
17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.Assembler.createApplication
Assembling app: /Users/matthewbroadhead/eclips
eWS/case-management/.metadata/.plugins/org.eclipse.wst.
server.core/tmp0/wtpwebapps/file
17-Mar-2018 09:10:53.551 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate
PersistenceUnit(name=file, provider=org.apache.openjpa.pe
rsistence.PersistenceProviderImpl) - provider time 49ms
17-Mar-2018 09:10:53.589 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate
PersistenceUnit(name=operator, provider=org.apache.openjpa.pe
rsistence.PersistenceProviderImpl) - provider time 38ms
17-Mar-2018 09:10:53.637 INFO [localhost-startStop-1]
org.apache.openejb.assembler.classic.JndiBuilder.bind
Jndi(name=FileTimerLocalBean) --> Ejb(deployment-id=FileTimer)
...

On 16/03/2018 22:36, Romain Manni-Bucau wrote:


Can you try setting non jta datasources? Duplicate the jta definition and
just set jtamanaged to false and size to solthing small. Guess it is the
issue

Le 16 mars 2018 19:49, "Matthew Broadhead" 
a écrit :

this is the bit just after all the webapp deployment, and the relevant

webapp deployment is in this gist https://gist.github.com/chongm
a/948a4a369c1f9eae9406a99b60f0472e
16-Mar-2018 15:41:29.068 INFO [main] sun.reflect.DelegatingMethodAc
cessorImpl.invoke
Server startup in 104519 ms
16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1]
org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified.
OpenWebBeansELResolverComparator@43bde3b9 and the result order is
[org.apache.myfaces.el.unified.resolver.implicitobject.Impli
citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELR
esolver@420a4ab9,
org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40,
org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd,
org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,
org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1]
org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
of EL resolvers for Faces sorted with: org.apache.myfaces.el.unified.
OpenWebBeansELResolverComparator@43bde3b9 and the result order is
[org.apache.myfaces.el.unified.resolver.implicitobject.Impli
citObjectResolver@1db5922e, org.apache.myfaces.el.unified.
resolver.CompositeComponentELResolver@9235f63,
org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0,
org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311,
org.apache.myfaces.el.FlashELResolver@38d794e5,
org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb,
org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1,
javax.el.ResourceBundleELResolver@3ad1a339,
org.apache.myfaces.el.unified.
resolver.ResourceBundleResolver@3e25683a, org.apache.el.stream.StreamELR
esolverImpl@759451f1, javax.el.StaticFieldELResolver@5592c7ac,
javax.el.MapELResolver@62ed6e4c, javax.el.ListELResolver@771cae93,
javax.el.ArrayELResolver@20506258, javax.el.BeanELResolver@633c6e59]
16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1]

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

Can you prepare a sample on github re1dy to compile/run (with hsqldb maybe)?

Le 17 mars 2018 09:18, "Matthew Broadhead" 
a écrit :

> it is exactly the same.  still creating the tables in first db. here is
> section from catalina
>
> 17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1]
> org.apache.tomee.catalina.TomcatWebAppBuilder.init
> - localhost -> /file
> ...
> 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
> org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
> resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to
> Resource(id=jdbc/MySQL)
> 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1]
> org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking
> resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to
> Resource(id=jdbc/MySQL)
> 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
> org.apache.openejb.config.AutoConfig.deploy Configuring
> PersistenceUnit(name=file)
> 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1]
> org.apache.openejb.config.AutoConfig.deploy Configuring
> PersistenceUnit(name=operator)
> 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
> org.apache.openejb.config.AppInfoBuilder.build Enterprise application
> "/Users/matthewbroadhead/eclipseWS/case-management/.metadata
> /.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file" loaded.
> 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1]
> org.apache.openejb.assembler.classic.Assembler.createApplication
> Assembling app: /Users/matthewbroadhead/eclips
> eWS/case-management/.metadata/.plugins/org.eclipse.wst.
> server.core/tmp0/wtpwebapps/file
> 17-Mar-2018 09:10:53.551 INFO [localhost-startStop-1]
> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate
> PersistenceUnit(name=file, provider=org.apache.openjpa.pe
> rsistence.PersistenceProviderImpl) - provider time 49ms
> 17-Mar-2018 09:10:53.589 INFO [localhost-startStop-1]
> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate
> PersistenceUnit(name=operator, provider=org.apache.openjpa.pe
> rsistence.PersistenceProviderImpl) - provider time 38ms
> 17-Mar-2018 09:10:53.637 INFO [localhost-startStop-1]
> org.apache.openejb.assembler.classic.JndiBuilder.bind
> Jndi(name=FileTimerLocalBean) --> Ejb(deployment-id=FileTimer)
> ...
>
> On 16/03/2018 22:36, Romain Manni-Bucau wrote:
>
>> Can you try setting non jta datasources? Duplicate the jta definition and
>> just set jtamanaged to false and size to solthing small. Guess it is the
>> issue
>>
>> Le 16 mars 2018 19:49, "Matthew Broadhead" > k>
>> a écrit :
>>
>> this is the bit just after all the webapp deployment, and the relevant
>>> webapp deployment is in this gist https://gist.github.com/chongm
>>> a/948a4a369c1f9eae9406a99b60f0472e
>>> 16-Mar-2018 15:41:29.068 INFO [main] sun.reflect.DelegatingMethodAc
>>> cessorImpl.invoke
>>> Server startup in 104519 ms
>>> 16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1]
>>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
>>> of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified.
>>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
>>> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
>>> citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELR
>>> esolver@420a4ab9,
>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40,
>>> org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd,
>>> org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
>>> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
>>> org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,
>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
>>> 16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1]
>>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
>>> of EL resolvers for Faces sorted with: org.apache.myfaces.el.unified.
>>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
>>> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
>>> citObjectResolver@1db5922e, org.apache.myfaces.el.unified.
>>> resolver.CompositeComponentELResolver@9235f63,
>>> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
>>> org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0,
>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311,
>>> org.apache.myfaces.el.FlashELResolver@38d794e5,
>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb,
>>> org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1,
>>> javax.el.ResourceBundleELResolver@3ad1a339,
>>> org.apache.myfaces.el.unified.
>>> resolver.ResourceBundleResolver@3e25683a, org.apache.el.stream.StreamELR
>>> esolverImpl@759451f1, javax.el.StaticFieldELResolver@5592c7ac,
>>> javax.el.MapELResolver@62ed6e4c, 

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

it is exactly the same.  still creating the tables in first db. here is 
section from catalina


17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1] 
org.apache.tomee.catalina.TomcatWebAppBuilder.init 
- localhost -> /file

...
17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1] 
org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking 
resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to 
Resource(id=jdbc/MySQL)
17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1] 
org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking 
resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to 
Resource(id=jdbc/MySQL)
17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1] 
org.apache.openejb.config.AutoConfig.deploy Configuring 
PersistenceUnit(name=file)
17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1] 
org.apache.openejb.config.AutoConfig.deploy Configuring 
PersistenceUnit(name=operator)
17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1] 
org.apache.openejb.config.AppInfoBuilder.build Enterprise application 
"/Users/matthewbroadhead/eclipseWS/case-management/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file" 
loaded.
17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1] 
org.apache.openejb.assembler.classic.Assembler.createApplication 
Assembling app: 
/Users/matthewbroadhead/eclipseWS/case-management/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file
17-Mar-2018 09:10:53.551 INFO [localhost-startStop-1] 
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate 
PersistenceUnit(name=file, 
provider=org.apache.openjpa.persistence.PersistenceProviderImpl) - 
provider time 49ms
17-Mar-2018 09:10:53.589 INFO [localhost-startStop-1] 
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate 
PersistenceUnit(name=operator, 
provider=org.apache.openjpa.persistence.PersistenceProviderImpl) - 
provider time 38ms
17-Mar-2018 09:10:53.637 INFO [localhost-startStop-1] 
org.apache.openejb.assembler.classic.JndiBuilder.bind 
Jndi(name=FileTimerLocalBean) --> Ejb(deployment-id=FileTimer)

...

On 16/03/2018 22:36, Romain Manni-Bucau wrote:

Can you try setting non jta datasources? Duplicate the jta definition and
just set jtamanaged to false and size to solthing small. Guess it is the
issue

Le 16 mars 2018 19:49, "Matthew Broadhead" 
a écrit :


this is the bit just after all the webapp deployment, and the relevant
webapp deployment is in this gist https://gist.github.com/chongm
a/948a4a369c1f9eae9406a99b60f0472e
16-Mar-2018 15:41:29.068 INFO [main] 
sun.reflect.DelegatingMethodAccessorImpl.invoke
Server startup in 104519 ms
16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1]
org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified.
OpenWebBeansELResolverComparator@43bde3b9 and the result order is
[org.apache.myfaces.el.unified.resolver.implicitobject.Impli
citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELResolver@420a4ab9,
org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40,
org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd,
org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,
org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1]
org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
of EL resolvers for Faces sorted with: org.apache.myfaces.el.unified.
OpenWebBeansELResolverComparator@43bde3b9 and the result order is
[org.apache.myfaces.el.unified.resolver.implicitobject.Impli
citObjectResolver@1db5922e, org.apache.myfaces.el.unified.
resolver.CompositeComponentELResolver@9235f63,
org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0,
org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311,
org.apache.myfaces.el.FlashELResolver@38d794e5,
org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb,
org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1,
javax.el.ResourceBundleELResolver@3ad1a339, org.apache.myfaces.el.unified.
resolver.ResourceBundleResolver@3e25683a, org.apache.el.stream.StreamELR
esolverImpl@759451f1, javax.el.StaticFieldELResolver@5592c7ac,
javax.el.MapELResolver@62ed6e4c, javax.el.ListELResolver@771cae93,
javax.el.ArrayELResolver@20506258, javax.el.BeanELResolver@633c6e59]
16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1]
javax.faces.component._ExternalSpecifications.isBeanValidationAvailable
MyFaces Bean Validation support enabled
16-Mar-2018 15:43:21.686 INFO [http-nio-8080-exec-1]
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
TABLE box ADD 

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

Can you try setting non jta datasources? Duplicate the jta definition and
just set jtamanaged to false and size to solthing small. Guess it is the
issue

Le 16 mars 2018 19:49, "Matthew Broadhead" 
a écrit :

> this is the bit just after all the webapp deployment, and the relevant
> webapp deployment is in this gist https://gist.github.com/chongm
> a/948a4a369c1f9eae9406a99b60f0472e
> 16-Mar-2018 15:41:29.068 INFO [main] 
> sun.reflect.DelegatingMethodAccessorImpl.invoke
> Server startup in 104519 ms
> 16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1]
> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
> of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified.
> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
> citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELResolver@420a4ab9,
> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40,
> org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd,
> org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
> org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,
> org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
> 16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1]
> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
> of EL resolvers for Faces sorted with: org.apache.myfaces.el.unified.
> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
> citObjectResolver@1db5922e, org.apache.myfaces.el.unified.
> resolver.CompositeComponentELResolver@9235f63,
> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
> org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0,
> org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311,
> org.apache.myfaces.el.FlashELResolver@38d794e5,
> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb,
> org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1,
> javax.el.ResourceBundleELResolver@3ad1a339, org.apache.myfaces.el.unified.
> resolver.ResourceBundleResolver@3e25683a, org.apache.el.stream.StreamELR
> esolverImpl@759451f1, javax.el.StaticFieldELResolver@5592c7ac,
> javax.el.MapELResolver@62ed6e4c, javax.el.ListELResolver@771cae93,
> javax.el.ArrayELResolver@20506258, javax.el.BeanELResolver@633c6e59]
> 16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1]
> javax.faces.component._ExternalSpecifications.isBeanValidationAvailable
> MyFaces Bean Validation support enabled
> 16-Mar-2018 15:43:21.686 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE box ADD finishedId INTEGER --> 182ms
> 16-Mar-2018 15:43:22.037 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE box ADD userId INTEGER --> 348ms
> 16-Mar-2018 15:43:22.250 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE box ADD version BIGINT --> 211ms
> 16-Mar-2018 15:43:22.459 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE category ADD version BIGINT --> 205ms
> 16-Mar-2018 15:43:22.594 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE cqsreview ADD version BIGINT --> 132ms
> 16-Mar-2018 15:43:22.866 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE department ADD version BIGINT --> 270ms
> 16-Mar-2018 15:43:26.886 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE event ADD userId INTEGER --> 4017ms
> 16-Mar-2018 15:43:30.978 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE event ADD version BIGINT --> 4088ms
> 16-Mar-2018 15:43:31.223 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE eventtype ADD version BIGINT --> 241ms
> 16-Mar-2018 15:43:31.959 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE file ADD version BIGINT --> 733ms
> 16-Mar-2018 15:43:32.552 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE log ADD userId INTEGER --> 590ms
> 16-Mar-2018 15:43:33.237 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE log ADD version BIGINT --> 682ms
> 16-Mar-2018 15:43:34.606 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE note ADD userId INTEGER --> 1364ms
> 16-Mar-2018 

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

this is the bit just after all the webapp deployment, and the relevant 
webapp deployment is in this gist 
https://gist.github.com/chongma/948a4a369c1f9eae9406a99b60f0472e
16-Mar-2018 15:41:29.068 INFO [main] 
sun.reflect.DelegatingMethodAccessorImpl.invoke Server startup in 104519 ms
16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1] 
org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain 
of EL resolvers for JSP sorted with: 
org.apache.myfaces.el.unified.OpenWebBeansELResolverComparator@43bde3b9 
and the result order is 
[org.apache.myfaces.el.unified.resolver.implicitobject.ImplicitObjectResolver@e6ec1ab, 
org.apache.myfaces.el.FlashELResolver@420a4ab9, 
org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40, 
org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd, 
org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71, 
org.apache.webbeans.el22.WebBeansELResolver@2fa764a7, 
org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9, 
org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1] 
org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain 
of EL resolvers for Faces sorted with: 
org.apache.myfaces.el.unified.OpenWebBeansELResolverComparator@43bde3b9 
and the result order is 
[org.apache.myfaces.el.unified.resolver.implicitobject.ImplicitObjectResolver@1db5922e, 
org.apache.myfaces.el.unified.resolver.CompositeComponentELResolver@9235f63, 
org.apache.webbeans.el22.WebBeansELResolver@2fa764a7, 
org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0, 
org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311, 
org.apache.myfaces.el.FlashELResolver@38d794e5, 
org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb, 
org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1, 
javax.el.ResourceBundleELResolver@3ad1a339, 
org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@3e25683a, 
org.apache.el.stream.StreamELResolverImpl@759451f1, 
javax.el.StaticFieldELResolver@5592c7ac, 
javax.el.MapELResolver@62ed6e4c, javax.el.ListELResolver@771cae93, 
javax.el.ArrayELResolver@20506258, javax.el.BeanELResolver@633c6e59]
16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1] 
javax.faces.component._ExternalSpecifications.isBeanValidationAvailable 
MyFaces Bean Validation support enabled
16-Mar-2018 15:43:21.686 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE box ADD finishedId INTEGER --> 182ms
16-Mar-2018 15:43:22.037 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE box ADD userId INTEGER --> 348ms
16-Mar-2018 15:43:22.250 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE box ADD version BIGINT --> 211ms
16-Mar-2018 15:43:22.459 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE category ADD version BIGINT --> 205ms
16-Mar-2018 15:43:22.594 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE cqsreview ADD version BIGINT --> 132ms
16-Mar-2018 15:43:22.866 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE department ADD version BIGINT --> 270ms
16-Mar-2018 15:43:26.886 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE event ADD userId INTEGER --> 4017ms
16-Mar-2018 15:43:30.978 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE event ADD version BIGINT --> 4088ms
16-Mar-2018 15:43:31.223 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE eventtype ADD version BIGINT --> 241ms
16-Mar-2018 15:43:31.959 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE file ADD version BIGINT --> 733ms
16-Mar-2018 15:43:32.552 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE log ADD userId INTEGER --> 590ms
16-Mar-2018 15:43:33.237 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE log ADD version BIGINT --> 682ms
16-Mar-2018 15:43:34.606 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE note ADD userId INTEGER --> 1364ms
16-Mar-2018 15:43:36.223 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE note ADD version BIGINT --> 1426ms
16-Mar-2018 15:43:36.493 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE undertaking ADD userId INTEGER --> 266ms
16-Mar-2018 

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

Hmm, i dont see the startup logs, typically it is in catalina.log or so,
you should have lines about your webapp deployment too.


Romain Manni-Bucau
@rmannibucau  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-16 15:44 GMT+01:00 Matthew Broadhead :

> this is all that came out
> 16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1]
> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
> of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified.
> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
> citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELResolver@420a4ab9,
> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40,
> org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd,
> org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
> org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,
> org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
> 16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1]
> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
> of EL resolvers for Faces sorted with: org.apache.myfaces.el.unified.
> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
> citObjectResolver@1db5922e, org.apache.myfaces.el.unified.
> resolver.CompositeComponentELResolver@9235f63,
> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
> org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0,
> org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311,
> org.apache.myfaces.el.FlashELResolver@38d794e5,
> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb,
> org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1,
> javax.el.ResourceBundleELResolver@3ad1a339, org.apache.myfaces.el.unified.
> resolver.ResourceBundleResolver@3e25683a, org.apache.el.stream.StreamELR
> esolverImpl@759451f1, javax.el.StaticFieldELResolver@5592c7ac,
> javax.el.MapELResolver@62ed6e4c, javax.el.ListELResolver@771cae93,
> javax.el.ArrayELResolver@20506258, javax.el.BeanELResolver@633c6e59]
> 16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1]
> javax.faces.component._ExternalSpecifications.isBeanValidationAvailable
> MyFaces Bean Validation support enabled
> 16-Mar-2018 15:43:21.686 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE box ADD finishedId INTEGER --> 182ms
> 16-Mar-2018 15:43:22.037 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE box ADD userId INTEGER --> 348ms
> 16-Mar-2018 15:43:22.250 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE box ADD version BIGINT --> 211ms
> 16-Mar-2018 15:43:22.459 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE category ADD version BIGINT --> 205ms
> 16-Mar-2018 15:43:22.594 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE cqsreview ADD version BIGINT --> 132ms
> 16-Mar-2018 15:43:22.866 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE department ADD version BIGINT --> 270ms
> 16-Mar-2018 15:43:26.886 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE event ADD userId INTEGER --> 4017ms
> 16-Mar-2018 15:43:30.978 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE event ADD version BIGINT --> 4088ms
> 16-Mar-2018 15:43:31.223 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE eventtype ADD version BIGINT --> 241ms
> 16-Mar-2018 15:43:31.959 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE file ADD version BIGINT --> 733ms
> 16-Mar-2018 15:43:32.552 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE log ADD userId INTEGER --> 590ms
> 16-Mar-2018 15:43:33.237 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE log ADD version BIGINT --> 682ms
> 16-Mar-2018 15:43:34.606 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE note ADD 

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

this is all that came out
16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1] 
org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain 
of EL resolvers for JSP sorted with: 
org.apache.myfaces.el.unified.OpenWebBeansELResolverComparator@43bde3b9 
and the result order is 
[org.apache.myfaces.el.unified.resolver.implicitobject.ImplicitObjectResolver@e6ec1ab, 
org.apache.myfaces.el.FlashELResolver@420a4ab9, 
org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40, 
org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd, 
org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71, 
org.apache.webbeans.el22.WebBeansELResolver@2fa764a7, 
org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9, 
org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1] 
org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain 
of EL resolvers for Faces sorted with: 
org.apache.myfaces.el.unified.OpenWebBeansELResolverComparator@43bde3b9 
and the result order is 
[org.apache.myfaces.el.unified.resolver.implicitobject.ImplicitObjectResolver@1db5922e, 
org.apache.myfaces.el.unified.resolver.CompositeComponentELResolver@9235f63, 
org.apache.webbeans.el22.WebBeansELResolver@2fa764a7, 
org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0, 
org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311, 
org.apache.myfaces.el.FlashELResolver@38d794e5, 
org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb, 
org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1, 
javax.el.ResourceBundleELResolver@3ad1a339, 
org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@3e25683a, 
org.apache.el.stream.StreamELResolverImpl@759451f1, 
javax.el.StaticFieldELResolver@5592c7ac, 
javax.el.MapELResolver@62ed6e4c, javax.el.ListELResolver@771cae93, 
javax.el.ArrayELResolver@20506258, javax.el.BeanELResolver@633c6e59]
16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1] 
javax.faces.component._ExternalSpecifications.isBeanValidationAvailable 
MyFaces Bean Validation support enabled
16-Mar-2018 15:43:21.686 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE box ADD finishedId INTEGER --> 182ms
16-Mar-2018 15:43:22.037 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE box ADD userId INTEGER --> 348ms
16-Mar-2018 15:43:22.250 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE box ADD version BIGINT --> 211ms
16-Mar-2018 15:43:22.459 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE category ADD version BIGINT --> 205ms
16-Mar-2018 15:43:22.594 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE cqsreview ADD version BIGINT --> 132ms
16-Mar-2018 15:43:22.866 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE department ADD version BIGINT --> 270ms
16-Mar-2018 15:43:26.886 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE event ADD userId INTEGER --> 4017ms
16-Mar-2018 15:43:30.978 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE event ADD version BIGINT --> 4088ms
16-Mar-2018 15:43:31.223 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE eventtype ADD version BIGINT --> 241ms
16-Mar-2018 15:43:31.959 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE file ADD version BIGINT --> 733ms
16-Mar-2018 15:43:32.552 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE log ADD userId INTEGER --> 590ms
16-Mar-2018 15:43:33.237 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE log ADD version BIGINT --> 682ms
16-Mar-2018 15:43:34.606 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE note ADD userId INTEGER --> 1364ms
16-Mar-2018 15:43:36.223 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE note ADD version BIGINT --> 1426ms
16-Mar-2018 15:43:36.493 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE undertaking ADD userId INTEGER --> 266ms
16-Mar-2018 15:43:36.725 INFO [http-nio-8080-exec-1] 
org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 
ALTER TABLE undertaking ADD version BIGINT --> 229ms
16-Mar-2018 15:43:36.897 INFO [http-nio-8080-exec-1] 

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

sorry actually it is already writing to file and console.  i will see if 
i can get it more verbose


On 16/03/2018 15:34, Matthew Broadhead wrote:
is there a way to output tomee logs to file?  i am using eclipse and 
they will get swallowed by console.


On 16/03/2018 14:58, Romain Manni-Bucau wrote:

was more thinking about tomee startup/deployment logs


Romain Manni-Bucau
@rmannibucau  |  Blog
 | Old Blog
 | Github 
 |

LinkedIn  | Book
 



2018-03-16 14:44 GMT+01:00 Matthew Broadhead 
 getColumns: conveyancing, null, 
payment, null
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading

column information for table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Found

existing column "id" on table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Found

existing column "categoryid" on table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Found

existing column "name" on table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Found

existing column "value" on table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading

sequence information for schema "null", sequence name "null".
216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  [0 ms] commit
216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading

table information for schema name "null", table name "Operator".
216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  getColumns: conveyancing, null, Operator,
null
216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading

sequence information for schema "null", sequence name "null".
216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  [0 ms] commit
216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading

table information for schema name "null", table name "Council".
216082  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> getColumns: conveyancing, null, 
Council, null
216082  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading

sequence information for schema "null", sequence name "null".
216083  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  [0 ms] commit
216083  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading

table information for schema name "null", table name "Client".
216084  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> getColumns: conveyancing, null, 
Client, null
216085  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading

sequence information for schema "null", sequence name "null".
216086  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  [0 ms] commit
216087  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading

table information for schema name "null", table name "event".
216087  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> getColumns: conveyancing, null, event, 
null


also i wondered if i should move the second persistence unit into 
a jar

file to see if it made any difference


shouldnt




On 16/03/2018 14:08, Romain Manni-Bucau wrote:

do you have some "adjusting" lines in the logs?


Romain Manni-Bucau
@rmannibucau  | Blog
 | Old Blog
 | Github <

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

is there a way to output tomee logs to file?  i am using eclipse and 
they will get swallowed by console.


On 16/03/2018 14:58, Romain Manni-Bucau wrote:

was more thinking about tomee startup/deployment logs


Romain Manni-Bucau
@rmannibucau  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-16 14:44 GMT+01:00 Matthew Broadhead  |  Blog
 | Old Blog
 | Github <
https://github.com/rmannibucau> |
LinkedIn  | Book


2018-03-16 12:25 GMT+01:00 Matthew Broadhead <
matthew.broadh...@nbmlaw.co.uk

:

the relevant part of the log seems to be:

231734  file  TRACE  

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

was more thinking about tomee startup/deployment logs


Romain Manni-Bucau
@rmannibucau  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-16 14:44 GMT+01:00 Matthew Broadhead :

> https://gist.github.com/chongma/f019380ec6109d566b8b3444a41814eb
>
>
> On 16/03/2018 14:37, Romain Manni-Bucau wrote:
>
>> 2018-03-16 14:30 GMT+01:00 Matthew Broadhead <
>> matthew.broadh...@nbmlaw.co.uk
>>
>>> :
>>> i searched for adjusting but found nothing.  do you want to see the whole
>>> log file?  can the mailing list take attachments or do i have to send it
>>> another way?
>>>
>>
>> a gist/pastebin would be fine
>>
>>
>>it has some stuff like this:
>>> 216070  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> [0 ms] commit
>>> 216070  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> table information for schema name "null", table name "Posttown".
>>> 216070  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> getColumns: conveyancing, null, Posttown,
>>> null
>>> 216071  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> sequence information for schema "null", sequence name "null".
>>> 216072  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> [0 ms] commit
>>> 216072  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> table information for schema name "null", table name "payment".
>>> 216072  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> getColumns: conveyancing, null, payment, null
>>> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> column information for table "payment".
>>> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found
>>> existing column "id" on table "payment".
>>> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found
>>> existing column "categoryid" on table "payment".
>>> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found
>>> existing column "name" on table "payment".
>>> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found
>>> existing column "value" on table "payment".
>>> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> sequence information for schema "null", sequence name "null".
>>> 216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> [0 ms] commit
>>> 216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> table information for schema name "null", table name "Operator".
>>> 216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> getColumns: conveyancing, null, Operator,
>>> null
>>> 216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> sequence information for schema "null", sequence name "null".
>>> 216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> [0 ms] commit
>>> 216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> table information for schema name "null", table name "Council".
>>> 216082  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> getColumns: conveyancing, null, Council, null
>>> 216082  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> sequence information for schema "null", sequence name "null".
>>> 216083  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> [0 ms] commit
>>> 216083  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> table information for schema name "null", table name "Client".
>>> 216084  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> getColumns: conveyancing, null, Client, null
>>> 216085  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> sequence information for schema "null", sequence name "null".
>>> 216086  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> [0 ms] commit
>>> 216087  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
>>> table information for schema name "null", table name "event".
>>> 216087  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >> 145697756, conn 1016116032> getColumns: conveyancing, null, event, null
>>>
>>> also i wondered if i should move the second persistence unit into a jar
>>> file to see if it made any difference
>>>
>>
>> shouldnt
>>
>>
>>
>>> On 16/03/2018 14:08, Romain Manni-Bucau wrote:
>>>
>>> do you have some "adjusting" lines in the logs?


 Romain 

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

https://gist.github.com/chongma/f019380ec6109d566b8b3444a41814eb

On 16/03/2018 14:37, Romain Manni-Bucau wrote:

2018-03-16 14:30 GMT+01:00 Matthew Broadhead  |  Blog
 | Old Blog
 | Github <
https://github.com/rmannibucau> |
LinkedIn  | Book


2018-03-16 12:25 GMT+01:00 Matthew Broadhead <
matthew.broadh...@nbmlaw.co.uk


:
the relevant part of the log seems to be:

231734  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  executing stmnt 2028257349 CREATE TABLE
Address
(address_n INTEGER NOT NULL, district VARCHAR(26), num_in_st VARCHAR(11),
postcode VARCHAR(8), road VARCHAR(26), telephone VARCHAR(13), title_no_1
VARCHAR(9), title_no_2 VARCHAR(9), title_no_3 VARCHAR(9), unit
VARCHAR(30),
posttown_n INTEGER, PRIMARY KEY (address_n)) ENGINE = innodb
231901  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  [167 ms] spent
231901  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  [0 ms] commit
231901  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  [0 ms] close
231902  file  TRACE  

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

2018-03-16 14:30 GMT+01:00 Matthew Broadhead :

> i searched for adjusting but found nothing.  do you want to see the whole
> log file?  can the mailing list take attachments or do i have to send it
> another way?


a gist/pastebin would be fine


>   it has some stuff like this:
> 216070  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> [0 ms] commit
> 216070  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> table information for schema name "null", table name "Posttown".
> 216070  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> getColumns: conveyancing, null, Posttown, null
> 216071  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> sequence information for schema "null", sequence name "null".
> 216072  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> [0 ms] commit
> 216072  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> table information for schema name "null", table name "payment".
> 216072  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> getColumns: conveyancing, null, payment, null
> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> column information for table "payment".
> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found
> existing column "id" on table "payment".
> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found
> existing column "categoryid" on table "payment".
> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found
> existing column "name" on table "payment".
> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found
> existing column "value" on table "payment".
> 216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> sequence information for schema "null", sequence name "null".
> 216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> [0 ms] commit
> 216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> table information for schema name "null", table name "Operator".
> 216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> getColumns: conveyancing, null, Operator, null
> 216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> sequence information for schema "null", sequence name "null".
> 216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> [0 ms] commit
> 216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> table information for schema name "null", table name "Council".
> 216082  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> getColumns: conveyancing, null, Council, null
> 216082  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> sequence information for schema "null", sequence name "null".
> 216083  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> [0 ms] commit
> 216083  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> table information for schema name "null", table name "Client".
> 216084  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> getColumns: conveyancing, null, Client, null
> 216085  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> sequence information for schema "null", sequence name "null".
> 216086  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> [0 ms] commit
> 216087  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Reading
> table information for schema name "null", table name "event".
> 216087  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1016116032> getColumns: conveyancing, null, event, null
>
> also i wondered if i should move the second persistence unit into a jar
> file to see if it made any difference


shouldnt


>
>
> On 16/03/2018 14:08, Romain Manni-Bucau wrote:
>
>> do you have some "adjusting" lines in the logs?
>>
>>
>> Romain Manni-Bucau
>> @rmannibucau  |  Blog
>>  | Old Blog
>>  | Github <
>> https://github.com/rmannibucau> |
>> LinkedIn  | Book
>> > high-performance>
>>
>> 2018-03-16 12:25 GMT+01:00 Matthew Broadhead <
>> matthew.broadh...@nbmlaw.co.uk
>>
>>> :
>>> the relevant part of the log seems to be:
>>>
>>> 231734  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - >> 145697756, conn 865011519> executing stmnt 2028257349 CREATE TABLE
>>> Address
>>> (address_n INTEGER NOT NULL, district VARCHAR(26), num_in_st VARCHAR(11),
>>> postcode VARCHAR(8), road VARCHAR(26), telephone 

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

i searched for adjusting but found nothing.  do you want to see the 
whole log file?  can the mailing list take attachments or do i have to 
send it another way?  it has some stuff like this:
216070  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> [0 ms] commit
216070  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading table information for schema name "null", table name "Posttown".
216070  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> getColumns: conveyancing, null, Posttown, null
216071  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading sequence information for schema "null", sequence name "null".
216072  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> [0 ms] commit
216072  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading table information for schema name "null", table name "payment".
216072  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> getColumns: conveyancing, null, payment, null
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading column information for table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found 
existing column "id" on table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found 
existing column "categoryid" on table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found 
existing column "name" on table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - Found 
existing column "value" on table "payment".
216079  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading sequence information for schema "null", sequence name "null".
216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> [0 ms] commit
216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading table information for schema name "null", table name "Operator".
216080  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> getColumns: conveyancing, null, Operator, null
216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading sequence information for schema "null", sequence name "null".
216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> [0 ms] commit
216081  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading table information for schema name "null", table name "Council".
216082  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> getColumns: conveyancing, null, Council, null
216082  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading sequence information for schema "null", sequence name "null".
216083  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> [0 ms] commit
216083  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading table information for schema name "null", table name "Client".
216084  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> getColumns: conveyancing, null, Client, null
216085  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading sequence information for schema "null", sequence name "null".
216086  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> [0 ms] commit
216087  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.Schema - 
Reading table information for schema name "null", table name "event".
216087  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1016116032> getColumns: conveyancing, null, event, null


also i wondered if i should move the second persistence unit into a jar 
file to see if it made any difference


On 16/03/2018 14:08, Romain Manni-Bucau wrote:

do you have some "adjusting" lines in the logs?


Romain Manni-Bucau
@rmannibucau  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-16 12:25 GMT+01:00 Matthew Broadhead 

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

do you have some "adjusting" lines in the logs?


Romain Manni-Bucau
@rmannibucau  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-16 12:25 GMT+01:00 Matthew Broadhead :

> the relevant part of the log seems to be:
>
> 231734  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 865011519> executing stmnt 2028257349 CREATE TABLE Address
> (address_n INTEGER NOT NULL, district VARCHAR(26), num_in_st VARCHAR(11),
> postcode VARCHAR(8), road VARCHAR(26), telephone VARCHAR(13), title_no_1
> VARCHAR(9), title_no_2 VARCHAR(9), title_no_3 VARCHAR(9), unit VARCHAR(30),
> posttown_n INTEGER, PRIMARY KEY (address_n)) ENGINE = innodb
> 231901  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 865011519> [167 ms] spent
> 231901  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 865011519> [0 ms] commit
> 231901  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 865011519> [0 ms] close
> 231902  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1788652555> [0 ms] rollback
> 231902  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 1788652555> executing stmnt 1832391635 CREATE TABLE Client
> (client_n INTEGER NOT NULL, birthdate DATETIME, forename VARCHAR(33),
> prefix VARCHAR(5), surname VARCHAR(25), teldaytime VARCHAR(18), telfax
> VARCHAR(13), telmobile VARCHAR(12), PRIMARY KEY (client_n)) ENGINE = innodb
> 232127  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 1788652555> [225 ms] spent
> 232127  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1788652555> [0 ms] commit
> 232128  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1788652555> [0 ms] close
> 232129  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1856856880> [0 ms] rollback
> 232129  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 1856856880> executing stmnt 1020559479 CREATE TABLE Council
> (council_n INTEGER NOT NULL, county VARCHAR(16), district VARCHAR(26), dx
> VARCHAR(26), fax VARCHAR(13), llc_fee DOUBLE, name VARCHAR(30), need_plan
> INTEGER, num_in_st VARCHAR(7), phone VARCHAR(13), postcode VARCHAR(8),
> posttown VARCHAR(20), road VARCHAR(25), unit VARCHAR(30), wtr_agency
> VARCHAR(1), PRIMARY KEY (council_n)) ENGINE = innodb
> 232341  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 1856856880> [212 ms] spent
> 232342  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1856856880> [1 ms] commit
> 232342  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1856856880> [0 ms] close
> 232343  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 910550352> [0 ms] rollback
> 232343  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 910550352> executing stmnt 185905453 CREATE TABLE opecli_l
> (operator_n INTEGER, client_n INTEGER) ENGINE = innodb
> 232631  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 910550352> [288 ms] spent
> 232631  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 910550352> [0 ms] commit
> 232632  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 910550352> [0 ms] close
> 232633  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1652020186> [0 ms] rollback
> 232633  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 1652020186> executing stmnt 436027210 CREATE TABLE Operator
> (operator_n INTEGER NOT NULL, abortive_d DATETIME, abowarned DATETIME,
> account_n INTEGER, agent_d DATETIME, branch_code VARCHAR(2), categor
> VARCHAR(1), client_add VARCHAR(30), client_ref VARCHAR(10), cntr_del_d
> DATETIME, complset_d DATETIME, deeds_in_d DATETIME, enquiry_n INTEGER,
> exchange_d DATETIME, fee_earner VARCHAR(3), lawyer_d DATETIME, llc_in_d
> DATETIME, lowfeebill DATETIME, lowfeeinst DATETIME, mtg_offr_d DATETIME,
> qaire_in_d DATETIME, related_n INTEGER, subject VARCHAR(30), surname
> VARCHAR(20), water_in_d DATETIME, subjec_a_n INTEGER, PRIMARY KEY
> (operator_n)) ENGINE = innodb
> 232953  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  145697756, conn 1652020186> [320 ms] spent
> 232953  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1652020186> [0 ms] commit
> 232953  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 1652020186> [0 ms] close
> 232954  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC -  145697756, conn 25303698> [0 ms] rollback
> 232954  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL -  

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

the relevant part of the log seems to be:

231734  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 865011519> executing stmnt 2028257349 CREATE TABLE 
Address (address_n INTEGER NOT NULL, district VARCHAR(26), num_in_st 
VARCHAR(11), postcode VARCHAR(8), road VARCHAR(26), telephone 
VARCHAR(13), title_no_1 VARCHAR(9), title_no_2 VARCHAR(9), title_no_3 
VARCHAR(9), unit VARCHAR(30), posttown_n INTEGER, PRIMARY KEY 
(address_n)) ENGINE = innodb
231901  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 865011519> [167 ms] spent
231901  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 865011519> [0 ms] commit
231901  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 865011519> [0 ms] close
231902  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1788652555> [0 ms] rollback
231902  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 1788652555> executing stmnt 1832391635 CREATE TABLE 
Client (client_n INTEGER NOT NULL, birthdate DATETIME, forename 
VARCHAR(33), prefix VARCHAR(5), surname VARCHAR(25), teldaytime 
VARCHAR(18), telfax VARCHAR(13), telmobile VARCHAR(12), PRIMARY KEY 
(client_n)) ENGINE = innodb
232127  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 1788652555> [225 ms] spent
232127  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1788652555> [0 ms] commit
232128  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1788652555> [0 ms] close
232129  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1856856880> [0 ms] rollback
232129  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 1856856880> executing stmnt 1020559479 CREATE TABLE 
Council (council_n INTEGER NOT NULL, county VARCHAR(16), district 
VARCHAR(26), dx VARCHAR(26), fax VARCHAR(13), llc_fee DOUBLE, name 
VARCHAR(30), need_plan INTEGER, num_in_st VARCHAR(7), phone VARCHAR(13), 
postcode VARCHAR(8), posttown VARCHAR(20), road VARCHAR(25), unit 
VARCHAR(30), wtr_agency VARCHAR(1), PRIMARY KEY (council_n)) ENGINE = innodb
232341  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 1856856880> [212 ms] spent
232342  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1856856880> [1 ms] commit
232342  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1856856880> [0 ms] close
232343  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 910550352> [0 ms] rollback
232343  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 910550352> executing stmnt 185905453 CREATE TABLE 
opecli_l (operator_n INTEGER, client_n INTEGER) ENGINE = innodb
232631  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 910550352> [288 ms] spent
232631  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 910550352> [0 ms] commit
232632  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 910550352> [0 ms] close
232633  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1652020186> [0 ms] rollback
232633  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 1652020186> executing stmnt 436027210 CREATE TABLE 
Operator (operator_n INTEGER NOT NULL, abortive_d DATETIME, abowarned 
DATETIME, account_n INTEGER, agent_d DATETIME, branch_code VARCHAR(2), 
categor VARCHAR(1), client_add VARCHAR(30), client_ref VARCHAR(10), 
cntr_del_d DATETIME, complset_d DATETIME, deeds_in_d DATETIME, enquiry_n 
INTEGER, exchange_d DATETIME, fee_earner VARCHAR(3), lawyer_d DATETIME, 
llc_in_d DATETIME, lowfeebill DATETIME, lowfeeinst DATETIME, mtg_offr_d 
DATETIME, qaire_in_d DATETIME, related_n INTEGER, subject VARCHAR(30), 
surname VARCHAR(20), water_in_d DATETIME, subjec_a_n INTEGER, PRIMARY 
KEY (operator_n)) ENGINE = innodb
232953  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 1652020186> [320 ms] spent
232953  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1652020186> [0 ms] commit
232953  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1652020186> [0 ms] close
232954  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 25303698> [0 ms] rollback
232954  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 25303698> executing stmnt 636986972 CREATE TABLE 
o_addr_l (operator_n INTEGER, address_n INTEGER) ENGINE = innodb
233210  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.SQL - 145697756, conn 25303698> [256 ms] spent
233210  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 25303698> [0 ms] commit
233210  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 25303698> [0 ms] close
233211  file  TRACE  [http-nio-8080-exec-7] openjpa.jdbc.JDBC - 145697756, conn 1200479413> [0 ms] rollback
233211  file  TRACE  

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

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  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-16 9:46 GMT+01:00 Matthew Broadhead 
:


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  |  Blog
 | Old Blog
 | Github <
https://github.com/rmannibucau> |
LinkedIn  | Book



2018-03-16 9:23 GMT+01:00 Matthew Broadhead <
matthew.broadh...@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

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">
  
  file
  uk.me.kissy.file.entities.jpa.Box
uk.me.kissy.file.entities.jpa.Category
uk.me.kissy.file.entities.jpa.CqsReview
uk.me.kissy.file.entities.jpa.Department
uk.me.kissy.file.entities.jpa.Enclosure
uk.me.kissy.file.entities.jpa.Event
uk.me.kissy.file.entities.jpa.EventData
uk.me.kissy.file.entities.jpa.EventType
  
  uk.me.kissy.file.entities.jpa.Log
uk.me.kissy.file.entities.jpa.Note
uk.me.kissy.file.entities.jpa.Payment
uk.me.kissy.file.entities.jpa.Price
uk.me.kissy.file.entities.jpa.Undertaking
uk.me.kissy.file.entities.jpa.UndertakingType
uk.me.kissy.file.entities.jpa.Workflow
  
  
  
  
  
  operator
uk.me.kissy.file.entities.jpa.operator.Address
uk.me.kissy.file.entities.jpa.operator.Client
uk.me.kissy.file.entities.jpa.operator.Council
uk.me.kissy.file.entities.jpa.operator.Operator
uk.me.kissy.file.entities.jpa.operator.Posttown
uk.me.kissy.file.entities.jpa.operator.Wtr_auth
  

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

maybe activate sql logging to check what is happening exactly (LogSql=true
for instance)


Romain Manni-Bucau
@rmannibucau  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-16 9:46 GMT+01:00 Matthew Broadhead 
:

> 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  |  Blog
>>  | Old Blog
>>  | Github <
>> https://github.com/rmannibucau> |
>> LinkedIn  | Book
>> > high-performance>
>>
>>
>> 2018-03-16 9:23 GMT+01:00 Matthew Broadhead <
>> matthew.broadh...@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
>>> 
>>> 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">
>>>  
>>>  file
>>>  uk.me.kissy.file.entities.jpa.Box
>>> uk.me.kissy.file.entities.jpa.Category
>>> uk.me.kissy.file.entities.jpa.CqsReview
>>> uk.me.kissy.file.entities.jpa.Department
>>> uk.me.kissy.file.entities.jpa.Enclosure
>>> uk.me.kissy.file.entities.jpa.Event
>>> uk.me.kissy.file.entities.jpa.EventData
>>> uk.me.kissy.file.entities.jpa.EventType
>>>  
>>>  uk.me.kissy.file.entities.jpa.Log
>>> uk.me.kissy.file.entities.jpa.Note
>>> uk.me.kissy.file.entities.jpa.Payment
>>> uk.me.kissy.file.entities.jpa.Price
>>> uk.me.kissy.file.entities.jpa.Undertaking
>>> uk.me.kissy.file.entities.jpa.UndertakingType
>>> uk.me.kissy.file.entities.jpa.Workflow
>>>  
>>>  >> value="buildSchema(ForeignKeys=true)" />
>>>  
>>>  
>>>  
>>>  operator
>>> uk.me.kissy.file.entities.jpa.operator.Address
>>> uk.me.kissy.file.entities.jpa.operator.Client
>>> uk.me.kissy.file.entities.jpa.operator.Council
>>> uk.me.kissy.file.entities.jpa.operator.Operator
>>> uk.me.kissy.file.entities.jpa.operator.Posttown
>>> uk.me.kissy.file.entities.jpa.operator.Wtr_auth
>>>  
>>> 
>>>
>>>
>

Re: [openjpa] multiple persistence units

[Matthew Broadhead]

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  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-16 9:23 GMT+01:00 Matthew Broadhead 
:


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

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">
 
 file
 uk.me.kissy.file.entities.jpa.Box
uk.me.kissy.file.entities.jpa.Category
uk.me.kissy.file.entities.jpa.CqsReview
uk.me.kissy.file.entities.jpa.Department
uk.me.kissy.file.entities.jpa.Enclosure
uk.me.kissy.file.entities.jpa.Event
uk.me.kissy.file.entities.jpa.EventData
uk.me.kissy.file.entities.jpa.EventType
 
 uk.me.kissy.file.entities.jpa.Log
uk.me.kissy.file.entities.jpa.Note
uk.me.kissy.file.entities.jpa.Payment
uk.me.kissy.file.entities.jpa.Price
uk.me.kissy.file.entities.jpa.Undertaking
uk.me.kissy.file.entities.jpa.UndertakingType
uk.me.kissy.file.entities.jpa.Workflow
 
 
 
 
 
 operator
uk.me.kissy.file.entities.jpa.operator.Address
uk.me.kissy.file.entities.jpa.operator.Client
uk.me.kissy.file.entities.jpa.operator.Council
uk.me.kissy.file.entities.jpa.operator.Operator
uk.me.kissy.file.entities.jpa.operator.Posttown
uk.me.kissy.file.entities.jpa.operator.Wtr_auth
 

Re: [openjpa] multiple persistence units

[Romain Manni-Bucau]

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  |  Blog
 | Old Blog
 | Github  |
LinkedIn  | Book


2018-03-16 9:23 GMT+01:00 Matthew Broadhead 
:

> 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
> 
> 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">
> 
> file
> uk.me.kissy.file.entities.jpa.Box
> uk.me.kissy.file.entities.jpa.Category
> uk.me.kissy.file.entities.jpa.CqsReview
> uk.me.kissy.file.entities.jpa.Department
> uk.me.kissy.file.entities.jpa.Enclosure
> uk.me.kissy.file.entities.jpa.Event
> uk.me.kissy.file.entities.jpa.EventData
> uk.me.kissy.file.entities.jpa.EventType
> 
> uk.me.kissy.file.entities.jpa.Log
> uk.me.kissy.file.entities.jpa.Note
> uk.me.kissy.file.entities.jpa.Payment
> uk.me.kissy.file.entities.jpa.Price
> uk.me.kissy.file.entities.jpa.Undertaking
> uk.me.kissy.file.entities.jpa.UndertakingType
> uk.me.kissy.file.entities.jpa.Workflow
> 
>  value="buildSchema(ForeignKeys=true)" />
> 
> 
> 
> operator
> uk.me.kissy.file.entities.jpa.operator.Address
> uk.me.kissy.file.entities.jpa.operator.Client
> uk.me.kissy.file.entities.jpa.operator.Council
> uk.me.kissy.file.entities.jpa.operator.Operator
> uk.me.kissy.file.entities.jpa.operator.Posttown
> uk.me.kissy.file.entities.jpa.operator.Wtr_auth
> 
> 
>

[openjpa] multiple persistence units

[Matthew Broadhead]

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


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">
    
        file
        uk.me.kissy.file.entities.jpa.Box
uk.me.kissy.file.entities.jpa.Category
uk.me.kissy.file.entities.jpa.CqsReview
uk.me.kissy.file.entities.jpa.Department
uk.me.kissy.file.entities.jpa.Enclosure
uk.me.kissy.file.entities.jpa.Event
uk.me.kissy.file.entities.jpa.EventData
uk.me.kissy.file.entities.jpa.EventType
        
        uk.me.kissy.file.entities.jpa.Log
uk.me.kissy.file.entities.jpa.Note
uk.me.kissy.file.entities.jpa.Payment
uk.me.kissy.file.entities.jpa.Price
uk.me.kissy.file.entities.jpa.Undertaking
uk.me.kissy.file.entities.jpa.UndertakingType
uk.me.kissy.file.entities.jpa.Workflow
        
            value="buildSchema(ForeignKeys=true)" />

        
    
    
        operator
uk.me.kissy.file.entities.jpa.operator.Address
uk.me.kissy.file.entities.jpa.operator.Client
uk.me.kissy.file.entities.jpa.operator.Council
uk.me.kissy.file.entities.jpa.operator.Operator
uk.me.kissy.file.entities.jpa.operator.Posttown
uk.me.kissy.file.entities.jpa.operator.Wtr_auth