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.entities.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> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >