[java] INFO:  Type match assertion disabled;  set "checkTypes" to true to enable
     [java] INFO:  Data export files will be read from 'data\dump\hotel\'
     [java] INFO:  Using 4 threads for import
     [java] 3þýþý03, 2018 8:39:49 上åþý org.hibernate.dialect.Dialect <init>
     [java] INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect
     [java] .\data\namespace\hotel.p2o
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.annotations.common.Version <clinit>
     [java] INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.Version logVersion
     [java] INFO: HHH000412: Hibernate Core {4.1.8.Final}
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Environment <clinit>
     [java] INFO: HHH000206: hibernate.properties not found
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Environment buildBytecodeProvider
     [java] INFO: HHH000021: Bytecode provider name : javassist
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/GuestIdTypeImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/MetaUserImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/RoomTypeImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/RoomImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/StayImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/ReservationImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/RateImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:50 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/GuestImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:51 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/ServiceTypeImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:51 上åþý org.hibernate.cfg.Configuration addResource
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/ServiceImpl.hbm.xml
     [java] 3þýþý03, 2018 8:39:51 上åþý org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator instantiateExplicitConnectionProvider
     [java] INFO: HHH000130: Instantiating explicit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider
     [java] 3þýþý03, 2018 8:39:51 上åþý org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider configure
     [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
     [java] 3þýþý03, 2018 8:39:51 上åþý org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider configure
     [java] INFO: HHH000046: Connection properties: {user=fwd_user, password=****}
     [java] 3þýþý03, 2018 8:39:51 上åþý org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider configure
     [java] INFO: HHH000006: Autocommit mode: false
     [java] SLF4J: Class path contains multiple SLF4J bindings.
     [java] SLF4J: Found binding in [jar:file:/C:/FWD/hotel/deploy/lib/slf4j-jdk14-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
     [java] SLF4J: Found binding in [jar:file:/C:/FWD/hotel/deploy/lib/slf4j-simple-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
     [java] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
     [java] SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
     [java] 3þýþý03, 2018 8:39:51 上åþý com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log
     [java] 資èþý: MLog clients using slf4j logging.
     [java] 3þýþý03, 2018 8:39:53 上åþý com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log
     [java] 資èþý: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
     [java] 3þýþý03, 2018 8:39:53 上åþý com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log
     [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 ]
     [java] 3þýþý03, 2018 8:39:53 上åþý com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$WarnLogger log
     [java] è­¦åþý: Bad pool size config, start 3 < min 8. Using 8 as start.
     [java] 3þýþý03, 2018 8:39:54 上åþý org.hibernate.dialect.Dialect <init>
     [java] INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect
     [java] 3þýþý03, 2018 8:39:54 上åþý org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
     [java] INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
     [java] 3þýþý03, 2018 8:39:54 上åþý org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
     [java] INFO: HHH000397: Using ASTQueryTranslatorFactory
     [java] 3þýþý03, 2018 8:39:54 上åþý org.hibernate.dialect.Dialect <init>
     [java] INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect
     [java] 3þýþý03, 2018 8:39:55 上åþý org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
     [java] INFO: HHH000397: Using ASTQueryTranslatorFactory
     [java] IMPORT ORDER:
     [java] 1) GuestImpl:15532.0 [7766 bytes]
     [java] 2) StayImpl:11196.0 [5598 bytes]
     [java] 3) ReservationImpl:3636.0 [1818 bytes]
     [java] 4) RateImpl:2946.0 [1473 bytes]
     [java] 5) RoomImpl:1042.0 [521 bytes]
     [java] 6) RoomTypeImpl:986.0 [493 bytes]
     [java] 7) MetaUserImpl:496.0 [248 bytes]
     [java] 8) ServiceImpl:484.0 [242 bytes]
     [java] 9) GuestIdTypeImpl:426.0 [213 bytes]
     [java] 10) ServiceTypeImpl:426.0 [213 bytes]
     [java] BEGIN guest (guest.d)
     [java] BEGIN stay (stay.d)
     [java] BEGIN reservation (reservation.d)
     [java] BEGIN rate (rate.d)
     [java] 3þýþý03, 2018 8:39:57 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] 資èþý: SQL: drop index if exists idx__reservation_room_num_date
     [java] 3þýþý03, 2018 8:39:57 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] 資èþý: SQL: drop index if exists idx__guest_stay_order
     [java] 3þýþý03, 2018 8:39:57 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] 資èþý: SQL: drop index if exists idx__rate_room_type_date
     [java] 3þýþý03, 2018 8:39:57 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] 資èþý: SQL: drop index if exists idx__stay_stay_id
     [java] 3þýþý03, 2018 8:39:57 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndexes
     [java] 資èþý: Skipping dropping of word index: idx__reservation_guest
     [java] 3þýþý03, 2018 8:39:57 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create unique index idx__stay_stay_id on stay (stay_id)
     [java] 3þýþý03, 2018 8:39:57 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create unique index idx__guest_stay_order on guest (stay_id, order_)
     [java] Unable to read PSC footer. Using defaults.
     [java] Unable to read PSC footer. Using defaults.
     [java] Unable to read PSC footer. Using defaults.
     [java] Unable to read PSC footer. Using defaults.
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create index idx__reservation_room_num_date on reservation (room_num, start_date, end_date, id)
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create index idx__rate_room_type_date on rate (room_type, start_date, end_date, id)
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndexes
     [java] 資èþý: Skipping creation of word index: idx__reservation_guest
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] END reservation;  37 records imported
     [java] 9.78208% complete:  37 recs in 0:00:02.090 (17/sec, 1062/min, 63732/hr)
     [java] END guest;  163 records imported
     [java] 51.56847% complete:  200 recs in 0:00:02.119 (94/sec, 5663/min, 339782/hr)
     [java] END stay;  158 records imported
     [java] 81.68953% complete:  358 recs in 0:00:02.121 (168/sec, 10127/min, 607637/hr)
     [java] END rate;  56 records imported
     [java] 89.61528% complete:  414 recs in 0:00:02.122 (195/sec, 11705/min, 702356/hr)
     [java] BEGIN room (room.d)
     [java] BEGIN room_type (room-type.d)
     [java] BEGIN meta_user (_user.d)
     [java] BEGIN service (service.d)
     [java] END room_type;  7 records imported
     [java] 92.26796% complete:  421 recs in 0:00:02.185 (192/sec, 11560/min, 693638/hr)
     [java] 資èþý: SQL: drop index if exists idx__room_room_num
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] 資èþý: SQL: drop index if exists idx__room_type_type
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create unique index idx__room_type_type on room_type (room_type)
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] 資èþý: SQL: drop index if exists idx__meta_user_userid
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create unique index idx__room_room_num on room (room_num)
     [java] Unable to read PSC footer. Using defaults.
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] 資èþý: SQL: drop index if exists idx__service_stay_charge
     [java] Unable to read PSC footer. Using defaults.
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create unique index idx__meta_user_userid on meta_user (__iuserid)
     [java] Unable to read PSC footer. Using defaults.
     [java] BEGIN guest_id_type (guest-id-type.d)
     [java] END service;  5 records imported
     [java] 93.57008% complete:  426 recs in 0:00:02.231 (190/sec, 11456/min, 687404/hr)
     [java] BEGIN service_type (service-type.d)
     [java] END service_type;  3 records imported
     [java] 94.71617% complete:  429 recs in 0:00:02.259 (189/sec, 11394/min, 683665/hr)
     [java] END room;  30 records imported
     [java] 97.51950% complete:  459 recs in 0:00:02.268 (202/sec, 12142/min, 728571/hr)
     [java] END guest_id_type;  3 records imported
     [java] 98.66559% complete:  462 recs in 0:00:02.270 (203/sec, 12211/min, 732687/hr)
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] 資èþý: SQL: drop index if exists idx__guest_id_type_id_type
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create index idx__service_stay_charge on service (stay_id, service_type, service_date, id)
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library dropIndex
     [java] 資èþý: SQL: drop index if exists idx__service_type_charge_type
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create unique index idx__service_type_charge_type on service_type (service_type)
     [java] 3þýþý03, 2018 8:39:58 上åþý com.goldencode.p2j.schema.ImportWorker$Library createIndex
     [java] 資èþý: SQL: create unique index idx__guest_id_type_id_type on guest_id_type (id_type)
     [java] Unable to read PSC footer. Using defaults.
     [java] Unable to read PSC footer. Using defaults.
     [java] END meta_user;  1 records imported
     [java] 100.00000% complete:  463 recs in 0:00:02.405 (192/sec, 11550/min, 693056/hr)
     [java] Total records processed:  463 in 0:00:02.433 (190.300 records/sec)
     [java] Total sequences initialized: 0.
     [java] Reading merge DMO definitions...
     [java] Elapsed job time:  00:00:10.766