Revize 460852db

merge

project/Deserializer/src/Converter.java

@@ -26 +26 @@
 	private Semaphore inputAvailable;
     
 	private File inputFile;
-	private String inputString;
+	private String query;
 	private boolean testing;
 	
     //Key as enum?
@@ -65 +65 @@
 		setInput(null, null, false);
 	}
 	
-	public void setInput(File inputFile, String inputString, boolean testing) {
+	public void setInput(File inputFile, String query, boolean testing) {
 		entryLock.lock();
 		this.inputFile = inputFile;
-		this.inputString = inputString;
+		this.query = query;
 		this.testing = testing;
 		entryLock.unlock();
 		
@@ -76 +76 @@
 			inputAvailable.release(); // MAX VALUE = 1!
 	}
 	
-	public boolean getInput(AtomicReference<File> inputFile, AtomicReference<String> inputString, AtomicBoolean testing) {
+	public boolean getInput(AtomicReference<File> inputFile, AtomicReference<String> query, AtomicBoolean testing) {
 		try {
 			inputAvailable.acquire();
 		} catch (InterruptedException e) {
@@ -85 +85 @@
 		
 		entryLock.lock();
 		inputFile.set(this.inputFile);
-		inputString.set(this.inputString);
+		query.set(this.query);
 		testing.set(this.testing);
 		
 		this.inputFile = null;
-		this.inputString = null;
+		this.query = null;
 		entryLock.unlock();
 		
 		return true;
@@ -100 +100 @@
 		super.run();
 		while (active.get()) {
 			AtomicReference<File> inputFile = new AtomicReference<File>();
-			AtomicReference<String> inputString = new AtomicReference<String>();
+			AtomicReference<String> query = new AtomicReference<String>();
 			AtomicBoolean testing = new AtomicBoolean();
 			
-			if (!getInput(inputFile, inputString, testing)) {
+			if (!getInput(inputFile, query, testing)) {
 				continue;
 			}
 			
 			if (inputFile.get() != null) {
 				processA(inputFile.get(), testing.get());
-			} else if (inputString.get() != null) {
-				processB(inputString.get().getBytes(), testing.get());
+			} else if (query.get() != null) {
+				processB(query.get().getBytes(), testing.get());
 			}
 		}
 	}

project/Deserializer/src/io/Database.java

@@ +1 @@
+package io;
+
+import java.sql.Blob;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+public class Database {
+	
+	private static class DB_Messenger {
+		public String url; // jdbc:mysql://localhost/mydb
+		public String user; // root
+		public String password; // 1234
+		public String query; // SELECT * FROM table
+		public String blob; // image
+		
+		public DB_Messenger(String url, String user, String password, String query, String blob) {
+			this.url = url;
+			this.user = user;
+			this.password = password;
+			this.query = query;
+			this.blob = blob;
+		}
+	}
+	
+	public byte[] doWork(DB_Messenger crate) {
+		Connection conn = null;
+		Statement stmt = null;
+		
+		try {
+			System.out.println("Connecting to the database...");
+			conn = DriverManager.getConnection(crate.url, crate.user, crate.password);
+			System.out.println("Connected.");
+		} catch (SQLException e) {
+			System.out.println("Connection error.");
+			e.printStackTrace();
+			return null;
+		}
+		
+		System.out.println("Getting the BLOB...");
+		try {
+			stmt = conn.createStatement();
+			ResultSet rs = stmt.executeQuery(crate.query);
+			while (rs.next()) {
+				Blob blob = rs.getBlob(crate.blob);
+				if (blob != null) {
+					byte[] bytes = blob.getBytes(1l, (int) blob.length());
+					System.out.println("The BLOB was found.");
+					return bytes;
+				}
+			}
+		} catch (SQLException e) {
+			System.out.println("Error getting the BLOB.");
+			e.printStackTrace();
+			
+		}
+		
+		System.out.println("The BLOB wasn't found.");
+		return null;
+	}
+
+}

project/Deserializer/xyz.json

@@ +1 @@
+{
+	class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+		"multipleTransactionFlag" : false, 
+		"container" : 		{
+			class java.util.Vector : {
+				"capacityIncrement" : 0, 
+				"elementCount" : 1130, 
+				"elementData" : [ 				{
+					class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : U, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+						"table" : 						{
+							class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+							}
+},
+						{
+							class gk.tbi.TbiTable : {
+								"changed" : true, 
+								"hasMoreData" : false, 
+								"rows" : 								{
+									class java.util.Vector : {
+										"capacityIncrement" : 0, 
+										"elementCount" : 1, 
+										"elementData" : [ 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+												"_item_selling_prices_id" : 100000000001681471, 
+												"_price_amount" : 11500.0, 
+												"_description" : "ACTIVE_SALES_PRICE", 
+												"_differentiator_typecode" : "00", 
+												"_differentiator_value" : "3690113", 
+												"_item_id" : "3690113", 
+												"_price_effective_date" : 												{
+													class java.sql.Timestamp extends java.util.Date : {
+														"nanos" : 0
+													}
+},
+												{
+													class java.util.Date : {
+													}
+												}, 
+												"_price_type_code" : "99"
+											}
+},
+										{
+											class gk.tbi.TbiRow : {
+												"status" : 0, 
+												"notNullArray" : [ -17, -128 ]
+											}
+										},  ]
+									}
+								}
+							}
+						}
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : U, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+						"table" : 						{
+							class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+							}
+},
+						{
+							class gk.tbi.TbiTable : {
+								"changed" : true, 
+								"hasMoreData" : false, 
+								"rows" : 								{
+									class java.util.Vector : {
+										"capacityIncrement" : 0, 
+										"elementCount" : 1, 
+										"elementData" : [ 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+												"_item_selling_prices_id" : 100000000001681472, 
+												"_price_amount" : 11500.0, 
+												"_description" : "LOWEST_PRICE_LAST_DAYS", 
+												"_differentiator_typecode" : "00", 
+												"_differentiator_value" : "3690113", 
+												"_item_id" : "3690113", 
+												"_price_effective_date" : 												{
+													class java.sql.Timestamp extends java.util.Date : {
+														"nanos" : 0
+													}
+},
+												{
+													class java.util.Date : {
+													}
+												}, 
+												"_price_type_code" : "98"
+											}
+},
+										{
+											class gk.tbi.TbiRow : {
+												"status" : 0, 
+												"notNullArray" : [ -17, -128 ]
+											}
+										},  ]
+									}
+								}
+							}
+						}
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+						"multipleTransactionFlag" : false, 
+						"container" : 						{
+							class java.util.Vector : {
+								"capacityIncrement" : 0, 
+								"elementCount" : 2, 
+								"elementData" : [ 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001682290, 
+																"_price_amount" : 7499.0, 
+																"_description" : "ACTIVE_SALES_PRICE", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "S361737", 
+																"_item_id" : "S361737", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "99"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								}, 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001682291, 
+																"_price_amount" : 7499.0, 
+																"_description" : "LOWEST_PRICE_LAST_DAYS", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "S361737", 
+																"_item_id" : "S361737", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "98"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								},  ]
+							}
+						}, 
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : N, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+						"multipleTransactionFlag" : false, 
+						"container" : 						{
+							class java.util.Vector : {
+								"capacityIncrement" : 0, 
+								"elementCount" : 2, 
+								"elementData" : [ 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001682293, 
+																"_price_amount" : 9999.0, 
+																"_description" : "ACTIVE_SALES_PRICE", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "S361738", 
+																"_item_id" : "S361738", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "99"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								}, 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001682294, 
+																"_price_amount" : 9999.0, 
+																"_description" : "LOWEST_PRICE_LAST_DAYS", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "S361738", 
+																"_item_id" : "S361738", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "98"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								},  ]
+							}
+						}, 
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : N, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+						"multipleTransactionFlag" : false, 
+						"container" : 						{
+							class java.util.Vector : {
+								"capacityIncrement" : 0, 
+								"elementCount" : 2, 
+								"elementData" : [ 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : I, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001684487, 
+																"_price_amount" : 750.0, 
+																"_description" : "ACTIVE_SALES_PRICE", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "1248080", 
+																"_item_id" : "1248080", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "99"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								}, 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : I, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001684488, 
+																"_price_amount" : 750.0, 
+																"_description" : "LOWEST_PRICE_LAST_DAYS", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "1248080", 
+																"_item_id" : "1248080", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "98"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								},  ]
+							}
+						}, 
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : N, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+						"multipleTransactionFlag" : false, 
+						"container" : 						{
+							class java.util.Vector : {
+								"capacityIncrement" : 0, 
+								"elementCount" : 2, 
+								"elementData" : [ 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001646529, 
+																"_price_amount" : 150.0, 
+																"_description" : "ACTIVE_SALES_PRICE", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "2744600", 
+																"_item_id" : "2744600", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "99"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								}, 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001646530, 
+																"_price_amount" : 150.0, 
+																"_description" : "LOWEST_PRICE_LAST_DAYS", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "2744600", 
+																"_item_id" : "2744600", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "98"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								},  ]
+							}
+						}, 
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : N, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+						"multipleTransactionFlag" : false, 
+						"container" : 						{
+							class java.util.Vector : {
+								"capacityIncrement" : 0, 
+								"elementCount" : 2, 
+								"elementData" : [ 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : I, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001684490, 
+																"_price_amount" : 1500.0, 
+																"_description" : "ACTIVE_SALES_PRICE", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "1259432", 
+																"_item_id" : "1259432", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "99"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								}, 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : I, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001684491, 
+																"_price_amount" : 1500.0, 
+																"_description" : "LOWEST_PRICE_LAST_DAYS", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "1259432", 
+																"_item_id" : "1259432", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "98"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								},  ]
+							}
+						}, 
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : N, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+						"multipleTransactionFlag" : false, 
+						"container" : 						{
+							class java.util.Vector : {
+								"capacityIncrement" : 0, 
+								"elementCount" : 2, 
+								"elementData" : [ 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001683533, 
+																"_price_amount" : 4749.0, 
+																"_description" : "ACTIVE_SALES_PRICE", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "S364070", 
+																"_item_id" : "S364070", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "99"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								}, 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001683534, 
+																"_price_amount" : 4749.0, 
+																"_description" : "LOWEST_PRICE_LAST_DAYS", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "S364070", 
+																"_item_id" : "S364070", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "98"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								},  ]
+							}
+						}, 
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : N, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+						"multipleTransactionFlag" : false, 
+						"container" : 						{
+							class java.util.Vector : {
+								"capacityIncrement" : 0, 
+								"elementCount" : 2, 
+								"elementData" : [ 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001646532, 
+																"_price_amount" : 275.0, 
+																"_description" : "ACTIVE_SALES_PRICE", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "2746200", 
+																"_item_id" : "2746200", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "99"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								}, 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001646533, 
+																"_price_amount" : 275.0, 
+																"_description" : "LOWEST_PRICE_LAST_DAYS", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "2746200", 
+																"_item_id" : "2746200", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "98"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								},  ]
+							}
+						}, 
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : N, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+						"multipleTransactionFlag" : false, 
+						"container" : 						{
+							class java.util.Vector : {
+								"capacityIncrement" : 0, 
+								"elementCount" : 2, 
+								"elementData" : [ 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001657613, 
+																"_price_amount" : 500.0, 
+																"_description" : "ACTIVE_SALES_PRICE", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "2510400", 
+																"_item_id" : "2510400", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "99"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								}, 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : U, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001657614, 
+																"_price_amount" : 500.0, 
+																"_description" : "LOWEST_PRICE_LAST_DAYS", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "2510400", 
+																"_item_id" : "2510400", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "98"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								},  ]
+							}
+						}, 
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : N, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.ToTransportObjectContainer extends gk.std_bo_if.share.data.to.TransportObject : {
+						"multipleTransactionFlag" : false, 
+						"container" : 						{
+							class java.util.Vector : {
+								"capacityIncrement" : 0, 
+								"elementCount" : 2, 
+								"elementData" : [ 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : I, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001684493, 
+																"_price_amount" : 300.0, 
+																"_description" : "ACTIVE_SALES_PRICE", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "4312904", 
+																"_item_id" : "4312904", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "99"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								}, 								{
+									class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+									}
+},
+								{
+									class gk.std_bo_if.share.data.to.TransportObject : {
+										"operation" : I, 
+										"status" : 										{
+											class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+												"transactionID" : -2, 
+											}
+										}, 
+										"table" : 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+											}
+},
+										{
+											class gk.tbi.TbiTable : {
+												"changed" : true, 
+												"hasMoreData" : false, 
+												"rows" : 												{
+													class java.util.Vector : {
+														"capacityIncrement" : 0, 
+														"elementCount" : 1, 
+														"elementData" : [ 														{
+															class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+																"_item_selling_prices_id" : 100000000001684494, 
+																"_price_amount" : 300.0, 
+																"_description" : "LOWEST_PRICE_LAST_DAYS", 
+																"_differentiator_typecode" : "00", 
+																"_differentiator_value" : "4312904", 
+																"_item_id" : "4312904", 
+																"_price_effective_date" : 																{
+																	class java.sql.Timestamp extends java.util.Date : {
+																		"nanos" : 0
+																	}
+},
+																{
+																	class java.util.Date : {
+																	}
+																}, 
+																"_price_type_code" : "98"
+															}
+},
+														{
+															class gk.tbi.TbiRow : {
+																"status" : 0, 
+																"notNullArray" : [ -17, -128 ]
+															}
+														},  ]
+													}
+												}
+											}
+										}
+									}
+								},  ]
+							}
+						}, 
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : N, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+					}
+				}, 				{
+					class gk.std_bo_if.share.data.to.item_selling_prices.ToItemSellingPrices extends gk.std_bo_if.share.data.to.TransportObject : {
+					}
+},
+				{
+					class gk.std_bo_if.share.data.to.TransportObject : {
+						"operation" : U, 
+						"status" : 						{
+							class gk.std_bo_if.share.data.to.TransportObjectStatus : {
+								"transactionID" : -2, 
+							}
+						}, 
+						"table" : 						{
+							class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPrices extends gk.tbi.TbiTable : {
+							}
+},
+						{
+							class gk.tbi.TbiTable : {
+								"changed" : true, 
+								"hasMoreData" : false, 
+								"rows" : 								{
+									class java.util.Vector : {
+										"capacityIncrement" : 0, 
+										"elementCount" : 1, 
+										"elementData" : [ 										{
+											class gk.std_bo_if.share.data.to.item_selling_prices.TbiRItemSellingPricesRow extends gk.tbi.TbiRow : {
+												"_item_selling_prices_id" : 100000000001659304, 
+												"_price_amount" : 3500.0, 
+												"_description" : "ACTIVE_SALES_PRICE", 
+												"_differentiator_typecode" : "00", 
+												"_differentiator_value" : "3600077", 
+												"_item_id" : "3600077", 
+												"_price_effective_date" : 												{
+													class java.sql.Timestamp extends java.util.Date : {
+														"nanos" : 0
+													}
+},
+												{
+													class java.util.Date : {
+													}
+												}, 
+												"_price_type_code" : "99"
+											}
+},
+										{
+											class gk.tbi.TbiRow : {
+												"status" : 0, 
+												"notNullArray" : [ -17, -128 ]
+											}
+										},  ]
+									}
+								}