tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From A Z <powerus...@live.com.au>
Subject Re: [openjpa] multiple persistence units
Date Sat, 17 Mar 2018 09:55:28 GMT
Could someone please reply to me with the email address

to unsubscribe from the email list, please?


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

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

Le 17 mars 2018 09:18, "Matthew Broadhead" <matthew.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" <matthew.broadhead@nbmlaw.co.u
>> k>
>> a écrit :
>>
>> this is the bit just after all the webapp deployment, and the relevant
>>> webapp deployment is in this gist https://gist.github.com/chongm
>>> a/948a4a369c1f9eae9406a99b60f0472e
>>> 16-Mar-2018 15:41:29.068 INFO [main] sun.reflect.DelegatingMethodAc
>>> cessorImpl.invoke
>>> Server startup in 104519 ms
>>> 16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1]
>>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
>>> of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified.
>>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
>>> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
>>> citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELR
>>> esolver@420a4ab9,
>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40,
>>> org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd,
>>> org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
>>> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
>>> org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,
>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
>>> 16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1]
>>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
>>> of EL resolvers for Faces sorted with: org.apache.myfaces.el.unified.
>>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
>>> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
>>> citObjectResolver@1db5922e, org.apache.myfaces.el.unified.
>>> resolver.CompositeComponentELResolver@9235f63,
>>> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
>>> org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0,
>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311,
>>> org.apache.myfaces.el.FlashELResolver@38d794e5,
>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb,
>>> org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1,
>>> javax.el.ResourceBundleELResolver@3ad1a339,
>>> org.apache.myfaces.el.unified.
>>> resolver.ResourceBundleResolver@3e25683a, org.apache.el.stream.StreamELR
>>> esolverImpl@759451f1, javax.el.StaticFieldELResolver@5592c7ac,
>>> javax.el.MapELResolver@62ed6e4c, javax.el.ListELResolver@771cae93,
>>> javax.el.ArrayELResolver@20506258, javax.el.BeanELResolver@633c6e59]
>>> 16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1]
>>> javax.faces.component._ExternalSpecifications.isBeanValidationAvailable
>>> MyFaces Bean Validation support enabled
>>> 16-Mar-2018 15:43:21.686 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE box ADD finishedId INTEGER --> 182ms
>>> 16-Mar-2018 15:43:22.037 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE box ADD userId INTEGER --> 348ms
>>> 16-Mar-2018 15:43:22.250 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE box ADD version BIGINT --> 211ms
>>> 16-Mar-2018 15:43:22.459 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE category ADD version BIGINT --> 205ms
>>> 16-Mar-2018 15:43:22.594 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE cqsreview ADD version BIGINT --> 132ms
>>> 16-Mar-2018 15:43:22.866 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE department ADD version BIGINT --> 270ms
>>> 16-Mar-2018 15:43:26.886 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE event ADD userId INTEGER --> 4017ms
>>> 16-Mar-2018 15:43:30.978 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE event ADD version BIGINT --> 4088ms
>>> 16-Mar-2018 15:43:31.223 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE eventtype ADD version BIGINT --> 241ms
>>> 16-Mar-2018 15:43:31.959 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE file ADD version BIGINT --> 733ms
>>> 16-Mar-2018 15:43:32.552 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE log ADD userId INTEGER --> 590ms
>>> 16-Mar-2018 15:43:33.237 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE log ADD version BIGINT --> 682ms
>>> 16-Mar-2018 15:43:34.606 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE note ADD userId INTEGER --> 1364ms
>>> 16-Mar-2018 15:43:36.223 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE note ADD version BIGINT --> 1426ms
>>> 16-Mar-2018 15:43:36.493 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE undertaking ADD userId INTEGER --> 266ms
>>> 16-Mar-2018 15:43:36.725 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE undertaking ADD version BIGINT --> 229ms
>>> 16-Mar-2018 15:43:36.897 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> ALTER
>>> TABLE undertakingtype ADD version BIGINT --> 169ms
>>> 16-Mar-2018 15:43:37.100 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE TABLE Address (address_n INTEGER NOT NULL, district VARCHAR(26),
>>> num_in_st VARCHAR(11), postcode VARCHAR(8), road VARCHAR(26), telephone
>>> VARCHAR(13), title_no_1 VARCHAR(9), title_no_2 VARCHAR(9), title_no_3
>>> VARCHAR(9), unit VARCHAR(30), posttown_n INTEGER, PRIMARY KEY
>>> (address_n))
>>> ENGINE = innodb --> 100ms
>>> 16-Mar-2018 15:43:37.334 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE TABLE Client (client_n INTEGER NOT NULL, birthdate DATETIME,
>>> forename VARCHAR(33), prefix VARCHAR(5), surname VARCHAR(25), teldaytime
>>> VARCHAR(18), telfax VARCHAR(13), telmobile VARCHAR(12), PRIMARY KEY
>>> (client_n)) ENGINE = innodb --> 231ms
>>> 16-Mar-2018 15:43:37.547 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE TABLE Council (council_n INTEGER NOT NULL, county VARCHAR(16),
>>> district VARCHAR(26), dx VARCHAR(26), fax VARCHAR(13), llc_fee DOUBLE,
>>> name
>>> VARCHAR(30), need_plan INTEGER, num_in_st VARCHAR(7), phone VARCHAR(13),
>>> postcode VARCHAR(8), posttown VARCHAR(20), road VARCHAR(25), unit
>>> VARCHAR(30), wtr_agency VARCHAR(1), PRIMARY KEY (council_n)) ENGINE =
>>> innodb --> 210ms
>>> 16-Mar-2018 15:43:38.073 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE TABLE opecli_l (operator_n INTEGER, client_n INTEGER) ENGINE =
>>> innodb --> 523ms
>>> 16-Mar-2018 15:43:38.396 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE TABLE Operator (operator_n INTEGER NOT NULL, abortive_d DATETIME,
>>> abowarned DATETIME, account_n INTEGER, agent_d DATETIME, branch_code
>>> VARCHAR(2), categor VARCHAR(1), client_add VARCHAR(30), client_ref
>>> VARCHAR(10), cntr_del_d DATETIME, complset_d DATETIME, deeds_in_d
>>> DATETIME,
>>> enquiry_n INTEGER, exchange_d DATETIME, fee_earner VARCHAR(3), lawyer_d
>>> DATETIME, llc_in_d DATETIME, lowfeebill DATETIME, lowfeeinst DATETIME,
>>> mtg_offr_d DATETIME, qaire_in_d DATETIME, related_n INTEGER, subject
>>> VARCHAR(30), surname VARCHAR(20), water_in_d DATETIME, subjec_a_n
>>> INTEGER,
>>> PRIMARY KEY (operator_n)) ENGINE = innodb --> 320ms
>>> 16-Mar-2018 15:43:38.724 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE TABLE o_addr_l (operator_n INTEGER, address_n INTEGER) ENGINE =
>>> innodb --> 326ms
>>> 16-Mar-2018 15:43:38.954 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE TABLE Posttown (posttown_n INTEGER NOT NULL, county VARCHAR(22),
>>> posttown VARCHAR(22), council_n INTEGER, wtr_auth_n INTEGER, PRIMARY KEY
>>> (posttown_n)) ENGINE = innodb --> 227ms
>>> 16-Mar-2018 15:43:39.209 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE TABLE Wtr_auth (wtr_auth_n INTEGER NOT NULL, county VARCHAR(16),
>>> district VARCHAR(26), dx VARCHAR(26), fax VARCHAR(13), name VARCHAR(30),
>>> num_in_st VARCHAR(7), phone VARCHAR(13), postcode VARCHAR(8), posttown
>>> VARCHAR(20), road VARCHAR(25), sch_fee DOUBLE, unit VARCHAR(30), PRIMARY
>>> KEY (wtr_auth_n)) ENGINE = innodb --> 253ms
>>> 16-Mar-2018 15:43:39.433 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE INDEX I_ADDRESS_POSTTOWN ON Address (posttown_n) --> 221ms
>>> 16-Mar-2018 15:43:39.647 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE INDEX I_OPCLI_L_ELEMENT ON opecli_l (client_n) --> 212ms
>>> 16-Mar-2018 15:43:39.928 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE INDEX I_OPCLI_L_OPERATOR_N ON opecli_l (operator_n) --> 278ms
>>> 16-Mar-2018 15:43:40.278 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE INDEX I_OPERTOR_ADDRESS ON Operator (subjec_a_n) --> 349ms
>>> 16-Mar-2018 15:43:40.494 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE INDEX I_O_DDR_L_ELEMENT ON o_addr_l (address_n) --> 213ms
>>> 16-Mar-2018 15:43:40.686 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE INDEX I_O_DDR_L_OPERATOR_N ON o_addr_l (operator_n) --> 190ms
>>> 16-Mar-2018 15:43:40.894 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE INDEX I_PSTTOWN_COUNCIL ON Posttown (council_n) --> 205ms
>>> 16-Mar-2018 15:43:41.222 INFO [http-nio-8080-exec-1]
>>> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
>>> CREATE INDEX I_PSTTOWN_WTR_AUTH ON Posttown (wtr_auth_n) --> 326ms
>>>
>>> On 16/03/2018 15:49, Romain Manni-Bucau wrote:
>>>
>>> Hmm, i dont see the startup logs, typically it is in catalina.log or so,
>>>> you should have lines about your webapp deployment too.
>>>>
>>>>
>>>> Romain Manni-Bucau
>>>> @rmannibucau <https://twitter.com/rmannibucau> |  Blog
>>>> <https://rmannibucau.metawerx.net/> | Old Blog
>>>> <http://rmannibucau.wordpress.com> | Github <
>>>> https://github.com/rmannibucau> |
>>>> LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book
>>>> <https://www.packtpub.com/application-development/java-ee-8-
>>>> high-performance>
>>>>
>>>> 2018-03-16 15:44 GMT+01:00 Matthew Broadhead <
>>>> matthew.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.ResourceBundleResolver@47f35cbd
>>>>> ,
>>>>> org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
>>>>> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
>>>>> org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,
>>>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
>>>>> 16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1]
>>>>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers
>>>>> Chain
>>>>> of EL resolvers for Faces sorted with: org.apache.myfaces.el.unified.
>>>>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
>>>>> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
>>>>> citObjectResolver@1db5922e, org.apache.myfaces.el.unified.
>>>>> resolver.CompositeComponentELResolver@9235f63,
>>>>> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
>>>>> org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0,
>>>>> org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311,
>>>>> org.apache.myfaces.el.FlashELResolver@38d794e5,
>>>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb,
>>>>> org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1,
>>>>> javax.el.ResourceBundleELResolver@3ad1a339,
>>>>> org.apache.myfaces.el.unified.
>>>>> resolver.ResourceBundleResolver@3e25683a,
>>>>> org.apache.el.stream.StreamELR
>>>>> esolverImpl@759451f1, javax.el.StaticFieldELResolver@5592c7ac,
>>>>> javax.el.MapELResolver@62ed6e4c, javax.el.ListELResolver@771cae93,
>>>>> javax.el.ArrayELResolver@20506258, javax.el.BeanELResolver@633c6e59]
>>>>> 16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1]
>>>>> javax.faces.component._ExternalSpecifications.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.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 - <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/application-development/java-ee-8-
>>>>>>>>>>>> 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 -
>>>>>>>>>>>>> <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/application-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 <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.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
>>>>>>>>>>>>>>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>>>>>>>>>>>>>>> <persistence xmlns="http://java.sun.com/xml
>>>>>>>>>>>>>>>>>> /ns/persistence"
>>>>>>>>>>>>>>>>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>>>>>>>>>>>>>>>> xsi:schemaLocation="http://jav
>>>>>>>>>>>>>>>>>> a.sun.com/xml/ns/persistence
>>>>>>>>>>>>>>>>>> http://java.sun.com/xml/ns/per
>>>>>>>>>>>>>>>>>> sistence/persistence_2_0.xsd"
>>>>>>>>>>>>>>>>>>            version="2.0">
>>>>>>>>>>>>>>>>>>            <persistence-unit name="file">
>>>>>>>>>>>>>>>>>> <jta-data-source>file</jta-data-source>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Box</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Category</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.CqsReview</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Department</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Enclosure</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Event</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.EventData</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.EventType</class>
>>>>>>>>>>>>>>>>>>                <!-- <class>uk.me.kissy.file.entiti
>>>>>>>>>>>>>>>>>> es.jpa.File</class>
>>>>>>>>>>>>>>>>>> -->
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Log</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Note</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Payment</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Price</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Undertaking</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti
>>>>>>>>>>>>>>>>>> es.jpa.UndertakingType</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Workflow</class>
>>>>>>>>>>>>>>>>>>                <properties>
>>>>>>>>>>>>>>>>>>                    <property
>>>>>>>>>>>>>>>>>> name="openjpa.jdbc.Synchronize
>>>>>>>>>>>>>>>>>> Mappings"
>>>>>>>>>>>>>>>>>> value="buildSchema(ForeignKeys=true)" />
>>>>>>>>>>>>>>>>>>                </properties>
>>>>>>>>>>>>>>>>>>            </persistence-unit>
>>>>>>>>>>>>>>>>>>            <persistence-unit name="operator">
>>>>>>>>>>>>>>>>>> <jta-data-source>operator</jta-data-source>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.operator.Address</
>>>>>>>>>>>>>>>>>> class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entiti
>>>>>>>>>>>>>>>>>> es.jpa.operator.Client</class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.operator.Council</
>>>>>>>>>>>>>>>>>> class>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.operator.Operator</
>>>>>>>>>>>>>>>>>> class>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.operator.Posttown</
>>>>>>>>>>>>>>>>>> class>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.operator.Wtr_auth</
>>>>>>>>>>>>>>>>>> class>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>            </persistence-unit>
>>>>>>>>>>>>>>>>>> </persistence>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message