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.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: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@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.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/application-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://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.entities.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.entities.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> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>> >> > >