From users-return-26601-apmail-tomee-users-archive=tomee.apache.org@tomee.apache.org Mon Mar 19 10:44:47 2018 Return-Path: X-Original-To: apmail-tomee-users-archive@www.apache.org Delivered-To: apmail-tomee-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EF7C418AD6 for ; Mon, 19 Mar 2018 10:44:47 +0000 (UTC) Received: (qmail 98543 invoked by uid 500); 19 Mar 2018 10:44:47 -0000 Delivered-To: apmail-tomee-users-archive@tomee.apache.org Received: (qmail 98502 invoked by uid 500); 19 Mar 2018 10:44:47 -0000 Mailing-List: contact users-help@tomee.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@tomee.apache.org Delivered-To: mailing list users@tomee.apache.org Received: (qmail 98482 invoked by uid 99); 19 Mar 2018 10:44:47 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Mar 2018 10:44:46 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 7EA3FC6C0A for ; Mon, 19 Mar 2018 10:44:46 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.64 X-Spam-Level: * X-Spam-Status: No, score=1.64 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_COUK=0.85, KAM_SHORT=0.001, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id SVKJkQVJ4boN for ; Mon, 19 Mar 2018 10:44:41 +0000 (UTC) Received: from ns1.nbmlaw.co.uk (ns1.nbmlaw.co.uk [217.174.253.19]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 679FF5F478 for ; Mon, 19 Mar 2018 10:44:40 +0000 (UTC) Received: from Mac-mini-2.local (99.red-79-145-186.dynamicip.rima-tde.net [79.145.186.99]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by ns1.nbmlaw.co.uk (Postfix) with ESMTPSA id 0AB8D2C2CE5 for ; Mon, 19 Mar 2018 10:44:34 +0000 (GMT) DMARC-Filter: OpenDMARC Filter v1.3.2 ns1.nbmlaw.co.uk 0AB8D2C2CE5 Authentication-Results: ns1.nbmlaw.co.uk; dmarc=fail (p=quarantine dis=none) header.from=nbmlaw.co.uk Authentication-Results: ns1.nbmlaw.co.uk; spf=fail smtp.mailfrom=matthew.broadhead@nbmlaw.co.uk Subject: Re: [openjpa] multiple persistence units To: users@tomee.apache.org References: <9fc630ce-730e-7a10-fb17-846bb201d543@nbmlaw.co.uk> <6e39de84-8928-5f45-34f4-b235629e3e18@nbmlaw.co.uk> <406975dc-f9ad-a573-71cf-3b1352f949e8@nbmlaw.co.uk> <11bdc009-b9ed-15d5-7a64-b0c55fe3ce3f@nbmlaw.co.uk> <78b66c05-e66e-e1d6-dd0d-c2c6cde40ad7@nbmlaw.co.uk> <6b947ba1-578d-a657-927c-970ebb2562b5@nbmlaw.co.uk> <1264c53e-ba3d-7189-f93b-cab8ed3a6afe@nbmlaw.co.uk> <0a969477-f925-bcbf-449b-625756a36d09@nbmlaw.co.uk> From: Matthew Broadhead Message-ID: <9430a05f-690b-0006-3386-5ceb8e61c475@nbmlaw.co.uk> Date: Mon, 19 Mar 2018 11:44:33 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US thanks Romain, that works 1. wouldn't both units need buildschema if you wanted to build them automatically?  or is it only necessary to declare on one?  if so shouldn't it be a child of persistence not persistence-unit? 2. i never defined non jta before.  why do you need a jta and non jta?  yes it would be better if it defaults to create them automatically for multiple PU 3. again i assumed exclude-unlisted-classes to be the default because eclipse requires that entities are listed in persistence.xml, although it seems that really may not be the case and they are scanned On 18/03/2018 18:50, Romain Manni-Bucau wrote: > Not sure I get the reproducer logic: > > 1. both units have buildSchema > 2. both units don't define a non jta datasource so openejb will create one > copying the first datasource and reuse the auto created non jta datasource > for the second one leading to use the same connection for both ("as > expected" even if i agree this is not the best default we picked) > 3. you dont deactivate jpa scanning so you find all tables anyway > > here is how to fix it: > https://gist.github.com/rmannibucau/57fd014e30ca003d62700348355dc647 > > > > > Romain Manni-Bucau > @rmannibucau | Blog > | Old Blog > | Github | > LinkedIn | Book > > > 2018-03-17 18:44 GMT+01:00 Matthew Broadhead > : >> i made a reproducer here https://github.com/chongma/openjpa-reproducer. >> it might be enough to show the problem but if not let me know. >> >> it worked fine at the beginning using the standard archetype. >> >> adding the second pu seems to stop it from "view books present" (not >> persisting?) >> >> bookshelfDatabase >> openJpaReproducer.entities.Bookshelf >> >> > value="buildSchema(ForeignKeys=true)"/> >> >> >> >> logs show second table being created. presumably in the book-pu because >> nothing has triggered bookshelf-pu? >> /*C1*/SET SCHEMA SYSTEM_LOBS >> INSERT INTO BLOCKS VALUES(0,2147483647,0) >> COMMIT >> /*C21*/SET SCHEMA PUBLIC >> CREATE TABLE Book (bookId INTEGER NOT NULL, bookTitle VARCHAR(255), >> PRIMARY KEY (bookId)) >> CREATE TABLE Bookshelf (bookshelfId INTEGER NOT NULL, bookshelfTitle >> VARCHAR(255), PRIMARY KEY (bookshelfId)) >> CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID TINYINT NOT NULL, SEQUENCE_VALUE >> BIGINT, PRIMARY KEY (ID)) >> INSERT INTO OPENJPA_SEQUENCE_TABLE VALUES(0,1) >> COMMIT >> DELETE FROM OPENJPA_SEQUENCE_TABLE WHERE ID=0 >> INSERT INTO OPENJPA_SEQUENCE_TABLE VALUES(0,51) >> COMMIT >> /*C11*/SET SCHEMA PUBLIC >> INSERT INTO BOOK VALUES(1,'asasas') >> COMMIT >> INSERT INTO BOOK VALUES(2,'dfdfd') >> COMMIT >> INSERT INTO BOOK VALUES(3,'lplplp') >> COMMIT >> >> >> >> On 17/03/2018 09:31, Matthew Broadhead wrote: >> >>> ok will do >>> >>> On 17/03/2018 09:28, Romain Manni-Bucau wrote: >>> >>>> Can you prepare a sample on github re1dy to compile/run (with hsqldb >>>> maybe)? >>>> >>>> Le 17 mars 2018 09:18, "Matthew Broadhead" < >>>> matthew.broadhead@nbmlaw.co.uk> >>>> a écrit : >>>> >>>> it is exactly the same. still creating the tables in first db. here is >>>>> section from catalina >>>>> >>>>> 17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1] >>>>> org.apache.tomee.catalina.TomcatWebAppBuilder.init >>>>> ------------------------- localhost -> /file >>>>> ... >>>>> 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1] >>>>> org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking >>>>> resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to >>>>> Resource(id=jdbc/MySQL) >>>>> 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1] >>>>> org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking >>>>> resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to >>>>> Resource(id=jdbc/MySQL) >>>>> 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1] >>>>> org.apache.openejb.config.AutoConfig.deploy Configuring >>>>> PersistenceUnit(name=file) >>>>> 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1] >>>>> org.apache.openejb.config.AutoConfig.deploy Configuring >>>>> PersistenceUnit(name=operator) >>>>> 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1] >>>>> org.apache.openejb.config.AppInfoBuilder.build Enterprise application >>>>> "/Users/matthewbroadhead/eclipseWS/case-management/.metadata >>>>> /.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file" loaded. >>>>> 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1] >>>>> org.apache.openejb.assembler.classic.Assembler.createApplication >>>>> Assembling app: /Users/matthewbroadhead/eclips >>>>> eWS/case-management/.metadata/.plugins/org.eclipse.wst. >>>>> server.core/tmp0/wtpwebapps/file >>>>> 17-Mar-2018 09:10:53.551 INFO [localhost-startStop-1] >>>>> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate >>>>> >>>>> PersistenceUnit(name=file, provider=org.apache.openjpa.pe >>>>> rsistence.PersistenceProviderImpl) - provider time 49ms >>>>> 17-Mar-2018 09:10:53.589 INFO [localhost-startStop-1] >>>>> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createDelegate >>>>> >>>>> PersistenceUnit(name=operator, provider=org.apache.openjpa.pe >>>>> rsistence.PersistenceProviderImpl) - provider time 38ms >>>>> 17-Mar-2018 09:10:53.637 INFO [localhost-startStop-1] >>>>> org.apache.openejb.assembler.classic.JndiBuilder.bind >>>>> Jndi(name=FileTimerLocalBean) --> Ejb(deployment-id=FileTimer) >>>>> ... >>>>> >>>>> On 16/03/2018 22:36, Romain Manni-Bucau wrote: >>>>> >>>>> Can you try setting non jta datasources? Duplicate the jta definition >>>>>> and >>>>>> just set jtamanaged to false and size to solthing small. Guess it is >>>>>> the >>>>>> issue >>>>>> >>>>>> Le 16 mars 2018 19:49, "Matthew Broadhead" >>>>>> >>>>> k> >>>>>> a écrit : >>>>>> >>>>>> this is the bit just after all the webapp deployment, and the relevant >>>>>> >>>>>>> webapp deployment is in this gist https://gist.github.com/chongm >>>>>>> a/948a4a369c1f9eae9406a99b60f0472e >>>>>>> 16-Mar-2018 15:41:29.068 INFO [main] sun.reflect.DelegatingMethodAc >>>>>>> cessorImpl.invoke >>>>>>> Server startup in 104519 ms >>>>>>> 16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1] >>>>>>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers >>>>>>> Chain >>>>>>> of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified. >>>>>>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is >>>>>>> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli >>>>>>> citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELR >>>>>>> esolver@420a4ab9, >>>>>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40, >>>>>>> org.apache.myfaces.el.unified.resolver.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 | Blog >>>>>>>> | Old Blog >>>>>>>> | Github < >>>>>>>> https://github.com/rmannibucau> | >>>>>>>> LinkedIn | Book >>>>>>>> >>>>>>> high-performance> >>>>>>>> >>>>>>>> 2018-03-16 15:44 GMT+01:00 Matthew Broadhead < >>>>>>>> matthew.broadhead@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 verbose >>>>>>>>>> On 16/03/2018 15:34, Matthew Broadhead wrote: >>>>>>>>>> >>>>>>>>>> is there a way to output tomee logs to file? i am using eclipse >>>>>>>>>> and >>>>>>>>>> >>>>>>>>>> they will get swallowed by console. >>>>>>>>>>> On 16/03/2018 14:58, Romain Manni-Bucau wrote: >>>>>>>>>>> >>>>>>>>>>> was more thinking about tomee startup/deployment logs >>>>>>>>>>> >>>>>>>>>>> Romain Manni-Bucau >>>>>>>>>>>> @rmannibucau | Blog >>>>>>>>>>>> | Old Blog >>>>>>>>>>>> | Github < >>>>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>>>> LinkedIn | Book >>>>>>>>>>>> >>>>>>>>>>> high-performance> >>>>>>>>>>>> >>>>>>>>>>>> 2018-03-16 14:44 GMT+01:00 Matthew Broadhead < >>>>>>>>>>>> matthew.broadhead@nbmlaw.co.uk >>>>>>>>>>>> >>>>>>>>>>>> : >>>>>>>>>>>> >>>>>>>>>>>> https://gist.github.com/chongma/f019380ec6109d566b8b3444a41814eb >>>>>>>>>>>>> >>>>>>>>>>>>> On 16/03/2018 14:37, Romain Manni-Bucau wrote: >>>>>>>>>>>>> >>>>>>>>>>>>> 2018-03-16 14:30 GMT+01:00 Matthew Broadhead < >>>>>>>>>>>>> >>>>>>>>>>>>> matthew.broadhead@nbmlaw.co.uk >>>>>>>>>>>>> >>>>>>>>>>>>>> : >>>>>>>>>>>>>> >>>>>>>>>>>>>> i searched for adjusting but found nothing. do you want to see >>>>>>>>>>>>>> >>>>>>>>>>>>>>> the >>>>>>>>>>>>>>> whole >>>>>>>>>>>>>>> log file? can the mailing list take attachments or do i have >>>>>>>>>>>>>>> to >>>>>>>>>>>>>>> send it >>>>>>>>>>>>>>> another way? >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> a gist/pastebin would be fine >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> it has some stuff like this: >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 216070 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>>>>>> 216070 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> table information for schema name "null", table name >>>>>>>>>>>>>>> "Posttown". >>>>>>>>>>>>>>> 216070 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>>>>>> Posttown, >>>>>>>>>>>>>>> null >>>>>>>>>>>>>>> 216071 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>>>>>> 216072 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>>>>>> 216072 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> table information for schema name "null", table name >>>>>>>>>>>>>>> "payment". >>>>>>>>>>>>>>> 216072 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>>>>>> payment, >>>>>>>>>>>>>>> null >>>>>>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> column information for table "payment". >>>>>>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Found >>>>>>>>>>>>>>> existing column "id" on table "payment". >>>>>>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Found >>>>>>>>>>>>>>> existing column "categoryid" on table "payment". >>>>>>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Found >>>>>>>>>>>>>>> existing column "name" on table "payment". >>>>>>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Found >>>>>>>>>>>>>>> existing column "value" on table "payment". >>>>>>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>>>>>> 216080 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>>>>>> 216080 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> table information for schema name "null", table name >>>>>>>>>>>>>>> "Operator". >>>>>>>>>>>>>>> 216080 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>>>>>> Operator, >>>>>>>>>>>>>>> null >>>>>>>>>>>>>>> 216081 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>>>>>> 216081 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>>>>>> 216081 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> table information for schema name "null", table name >>>>>>>>>>>>>>> "Council". >>>>>>>>>>>>>>> 216082 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>>>>>> Council, >>>>>>>>>>>>>>> null >>>>>>>>>>>>>>> 216082 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>>>>>> 216083 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>>>>>> 216083 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> table information for schema name "null", table name "Client". >>>>>>>>>>>>>>> 216084 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>>>>>> Client, >>>>>>>>>>>>>>> null >>>>>>>>>>>>>>> 216085 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>>>>>> 216086 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>>>>>> 216087 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>> openjpa.jdbc.Schema - >>>>>>>>>>>>>>> Reading >>>>>>>>>>>>>>> table information for schema name "null", table name "event". >>>>>>>>>>>>>>> 216087 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>>>> >>>>>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>>>>>> event, >>>>>>>>>>>>>>> null >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> also i wondered if i should move the second persistence unit >>>>>>>>>>>>>>> into a >>>>>>>>>>>>>>> jar >>>>>>>>>>>>>>> file to see if it made any difference >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> shouldnt >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On 16/03/2018 14:08, Romain Manni-Bucau wrote: >>>>>>>>>>>>>> do you have some "adjusting" lines in the logs? >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Romain Manni-Bucau >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> @rmannibucau | Blog >>>>>>>>>>>>>>>> | Old Blog >>>>>>>>>>>>>>>> | Github < >>>>>>>>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>>>>>>>> LinkedIn | Book >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> high-performance> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 2018-03-16 12:25 GMT+01:00 Matthew Broadhead < >>>>>>>>>>>>>>>> matthew.broadhead@nbmlaw.co.uk >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> : >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> the relevant part of the log seems to be: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 231734 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 865011519> executing stmnt 2028257349 CREATE >>>>>>>>>>>>>>>>> TABLE >>>>>>>>>>>>>>>>> Address >>>>>>>>>>>>>>>>> (address_n INTEGER NOT NULL, district VARCHAR(26), num_in_st >>>>>>>>>>>>>>>>> VARCHAR(11), >>>>>>>>>>>>>>>>> postcode VARCHAR(8), road VARCHAR(26), telephone >>>>>>>>>>>>>>>>> VARCHAR(13), >>>>>>>>>>>>>>>>> title_no_1 >>>>>>>>>>>>>>>>> VARCHAR(9), title_no_2 VARCHAR(9), title_no_3 VARCHAR(9), >>>>>>>>>>>>>>>>> unit >>>>>>>>>>>>>>>>> VARCHAR(30), >>>>>>>>>>>>>>>>> posttown_n INTEGER, PRIMARY KEY (address_n)) ENGINE = innodb >>>>>>>>>>>>>>>>> 231901 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 865011519> [167 ms] spent >>>>>>>>>>>>>>>>> 231901 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 865011519> [0 ms] commit >>>>>>>>>>>>>>>>> 231901 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 865011519> [0 ms] close >>>>>>>>>>>>>>>>> 231902 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1788652555> [0 ms] rollback >>>>>>>>>>>>>>>>> 231902 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1788652555> executing stmnt 1832391635 >>>>>>>>>>>>>>>>> CREATE >>>>>>>>>>>>>>>>> TABLE >>>>>>>>>>>>>>>>> Client >>>>>>>>>>>>>>>>> (client_n INTEGER NOT NULL, birthdate DATETIME, forename >>>>>>>>>>>>>>>>> VARCHAR(33), >>>>>>>>>>>>>>>>> prefix VARCHAR(5), surname VARCHAR(25), teldaytime >>>>>>>>>>>>>>>>> VARCHAR(18), >>>>>>>>>>>>>>>>> telfax >>>>>>>>>>>>>>>>> VARCHAR(13), telmobile VARCHAR(12), PRIMARY KEY (client_n)) >>>>>>>>>>>>>>>>> ENGINE >>>>>>>>>>>>>>>>> = >>>>>>>>>>>>>>>>> innodb >>>>>>>>>>>>>>>>> 232127 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1788652555> [225 ms] spent >>>>>>>>>>>>>>>>> 232127 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1788652555> [0 ms] commit >>>>>>>>>>>>>>>>> 232128 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1788652555> [0 ms] close >>>>>>>>>>>>>>>>> 232129 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1856856880> [0 ms] rollback >>>>>>>>>>>>>>>>> 232129 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1856856880> executing stmnt 1020559479 >>>>>>>>>>>>>>>>> CREATE >>>>>>>>>>>>>>>>> TABLE >>>>>>>>>>>>>>>>> Council >>>>>>>>>>>>>>>>> (council_n INTEGER NOT NULL, county VARCHAR(16), district >>>>>>>>>>>>>>>>> VARCHAR(26), >>>>>>>>>>>>>>>>> dx >>>>>>>>>>>>>>>>> VARCHAR(26), fax VARCHAR(13), llc_fee DOUBLE, name >>>>>>>>>>>>>>>>> VARCHAR(30), >>>>>>>>>>>>>>>>> need_plan >>>>>>>>>>>>>>>>> INTEGER, num_in_st VARCHAR(7), phone VARCHAR(13), postcode >>>>>>>>>>>>>>>>> VARCHAR(8), >>>>>>>>>>>>>>>>> posttown VARCHAR(20), road VARCHAR(25), unit VARCHAR(30), >>>>>>>>>>>>>>>>> wtr_agency >>>>>>>>>>>>>>>>> VARCHAR(1), PRIMARY KEY (council_n)) ENGINE = innodb >>>>>>>>>>>>>>>>> 232341 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1856856880> [212 ms] spent >>>>>>>>>>>>>>>>> 232342 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1856856880> [1 ms] commit >>>>>>>>>>>>>>>>> 232342 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1856856880> [0 ms] close >>>>>>>>>>>>>>>>> 232343 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 910550352> [0 ms] rollback >>>>>>>>>>>>>>>>> 232343 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 910550352> executing stmnt 185905453 CREATE >>>>>>>>>>>>>>>>> TABLE >>>>>>>>>>>>>>>>> opecli_l >>>>>>>>>>>>>>>>> (operator_n INTEGER, client_n INTEGER) ENGINE = innodb >>>>>>>>>>>>>>>>> 232631 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 910550352> [288 ms] spent >>>>>>>>>>>>>>>>> 232631 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 910550352> [0 ms] commit >>>>>>>>>>>>>>>>> 232632 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 910550352> [0 ms] close >>>>>>>>>>>>>>>>> 232633 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1652020186> [0 ms] rollback >>>>>>>>>>>>>>>>> 232633 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1652020186> executing stmnt 436027210 CREATE >>>>>>>>>>>>>>>>> TABLE >>>>>>>>>>>>>>>>> Operator >>>>>>>>>>>>>>>>> (operator_n INTEGER NOT NULL, abortive_d DATETIME, abowarned >>>>>>>>>>>>>>>>> DATETIME, >>>>>>>>>>>>>>>>> account_n INTEGER, agent_d DATETIME, branch_code VARCHAR(2), >>>>>>>>>>>>>>>>> categor >>>>>>>>>>>>>>>>> VARCHAR(1), client_add VARCHAR(30), client_ref VARCHAR(10), >>>>>>>>>>>>>>>>> cntr_del_d >>>>>>>>>>>>>>>>> DATETIME, complset_d DATETIME, deeds_in_d DATETIME, >>>>>>>>>>>>>>>>> enquiry_n >>>>>>>>>>>>>>>>> INTEGER, >>>>>>>>>>>>>>>>> exchange_d DATETIME, fee_earner VARCHAR(3), lawyer_d >>>>>>>>>>>>>>>>> DATETIME, >>>>>>>>>>>>>>>>> llc_in_d >>>>>>>>>>>>>>>>> DATETIME, lowfeebill DATETIME, lowfeeinst DATETIME, >>>>>>>>>>>>>>>>> mtg_offr_d >>>>>>>>>>>>>>>>> DATETIME, >>>>>>>>>>>>>>>>> qaire_in_d DATETIME, related_n INTEGER, subject VARCHAR(30), >>>>>>>>>>>>>>>>> surname >>>>>>>>>>>>>>>>> VARCHAR(20), water_in_d DATETIME, subjec_a_n INTEGER, >>>>>>>>>>>>>>>>> PRIMARY >>>>>>>>>>>>>>>>> KEY >>>>>>>>>>>>>>>>> (operator_n)) ENGINE = innodb >>>>>>>>>>>>>>>>> 232953 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1652020186> [320 ms] spent >>>>>>>>>>>>>>>>> 232953 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1652020186> [0 ms] commit >>>>>>>>>>>>>>>>> 232953 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1652020186> [0 ms] close >>>>>>>>>>>>>>>>> 232954 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 25303698> [0 ms] rollback >>>>>>>>>>>>>>>>> 232954 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 25303698> executing stmnt 636986972 CREATE >>>>>>>>>>>>>>>>> TABLE >>>>>>>>>>>>>>>>> o_addr_l >>>>>>>>>>>>>>>>> (operator_n INTEGER, address_n INTEGER) ENGINE = innodb >>>>>>>>>>>>>>>>> 233210 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 25303698> [256 ms] spent >>>>>>>>>>>>>>>>> 233210 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 25303698> [0 ms] commit >>>>>>>>>>>>>>>>> 233210 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 25303698> [0 ms] close >>>>>>>>>>>>>>>>> 233211 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1200479413> [0 ms] rollback >>>>>>>>>>>>>>>>> 233211 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1200479413> [212 ms] spent >>>>>>>>>>>>>>>>> 233423 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1200479413> [0 ms] commit >>>>>>>>>>>>>>>>> 233423 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1200479413> [0 ms] close >>>>>>>>>>>>>>>>> 233424 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 684696833> [0 ms] rollback >>>>>>>>>>>>>>>>> 233424 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 684696833> [259 ms] spent >>>>>>>>>>>>>>>>> 233683 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 684696833> [0 ms] commit >>>>>>>>>>>>>>>>> 233683 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 684696833> [0 ms] close >>>>>>>>>>>>>>>>> 233684 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 976916420> [0 ms] rollback >>>>>>>>>>>>>>>>> 233684 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 976916420> [296 ms] spent >>>>>>>>>>>>>>>>> 233980 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 976916420> [0 ms] commit >>>>>>>>>>>>>>>>> 233981 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 976916420> [0 ms] close >>>>>>>>>>>>>>>>> 233981 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 737216388> [0 ms] rollback >>>>>>>>>>>>>>>>> 233982 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 737216388> [268 ms] spent >>>>>>>>>>>>>>>>> 234250 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 737216388> [0 ms] commit >>>>>>>>>>>>>>>>> 234250 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 737216388> [0 ms] close >>>>>>>>>>>>>>>>> 234251 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 676196467> [0 ms] rollback >>>>>>>>>>>>>>>>> 234251 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 676196467> [211 ms] spent >>>>>>>>>>>>>>>>> 234462 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 676196467> [0 ms] commit >>>>>>>>>>>>>>>>> 234463 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 676196467> [0 ms] close >>>>>>>>>>>>>>>>> 234463 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1395003156> [0 ms] rollback >>>>>>>>>>>>>>>>> 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1395003156> [272 ms] spent >>>>>>>>>>>>>>>>> 234735 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1395003156> [0 ms] commit >>>>>>>>>>>>>>>>> 234735 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1395003156> [0 ms] close >>>>>>>>>>>>>>>>> 234736 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1481756422> [0 ms] rollback >>>>>>>>>>>>>>>>> 234736 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1481756422> [340 ms] spent >>>>>>>>>>>>>>>>> 235077 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1481756422> [1 ms] commit >>>>>>>>>>>>>>>>> 235077 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1481756422> [0 ms] close >>>>>>>>>>>>>>>>> 235078 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1762875674> [0 ms] rollback >>>>>>>>>>>>>>>>> 235078 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1762875674> [211 ms] spent >>>>>>>>>>>>>>>>> 235290 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1762875674> [0 ms] commit >>>>>>>>>>>>>>>>> 235290 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1762875674> [0 ms] close >>>>>>>>>>>>>>>>> 235291 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1179694077> [1 ms] rollback >>>>>>>>>>>>>>>>> 235291 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1179694077> [233 ms] spent >>>>>>>>>>>>>>>>> 235524 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1179694077> [0 ms] commit >>>>>>>>>>>>>>>>> 235525 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 1179694077> [0 ms] close >>>>>>>>>>>>>>>>> 235526 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 469864432> [0 ms] rollback >>>>>>>>>>>>>>>>> 235526 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>> - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 469864432> [259 ms] spent >>>>>>>>>>>>>>>>> 235785 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 145697756, conn 469864432> [0 ms] commit >>>>>>>>>>>>>>>>> 235786 file TRACE [http-nio-8080-exec-7] >>>>>>>>>>>>>>>>> openjpa.jdbc.JDBC - >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 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 | Blog >>>>>>>>>>>>>>>>>>> | Old Blog >>>>>>>>>>>>>>>>>>> | Github < >>>>>>>>>>>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>>>>>>>>>>> LinkedIn | Book >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> ication-development/java-ee-8- >>>>>>>>>>>>>>>>>>> high-performance> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> 2018-03-16 9:46 GMT+01:00 Matthew Broadhead < >>>>>>>>>>>>>>>>>>> matthew.broadhead@nbmlaw.co.uk> >>>>>>>>>>>>>>>>>>> : >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> they are both mysql databases >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> On 16/03/2018 09:33, Romain Manni-Bucau wrote: >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> this is the way to do, maybe check your system properties >>>>>>>>>>>>>>>>>>>> and >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> database >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> configurations. With some DB you can need some more >>>>>>>>>>>>>>>>>>>>> config >>>>>>>>>>>>>>>>>>>>> (thinking >>>>>>>>>>>>>>>>>>>>> to >>>>>>>>>>>>>>>>>>>>> oracle and schemas for instance) >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Romain Manni-Bucau >>>>>>>>>>>>>>>>>>>>> @rmannibucau | Blog >>>>>>>>>>>>>>>>>>>>> | Old Blog >>>>>>>>>>>>>>>>>>>>> | Github < >>>>>>>>>>>>>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>>>>>>>>>>>>> LinkedIn | >>>>>>>>>>>>>>>>>>>>> Book >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> ication-development/java-ee-8- >>>>>>>>>>>>>>>>>>>>> high-performance> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> 2018-03-16 9:23 GMT+01:00 Matthew Broadhead < >>>>>>>>>>>>>>>>>>>>> matthew.broadhead@nbmlaw.co.uk> >>>>>>>>>>>>>>>>>>>>> : >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> hi, >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> i just wrote an email to users@openjpa but there >>>>>>>>>>>>>>>>>>>>> doesn't >>>>>>>>>>>>>>>>>>>>> seem >>>>>>>>>>>>>>>>>>>>> to >>>>>>>>>>>>>>>>>>>>> be >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> much >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> activity there. >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> do you know how to declare multiple persistence >>>>>>>>>>>>>>>>>>>>>> units? i >>>>>>>>>>>>>>>>>>>>>> created >>>>>>>>>>>>>>>>>>>>>> 2 >>>>>>>>>>>>>>>>>>>>>> persistence units inside persistence.xml but it seems >>>>>>>>>>>>>>>>>>>>>> to >>>>>>>>>>>>>>>>>>>>>> create >>>>>>>>>>>>>>>>>>>>>> the >>>>>>>>>>>>>>>>>>>>>> entities from the second PU in the database of the >>>>>>>>>>>>>>>>>>>>>> first >>>>>>>>>>>>>>>>>>>>>> one. my >>>>>>>>>>>>>>>>>>>>>> persistence.xml is like this. the operator tables get >>>>>>>>>>>>>>>>>>>>>> created >>>>>>>>>>>>>>>>>>>>>> inside >>>>>>>>>>>>>>>>>>>>>> the >>>>>>>>>>>>>>>>>>>>>> file database >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> 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"> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> file >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Box >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Category >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.CqsReview >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Department >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Enclosure >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Event >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.EventData >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.EventType >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Log >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Note >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Payment >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Price >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Undertaking >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>> es.jpa.UndertakingType >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.Workflow >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> name="openjpa.jdbc.Synchronize >>>>>>>>>>>>>>>>>>>>>> Mappings" >>>>>>>>>>>>>>>>>>>>>> value="buildSchema(ForeignKeys=true)" /> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> operator >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Address>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entiti >>>>>>>>>>>>>>>>>>>>>> es.jpa.operator.Client >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Council>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Operator>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Posttown>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Wtr_auth>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> class> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>