2018-03-19 11:44 GMT+01:00 Matthew Broadhead <matthew.broadh...@nbmlaw.co.uk >:
> 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 <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 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.ReloadableEntityManager >>>>>> Factory.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.ReloadableEntityManager >>>>>> Factory.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@6 >>>>>>>> b7fda40, >>>>>>>> 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@3 >>>>>>>> a9f16c9, >>>>>>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@6 >>>>>>>> 754a393] >>>>>>>> 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@4 >>>>>>>> b4839d0, >>>>>>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311, >>>>>>>> org.apache.myfaces.el.FlashELResolver@38d794e5, >>>>>>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2 >>>>>>>> b9c0cdb, >>>>>>>> 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: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@6 >>>>>>>>>> b7fda40, >>>>>>>>>> >>>>>>>>>> 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@3 >>>>>>>>>> a9f16c9, >>>>>>>>>> >>>>>>>>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@6 >>>>>>>>>> 754a393] >>>>>>>>>> >>>>>>>>>> 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@4 >>>>>>>>>> b4839d0, >>>>>>>>>> >>>>>>>>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@9 >>>>>>>>>> c25311, >>>>>>>>>> org.apache.myfaces.el.FlashELResolver@38d794e5, >>>>>>>>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2 >>>>>>>>>> b9c0cdb, >>>>>>>>>> >>>>>>>>>> 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@771cae >>>>>>>>>> 93, >>>>>>>>>> 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 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 <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/f019380ec6109d566b8b3444a418 >>>>>>>>>>>>> 14eb >>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> 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 - >>>>>>>>>>>>>>> <t >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> 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 - >>>>>>>>>>>>>>>> <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/appl >>>>>>>>>>>>>>>>> ication-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 >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> @Table >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> annotation. i haven't tried that yet but i will try the >>>>>>>>>>>>>>>>>>> logging >>>>>>>>>>>>>>>>>>> first >>>>>>>>>>>>>>>>>>> to >>>>>>>>>>>>>>>>>>> see if it shows anything. >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> On 16/03/2018 10:17, Romain Manni-Bucau wrote: >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> maybe activate sql logging to check what is happening >>>>>>>>>>>>>>>>>>> exactly >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> (LogSql=true >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> for instance) >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> Romain Manni-Bucau >>>>>>>>>>>>>>>>>>>> @rmannibucau <https://twitter.com/rmannibucau> | Blog >>>>>>>>>>>>>>>>>>>> <https://rmannibucau.metawerx.net/> | Old Blog >>>>>>>>>>>>>>>>>>>> <http://rmannibucau.wordpress.com> | Github < >>>>>>>>>>>>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>>>>>>>>>>>> LinkedIn <https://www.linkedin.com/in/rmannibucau> | >>>>>>>>>>>>>>>>>>>> Book >>>>>>>>>>>>>>>>>>>> <https://www.packtpub.com/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 >>>>>>>>>>>>>>>>>>>> properties >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> and >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> database >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> configurations. With some DB you can need some more >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> config >>>>>>>>>>>>>>>>>>>>>> (thinking >>>>>>>>>>>>>>>>>>>>>> to >>>>>>>>>>>>>>>>>>>>>> oracle and schemas for instance) >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Romain Manni-Bucau >>>>>>>>>>>>>>>>>>>>>> @rmannibucau <https://twitter.com/rmannibucau> | Blog >>>>>>>>>>>>>>>>>>>>>> <https://rmannibucau.metawerx.net/> | Old Blog >>>>>>>>>>>>>>>>>>>>>> <http://rmannibucau.wordpress.com> | Github < >>>>>>>>>>>>>>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>>>>>>>>>>>>>> LinkedIn <https://www.linkedin.com/in/rmannibucau> | >>>>>>>>>>>>>>>>>>>>>> Book >>>>>>>>>>>>>>>>>>>>>> <https://www.packtpub.com/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.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.Category</class> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.CqsReview</class> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.Department</class> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.Enclosure</class> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Event</class> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.EventData</class> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.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.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.Undertaking</class> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.UndertakingType</class> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.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.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.operator.Address</ >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.operator.Client</class> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.operator.Council</ >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.operator.Operator</ >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.operator.Posttown</ >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>>> es.jpa.operator.Wtr_auth</ >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> </persistence-unit> >>>>>>>>>>>>>>>>>>>>>>> </persistence> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >