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 <[email protected] >: > 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 < >> [email protected] >> >>> : >>> 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 < >>>> [email protected] >>>> >>>> : >>>>> 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 < >>>>>>> [email protected]> >>>>>>> : >>>>>>> >>>>>>> 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 < >>>>>>>>> [email protected]> >>>>>>>>> : >>>>>>>>> >>>>>>>>> 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.SynchronizeMappings" >>>>>>>>>> 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> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >
