Hibernate Books

All times are UTC - 5 hours [ DST ]



Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Mon Jun 19, 2017 9:06 am 
Newbie

Joined: Mon Jun 19, 2017 5:31 am
Posts: 6
I successfully configured Hibernate to use batch query to create/update objects but there is a scenario that isn't working yet.

I've 3 entities: - Main Entity - Entity A - Entity B

Main Entity has ManyToMany relation with both Entity A and Entity B. Main Entity is the owner of the relation:
Code:
@ManyToMany
@JoinTable(name = "MAIN_A", joinColumns = {
@JoinColumn(name = "MAIN_UID", nullable = false, updatable = false) }, inverseJoinColumns = {
@JoinColumn(name = "A_UID", nullable = false, updatable = false) })
private Set<EntityA> entitiesA = new HashSet<>(0);

@ManyToMany
@JoinTable(name = "MAIN_B", joinColumns = {
@JoinColumn(name = "MAIN_UID", nullable = false, updatable = false) }, inverseJoinColumns = {
@JoinColumn(name = "B_UID", nullable = false, updatable = false) })
private Set<EntityB> entitiesB = new HashSet<>(0);


I wrote a 3 simple test. First I create some Entity A and Entity B rows in the database (this is in common with all 2 test cases).

First scenario: Create n Main Entity and for each set only the Entity A

Result: Only one insert for all the Main Entity and MAIN_A table entries. So in this case the bath insertion is working as expected.

Second scenario: Create n Main Entity and for each set only the Entity B

Result: Only one insert for all the Main Entity and MAIN_B table entries. So in this case the bath insertion is working as expected.

Third scenario: Create n Main Entity and for each set both Entity A and the Entity B

Result: Only one insert for all the Main Entity and n insert for both MAIN A and MAIN_B table entries. In this case the batch insert didn't work. I googled and searched but I couldn't find an answer.

Does anyone know why it isn't working as expected in the third case? Am I doing anything wrong? Is there anything in the configuration that address my requirement?

The code of the 3 scenarios is pretty straightforward:
Code:
  Set<EntityA> setA;
  Set<EntityB> setB;
  for (long i = 1; i < n; i++) {

  MainEntity e = new MainEntity();
  ac.setEntitiesA(setA); //this is commented in the second scenario
  ac.setEntitiesB(setB); // this is commented in the first scenario

  session.save(e);
}


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Mon Jun 19, 2017 9:41 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1527
1. Why do you use updatable = false on every @JoinColumn? What is the purpose of not propagating the FK update?

2. You said that you only saved MainEntity, and the other entities would be saved as well. If that is true, why don't you have a cascade association on your mappings? It just doesn't add up.

3. As explained in this article, cascading might interfere with JDBC batch updates. Try setting the following Hibernate configuration properties:

Code:
properties.put("hibernate.order_inserts", "true");
properties.put("hibernate.order_updates", "true");

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Tue Jun 20, 2017 3:42 am 
Newbie

Joined: Mon Jun 19, 2017 5:31 am
Posts: 6
1. FK in my scenario are never updated so I set them as updateable = false
2. You're right, I manually save them since I want to keep the control for now
3. These properties are already set

Any clue about what the cause could be?


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Tue Jun 20, 2017 3:52 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1527
If you can write a replicating test case, then you should open a Jira issue.

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Tue Jun 20, 2017 5:39 am 
Newbie

Joined: Mon Jun 19, 2017 5:31 am
Posts: 6
Ok, I'll try to implement the testcase and keep you posted.

In the meanwhile I performed some additional test and I extracted some information I hope it's useful.
I performed those test with
Code:
[b]batch_size = 500[/b]


I created 499 MainEntity and for each MainEntity I set 2 EntityA and 4 EntityB.
I traced in the DB how many inserts were executed for the 3 tables involved:
  • Inserts for MainEntity = 1 (this worked as expected)
  • Inserts for table representing the relation between MainEntity and EntityA = 499 (this didn't work as expected but it seems that batch_size allowed to insert 2 rows per time)
  • Inserts for table representing the relation between MainEntity and EntityB = 499 (this didn't work as expected but it seems that batch_size allowed to insert 4 rows per time)

Let me know if this test can help some how to understand if I'm doing anything wrong in the code/configuration or it really looks like an Hibernate bug.


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Tue Jun 20, 2017 5:50 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1527
You should also check the JDBC statements using datasource-proxy or p6spy which give you a better insight into what happens under the hood.

As for this statement:

Quote:
it seems that batch_size allowed to insert 2 rows per time


I don't understand what you are talking about. What is "2 rows per time"?

As for batch ordering and ManyToMany associations, we have this test on GitHub which works like a charm.

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Tue Jun 20, 2017 6:50 am 
Newbie

Joined: Mon Jun 19, 2017 5:31 am
Posts: 6
Thanks for the advice about how to better understand what's happening under the hood; I'll use it.

About my statement: total rows to insert in that table are 499*2 but actually are executed 499 SQL inserts. This means it inserts 2 rows per time (this is exactly the cardinality between MainEntity and EntityA)


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Wed Jun 21, 2017 7:55 am 
Newbie

Joined: Mon Jun 19, 2017 5:31 am
Posts: 6
I enabled p6spy logging and this is the result:
Code:
....
...
..

1498045598176|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, ...
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 404, 5203)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 405, 5204)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 406, 5205)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 407, 5206)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 408, 5207)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 409, 5208)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 410, 5209)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 411, 5210)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 412, 5211)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 413, 5212)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 414, 5213)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 415, 5214)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 416, 5215)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 417, 5216)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 418, 5217)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 419, 5218)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 420, 5219)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 421, 5220)
1498045598204|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 422, 5221)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 423, 5222)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 424, 5223)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 425, 5224)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 426, 5225)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 427, 5226)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 428, 5227)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 429, 5228)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 430, 5229)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 431, 5230)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 432, 5231)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 433, 5232)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 434, 5233)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 435, 5234)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 436, 5235)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 437, 5236)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 438, 5237)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 439, 5238)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 440, 5239)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 441, 5240)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 442, 5241)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 443, 5242)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 444, 5243)
1498045598205|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 445, 5244)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 446, 5245)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 447, 5246)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 448, 5247)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 449, 5248)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 450, 5249)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 451, 5250)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 452, 5251)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 453, 5252)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 454, 5253)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 455, 5254)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 456, 5255)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 457, 5256)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 458, 5257)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 459, 5258)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 460, 5259)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 461, 5260)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 462, 5261)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 463, 5262)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 464, 5263)
1498045598206|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 465, 5264)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 466, 5265)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 467, 5266)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 468, 5267)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 469, 5268)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 470, 5269)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 471, 5270)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 472, 5271)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 473, 5272)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 474, 5273)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 475, 5274)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 476, 5275)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 477, 5276)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 478, 5277)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 479, 5278)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 480, 5279)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 481, 5280)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 482, 5281)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 483, 5282)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 484, 5283)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 485, 5284)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 486, 5285)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 487, 5286)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 488, 5287)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 489, 5288)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 490, 5289)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 491, 5290)
1498045598207|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 492, 5291)
1498045598208|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 493, 5292)
1498045598208|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 494, 5293)
1498045598208|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 495, 5294)
1498045598208|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 496, 5295)
1498045598208|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 497, 5296)
1498045598208|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 498, 5297)
1498045598208|0|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 499, 5298)
1498045598228|19|batch|connection 1|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (?, ?, ?, ?)|insert into MAIN (MAIN_ID, MAIN_TYPE, PRODUCT_IDS_HASH, MAIN_UID) values (NULL, 0, 499, 5298)
1498045598228|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4800, 6)
1498045598229|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4800, 7)
1498045598229|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4800, 8)
1498045598229|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4800, 9)
1498045598230|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4800, 9)
1498045598230|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4800, 5500)
1498045598230|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4800, 5501)
1498045598233|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4800, 5501)
1498045598233|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4801, 6)
1498045598233|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4801, 7)
1498045598233|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4801, 8)
1498045598233|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4801, 9)
1498045598234|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4801, 9)
1498045598234|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4801, 5501)
1498045598234|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4801, 5502)
1498045598236|1|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4801, 5502)
1498045598236|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4802, 6)
1498045598236|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4802, 7)
1498045598236|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4802, 8)
1498045598236|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4802, 9)
1498045598237|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4802, 9)
1498045598237|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4802, 5502)
1498045598237|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4802, 5503)
1498045598240|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4802, 5503)
1498045598240|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4803, 6)
1498045598240|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4803, 7)
1498045598240|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4803, 8)
1498045598240|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4803, 9)
1498045598241|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4803, 9)
1498045598241|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4803, 5504)
1498045598241|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4803, 5503)
1498045598244|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4803, 5503)
1498045598244|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4804, 6)
1498045598244|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4804, 7)
1498045598244|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4804, 8)
1498045598244|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4804, 9)
1498045598245|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4804, 9)
1498045598245|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4804, 5504)
1498045598245|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4804, 5505)
1498045598249|3|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4804, 5505)
1498045598249|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4805, 6)
1498045598249|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4805, 7)
1498045598249|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4805, 8)
1498045598249|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4805, 9)
1498045598250|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4805, 9)
1498045598250|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4805, 5505)
1498045598250|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4805, 5506)
1498045598252|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4805, 5506)
1498045598253|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4806, 6)
1498045598253|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4806, 7)
1498045598253|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4806, 8)
1498045598253|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4806, 9)
1498045598253|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4806, 9)
1498045598254|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4806, 5506)
1498045598254|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4806, 5507)
1498045598257|3|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4806, 5507)
1498045598257|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4807, 6)
1498045598257|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4807, 7)
1498045598257|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4807, 8)
1498045598257|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4807, 9)
1498045598258|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4807, 9)
1498045598258|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4807, 5507)
1498045598258|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4807, 5508)
1498045598265|6|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4807, 5508)
1498045598265|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4808, 6)
1498045598265|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4808, 7)
1498045598265|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4808, 8)
1498045598265|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4808, 9)
1498045598265|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4808, 9)
1498045598266|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4808, 5508)
1498045598266|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4808, 5509)
1498045598268|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4808, 5509)
1498045598268|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4809, 6)
1498045598268|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4809, 7)
1498045598268|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4809, 8)
1498045598268|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4809, 9)
1498045598269|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4809, 9)
1498045598269|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4809, 5509)
1498045598269|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4809, 5510)
1498045598271|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4809, 5510)
1498045598272|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4810, 6)
1498045598272|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4810, 7)
1498045598272|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4810, 8)
1498045598272|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4810, 9)
1498045598272|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4810, 9)
1498045598273|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4810, 5510)
1498045598273|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4810, 5511)
1498045598275|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4810, 5511)
1498045598275|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4811, 6)
1498045598275|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4811, 7)
1498045598275|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4811, 8)
1498045598276|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4811, 9)
1498045598276|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4811, 9)
1498045598276|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4811, 5511)
1498045598276|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4811, 5512)
1498045598279|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4811, 5512)
1498045598279|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4812, 6)
1498045598279|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4812, 7)
1498045598279|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4812, 8)
1498045598279|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4812, 9)
1498045598280|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4812, 9)
1498045598280|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4812, 5512)
1498045598280|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4812, 5513)
1498045598283|3|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4812, 5513)
1498045598283|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4813, 6)
1498045598283|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4813, 7)
1498045598283|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4813, 8)
1498045598283|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4813, 9)
1498045598284|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4813, 9)
1498045598284|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4813, 5513)
1498045598284|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4813, 5514)
1498045598287|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4813, 5514)
1498045598287|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4814, 6)
1498045598287|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4814, 7)
1498045598287|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4814, 8)
1498045598287|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4814, 9)
1498045598288|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4814, 9)
1498045598288|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4814, 5514)
1498045598288|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4814, 5515)
1498045598290|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4814, 5515)
1498045598291|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4815, 6)
1498045598291|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4815, 7)
1498045598291|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4815, 8)
1498045598291|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4815, 9)
1498045598291|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4815, 9)
1498045598291|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4815, 5515)
1498045598291|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4815, 5516)
1498045598297|5|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4815, 5516)
1498045598297|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4816, 6)
1498045598297|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4816, 7)
1498045598297|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4816, 8)
1498045598297|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4816, 9)
1498045598297|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4816, 9)
1498045598298|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4816, 5516)
1498045598298|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4816, 5517)
1498045598301|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4816, 5517)
1498045598301|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4817, 6)
1498045598301|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4817, 7)
1498045598301|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4817, 8)
1498045598301|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4817, 9)
1498045598302|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4817, 9)
1498045598302|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4817, 5517)
1498045598302|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4817, 5518)
1498045598304|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4817, 5518)
1498045598304|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4818, 6)
1498045598304|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4818, 7)
1498045598304|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4818, 8)
1498045598304|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4818, 9)
1498045598306|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4818, 9)
1498045598306|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4818, 5518)
1498045598306|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4818, 5519)
1498045598309|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4818, 5519)
1498045598309|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4819, 6)
1498045598309|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4819, 7)
1498045598309|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4819, 8)
1498045598309|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4819, 9)
1498045598310|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4819, 9)
1498045598310|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4819, 5520)
1498045598310|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4819, 5519)
1498045598313|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4819, 5519)
1498045598313|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4820, 6)
1498045598313|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4820, 7)
1498045598313|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4820, 8)
1498045598313|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4820, 9)
1498045598313|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4820, 9)
1498045598313|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4820, 5520)
1498045598314|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4820, 5521)
1498045598318|4|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4820, 5521)
1498045598318|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4821, 6)
1498045598318|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4821, 7)
1498045598318|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4821, 8)
1498045598318|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4821, 9)
1498045598319|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4821, 9)
1498045598319|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4821, 5521)
1498045598319|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4821, 5522)
1498045598322|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4821, 5522)
1498045598322|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4822, 6)
1498045598322|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4822, 7)
1498045598322|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4822, 8)
1498045598322|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4822, 9)
1498045598323|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4822, 9)
1498045598323|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4822, 5522)
1498045598323|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4822, 5523)
1498045598327|3|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4822, 5523)
1498045598327|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4823, 6)
1498045598327|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4823, 7)
1498045598327|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4823, 8)
1498045598327|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4823, 9)
1498045598327|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4823, 9)
1498045598328|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4823, 5523)
1498045598328|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4823, 5524)
1498045598332|4|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4823, 5524)
1498045598333|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4824, 6)
1498045598333|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4824, 7)
1498045598333|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4824, 8)
1498045598333|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4824, 9)
1498045598333|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4824, 9)
1498045598333|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4824, 5524)
1498045598333|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4824, 5525)
1498045598336|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4824, 5525)
1498045598336|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4825, 6)
1498045598336|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4825, 7)
1498045598336|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4825, 8)
1498045598336|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4825, 9)
1498045598337|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4825, 9)
1498045598337|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4825, 5525)
1498045598337|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4825, 5526)
1498045598340|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4825, 5526)
1498045598340|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4826, 6)
1498045598340|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4826, 7)
1498045598340|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4826, 8)
1498045598340|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4826, 9)
1498045598341|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4826, 9)
1498045598341|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4826, 5526)
1498045598341|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4826, 5527)
1498045598344|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4826, 5527)
1498045598344|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4827, 6)
1498045598344|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4827, 7)
1498045598344|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4827, 8)
1498045598344|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4827, 9)
1498045598345|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4827, 9)
1498045598345|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4827, 5527)
1498045598345|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4827, 5528)
1498045598350|5|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4827, 5528)
1498045598350|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4828, 6)
1498045598350|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4828, 7)
1498045598350|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4828, 8)
1498045598351|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4828, 9)
1498045598351|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4828, 9)
1498045598351|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4828, 5528)
1498045598351|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4828, 5529)
1498045598354|2|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4828, 5529)
1498045598355|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4829, 6)
1498045598355|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4829, 7)
1498045598355|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4829, 8)
1498045598355|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4829, 9)
1498045598358|3|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4829, 9)
1498045598358|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4829, 5529)
1498045598358|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4829, 5530)
1498045598365|6|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4829, 5530)
1498045598365|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4830, 6)
1498045598365|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4830, 7)
1498045598365|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4830, 8)
1498045598365|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4830, 9)
1498045598366|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4830, 9)
1498045598366|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4830, 5530)
1498045598366|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4830, 5531)
1498045598373|7|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4830, 5531)
1498045598373|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4831, 6)
1498045598373|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4831, 7)
1498045598373|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4831, 8)
1498045598373|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4831, 9)
1498045598374|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4831, 9)
1498045598374|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4831, 5531)
1498045598374|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4831, 5532)
1498045598381|6|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4831, 5532)
1498045598381|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4832, 6)
1498045598381|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4832, 7)
1498045598382|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4832, 8)
1498045598382|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4832, 9)
1498045598385|3|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4832, 9)
1498045598386|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4832, 5532)
1498045598386|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4832, 5533)
1498045598394|7|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4832, 5533)
1498045598394|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4833, 6)
1498045598394|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4833, 7)
1498045598394|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4833, 8)
1498045598394|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4833, 9)
1498045598395|0|batch|connection 1|insert into MAIN_B (MAIN_UID, B_UID) values (?, ?)|insert into MAIN_B (MAIN_UID, B_UID) values (4833, 9)
1498045598395|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4833, 5533)
1498045598395|0|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4833, 5534)
1498045598403|7|batch|connection 1|insert into MAIN_A (MAIN_UID, A_UID) values (?, ?)|insert into MAIN_A (MAIN_UID, A_UID) values (4833, 5534)
.....
....
...
1498045603831|3|commit|connection 1||
1498045603833|0|rollback|connection 1||



It seems that MAIN_ENTITY insert is performed in batch. The Insert about MAIN_B and MAIN_A relations are performed in batch only regarding the same MAIN_ENTITY not in a wider scope.

Is this the expected behavior?


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Wed Jun 21, 2017 9:26 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1527
Everything is performed in batch as indicated by the 3rd column. Otherwise, you'd see a statement value there.

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Wed Jun 21, 2017 9:37 am 
Newbie

Joined: Mon Jun 19, 2017 5:31 am
Posts: 6
Yes you're right but it isn't performed in 1 batch per table as I would expect.
It performs 1 batch insert to insert 4 items in Entity B - Main relation table, then 1 batch insert to insert 2 items in Entity A - Main relation table, and again 1 batch to insert 4 items in Entity B - Main relation table and so on...

What I would expect is 1 batch insert to insert all items in Entity B - Main relation table and 1 batch insert to insert all items in Entity A - Main relation table.


Top
 Profile  
 
 Post subject: Re: Hibernate batch transaction with multiple ManyToMany Rel
PostPosted: Wed Jun 21, 2017 9:39 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1527
You should provide a replicating test case and then open an issue.

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.