Can you prepare a sample on github re1dy to compile/run (with hsqldb maybe)?
Le 17 mars 2018 09:18, "Matthew Broadhead" <matthew.broadh...@nbmlaw.co.uk> a écrit : > it is exactly the same. still creating the tables in first db. here is > section from catalina > > 17-Mar-2018 09:10:51.900 INFO [localhost-startStop-1] > org.apache.tomee.catalina.TomcatWebAppBuilder.init > ------------------------- localhost -> /file > ... > 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1] > org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking > resource-ref 'java:comp/env/jdbc/MySQL' in bean FileTimer to > Resource(id=jdbc/MySQL) > 17-Mar-2018 09:10:53.494 INFO [localhost-startStop-1] > org.apache.openejb.config.AutoConfig.processResourceRef Auto-linking > resource-ref 'java:comp/env/jdbc/MySQL' in bean file.Comp582347742 to > Resource(id=jdbc/MySQL) > 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1] > org.apache.openejb.config.AutoConfig.deploy Configuring > PersistenceUnit(name=file) > 17-Mar-2018 09:10:53.495 INFO [localhost-startStop-1] > org.apache.openejb.config.AutoConfig.deploy Configuring > PersistenceUnit(name=operator) > 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1] > org.apache.openejb.config.AppInfoBuilder.build Enterprise application > "/Users/matthewbroadhead/eclipseWS/case-management/.metadata > /.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/file" loaded. > 17-Mar-2018 09:10:53.498 INFO [localhost-startStop-1] > org.apache.openejb.assembler.classic.Assembler.createApplication > Assembling app: /Users/matthewbroadhead/eclips > eWS/case-management/.metadata/.plugins/org.eclipse.wst. > server.core/tmp0/wtpwebapps/file > 17-Mar-2018 09:10:53.551 INFO [localhost-startStop-1] > org.apache.openejb.assembler.classic.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.broadh...@nbmlaw.co.u >> k> >> a écrit : >> >> this is the bit just after all the webapp deployment, and the relevant >>> webapp deployment is in this gist https://gist.github.com/chongm >>> a/948a4a369c1f9eae9406a99b60f0472e >>> 16-Mar-2018 15:41:29.068 INFO [main] sun.reflect.DelegatingMethodAc >>> cessorImpl.invoke >>> Server startup in 104519 ms >>> 16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1] >>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain >>> of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified. >>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is >>> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli >>> citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELR >>> esolver@420a4ab9, >>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@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.broadh...@nbmlaw.co.uk >>>> >>>> : >>>>> this is all that came out >>>>> 16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1] >>>>> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers >>>>> Chain >>>>> of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified. >>>>> OpenWebBeansELResolverComparator@43bde3b9 and the result order is >>>>> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli >>>>> citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELR >>>>> esolver@420a4ab9, >>>>> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@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.broadh...@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.broadh...@nbmlaw.co.uk >>>>>>>>>> >>>>>>>>>> : >>>>>>>>>> >>>>>>>>>> i searched for adjusting but found nothing. do you want to see >>>>>>>>>>> the >>>>>>>>>>> whole >>>>>>>>>>> log file? can the mailing list take attachments or do i have to >>>>>>>>>>> send it >>>>>>>>>>> another way? >>>>>>>>>>> >>>>>>>>>>> a gist/pastebin would be fine >>>>>>>>>>> >>>>>>>>>>> it has some stuff like this: >>>>>>>>>> >>>>>>>>>> 216070 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - <t >>>>>>>>>> >>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>> 216070 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> table information for schema name "null", table name "Posttown". >>>>>>>>>>> 216070 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>> Posttown, >>>>>>>>>>> null >>>>>>>>>>> 216071 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>> 216072 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>> 216072 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> table information for schema name "null", table name "payment". >>>>>>>>>>> 216072 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>> payment, >>>>>>>>>>> null >>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> column information for table "payment". >>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Found >>>>>>>>>>> existing column "id" on table "payment". >>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Found >>>>>>>>>>> existing column "categoryid" on table "payment". >>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Found >>>>>>>>>>> existing column "name" on table "payment". >>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Found >>>>>>>>>>> existing column "value" on table "payment". >>>>>>>>>>> 216079 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>> 216080 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>> 216080 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> table information for schema name "null", table name "Operator". >>>>>>>>>>> 216080 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>> Operator, >>>>>>>>>>> null >>>>>>>>>>> 216081 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>> 216081 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>> 216081 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> table information for schema name "null", table name "Council". >>>>>>>>>>> 216082 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>> Council, >>>>>>>>>>> null >>>>>>>>>>> 216082 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>> 216083 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>> 216083 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> table information for schema name "null", table name "Client". >>>>>>>>>>> 216084 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>> Client, >>>>>>>>>>> null >>>>>>>>>>> 216085 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> sequence information for schema "null", sequence name "null". >>>>>>>>>>> 216086 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> [0 ms] commit >>>>>>>>>>> 216087 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.Schema - >>>>>>>>>>> Reading >>>>>>>>>>> table information for schema name "null", table name "event". >>>>>>>>>>> 216087 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>> <t >>>>>>>>>>> 145697756, conn 1016116032> getColumns: conveyancing, null, >>>>>>>>>>> event, >>>>>>>>>>> null >>>>>>>>>>> >>>>>>>>>>> also i wondered if i should move the second persistence unit >>>>>>>>>>> into a >>>>>>>>>>> jar >>>>>>>>>>> file to see if it made any difference >>>>>>>>>>> >>>>>>>>>>> shouldnt >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> On 16/03/2018 14:08, Romain Manni-Bucau wrote: >>>>>>>>>> >>>>>>>>>> do you have some "adjusting" lines in the logs? >>>>>>>>>>> >>>>>>>>>>> Romain Manni-Bucau >>>>>>>>>>> >>>>>>>>>>>> @rmannibucau <https://twitter.com/rmannibucau> | Blog >>>>>>>>>>>> <https://rmannibucau.metawerx.net/> | Old Blog >>>>>>>>>>>> <http://rmannibucau.wordpress.com> | Github < >>>>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>>>> LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book >>>>>>>>>>>> <https://www.packtpub.com/application-development/java-ee-8- >>>>>>>>>>>> high-performance> >>>>>>>>>>>> >>>>>>>>>>>> 2018-03-16 12:25 GMT+01:00 Matthew Broadhead < >>>>>>>>>>>> matthew.broadh...@nbmlaw.co.uk >>>>>>>>>>>> >>>>>>>>>>>> : >>>>>>>>>>>> >>>>>>>>>>>> the relevant part of the log seems to be: >>>>>>>>>>>> >>>>>>>>>>>>> 231734 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 865011519> executing stmnt 2028257349 CREATE >>>>>>>>>>>>> TABLE >>>>>>>>>>>>> Address >>>>>>>>>>>>> (address_n INTEGER NOT NULL, district VARCHAR(26), num_in_st >>>>>>>>>>>>> VARCHAR(11), >>>>>>>>>>>>> postcode VARCHAR(8), road VARCHAR(26), telephone VARCHAR(13), >>>>>>>>>>>>> title_no_1 >>>>>>>>>>>>> VARCHAR(9), title_no_2 VARCHAR(9), title_no_3 VARCHAR(9), unit >>>>>>>>>>>>> VARCHAR(30), >>>>>>>>>>>>> posttown_n INTEGER, PRIMARY KEY (address_n)) ENGINE = innodb >>>>>>>>>>>>> 231901 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 865011519> [167 ms] spent >>>>>>>>>>>>> 231901 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 865011519> [0 ms] commit >>>>>>>>>>>>> 231901 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 865011519> [0 ms] close >>>>>>>>>>>>> 231902 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1788652555> [0 ms] rollback >>>>>>>>>>>>> 231902 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1788652555> executing stmnt 1832391635 CREATE >>>>>>>>>>>>> TABLE >>>>>>>>>>>>> Client >>>>>>>>>>>>> (client_n INTEGER NOT NULL, birthdate DATETIME, forename >>>>>>>>>>>>> VARCHAR(33), >>>>>>>>>>>>> prefix VARCHAR(5), surname VARCHAR(25), teldaytime VARCHAR(18), >>>>>>>>>>>>> telfax >>>>>>>>>>>>> VARCHAR(13), telmobile VARCHAR(12), PRIMARY KEY (client_n)) >>>>>>>>>>>>> ENGINE >>>>>>>>>>>>> = >>>>>>>>>>>>> innodb >>>>>>>>>>>>> 232127 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1788652555> [225 ms] spent >>>>>>>>>>>>> 232127 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1788652555> [0 ms] commit >>>>>>>>>>>>> 232128 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1788652555> [0 ms] close >>>>>>>>>>>>> 232129 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1856856880> [0 ms] rollback >>>>>>>>>>>>> 232129 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1856856880> executing stmnt 1020559479 CREATE >>>>>>>>>>>>> TABLE >>>>>>>>>>>>> Council >>>>>>>>>>>>> (council_n INTEGER NOT NULL, county VARCHAR(16), district >>>>>>>>>>>>> VARCHAR(26), >>>>>>>>>>>>> dx >>>>>>>>>>>>> VARCHAR(26), fax VARCHAR(13), llc_fee DOUBLE, name VARCHAR(30), >>>>>>>>>>>>> need_plan >>>>>>>>>>>>> INTEGER, num_in_st VARCHAR(7), phone VARCHAR(13), postcode >>>>>>>>>>>>> VARCHAR(8), >>>>>>>>>>>>> posttown VARCHAR(20), road VARCHAR(25), unit VARCHAR(30), >>>>>>>>>>>>> wtr_agency >>>>>>>>>>>>> VARCHAR(1), PRIMARY KEY (council_n)) ENGINE = innodb >>>>>>>>>>>>> 232341 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1856856880> [212 ms] spent >>>>>>>>>>>>> 232342 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1856856880> [1 ms] commit >>>>>>>>>>>>> 232342 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1856856880> [0 ms] close >>>>>>>>>>>>> 232343 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 910550352> [0 ms] rollback >>>>>>>>>>>>> 232343 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 910550352> executing stmnt 185905453 CREATE >>>>>>>>>>>>> TABLE >>>>>>>>>>>>> opecli_l >>>>>>>>>>>>> (operator_n INTEGER, client_n INTEGER) ENGINE = innodb >>>>>>>>>>>>> 232631 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 910550352> [288 ms] spent >>>>>>>>>>>>> 232631 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 910550352> [0 ms] commit >>>>>>>>>>>>> 232632 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 910550352> [0 ms] close >>>>>>>>>>>>> 232633 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1652020186> [0 ms] rollback >>>>>>>>>>>>> 232633 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1652020186> executing stmnt 436027210 CREATE >>>>>>>>>>>>> TABLE >>>>>>>>>>>>> Operator >>>>>>>>>>>>> (operator_n INTEGER NOT NULL, abortive_d DATETIME, abowarned >>>>>>>>>>>>> DATETIME, >>>>>>>>>>>>> account_n INTEGER, agent_d DATETIME, branch_code VARCHAR(2), >>>>>>>>>>>>> categor >>>>>>>>>>>>> VARCHAR(1), client_add VARCHAR(30), client_ref VARCHAR(10), >>>>>>>>>>>>> cntr_del_d >>>>>>>>>>>>> DATETIME, complset_d DATETIME, deeds_in_d DATETIME, enquiry_n >>>>>>>>>>>>> INTEGER, >>>>>>>>>>>>> exchange_d DATETIME, fee_earner VARCHAR(3), lawyer_d DATETIME, >>>>>>>>>>>>> llc_in_d >>>>>>>>>>>>> DATETIME, lowfeebill DATETIME, lowfeeinst DATETIME, mtg_offr_d >>>>>>>>>>>>> DATETIME, >>>>>>>>>>>>> qaire_in_d DATETIME, related_n INTEGER, subject VARCHAR(30), >>>>>>>>>>>>> surname >>>>>>>>>>>>> VARCHAR(20), water_in_d DATETIME, subjec_a_n INTEGER, PRIMARY >>>>>>>>>>>>> KEY >>>>>>>>>>>>> (operator_n)) ENGINE = innodb >>>>>>>>>>>>> 232953 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1652020186> [320 ms] spent >>>>>>>>>>>>> 232953 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1652020186> [0 ms] commit >>>>>>>>>>>>> 232953 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1652020186> [0 ms] close >>>>>>>>>>>>> 232954 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 25303698> [0 ms] rollback >>>>>>>>>>>>> 232954 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 25303698> executing stmnt 636986972 CREATE >>>>>>>>>>>>> TABLE >>>>>>>>>>>>> o_addr_l >>>>>>>>>>>>> (operator_n INTEGER, address_n INTEGER) ENGINE = innodb >>>>>>>>>>>>> 233210 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 25303698> [256 ms] spent >>>>>>>>>>>>> 233210 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 25303698> [0 ms] commit >>>>>>>>>>>>> 233210 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 25303698> [0 ms] close >>>>>>>>>>>>> 233211 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1200479413> [0 ms] rollback >>>>>>>>>>>>> 233211 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1200479413> executing stmnt 1599100766 CREATE >>>>>>>>>>>>> TABLE >>>>>>>>>>>>> Posttown (posttown_n INTEGER NOT NULL, county VARCHAR(22), >>>>>>>>>>>>> posttown >>>>>>>>>>>>> VARCHAR(22), council_n INTEGER, wtr_auth_n INTEGER, PRIMARY KEY >>>>>>>>>>>>> (posttown_n)) ENGINE = innodb >>>>>>>>>>>>> 233423 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1200479413> [212 ms] spent >>>>>>>>>>>>> 233423 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1200479413> [0 ms] commit >>>>>>>>>>>>> 233423 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1200479413> [0 ms] close >>>>>>>>>>>>> 233424 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 684696833> [0 ms] rollback >>>>>>>>>>>>> 233424 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 684696833> executing stmnt 1154075410 CREATE >>>>>>>>>>>>> TABLE >>>>>>>>>>>>> Wtr_auth >>>>>>>>>>>>> (wtr_auth_n INTEGER NOT NULL, county VARCHAR(16), district >>>>>>>>>>>>> VARCHAR(26), >>>>>>>>>>>>> dx >>>>>>>>>>>>> VARCHAR(26), fax VARCHAR(13), name VARCHAR(30), num_in_st >>>>>>>>>>>>> VARCHAR(7), >>>>>>>>>>>>> phone >>>>>>>>>>>>> VARCHAR(13), postcode VARCHAR(8), posttown VARCHAR(20), road >>>>>>>>>>>>> VARCHAR(25), >>>>>>>>>>>>> sch_fee DOUBLE, unit VARCHAR(30), PRIMARY KEY (wtr_auth_n)) >>>>>>>>>>>>> ENGINE >>>>>>>>>>>>> = >>>>>>>>>>>>> innodb >>>>>>>>>>>>> 233683 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 684696833> [259 ms] spent >>>>>>>>>>>>> 233683 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 684696833> [0 ms] commit >>>>>>>>>>>>> 233683 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 684696833> [0 ms] close >>>>>>>>>>>>> 233684 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 976916420> [0 ms] rollback >>>>>>>>>>>>> 233684 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 976916420> executing stmnt 830816227 CREATE >>>>>>>>>>>>> INDEX >>>>>>>>>>>>> I_ADDRESS_POSTTOWN ON Address (posttown_n) >>>>>>>>>>>>> 233980 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 976916420> [296 ms] spent >>>>>>>>>>>>> 233980 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 976916420> [0 ms] commit >>>>>>>>>>>>> 233981 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 976916420> [0 ms] close >>>>>>>>>>>>> 233981 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 737216388> [0 ms] rollback >>>>>>>>>>>>> 233982 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 737216388> executing stmnt 794352343 CREATE >>>>>>>>>>>>> INDEX >>>>>>>>>>>>> I_OPCLI_L_ELEMENT ON opecli_l (client_n) >>>>>>>>>>>>> 234250 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 737216388> [268 ms] spent >>>>>>>>>>>>> 234250 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 737216388> [0 ms] commit >>>>>>>>>>>>> 234250 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 737216388> [0 ms] close >>>>>>>>>>>>> 234251 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 676196467> [0 ms] rollback >>>>>>>>>>>>> 234251 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 676196467> executing stmnt 1101666767 CREATE >>>>>>>>>>>>> INDEX >>>>>>>>>>>>> I_OPCLI_L_OPERATOR_N ON opecli_l (operator_n) >>>>>>>>>>>>> 234462 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 676196467> [211 ms] spent >>>>>>>>>>>>> 234462 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 676196467> [0 ms] commit >>>>>>>>>>>>> 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 676196467> [0 ms] close >>>>>>>>>>>>> 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1395003156> [0 ms] rollback >>>>>>>>>>>>> 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1395003156> executing stmnt 1112735966 CREATE >>>>>>>>>>>>> INDEX >>>>>>>>>>>>> I_OPERTOR_ADDRESS ON Operator (subjec_a_n) >>>>>>>>>>>>> 234735 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1395003156> [272 ms] spent >>>>>>>>>>>>> 234735 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1395003156> [0 ms] commit >>>>>>>>>>>>> 234735 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1395003156> [0 ms] close >>>>>>>>>>>>> 234736 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1481756422> [0 ms] rollback >>>>>>>>>>>>> 234736 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1481756422> executing stmnt 48128290 CREATE >>>>>>>>>>>>> INDEX >>>>>>>>>>>>> I_O_DDR_L_ELEMENT ON o_addr_l (address_n) >>>>>>>>>>>>> 235076 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1481756422> [340 ms] spent >>>>>>>>>>>>> 235077 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1481756422> [1 ms] commit >>>>>>>>>>>>> 235077 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1481756422> [0 ms] close >>>>>>>>>>>>> 235078 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1762875674> [0 ms] rollback >>>>>>>>>>>>> 235078 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1762875674> executing stmnt 414573163 CREATE >>>>>>>>>>>>> INDEX >>>>>>>>>>>>> I_O_DDR_L_OPERATOR_N ON o_addr_l (operator_n) >>>>>>>>>>>>> 235289 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1762875674> [211 ms] spent >>>>>>>>>>>>> 235290 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1762875674> [0 ms] commit >>>>>>>>>>>>> 235290 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1762875674> [0 ms] close >>>>>>>>>>>>> 235291 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1179694077> [1 ms] rollback >>>>>>>>>>>>> 235291 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1179694077> executing stmnt 1845663100 CREATE >>>>>>>>>>>>> INDEX >>>>>>>>>>>>> I_PSTTOWN_COUNCIL ON Posttown (council_n) >>>>>>>>>>>>> 235524 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1179694077> [233 ms] spent >>>>>>>>>>>>> 235524 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1179694077> [0 ms] commit >>>>>>>>>>>>> 235525 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 1179694077> [0 ms] close >>>>>>>>>>>>> 235526 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 469864432> [0 ms] rollback >>>>>>>>>>>>> 235526 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 469864432> executing stmnt 1716670585 CREATE >>>>>>>>>>>>> INDEX >>>>>>>>>>>>> I_PSTTOWN_WTR_AUTH ON Posttown (wtr_auth_n) >>>>>>>>>>>>> 235785 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 469864432> [259 ms] spent >>>>>>>>>>>>> 235785 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 469864432> [0 ms] commit >>>>>>>>>>>>> 235786 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>>>>>>>>>> <t >>>>>>>>>>>>> 145697756, conn 469864432> [0 ms] close >>>>>>>>>>>>> 235802 file TRACE [http-nio-8080-exec-7] openjpa.Runtime - >>>>>>>>>>>>> Found >>>>>>>>>>>>> datasource1: datasource 270095066 from configuration. >>>>>>>>>>>>> StoreContext: >>>>>>>>>>>>> org.apache.openjpa.kernel.BrokerImpl@53900e77 >>>>>>>>>>>>> 235828 file TRACE [http-nio-8080-exec-7] openjpa.Runtime - >>>>>>>>>>>>> org.apache.openjpa.persistence.EntityManagerFactoryImpl@3ad8 >>>>>>>>>>>>> d37d >>>>>>>>>>>>> created >>>>>>>>>>>>> EntityManager org.apache.openjpa.persistence >>>>>>>>>>>>> .EntityManagerImpl@53900e77. >>>>>>>>>>>>> 235840 file TRACE [http-nio-8080-exec-7] openjpa.MetaData - >>>>>>>>>>>>> Loading >>>>>>>>>>>>> metadata for "class uk.me.kissy.file.entities.jpa. >>>>>>>>>>>>> operator.Posttown" >>>>>>>>>>>>> under mode "[META][QUERY]". >>>>>>>>>>>>> 235841 file TRACE [http-nio-8080-exec-7] openjpa.MetaData - >>>>>>>>>>>>> Parsing >>>>>>>>>>>>> resource "file:/Users/matthewbroadhead/ >>>>>>>>>>>>> eclipseWS/case-management/.met >>>>>>>>>>>>> adata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/ >>>>>>>>>>>>> file/WEB-INF/classes/META-INF/orm.xml". >>>>>>>>>>>>> 235841 file TRACE [http-nio-8080-exec-7] openjpa.MetaData - >>>>>>>>>>>>> Overriding >>>>>>>>>>>>> thread context classloader from "TomEEWebappClassLoader >>>>>>>>>>>>> >>>>>>>>>>>>> it doesn't specify how it determines which resource it is using >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On 16/03/2018 11:42, Matthew Broadhead wrote: >>>>>>>>>>>>> >>>>>>>>>>>>> that is a good idea! i will try that. i was thinking it might >>>>>>>>>>>>> be >>>>>>>>>>>>> >>>>>>>>>>>>> necessary to specify the schema at the top of the @Entity in >>>>>>>>>>>>> the >>>>>>>>>>>>> >>>>>>>>>>>>> @Table >>>>>>>>>>>>>> annotation. i haven't tried that yet but i will try the >>>>>>>>>>>>>> logging >>>>>>>>>>>>>> first >>>>>>>>>>>>>> to >>>>>>>>>>>>>> see if it shows anything. >>>>>>>>>>>>>> >>>>>>>>>>>>>> On 16/03/2018 10:17, Romain Manni-Bucau wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>> maybe activate sql logging to check what is happening exactly >>>>>>>>>>>>>> >>>>>>>>>>>>>> (LogSql=true >>>>>>>>>>>>>> >>>>>>>>>>>>>> for instance) >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Romain Manni-Bucau >>>>>>>>>>>>>>> @rmannibucau <https://twitter.com/rmannibucau> | Blog >>>>>>>>>>>>>>> <https://rmannibucau.metawerx.net/> | Old Blog >>>>>>>>>>>>>>> <http://rmannibucau.wordpress.com> | Github < >>>>>>>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>>>>>>> LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book >>>>>>>>>>>>>>> <https://www.packtpub.com/application-development/java-ee-8- >>>>>>>>>>>>>>> high-performance> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> 2018-03-16 9:46 GMT+01:00 Matthew Broadhead < >>>>>>>>>>>>>>> matthew.broadh...@nbmlaw.co.uk> >>>>>>>>>>>>>>> : >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> they are both mysql databases >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On 16/03/2018 09:33, Romain Manni-Bucau wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> this is the way to do, maybe check your system properties >>>>>>>>>>>>>>>> and >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> database >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> configurations. With some DB you can need some more config >>>>>>>>>>>>>>>>> (thinking >>>>>>>>>>>>>>>>> to >>>>>>>>>>>>>>>>> oracle and schemas for instance) >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Romain Manni-Bucau >>>>>>>>>>>>>>>>> @rmannibucau <https://twitter.com/rmannibucau> | Blog >>>>>>>>>>>>>>>>> <https://rmannibucau.metawerx.net/> | Old Blog >>>>>>>>>>>>>>>>> <http://rmannibucau.wordpress.com> | Github < >>>>>>>>>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>>>>>>>>> LinkedIn <https://www.linkedin.com/in/rmannibucau> | Book >>>>>>>>>>>>>>>>> <https://www.packtpub.com/appl >>>>>>>>>>>>>>>>> ication-development/java-ee-8- >>>>>>>>>>>>>>>>> high-performance> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> 2018-03-16 9:23 GMT+01:00 Matthew Broadhead < >>>>>>>>>>>>>>>>> matthew.broadh...@nbmlaw.co.uk> >>>>>>>>>>>>>>>>> : >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> hi, >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> i just wrote an email to users@openjpa but there doesn't >>>>>>>>>>>>>>>>> seem >>>>>>>>>>>>>>>>> to >>>>>>>>>>>>>>>>> be >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> much >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> activity there. >>>>>>>>>>>>>>>>>> do you know how to declare multiple persistence units? i >>>>>>>>>>>>>>>>>> created >>>>>>>>>>>>>>>>>> 2 >>>>>>>>>>>>>>>>>> persistence units inside persistence.xml but it seems to >>>>>>>>>>>>>>>>>> create >>>>>>>>>>>>>>>>>> the >>>>>>>>>>>>>>>>>> entities from the second PU in the database of the first >>>>>>>>>>>>>>>>>> one. my >>>>>>>>>>>>>>>>>> persistence.xml is like this. the operator tables get >>>>>>>>>>>>>>>>>> created >>>>>>>>>>>>>>>>>> inside >>>>>>>>>>>>>>>>>> the >>>>>>>>>>>>>>>>>> file database >>>>>>>>>>>>>>>>>> <?xml version="1.0" encoding="UTF-8"?> >>>>>>>>>>>>>>>>>> <persistence xmlns="http://java.sun.com/xml >>>>>>>>>>>>>>>>>> /ns/persistence" >>>>>>>>>>>>>>>>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >>>>>>>>>>>>>>>>>> xsi:schemaLocation="http://jav >>>>>>>>>>>>>>>>>> a.sun.com/xml/ns/persistence >>>>>>>>>>>>>>>>>> http://java.sun.com/xml/ns/per >>>>>>>>>>>>>>>>>> sistence/persistence_2_0.xsd" >>>>>>>>>>>>>>>>>> version="2.0"> >>>>>>>>>>>>>>>>>> <persistence-unit name="file"> >>>>>>>>>>>>>>>>>> <jta-data-source>file</jta-data-source> >>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.entities.jpa.Box</class> >>>>>>>>>>>>>>>>>> <class>uk.me.kissy.file.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> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>> >