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:34:44 GMT
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