|
1
|
[java] Using unnamed schema profile.
|
|
2
|
[java] ./cvt/data/tstcasedata.p2o
|
|
3
|
[java] MLog clients using slf4j logging.
|
|
4
|
[java] Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
|
|
5
|
[java] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> z8kfsxaw9xdkmo168dxxx|3a45c42a, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.h2.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> z8kfsxaw9xdkmo168dxxx|3a45c42a, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:h2:/home/gbb/Code/testcases-working/deploy/db/tstcasedata;MV_STORE=FALSE;LOG=0;CACHE_SIZE=65536;CACHE_TYPE=SOFT_LRU;LOCK_MODE=0;UNDO_LOG=0, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
|
|
6
|
[java] Found identity generator sequence starting at 1.
|
|
7
|
[java] IMPORT ORDER:
|
|
8
|
[java] 1) _sec-authentication-domain.d:2088.0 [1044 bytes]
|
|
9
|
[java] 2) _sec-authentication-system.d:984.0 [492 bytes]
|
|
10
|
[java] 3) item.d:366.0 [183 bytes]
|
|
11
|
[java] 4) orderline.d:356.0 [178 bytes]
|
|
12
|
[java] 5) customer.d:354.0 [177 bytes]
|
|
13
|
[java] 6) order.d:348.0 [174 bytes]
|
|
14
|
[java] BEGIN _sec-authentication-domain.d (sec_authentication_domain)
|
|
15
|
[java] BEGIN _sec-authentication-system.d (sec_authentication_system)
|
|
16
|
[java] _sec-authentication-domain.d: SQL: drop index if exists idx__sec_authentication_domain_idx__domain_name
|
|
17
|
[java] _sec-authentication-system.d: SQL: drop index if exists idx__sec_authentication_system_idx__domain_type
|
|
18
|
[java] _sec-authentication-domain.d: SQL: drop index if exists idx__sec_authentication_domain_idx__domain_description
|
|
19
|
[java] _sec-authentication-system.d: SQL: drop index if exists idx__sec_authentication_system_idx__domain_type_description
|
|
20
|
[java] _sec-authentication-domain.d: SQL: drop index if exists idx__sec_authentication_domain_idx__domain_enabled
|
|
21
|
[java] _sec-authentication-system.d: SQL: drop index if exists idx__sec_authentication_system_idx__pam_module_name
|
|
22
|
[java] _sec-authentication-domain.d: SQL: drop index if exists idx__sec_authentication_domain_idx__domain_id
|
|
23
|
[java] _sec-authentication-domain.d: SQL: drop index if exists idx__sec_authentication_domain_idx__domain_type
|
|
24
|
[java] _sec-authentication-domain.d: SQL: drop index if exists idx__sec_authentication_domain_idx__tenant_name
|
|
25
|
[java] _sec-authentication-system.d: SQL: create unique index idx__sec_authentication_system_idx__domain_type on sec_authentication_system (domain_type nulls last)
|
|
26
|
[java] _sec-authentication-domain.d: SQL: create unique index idx__sec_authentication_domain_idx__domain_id on sec_authentication_domain (domain_id nulls last)
|
|
27
|
[java] _sec-authentication-domain.d: SQL: create unique index idx__sec_authentication_domain_idx__domain_name on sec_authentication_domain (domain_name nulls last)
|
|
28
|
[java] _sec-authentication-domain.d: Unable to read PSC footer at 0x00000349. Failed magic check. Heuristic search found a PSC footer candidate. The file was probably altered after being exported from database.
|
|
29
|
[java] _sec-authentication-domain.d: Set up ibm850 character encoding.
|
|
30
|
[java] _sec-authentication-system.d: Set up ibm850 character encoding.
|
|
31
|
[java] _sec-authentication-system.d: SQL: create index idx__sec_authentication_system_idx__domain_type_description on sec_authentication_system (domain_type_description nulls last, recid)
|
|
32
|
[java] _sec-authentication-system.d: SQL: create index idx__sec_authentication_system_idx__pam_module_name on sec_authentication_system (pam_module_name nulls last, recid)
|
|
33
|
[java] _sec-authentication-domain.d: SQL: create index idx__sec_authentication_domain_idx__domain_description on sec_authentication_domain (domain_description nulls last, recid)
|
|
34
|
[java] _sec-authentication-domain.d: SQL: create index idx__sec_authentication_domain_idx__domain_enabled on sec_authentication_domain (domain_enabled nulls last, recid)
|
|
35
|
[java] _sec-authentication-domain.d: SQL: create index idx__sec_authentication_domain_idx__domain_type on sec_authentication_domain (domain_type nulls last, recid)
|
|
36
|
[java] _sec-authentication-domain.d: SQL: create index idx__sec_authentication_domain_idx__tenant_name on sec_authentication_domain (tenant_name nulls last, recid)
|
|
37
|
[java] _sec-authentication-domain.d: Analyzing sec_authentication_domain...
|
|
38
|
[java] _sec-authentication-system.d: Analyzing sec_authentication_system...
|
|
39
|
[java] END _sec-authentication-domain.d. 6 records imported into sec_authentication_domain
|
|
40
|
[java] 46.44128% complete: 6 recs in 0:00:00.992 (6/sec, 362/min, 21774/hr)
|
|
41
|
[java] BEGIN item.d (item)
|
|
42
|
[java] item.d: SQL: drop index if exists idx__item_idx__pk
|
|
43
|
[java] END _sec-authentication-system.d. 4 records imported into sec_authentication_system
|
|
44
|
[java] 68.32740% complete: 10 recs in 0:00:00.996 (10/sec, 602/min, 36144/hr)
|
|
45
|
[java] item.d: SQL: drop index if exists idx__item_idx__name
|
|
46
|
[java] BEGIN orderline.d (orderline)
|
|
47
|
[java] orderline.d: SQL: drop index if exists idx__orderline_idx__pk
|
|
48
|
[java] item.d: SQL: create unique index idx__item_idx__pk on item (item_num nulls last)
|
|
49
|
[java] orderline.d: SQL: create unique index idx__orderline_idx__pk on orderline (order_num nulls last, item_num nulls last)
|
|
50
|
[java] item.d: Set up ibm850 character encoding.
|
|
51
|
[java] orderline.d: Set up ibm850 character encoding.
|
|
52
|
[java] orderline.d: Analyzing orderline...
|
|
53
|
[java] END orderline.d. 0 records imported into orderline
|
|
54
|
[java] 76.24555% complete: 10 recs in 0:00:01.000 (10/sec, 600/min, 36000/hr)
|
|
55
|
[java] item.d: SQL: create index idx__item_idx__name on item (item_name nulls last, recid)
|
|
56
|
[java] BEGIN customer.d (customer)
|
|
57
|
[java] customer.d: SQL: drop index if exists idx__customer_idx__pk
|
|
58
|
[java] item.d: Analyzing item...
|
|
59
|
[java] customer.d: SQL: create unique index idx__customer_idx__pk on customer (customer_num nulls last)
|
|
60
|
[java] END item.d. 1 records imported into item
|
|
61
|
[java] 84.38612% complete: 11 recs in 0:00:01.004 (10/sec, 657/min, 39442/hr)
|
|
62
|
[java] BEGIN order.d (order_)
|
|
63
|
[java] customer.d: Set up ibm850 character encoding.
|
|
64
|
[java] order.d: SQL: drop index if exists idx__order__idx__pk
|
|
65
|
[java] customer.d: Analyzing customer...
|
|
66
|
[java] order.d: SQL: drop index if exists idx__order__idx__fk
|
|
67
|
[java] order.d: SQL: create unique index idx__order__idx__pk on order_ (order_num nulls last)
|
|
68
|
[java] END customer.d. 0 records imported into customer
|
|
69
|
[java] 92.25979% complete: 11 recs in 0:00:01.008 (10/sec, 654/min, 39285/hr)
|
|
70
|
[java] order.d: Set up ibm850 character encoding.
|
|
71
|
[java] order.d: SQL: create index idx__order__idx__fk on order_ (customer_num nulls last, recid)
|
|
72
|
[java] order.d: Analyzing order_...
|
|
73
|
[java] END order.d. 0 records imported into order_
|
|
74
|
[java] 100.00000% complete: 11 recs in 0:00:01.012 (10/sec, 652/min, 39130/hr)
|
|
75
|
[java] Updated identity generator sequence starting at 20001.
|
|
76
|
[java] Elapsed job time: 00:00:02.463
|