Project

General

Profile

import_db_h2.log

Kenny Chan, 02/24/2018 11:11 AM

Download (11.8 KB)

 
1
Buildfile: C:\FWD\hotel\build.xml
2

    
3
dir.check:
4

    
5
check.p2j.dir:
6

    
7
init:
8

    
9
clean.db.h2:
10

    
11
download-ant-contrib:
12

    
13
init-ant-contrib:
14

    
15
db.task:
16

    
17
clean.db.h2:
18

    
19
create.db.h2:
20

    
21
download-ant-contrib:
22

    
23
init-ant-contrib:
24

    
25
db.task:
26

    
27
create.db.h2:
28

    
29
import.db.h2:
30

    
31
download-ant-contrib:
32

    
33
init-ant-contrib:
34

    
35
db.task:
36

    
37
import.db.h2:
38
     [java] INFO:  Type match assertion disabled;  set "checkTypes" to true to enable
39
     [java] INFO:  Data export files will be read from 'data\dump\hotel\'
40
     [java] INFO:  Using 4 threads for import
41
     [java] 2?? 24, 2018 11:52:10 ?U?? org.hibernate.dialect.Dialect <init>
42
     [java] INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect
43
     [java] .\data\namespace\hotel.p2o
44
     [java] 2?? 24, 2018 11:52:10 ?U?? org.hibernate.annotations.common.Version <clinit>
45
     [java] INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
46
     [java] 2?? 24, 2018 11:52:10 ?U?? org.hibernate.Version logVersion
47
     [java] INFO: HHH000412: Hibernate Core {4.1.8.Final}
48
     [java] 2?? 24, 2018 11:52:10 ?U?? org.hibernate.cfg.Environment <clinit>
49
     [java] INFO: HHH000206: hibernate.properties not found
50
     [java] 2?? 24, 2018 11:52:10 ?U?? org.hibernate.cfg.Environment buildBytecodeProvider
51
     [java] INFO: HHH000021: Bytecode provider name : javassist
52
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
53
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/GuestIdTypeImpl.hbm.xml
54
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
55
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/MetaUserImpl.hbm.xml
56
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
57
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/RoomTypeImpl.hbm.xml
58
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
59
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/RoomImpl.hbm.xml
60
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
61
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/StayImpl.hbm.xml
62
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
63
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/ReservationImpl.hbm.xml
64
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
65
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/RateImpl.hbm.xml
66
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
67
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/GuestImpl.hbm.xml
68
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
69
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/ServiceTypeImpl.hbm.xml
70
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.cfg.Configuration addResource
71
     [java] INFO: HHH000221: Reading mappings from resource: com/goldencode/hotel/dmo/hotel/impl/ServiceImpl.hbm.xml
72
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator instantiateExplicitConnectionProvider
73
     [java] INFO: HHH000130: Instantiating explicit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider
74
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider configure
75
     [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
76
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider configure
77
     [java] INFO: HHH000046: Connection properties: {user=fwd_user, password=****}
78
     [java] 2?? 24, 2018 11:52:11 ?U?? org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider configure
79
     [java] INFO: HHH000006: Autocommit mode: false
80
     [java] SLF4J: Class path contains multiple SLF4J bindings.
81
     [java] SLF4J: Found binding in [jar:file:/C:/FWD/hotel/deploy/lib/slf4j-jdk14-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
82
     [java] SLF4J: Found binding in [jar:file:/C:/FWD/hotel/deploy/lib/slf4j-simple-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
83
     [java] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
84
     [java] SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
85
     [java] 2?? 24, 2018 11:52:12 ?U?? com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log
86
     [java] ??T: MLog clients using slf4j logging.
87
     [java] 2?? 24, 2018 11:52:14 ?U?? com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log
88
     [java] ??T: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
89
     [java] 2?? 24, 2018 11:52:14 ?U?? com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log
90
     [java] ??T: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@26c4575c [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@7196d27f [ 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 -> 1hge15w9t1jmvufv1rh3url|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@2f38441d [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 1hge15w9t1jmvufv1rh3url|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 -> 1hge15w9t1jmvufv1rh3url|5403f35f, numHelperThreads -> 3 ]
91
     [java] 2?? 24, 2018 11:52:14 ?U?? com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$WarnLogger log
92
     [java] ??i: Bad pool size config, start 3 < min 8. Using 8 as start.
93
     [java] 2?? 24, 2018 11:52:16 ?U?? org.hibernate.dialect.Dialect <init>
94
     [java] INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect
95
     [java] 2?? 24, 2018 11:52:16 ?U?? org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
96
     [java] INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
97
     [java] 2?? 24, 2018 11:52:16 ?U?? org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
98
     [java] INFO: HHH000397: Using ASTQueryTranslatorFactory
99
     [java] 2?? 24, 2018 11:52:16 ?U?? org.hibernate.dialect.Dialect <init>
100
     [java] INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect
101
     [java] 2?? 24, 2018 11:52:16 ?U?? org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
102
     [java] INFO: HHH000397: Using ASTQueryTranslatorFactory
103
     [java] IMPORT ORDER:
104
     [java] 1) GuestImpl:15532.0 [7766 bytes]
105
     [java] 2) StayImpl:11196.0 [5598 bytes]
106
     [java] 3) ReservationImpl:3636.0 [1818 bytes]
107
     [java] 4) RateImpl:2946.0 [1473 bytes]
108
     [java] 5) RoomImpl:1042.0 [521 bytes]
