Hmm, i dont see the startup logs, typically it is in catalina.log or so,
you should have lines about your webapp deployment too.


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 15:44 GMT+01:00 Matthew Broadhead <matthew.broadh...@nbmlaw.co.uk
>:

> this is all that came out
> 16-Mar-2018 15:43:19.844 INFO [http-nio-8080-exec-1]
> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
> of EL resolvers for JSP sorted with: org.apache.myfaces.el.unified.
> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
> citObjectResolver@e6ec1ab, org.apache.myfaces.el.FlashELResolver@420a4ab9,
> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@6b7fda40,
> org.apache.myfaces.el.unified.resolver.ResourceBundleResolver@47f35cbd,
> org.apache.myfaces.el.unified.resolver.ResourceResolver@3f68ae71,
> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
> org.apache.myfaces.el.convert.VariableResolverToELResolver@3a9f16c9,
> org.apache.myfaces.el.convert.PropertyResolverToELResolver@6754a393]
> 16-Mar-2018 15:43:20.168 INFO [http-nio-8080-exec-1]
> org.apache.myfaces.el.unified.ResolverBuilderBase.sortELResolvers Chain
> of EL resolvers for Faces sorted with: org.apache.myfaces.el.unified.
> OpenWebBeansELResolverComparator@43bde3b9 and the result order is
> [org.apache.myfaces.el.unified.resolver.implicitobject.Impli
> citObjectResolver@1db5922e, org.apache.myfaces.el.unified.
> resolver.CompositeComponentELResolver@9235f63,
> org.apache.webbeans.el22.WebBeansELResolver@2fa764a7,
> org.apache.myfaces.el.convert.VariableResolverToELResolver@4b4839d0,
> org.apache.myfaces.el.convert.PropertyResolverToELResolver@9c25311,
> org.apache.myfaces.el.FlashELResolver@38d794e5,
> org.apache.myfaces.el.unified.resolver.ManagedBeanResolver@2b9c0cdb,
> org.apache.myfaces.el.unified.resolver.ResourceResolver@219026c1,
> javax.el.ResourceBundleELResolver@3ad1a339, org.apache.myfaces.el.unified.
> resolver.ResourceBundleResolver@3e25683a, org.apache.el.stream.StreamELR
> esolverImpl@759451f1, javax.el.StaticFieldELResolver@5592c7ac,
> javax.el.MapELResolver@62ed6e4c, javax.el.ListELResolver@771cae93,
> javax.el.ArrayELResolver@20506258, javax.el.BeanELResolver@633c6e59]
> 16-Mar-2018 15:43:20.326 INFO [http-nio-8080-exec-1]
> javax.faces.component._ExternalSpecifications.isBeanValidationAvailable
> MyFaces Bean Validation support enabled
> 16-Mar-2018 15:43:21.686 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE box ADD finishedId INTEGER --> 182ms
> 16-Mar-2018 15:43:22.037 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE box ADD userId INTEGER --> 348ms
> 16-Mar-2018 15:43:22.250 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE box ADD version BIGINT --> 211ms
> 16-Mar-2018 15:43:22.459 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE category ADD version BIGINT --> 205ms
> 16-Mar-2018 15:43:22.594 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE cqsreview ADD version BIGINT --> 132ms
> 16-Mar-2018 15:43:22.866 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE department ADD version BIGINT --> 270ms
> 16-Mar-2018 15:43:26.886 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE event ADD userId INTEGER --> 4017ms
> 16-Mar-2018 15:43:30.978 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE event ADD version BIGINT --> 4088ms
> 16-Mar-2018 15:43:31.223 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE eventtype ADD version BIGINT --> 241ms
> 16-Mar-2018 15:43:31.959 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE file ADD version BIGINT --> 733ms
> 16-Mar-2018 15:43:32.552 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE log ADD userId INTEGER --> 590ms
> 16-Mar-2018 15:43:33.237 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE log ADD version BIGINT --> 682ms
> 16-Mar-2018 15:43:34.606 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE note ADD userId INTEGER --> 1364ms
> 16-Mar-2018 15:43:36.223 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE note ADD version BIGINT --> 1426ms
> 16-Mar-2018 15:43:36.493 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE undertaking ADD userId INTEGER --> 266ms
> 16-Mar-2018 15:43:36.725 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE undertaking ADD version BIGINT --> 229ms
> 16-Mar-2018 15:43:36.897 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke ALTER
> TABLE undertakingtype ADD version BIGINT --> 169ms
> 16-Mar-2018 15:43:37.100 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> 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 --> 100ms
> 16-Mar-2018 15:43:37.334 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> 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 --> 231ms
> 16-Mar-2018 15:43:37.547 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> 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 --> 210ms
> 16-Mar-2018 15:43:38.073 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE TABLE opecli_l (operator_n INTEGER, client_n INTEGER) ENGINE =
> innodb --> 523ms
> 16-Mar-2018 15:43:38.396 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> 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 --> 320ms
> 16-Mar-2018 15:43:38.724 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE TABLE o_addr_l (operator_n INTEGER, address_n INTEGER) ENGINE =
> innodb --> 326ms
> 16-Mar-2018 15:43:38.954 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> 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 --> 227ms
> 16-Mar-2018 15:43:39.209 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> 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 --> 253ms
> 16-Mar-2018 15:43:39.433 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE INDEX I_ADDRESS_POSTTOWN ON Address (posttown_n) --> 221ms
> 16-Mar-2018 15:43:39.647 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE INDEX I_OPCLI_L_ELEMENT ON opecli_l (client_n) --> 212ms
> 16-Mar-2018 15:43:39.928 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE INDEX I_OPCLI_L_OPERATOR_N ON opecli_l (operator_n) --> 278ms
> 16-Mar-2018 15:43:40.278 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE INDEX I_OPERTOR_ADDRESS ON Operator (subjec_a_n) --> 349ms
> 16-Mar-2018 15:43:40.494 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE INDEX I_O_DDR_L_ELEMENT ON o_addr_l (address_n) --> 213ms
> 16-Mar-2018 15:43:40.686 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE INDEX I_O_DDR_L_OPERATOR_N ON o_addr_l (operator_n) --> 190ms
> 16-Mar-2018 15:43:40.894 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE INDEX I_PSTTOWN_COUNCIL ON Posttown (council_n) --> 205ms
> 16-Mar-2018 15:43:41.222 INFO [http-nio-8080-exec-1]
> org.apache.openejb.resource.jdbc.logging.LoggingSqlStatement.invoke
> CREATE INDEX I_PSTTOWN_WTR_AUTH ON Posttown (wtr_auth_n) --> 326ms
>
>
>
> On 16/03/2018 15:37, Matthew Broadhead wrote:
>
>> sorry actually it is already writing to file and console.  i will see if
>> i can get it more verbose
>>
>> On 16/03/2018 15:34, Matthew Broadhead wrote:
>>
>>> 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 <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 <
>>>> matthew.broadh...@nbmlaw.co.uk
>>>>
>>>>> :
>>>>> 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.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.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.Synchronize
>>>>>>>>>>>>>> Mappings"
>>>>>>>>>>>>>> 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