1
|
[java] INFO: Type match assertion disabled; set "checkTypes" to true to enable
|
2
|
[java] INFO: Data export files will be read from 'data\dump\hotel\'
|
3
|
[java] INFO: Using 4 threads for import
|
4
|
[java] 3????03, 2018 8:39:49 ???? org.hibernate.dialect.Dialect <init>
|
5
|
[java] INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect
|
6
|
[java] .\data\namespace\hotel.p2o
|
7
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.annotations.common.Version <clinit>
|
8
|
[java] INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
|
9
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.Version logVersion
|
10
|
[java] INFO: HHH000412: Hibernate Core {4.1.8.Final}
|
11
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Environment <clinit>
|
12
|
[java] INFO: HHH000206: hibernate.properties not found
|
13
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Environment buildBytecodeProvider
|
14
|
[java] INFO: HHH000021: Bytecode provider name : javassist
|
15
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Configuration addResource
|
16
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/GuestIdTypeImpl.hbm.xml
|
17
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Configuration addResource
|
18
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/MetaUserImpl.hbm.xml
|
19
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Configuration addResource
|
20
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/RoomTypeImpl.hbm.xml
|
21
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Configuration addResource
|
22
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/RoomImpl.hbm.xml
|
23
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Configuration addResource
|
24
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/StayImpl.hbm.xml
|
25
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Configuration addResource
|
26
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/ReservationImpl.hbm.xml
|
27
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Configuration addResource
|
28
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/RateImpl.hbm.xml
|
29
|
[java] 3????03, 2018 8:39:50 ???? org.hibernate.cfg.Configuration addResource
|
30
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/GuestImpl.hbm.xml
|
31
|
[java] 3????03, 2018 8:39:51 ???? org.hibernate.cfg.Configuration addResource
|
32
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/ServiceTypeImpl.hbm.xml
|
33
|
[java] 3????03, 2018 8:39:51 ???? org.hibernate.cfg.Configuration addResource
|
34
|
[java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/ServiceImpl.hbm.xml
|
35
|
[java] 3????03, 2018 8:39:51 ???? org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator instantiateExplicitConnectionProvider
|
36
|
[java] INFO: HHH000130: Instantiating explicit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider
|
37
|
[java] 3????03, 2018 8:39:51 ???? org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider configure
|
38
|
[java] INFO: HHH010002: C3P0 using driver: org.h2.Driver at URL: jdbc:h2:C:\FWD\hotel/deploy/db/hotel;MV_STORE=FALSE;LOG=0;CACHE_SIZE=65536;LOCK_MODE=0;UNDO_LOG=0
|
39
|
[java] 3????03, 2018 8:39:51 ???? org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider configure
|
40
|
[java] INFO: HHH000046: Connection properties: {user=fwd_user, password=****}
|
41
|
[java] 3????03, 2018 8:39:51 ???? org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider configure
|
42
|
[java] INFO: HHH000006: Autocommit mode: false
|
43
|
[java] SLF4J: Class path contains multiple SLF4J bindings.
|
44
|
[java] SLF4J: Found binding in [jar:file:/C:/FWD/hotel/deploy/lib/slf4j-jdk14-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
|
45
|
[java] SLF4J: Found binding in [jar:file:/C:/FWD/hotel/deploy/lib/slf4j-simple-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
|
46
|
[java] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
|
47
|
[java] SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
|
48
|
[java] 3????03, 2018 8:39:51 ???? com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log
|
49
|
[java] ????: MLog clients using slf4j logging.
|
50
|
[java] 3????03, 2018 8:39:53 ???? com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log
|
51
|
[java] ????: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
|
52
|
[java] 3????03, 2018 8:39:53 ???? com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log
|
53
|
[java] ????: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@9337a3d0 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@540e278b [ acquireIncrement -> 8, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, identityToken -> 1hge15w9t1sqdivs18pcxmt|3059cbc, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 24, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 8, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@9bab9091 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 1hge15w9t1sqdivs18pcxmt|4f67eb2a, jdbcUrl -> jdbc:h2:C:\FWD\hotel/deploy/db/hotel;MV_STORE=FALSE;LOG=0;CACHE_SIZE=65536;LOCK_MODE=0;UNDO_LOG=0, properties -> {user=******, password=******} ], preferredTestQuery -> null, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 1hge15w9t1sqdivs18pcxmt|5403f35f, numHelperThreads -> 3 ]
|
54
|
[java] 3????03, 2018 8:39:53 ???? com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$WarnLogger log
|
55
|
[java] ????: Bad pool size config, start 3 < min 8. Using 8 as start.
|
56
|
[java] 3????03, 2018 8:39:54 ???? org.hibernate.dialect.Dialect <init>
|
57
|
[java] INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect
|
58
|
[java] 3????03, 2018 8:39:54 ???? org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
|
59
|
[java] INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
|
60
|
[java] 3????03, 2018 8:39:54 ???? org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
|
61
|
[java] INFO: HHH000397: Using ASTQueryTranslatorFactory
|
62
|
[java] 3????03, 2018 8:39:54 ???? org.hibernate.dialect.Dialect <init>
|
63
|
[java] INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect
|
64
|
[java] 3????03, 2018 8:39:55 ???? org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
|
65
|
[java] INFO: HHH000397: Using ASTQueryTranslatorFactory
|
66
|
[java] IMPORT ORDER:
|
67
|
[java] 1) GuestImpl:15532.0 [7766 bytes]
|
68
|
[java] 2) StayImpl:11196.0 [5598 bytes]
|
69
|
[java] 3) ReservationImpl:3636.0 [1818 bytes]
|
70
|
[java] 4) RateImpl:2946.0 [1473 bytes]
|
71
|
[java] 5) RoomImpl:1042.0 [521 bytes]
|
72
|
[java] 6) RoomTypeImpl:986.0 [493 bytes]
|
73
|
[java] 7) MetaUserImpl:496.0 [248 bytes]
|
74
|
[java] 8) ServiceImpl:484.0 [242 bytes]
|
75
|
[java] 9) GuestIdTypeImpl:426.0 [213 bytes]
|
76
|
[java] 10) ServiceTypeImpl:426.0 [213 bytes]
|
77
|
[java] BEGIN guest (guest.d)
|
78
|
[java] BEGIN stay (stay.d)
|
79
|
[java] BEGIN reservation (reservation.d)
|
80
|
[java] BEGIN rate (rate.d)
|
81
|
[java] 3????03, 2018 8:39:57 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
82
|
[java] ????: SQL: drop index if exists idx__reservation_room_num_date
|
83
|
[java] 3????03, 2018 8:39:57 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
84
|
[java] ????: SQL: drop index if exists idx__guest_stay_order
|
85
|
[java] 3????03, 2018 8:39:57 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
86
|
[java] ????: SQL: drop index if exists idx__rate_room_type_date
|
87
|
[java] 3????03, 2018 8:39:57 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
88
|
[java] ????: SQL: drop index if exists idx__stay_stay_id
|
89
|
[java] 3????03, 2018 8:39:57 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndexes
|
90
|
[java] ????: Skipping dropping of word index: idx__reservation_guest
|
91
|
[java] 3????03, 2018 8:39:57 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
92
|
[java] ????: SQL: create unique index idx__stay_stay_id on stay (stay_id)
|
93
|
[java] 3????03, 2018 8:39:57 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
94
|
[java] ????: SQL: create unique index idx__guest_stay_order on guest (stay_id, order_)
|
95
|
[java] Unable to read PSC footer. Using defaults.
|
96
|
[java] Unable to read PSC footer. Using defaults.
|
97
|
[java] Unable to read PSC footer. Using defaults.
|
98
|
[java] Unable to read PSC footer. Using defaults.
|
99
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
100
|
[java] ????: SQL: create index idx__reservation_room_num_date on reservation (room_num, start_date, end_date, id)
|
101
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
102
|
[java] ????: SQL: create index idx__rate_room_type_date on rate (room_type, start_date, end_date, id)
|
103
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndexes
|
104
|
[java] ????: Skipping creation of word index: idx__reservation_guest
|
105
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
106
|
[java] END reservation; 37 records imported
|
107
|
[java] 9.78208% complete: 37 recs in 0:00:02.090 (17/sec, 1062/min, 63732/hr)
|
108
|
[java] END guest; 163 records imported
|
109
|
[java] 51.56847% complete: 200 recs in 0:00:02.119 (94/sec, 5663/min, 339782/hr)
|
110
|
[java] END stay; 158 records imported
|
111
|
[java] 81.68953% complete: 358 recs in 0:00:02.121 (168/sec, 10127/min, 607637/hr)
|
112
|
[java] END rate; 56 records imported
|
113
|
[java] 89.61528% complete: 414 recs in 0:00:02.122 (195/sec, 11705/min, 702356/hr)
|
114
|
[java] BEGIN room (room.d)
|
115
|
[java] BEGIN room_type (room-type.d)
|
116
|
[java] BEGIN meta_user (_user.d)
|
117
|
[java] BEGIN service (service.d)
|
118
|
[java] END room_type; 7 records imported
|
119
|
[java] 92.26796% complete: 421 recs in 0:00:02.185 (192/sec, 11560/min, 693638/hr)
|
120
|
[java] ????: SQL: drop index if exists idx__room_room_num
|
121
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
122
|
[java] ????: SQL: drop index if exists idx__room_type_type
|
123
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
124
|
[java] ????: SQL: create unique index idx__room_type_type on room_type (room_type)
|
125
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
126
|
[java] ????: SQL: drop index if exists idx__meta_user_userid
|
127
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
128
|
[java] ????: SQL: create unique index idx__room_room_num on room (room_num)
|
129
|
[java] Unable to read PSC footer. Using defaults.
|
130
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
131
|
[java] ????: SQL: drop index if exists idx__service_stay_charge
|
132
|
[java] Unable to read PSC footer. Using defaults.
|
133
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
134
|
[java] ????: SQL: create unique index idx__meta_user_userid on meta_user (__iuserid)
|
135
|
[java] Unable to read PSC footer. Using defaults.
|
136
|
[java] BEGIN guest_id_type (guest-id-type.d)
|
137
|
[java] END service; 5 records imported
|
138
|
[java] 93.57008% complete: 426 recs in 0:00:02.231 (190/sec, 11456/min, 687404/hr)
|
139
|
[java] BEGIN service_type (service-type.d)
|
140
|
[java] END service_type; 3 records imported
|
141
|
[java] 94.71617% complete: 429 recs in 0:00:02.259 (189/sec, 11394/min, 683665/hr)
|
142
|
[java] END room; 30 records imported
|
143
|
[java] 97.51950% complete: 459 recs in 0:00:02.268 (202/sec, 12142/min, 728571/hr)
|
144
|
[java] END guest_id_type; 3 records imported
|
145
|
[java] 98.66559% complete: 462 recs in 0:00:02.270 (203/sec, 12211/min, 732687/hr)
|
146
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
147
|
[java] ????: SQL: drop index if exists idx__guest_id_type_id_type
|
148
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
149
|
[java] ????: SQL: create index idx__service_stay_charge on service (stay_id, service_type, service_date, id)
|
150
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
|
151
|
[java] ????: SQL: drop index if exists idx__service_type_charge_type
|
152
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
153
|
[java] ????: SQL: create unique index idx__service_type_charge_type on service_type (service_type)
|
154
|
[java] 3????03, 2018 8:39:58 ???? com.goldencode.p2j.schema.ImportWorker$Library createIndex
|
155
|
[java] ????: SQL: create unique index idx__guest_id_type_id_type on guest_id_type (id_type)
|
156
|
[java] Unable to read PSC footer. Using defaults.
|
157
|
[java] Unable to read PSC footer. Using defaults.
|
158
|
[java] END meta_user; 1 records imported
|
159
|
[java] 100.00000% complete: 463 recs in 0:00:02.405 (192/sec, 11550/min, 693056/hr)
|
160
|
[java] Total records processed: 463 in 0:00:02.433 (190.300 records/sec)
|
161
|
[java] Total sequences initialized: 0.
|
162
|
[java] Reading merge DMO definitions...
|
163
|
[java] Elapsed job time: 00:00:10.766
|