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>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>
