Re: [openjpa] multiple persistence units

Fri, 16 Mar 2018 04:25:58 -0700 

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




























					Reply via email to