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