109
     [java] 6) RoomTypeImpl:986.0 [493 bytes]
110
     [java] 7) MetaUserImpl:496.0 [248 bytes]
111
     [java] 8) ServiceImpl:484.0 [242 bytes]
112
     [java] 9) GuestIdTypeImpl:426.0 [213 bytes]
113
     [java] 10) ServiceTypeImpl:426.0 [213 bytes]
114
     [java] 2?? 24, 2018 11:52:18 ?U?? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
115
     [java] ??T: SQL: drop index if exists idx__rate_room_type_date
116
     [java] 2?? 24, 2018 11:52:18 ?U?? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
117
     [java] ??T: SQL: drop index if exists idx__guest_stay_order
118
     [java] 2?? 24, 2018 11:52:18 ?U?? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
119
     [java] BEGIN guest (guest.d)
120
     [java] ??T: SQL: drop index if exists idx__stay_stay_idBEGIN stay (stay.d)
121
     [java] 
122
     [java] BEGIN reservation (reservation.d)
123
     [java] BEGIN rate (rate.d)
124
     [java] 2?? 24, 2018 11:52:18 ?U?? com.goldencode.p2j.schema.ImportWorker$Library dropIndex
125
     [java] ??T: SQL: drop index if exists idx__reservation_room_num_date
126
     [java] 2?? 24, 2018 11:52:18 ?U?? com.goldencode.p2j.schema.ImportWorker$Library dropIndexes
127
     [java] ??T: Skipping dropping of word index: idx__reservation_guest
128
     [java] 2?? 24, 2018 11:52:18 ?U?? com.goldencode.p2j.schema.ImportWorker$Library createIndex
129
     [java] ??T: SQL: create unique index idx__guest_stay_order on guest (stay_id, order_)
130
     [java] 2?? 24, 2018 11:52:18 ?U?? com.goldencode.p2j.schema.ImportWorker$Library createIndex
131
     [java] ??T: SQL: create unique index idx__stay_stay_id on stay (stay_id)
132
     [java] Exception in thread "Thread-8" java.lang.ExceptionInInitializerError
133
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1006)
134
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$0(ImportWorker.java:1457)
135
     [java] 	at java.lang.Thread.run(Thread.java:748)
136
     [java] Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 194
137
     [java] 	at java.lang.String.charAt(String.java:658)
138
     [java] 	at com.goldencode.p2j.util.CharsetConverter.<init>(CharsetConverter.java:123)
139
     [java] 	at com.goldencode.p2j.util.FileStream.<clinit>(FileStream.java:119)
140
     [java] 	... 3 more
141
     [java] Exception in thread "Thread-9" java.lang.NoClassDefFoundError: Could not initialize class com.goldencode.p2j.schema.ImportWorker$DataFileReader
142
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1006)
143
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$0(ImportWorker.java:1457)
144
     [java] 	at java.lang.Thread.run(Thread.java:748)
145
     [java] Exception in thread "Thread-6" java.lang.NoClassDefFoundError: Could not initialize class com.goldencode.p2j.schema.ImportWorker$DataFileReader
146
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1006)
147
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$0(ImportWorker.java:1457)
148
     [java] 	at java.lang.Thread.run(Thread.java:748)
149
     [java] Exception in thread "Thread-7" java.lang.NoClassDefFoundError: Could not initialize class com.goldencode.p2j.schema.ImportWorker$DataFileReader
150
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1006)
151
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$0(ImportWorker.java:1457)
152
     [java] 	at java.lang.Thread.run(Thread.java:748)