tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Broadhead <matthew.broadh...@nbmlaw.co.uk>
Subject Re: [openjpa] multiple persistence units
Date Fri, 16 Mar 2018 14:44:42 GMT
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.ImplicitObjectResolver@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.ImplicitObjectResolver@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.StreamELResolverImpl@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.broadhead@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.broadhead@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.broadhead@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.broadhead@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.broadhead@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.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>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>
>



Mime
View raw message