tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Broadhead <matthew.broadh...@nbmlaw.co.uk>
Subject Re: [openjpa] multiple persistence units
Date Sat, 17 Mar 2018 08:18:36 GMT
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/eclipseWS/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.persistence.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.persistence.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.uk>
> 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.DelegatingMethodAccessorImpl.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.FlashELResolver@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.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: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@3ad8d37d
>>>>>>>>>>>> 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/application-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://java.sun.com/xml/ns/persistence
>>>>>>>>>>>>>>>>> http://java.sun.com/xml/ns/persistence/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
View raw message