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 | Blog > | Old Blog > | Github | > LinkedIn | Book > > > 2018-03-16 14:44 GMT+01:00 Matthew Broadhead > : >> https://gist.github.com/chongma/f019380ec6109d566b8b3444a41814eb >> >> >> On 16/03/2018 14:37, Romain Manni-Bucau wrote: >> >>> 2018-03-16 14:30 GMT+01:00 Matthew Broadhead < >>> matthew.broadhead@nbmlaw.co.uk >>> >>>> : >>>> i searched for adjusting but found nothing. do you want to see the whole >>>> log file? can the mailing list take attachments or do i have to send it >>>> another way? >>>> >>> a gist/pastebin would be fine >>> >>> >>> it has some stuff like this: >>>> 216070 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>> 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 - >>> 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 - >>> 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 - >>> 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 - >>> 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 - >>> 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 - >>> 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 - >>> 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 - >>> 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 - >>> 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 - >>> 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 - >>> 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 | Blog >>>>> | Old Blog >>>>> | Github < >>>>> https://github.com/rmannibucau> | >>>>> LinkedIn | Book >>>>> >>>> high-performance> >>>>> >>>>> 2018-03-16 12:25 GMT+01:00 Matthew Broadhead < >>>>> matthew.broadhead@nbmlaw.co.uk >>>>> >>>>> : >>>>>> the relevant part of the log seems to be: >>>>>> >>>>>> 231734 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 865011519> [167 ms] spent >>>>>> 231901 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 865011519> [0 ms] commit >>>>>> 231901 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 865011519> [0 ms] close >>>>>> 231902 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1788652555> [0 ms] rollback >>>>>> 231902 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 1788652555> [225 ms] spent >>>>>> 232127 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1788652555> [0 ms] commit >>>>>> 232128 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1788652555> [0 ms] close >>>>>> 232129 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1856856880> [0 ms] rollback >>>>>> 232129 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 1856856880> [212 ms] spent >>>>>> 232342 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1856856880> [1 ms] commit >>>>>> 232342 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1856856880> [0 ms] close >>>>>> 232343 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 910550352> [0 ms] rollback >>>>>> 232343 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 910550352> [288 ms] spent >>>>>> 232631 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 910550352> [0 ms] commit >>>>>> 232632 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 910550352> [0 ms] close >>>>>> 232633 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1652020186> [0 ms] rollback >>>>>> 232633 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 1652020186> [320 ms] spent >>>>>> 232953 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1652020186> [0 ms] commit >>>>>> 232953 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1652020186> [0 ms] close >>>>>> 232954 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 25303698> [0 ms] rollback >>>>>> 232954 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 25303698> [256 ms] spent >>>>>> 233210 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 25303698> [0 ms] commit >>>>>> 233210 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 25303698> [0 ms] close >>>>>> 233211 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1200479413> [0 ms] rollback >>>>>> 233211 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 1200479413> [212 ms] spent >>>>>> 233423 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1200479413> [0 ms] commit >>>>>> 233423 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1200479413> [0 ms] close >>>>>> 233424 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 684696833> [0 ms] rollback >>>>>> 233424 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 684696833> [259 ms] spent >>>>>> 233683 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 684696833> [0 ms] commit >>>>>> 233683 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 684696833> [0 ms] close >>>>>> 233684 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 976916420> [0 ms] rollback >>>>>> 233684 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 976916420> [296 ms] spent >>>>>> 233980 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 976916420> [0 ms] commit >>>>>> 233981 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 976916420> [0 ms] close >>>>>> 233981 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 737216388> [0 ms] rollback >>>>>> 233982 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 737216388> [268 ms] spent >>>>>> 234250 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 737216388> [0 ms] commit >>>>>> 234250 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 737216388> [0 ms] close >>>>>> 234251 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 676196467> [0 ms] rollback >>>>>> 234251 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 676196467> [211 ms] spent >>>>>> 234462 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 676196467> [0 ms] commit >>>>>> 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 676196467> [0 ms] close >>>>>> 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1395003156> [0 ms] rollback >>>>>> 234463 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 1395003156> [272 ms] spent >>>>>> 234735 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1395003156> [0 ms] commit >>>>>> 234735 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1395003156> [0 ms] close >>>>>> 234736 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1481756422> [0 ms] rollback >>>>>> 234736 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 1481756422> [340 ms] spent >>>>>> 235077 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1481756422> [1 ms] commit >>>>>> 235077 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1481756422> [0 ms] close >>>>>> 235078 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1762875674> [0 ms] rollback >>>>>> 235078 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 1762875674> [211 ms] spent >>>>>> 235290 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1762875674> [0 ms] commit >>>>>> 235290 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1762875674> [0 ms] close >>>>>> 235291 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1179694077> [1 ms] rollback >>>>>> 235291 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 1179694077> [233 ms] spent >>>>>> 235524 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1179694077> [0 ms] commit >>>>>> 235525 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 1179694077> [0 ms] close >>>>>> 235526 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 469864432> [0 ms] rollback >>>>>> 235526 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.SQL - >>>>> 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 - >>>>> 145697756, conn 469864432> [259 ms] spent >>>>>> 235785 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 145697756, conn 469864432> [0 ms] commit >>>>>> 235786 file TRACE [http-nio-8080-exec-7] openjpa.jdbc.JDBC - >>>>> 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 | Blog >>>>>>>> | Old Blog >>>>>>>> | Github < >>>>>>>> https://github.com/rmannibucau> | >>>>>>>> LinkedIn | Book >>>>>>>> >>>>>>> high-performance> >>>>>>>> >>>>>>>> 2018-03-16 9:46 GMT+01:00 Matthew Broadhead < >>>>>>>> matthew.broadhead@nbmlaw.co.uk> >>>>>>>> : >>>>>>>> >>>>>>>> they are both mysql databases >>>>>>>> >>>>>>>> On 16/03/2018 09:33, Romain Manni-Bucau wrote: >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> this is the way to do, maybe check your system properties and >>>>>>>>>> database >>>>>>>>>> configurations. With some DB you can need some more config >>>>>>>>>> (thinking >>>>>>>>>> to >>>>>>>>>> oracle and schemas for instance) >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Romain Manni-Bucau >>>>>>>>>> @rmannibucau | Blog >>>>>>>>>> | Old Blog >>>>>>>>>> | Github < >>>>>>>>>> https://github.com/rmannibucau> | >>>>>>>>>> LinkedIn | Book >>>>>>>>>> >>>>>>>>> high-performance> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> 2018-03-16 9:23 GMT+01:00 Matthew Broadhead < >>>>>>>>>> matthew.broadhead@nbmlaw.co.uk> >>>>>>>>>> : >>>>>>>>>> >>>>>>>>>> hi, >>>>>>>>>> >>>>>>>>>> i just wrote an email to users@openjpa but there doesn't seem to >>>>>>>>>> be >>>>>>>>>> >>>>>>>>>>> much >>>>>>>>>>> activity there. >>>>>>>>>>> do you know how to declare multiple persistence units? i created >>>>>>>>>>> 2 >>>>>>>>>>> persistence units inside persistence.xml but it seems to create >>>>>>>>>>> the >>>>>>>>>>> entities from the second PU in the database of the first one. my >>>>>>>>>>> persistence.xml is like this. the operator tables get created >>>>>>>>>>> inside >>>>>>>>>>> the >>>>>>>>>>> file database >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> 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"> >>>>>>>>>>> >>>>>>>>>>> file >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Box >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Category >>>>>>>>>>> uk.me.kissy.file.entities.jpa.CqsReview >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Department >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Enclosure >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Event >>>>>>>>>>> uk.me.kissy.file.entities.jpa.EventData >>>>>>>>>>> uk.me.kissy.file.entities.jpa.EventType >>>>>>>>>>> >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Log >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Note >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Payment >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Price >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Undertaking >>>>>>>>>>> uk.me.kissy.file.entities.jpa.UndertakingType >>>>>>>>>>> uk.me.kissy.file.entities.jpa.Workflow >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> value="buildSchema(ForeignKeys=true)" /> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> operator >>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Address >>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Client >>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Council >>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Operator >>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Posttown >>>>>>>>>>> uk.me.kissy.file.entities.jpa.operator.Wtr_auth >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>>