thanks Romain, that works1. 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 <https://twitter.com/rmannibucau> | Blog <https://rmannibucau.metawerx.net/> | Old Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book <https://www.packtpub.com/application-development/java-ee-8-high-performance> 2018-03-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?) <persistence-unit name="bookshelf-pu" transaction-type="JTA"> <jta-data-source>bookshelfDatabase</jta-data-source> <class>openJpaReproducer.entities.Bookshelf</class> <properties> <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/> </properties> </persistence-unit> 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 issection 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 definitionand 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 relevantwebapp 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.ResourceBundleResolve r@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 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] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER TABLE undertakingtype ADD version BIGINT --> 169ms 16-Mar-2018 15:43:37.100 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 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 --> 100ms 16-Mar-2018 15:43:37.334 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 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 --> 231ms 16-Mar-2018 15:43:37.547 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 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 --> 210ms 16-Mar-2018 15:43:38.073 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE TABLE opecli_l (operator_n INTEGER, client_n INTEGER) ENGINE = innodb --> 523ms 16-Mar-2018 15:43:38.396 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 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 --> 320ms 16-Mar-2018 15:43:38.724 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE TABLE o_addr_l (operator_n INTEGER, address_n INTEGER) ENGINE = innodb --> 326ms 16-Mar-2018 15:43:38.954 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE TABLE Posttown (posttown_n INTEGER NOT NULL, county VARCHAR(22), posttown VARCHAR(22), council_n INTEGER, wtr_auth_n INTEGER, PRIMARY KEY (posttown_n)) ENGINE = innodb --> 227ms 16-Mar-2018 15:43:39.209 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE TABLE Wtr_auth (wtr_auth_n INTEGER NOT NULL, county VARCHAR(16), district VARCHAR(26), dx VARCHAR(26), fax VARCHAR(13), name VARCHAR(30), num_in_st VARCHAR(7), phone VARCHAR(13), postcode VARCHAR(8), posttown VARCHAR(20), road VARCHAR(25), sch_fee DOUBLE, unit VARCHAR(30), PRIMARY KEY (wtr_auth_n)) ENGINE = innodb --> 253ms 16-Mar-2018 15:43:39.433 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_ADDRESS_POSTTOWN ON Address (posttown_n) --> 221ms 16-Mar-2018 15:43:39.647 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_OPCLI_L_ELEMENT ON opecli_l (client_n) --> 212ms 16-Mar-2018 15:43:39.928 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_OPCLI_L_OPERATOR_N ON opecli_l (operator_n) --> 278ms 16-Mar-2018 15:43:40.278 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_OPERTOR_ADDRESS ON Operator (subjec_a_n) --> 349ms 16-Mar-2018 15:43:40.494 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_O_DDR_L_ELEMENT ON o_addr_l (address_n) --> 213ms 16-Mar-2018 15:43:40.686 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_O_DDR_L_OPERATOR_N ON o_addr_l (operator_n) --> 190ms 16-Mar-2018 15:43:40.894 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_PSTTOWN_COUNCIL ON Posttown (council_n) --> 205ms 16-Mar-2018 15:43:41.222 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_PSTTOWN_WTR_AUTH ON Posttown (wtr_auth_n) --> 326ms On 16/03/2018 15:49, Romain Manni-Bucau wrote: 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 <https://twitter.com/rmannibucau> | Blog <https://rmannibucau.metawerx.net/> | Old Blog <http://rmannibucau.wordpress.com> | Github < https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book <https://www.packtpub.com/application-development/java-ee-8- high-performance> 2018-03-16 15:44 GMT+01:00 Matthew Broadhead < matthew.broadh...@nbmlaw.co.uk :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.FlashELR esolver@420a4ab9, org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40, org.apache.myfaces.el.unified.resolver.ResourceBundleResolve r@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@633c6e 59] 16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1] javax.faces.component._ExternalSpecifications.isBeanValidati onAvailable 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] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER TABLE undertakingtype ADD version BIGINT --> 169ms 16-Mar-2018 15:43:37.100 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 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 --> 100ms 16-Mar-2018 15:43:37.334 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 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 --> 231ms 16-Mar-2018 15:43:37.547 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 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 --> 210ms 16-Mar-2018 15:43:38.073 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE TABLE opecli_l (operator_n INTEGER, client_n INTEGER) ENGINE = innodb --> 523ms 16-Mar-2018 15:43:38.396 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke 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 --> 320ms 16-Mar-2018 15:43:38.724 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE TABLE o_addr_l (operator_n INTEGER, address_n INTEGER) ENGINE = innodb --> 326ms 16-Mar-2018 15:43:38.954 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE TABLE Posttown (posttown_n INTEGER NOT NULL, county VARCHAR(22), posttown VARCHAR(22), council_n INTEGER, wtr_auth_n INTEGER, PRIMARY KEY (posttown_n)) ENGINE = innodb --> 227ms 16-Mar-2018 15:43:39.209 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE TABLE Wtr_auth (wtr_auth_n INTEGER NOT NULL, county VARCHAR(16), district VARCHAR(26), dx VARCHAR(26), fax VARCHAR(13), name VARCHAR(30), num_in_st VARCHAR(7), phone VARCHAR(13), postcode VARCHAR(8), posttown VARCHAR(20), road VARCHAR(25), sch_fee DOUBLE, unit VARCHAR(30), PRIMARY KEY (wtr_auth_n)) ENGINE = innodb --> 253ms 16-Mar-2018 15:43:39.433 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_ADDRESS_POSTTOWN ON Address (posttown_n) --> 221ms 16-Mar-2018 15:43:39.647 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_OPCLI_L_ELEMENT ON opecli_l (client_n) --> 212ms 16-Mar-2018 15:43:39.928 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_OPCLI_L_OPERATOR_N ON opecli_l (operator_n) --> 278ms 16-Mar-2018 15:43:40.278 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_OPERTOR_ADDRESS ON Operator (subjec_a_n) --> 349ms 16-Mar-2018 15:43:40.494 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_O_DDR_L_ELEMENT ON o_addr_l (address_n) --> 213ms 16-Mar-2018 15:43:40.686 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_O_DDR_L_OPERATOR_N ON o_addr_l (operator_n) --> 190ms 16-Mar-2018 15:43:40.894 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_PSTTOWN_COUNCIL ON Posttown (council_n) --> 205ms 16-Mar-2018 15:43:41.222 INFO [http-nio-8080-exec-1] org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke CREATE INDEX I_PSTTOWN_WTR_AUTH ON Posttown (wtr_auth_n) --> 326ms On 16/03/2018 15:37, Matthew Broadhead wrote: sorry actually it is already writing to file and console. i will see if i can get it more verboseOn 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 <https://twitter.com/rmannibucau> | Blog <https://rmannibucau.metawerx.net/> | Old Blog <http://rmannibucau.wordpress.com> | Github < https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book <https://www.packtpub.com/application-development/java-ee-8- high-performance> 2018-03-16 14:44 GMT+01:00 Matthew Broadhead < matthew.broadh...@nbmlaw.co.uk : https://gist.github.com/chongma/f019380ec6109d566b8b3444a41814ebOn 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 seethe 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 - <t 145697756, conn 1016116032> [0 ms] commit216070 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 - <t 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 - <t 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 - <t 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 - <t 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 - <t 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 - <t 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 - <t 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 - <t 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 - <t 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 - <t 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 - <t 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 <https://twitter.com/rmannibucau> | Blog<https://rmannibucau.metawerx.net/> | Old Blog <http://rmannibucau.wordpress.com> | Github < https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book <https://www.packtpub.com/application-development/java-ee-8- high-performance> 2018-03-16 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 -<t 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 - <t 145697756, conn 865011519> [167 ms] spent 231901 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 865011519> [0 ms] commit 231901 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 865011519> [0 ms] close 231902 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1788652555> [0 ms] rollback 231902 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 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 - <t 145697756, conn 1788652555> [225 ms] spent 232127 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1788652555> [0 ms] commit 232128 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1788652555> [0 ms] close 232129 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1856856880> [0 ms] rollback 232129 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 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 - <t 145697756, conn 1856856880> [212 ms] spent 232342 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1856856880> [1 ms] commit 232342 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1856856880> [0 ms] close 232343 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 910550352> [0 ms] rollback 232343 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 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 - <t 145697756, conn 910550352> [288 ms] spent 232631 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 910550352> [0 ms] commit 232632 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 910550352> [0 ms] close 232633 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1652020186> [0 ms] rollback 232633 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 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 - <t 145697756, conn 1652020186> [320 ms] spent 232953 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1652020186> [0 ms] commit 232953 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1652020186> [0 ms] close 232954 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 25303698> [0 ms] rollback 232954 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 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 - <t 145697756, conn 25303698> [256 ms] spent 233210 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 25303698> [0 ms] commit 233210 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 25303698> [0 ms] close 233211 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1200479413> [0 ms] rollback 233211 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1200479413> executing stmnt 1599100766 CREATE TABLE Posttown (posttown_n INTEGER NOT NULL, county VARCHAR(22), posttown VARCHAR(22), council_n INTEGER, wtr_auth_n INTEGER, PRIMARY KEY (posttown_n)) ENGINE = innodb 233423 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1200479413> [212 ms] spent 233423 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1200479413> [0 ms] commit 233423 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1200479413> [0 ms] close 233424 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 684696833> [0 ms] rollback 233424 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 684696833> executing stmnt 1154075410 CREATE TABLE Wtr_auth (wtr_auth_n INTEGER NOT NULL, county VARCHAR(16), district VARCHAR(26), dx VARCHAR(26), fax VARCHAR(13), name VARCHAR(30), num_in_st VARCHAR(7), phone VARCHAR(13), postcode VARCHAR(8), posttown VARCHAR(20), road VARCHAR(25), sch_fee DOUBLE, unit VARCHAR(30), PRIMARY KEY (wtr_auth_n)) ENGINE = innodb 233683 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 684696833> [259 ms] spent 233683 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 684696833> [0 ms] commit 233683 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 684696833> [0 ms] close 233684 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 976916420> [0 ms] rollback 233684 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 976916420> executing stmnt 830816227 CREATE INDEX I_ADDRESS_POSTTOWN ON Address (posttown_n) 233980 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 976916420> [296 ms] spent 233980 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 976916420> [0 ms] commit 233981 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 976916420> [0 ms] close 233981 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 737216388> [0 ms] rollback 233982 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 737216388> executing stmnt 794352343 CREATE INDEX I_OPCLI_L_ELEMENT ON opecli_l (client_n) 234250 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 737216388> [268 ms] spent 234250 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 737216388> [0 ms] commit 234250 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 737216388> [0 ms] close 234251 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 676196467> [0 ms] rollback 234251 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 676196467> executing stmnt 1101666767 CREATE INDEX I_OPCLI_L_OPERATOR_N ON opecli_l (operator_n) 234462 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 676196467> [211 ms] spent 234462 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 676196467> [0 ms] commit 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 676196467> [0 ms] close 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1395003156> [0 ms] rollback 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1395003156> executing stmnt 1112735966 CREATE INDEX I_OPERTOR_ADDRESS ON Operator (subjec_a_n) 234735 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1395003156> [272 ms] spent 234735 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1395003156> [0 ms] commit 234735 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1395003156> [0 ms] close 234736 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1481756422> [0 ms] rollback 234736 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1481756422> executing stmnt 48128290 CREATE INDEX I_O_DDR_L_ELEMENT ON o_addr_l (address_n) 235076 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1481756422> [340 ms] spent 235077 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1481756422> [1 ms] commit 235077 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1481756422> [0 ms] close 235078 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1762875674> [0 ms] rollback 235078 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1762875674> executing stmnt 414573163 CREATE INDEX I_O_DDR_L_OPERATOR_N ON o_addr_l (operator_n) 235289 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1762875674> [211 ms] spent 235290 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1762875674> [0 ms] commit 235290 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1762875674> [0 ms] close 235291 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1179694077> [1 ms] rollback 235291 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1179694077> executing stmnt 1845663100 CREATE INDEX I_PSTTOWN_COUNCIL ON Posttown (council_n) 235524 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 1179694077> [233 ms] spent 235524 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1179694077> [0 ms] commit 235525 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 1179694077> [0 ms] close 235526 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 469864432> [0 ms] rollback 235526 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 469864432> executing stmnt 1716670585 CREATE INDEX I_PSTTOWN_WTR_AUTH ON Posttown (wtr_auth_n) 235785 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - <t 145697756, conn 469864432> [259 ms] spent 235785 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 469864432> [0 ms] commit 235786 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t 145697756, conn 469864432> [0 ms] close 235802 file TRACE [http-nio-8080-exec-7] openjpa.Runtime - Found datasource1: datasource 270095066 from configuration. StoreContext: org.apache.openjpa.kernel.BrokerImpl@53900e77 235828 file TRACE [http-nio-8080-exec-7] openjpa.Runtime - org.apache.openjpa.persistence .EntityManagerFactoryImpl@3ad8 d37d created EntityManager org.apache.openjpa.persistence .EntityManagerImpl@53900e77. 235840 file TRACE [http-nio-8080-exec-7] openjpa.MetaData - Loading metadata for "class uk.me.kissy.file.entities.jpa. operator.Posttown" under mode "[META][QUERY]". 235841 file TRACE [http-nio-8080-exec-7] openjpa.MetaData - Parsing resource "file:/Users/matthewbroadhead/ eclipseWS/case-management/.met adata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/ file/WEB-INF/classes/META-INF/orm.xml". 235841 file TRACE [http-nio-8080-exec-7] openjpa.MetaData - Overriding thread context classloader from "TomEEWebappClassLoader it doesn't specify how it determines which resource it is using On 16/03/2018 11:42, Matthew Broadhead wrote: 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 @Tableannotation. i haven't tried that yet but i will try the logging first to see if it shows anything. On 16/03/2018 10:17, Romain Manni-Bucau wrote: maybe activate sql logging to check what is happening exactly (LogSql=true for instance)Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <https://rmannibucau.metawerx.net/> | Old Blog <http://rmannibucau.wordpress.com> | Github < https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book <https://www.packtpub.com/appl ication-development/java-ee-8- high-performance> 2018-03-16 9:46 GMT+01:00 Matthew Broadhead < matthew.broadh...@nbmlaw.co.uk> : they are both mysql databases On 16/03/2018 09:33, Romain Manni-Bucau wrote: Hi, this is the way to do, maybe check your system propertiesand database configurations. With some DB you can need some moreconfig (thinking to oracle and schemas for instance) Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <https://rmannibucau.metawerx.net/> | Old Blog <http://rmannibucau.wordpress.com> | Github < https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book <https://www.packtpub.com/appl ication-development/java-ee-8- 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 <?xml version="1.0" encoding="UTF-8"?> <persistence xmlns="http://java.sun.com/xml /ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jav a.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/per sistence/persistence_2_0.xsd" version="2.0"> <persistence-unit name="file"> <jta-data-source>file</jta-data-source> <class>uk.me.kissy.file.entities.jpa.Box</class> <class>uk.me.kissy.file.entities.jpa.Category</class> <class>uk.me.kissy.file.entities.jpa.CqsReview</class> <class>uk.me.kissy.file.entities.jpa.Department</class> <class>uk.me.kissy.file.entities.jpa.Enclosure</class> <class>uk.me.kissy.file.entities.jpa.Event</class> <class>uk.me.kissy.file.entities.jpa.EventData</class> <class>uk.me.kissy.file.entities.jpa.EventType</class> <!-- <class>uk.me.kissy.file.entiti es.jpa.File</class> --> <class>uk.me.kissy.file.entities.jpa.Log</class> <class>uk.me.kissy.file.entities.jpa.Note</class> <class>uk.me.kissy.file.entities.jpa.Payment</class> <class>uk.me.kissy.file.entities.jpa.Price</class> <class>uk.me.kissy.file.entities.jpa.Undertaking</class> <class>uk.me.kissy.file.entiti es.jpa.UndertakingType</class> <class>uk.me.kissy.file.entities.jpa.Workflow</class> <properties> <property name="openjpa.jdbc.Synchronize Mappings" value="buildSchema(ForeignKeys=true)" /> </properties> </persistence-unit> <persistence-unit name="operator"> <jta-data-source>operator</jta-data-source> <class>uk.me.kissy.file.entities.jpa.operator.Address</ class> <class>uk.me.kissy.file.entiti es.jpa.operator.Client</class> <class>uk.me.kissy.file.entities.jpa.operator.Council</ class> <class>uk.me.kissy.file.entities.jpa.operator.Operator</ class> <class>uk.me.kissy.file.entities.jpa.operator.Posttown</ class> <class>uk.me.kissy.file.entities.jpa.operator.Wtr_auth</ class> </persistence-unit> </persistence>