Buildfile: /home/sbi/projects/hotel_gui/build.xml

dir.check:

check.fwd.dir:

init:

clean.db.h2:

create.db.h2:

import.db.h2:

clean.db.pg:

download-ant-contrib:

init-ant-contrib:

db.task:

clean.db.pg:

create.db.pg:

download-ant-contrib:

init-ant-contrib:

db.task:

create.db.pg:
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE TABLE
     [exec] CREATE SEQUENCE

sql.udfs.pg:
     [java] Running script: [/udf/postgresql/udfs.sql]
     [java] Running script: [/udf/postgresql/words-udfs-sql.sql]
     [java] Running script: [/udf/postgresql/word-tables.sql]
     [java] Setting search_path for [hotel]

import.db.pg:

download-ant-contrib:

init-ant-contrib:

db.task:

import.db.pg:
     [java] Reflections took 124 ms to scan 2 urls, producing 10 keys and 24 values
     [java] Reflections took 36 ms to scan 2 urls, producing 5 keys and 7 values
     [java] Reflections took 30 ms to scan 2 urls, producing 8 keys and 10 values
     [java] Reflections took 17 ms to scan 2 urls, producing 10 keys and 29 values
     [java] Reflections took 163 ms to scan 2 urls, producing 255 keys and 1260 values
     [java] Reflections took 21 ms to scan 2 urls, producing 11 keys and 23 values
     [java] Reflections took 11 ms to scan 2 urls, producing 6 keys and 17 values
     [java] Reflections took 29 ms to scan 2 urls, producing 15 keys and 45 values
     [java] Reflections took 43 ms to scan 2 urls, producing 34 keys and 168 values
     [java] Reflections took 10 ms to scan 2 urls, producing 2 keys and 26 values
     [java] Reflections took 247 ms to scan 2 urls, producing 463 keys and 2174 values
     [java] Reflections took 143 ms to scan 2 urls, producing 354 keys and 1543 values
     [java] Reflections took 16 ms to scan 2 urls, producing 37 keys and 77 values
     [java] Reflections took 18 ms to scan 2 urls, producing 20 keys and 88 values
     [java] Using unnamed schema profile.
     [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:  Tenant import mode: none
     [java] INFO:  Using 4 threads for import with batch size of 200
     [java] ./cvt/data/hotel.p2o
     [java] MLog clients using slf4j logging.
     [java] Initializing c3p0-0.9.5.5 [built 11-December-2019 22:18:33 -0800; debug? true; trace: 10]
     [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 -> 1hge145bb3bwibf14iktoq|bb6869a, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.postgresql.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge145bb3bwibf14iktoq|bb6869a, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:postgresql://localhost:5435/hotel, 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 ]
     [java] No databases provided for bootstrap.
     [java] Found identity generator sequence starting at 1.
     [java] IMPORT ORDER:
     [java] 	1) guest.d:20802.0 [10401 bytes]
     [java] 	2) stay.d:15508.0 [7754 bytes]
     [java] 	3) reservation.d:3532.0 [1766 bytes]
     [java] 	4) rate.d:2946.0 [1473 bytes]
     [java] 	5) room.d:1042.0 [521 bytes]
     [java] 	6) room-type.d:986.0 [493 bytes]
     [java] 	7) _user.d:496.0 [248 bytes]
     [java] 	8) service.d:484.0 [242 bytes]
     [java] 	9) guest-id-type.d:426.0 [213 bytes]
     [java] 	10) service-type.d:426.0 [213 bytes]
     [java] BEGIN guest.d (guest)
     [java] BEGIN reservation.d (reservation)
     [java] BEGIN stay.d (stay)
     [java] BEGIN rate.d (rate)
     [java] guest.d: SQL: drop index if exists idx__guest_stay_order
     [java] stay.d: SQL: drop index if exists idx__stay_stay_id
     [java] guest.d: SQL: create unique index idx__guest_stay_order on guest (stay_id, order_) include (recid)
     [java] rate.d: SQL: drop index if exists idx__rate_room_type_date
     [java] stay.d: SQL: create unique index idx__stay_stay_id on stay (stay_id) include (recid)
     [java] stay.d: Error processing import data; 0 of ? record(s) successfully processed;  0 record(s) uncommitted due to this error;  1 record(s) dropped. Cause: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 57
     [java] 
     [java] com.goldencode.p2j.persist.PersistenceException: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 57
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "include"
     [java]   Position: 57
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
     [java] 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
     [java] 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:155)
     [java] 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.executeImpl(SQLExecutor.java:354)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:272)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:226)
     [java] 	at com.goldencode.p2j.persist.orm.SQLQuery.executeUpdate(SQLQuery.java:621)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndex(ImportWorker.java:2465)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndexes(ImportWorker.java:2418)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1334)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$4(ImportWorker.java:2173)
     [java] 	at java.lang.Thread.run(Thread.java:750)
     [java] 
     [java] END stay.d. 0 records imported into stay
     [java] 33.24473% complete:  0 recs in 0:00:01.212 (0/sec, 0/min, 0/hr)
     [java] BEGIN room.d (room)
     [java] guest.d: Error processing import data; 0 of ? record(s) successfully processed;  0 record(s) uncommitted due to this error;  1 record(s) dropped. Cause: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 70
     [java] 
     [java] com.goldencode.p2j.persist.PersistenceException: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 70
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "include"
     [java]   Position: 70
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
     [java] 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
     [java] 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:155)
     [java] 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.executeImpl(SQLExecutor.java:354)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:272)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:226)
     [java] 	at com.goldencode.p2j.persist.orm.SQLQuery.executeUpdate(SQLQuery.java:621)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndex(ImportWorker.java:2465)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndexes(ImportWorker.java:2418)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1334)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$4(ImportWorker.java:2173)
     [java] 	at java.lang.Thread.run(Thread.java:750)
     [java] 
     [java] END guest.d. 0 records imported into guest
     [java] 77.83828% complete:  0 recs in 0:00:01.217 (0/sec, 0/min, 0/hr)
     [java] BEGIN room-type.d (room_type)
     [java] room-type.d: SQL: drop index if exists idx__room_type_type
     [java] reservation.d: SQL: drop index if exists idx__reservation_room_num_date
     [java] room.d: SQL: drop index if exists idx__room_room_num
     [java] reservation.d: Skipping dropping of word index: guest
     [java] room.d: SQL: create unique index idx__room_room_num on room (room_num) include (recid)
     [java] room-type.d: SQL: create unique index idx__room_type_type on room_type (room_type) include (recid)
     [java] room.d: Error processing import data; 0 of ? record(s) successfully processed;  0 record(s) uncommitted due to this error;  1 record(s) dropped. Cause: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 59
     [java] room-type.d: Error processing import data; 0 of ? record(s) successfully processed;  0 record(s) uncommitted due to this error;  1 record(s) dropped. Cause: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 66
     [java] 
     [java] com.goldencode.p2j.persist.PersistenceException: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 59
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "include"
     [java]   Position: 59
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
     [java] 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
     [java] 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:155)
     [java] 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.executeImpl(SQLExecutor.java:354)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:272)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:226)
     [java] 	at com.goldencode.p2j.persist.orm.SQLQuery.executeUpdate(SQLQuery.java:621)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndex(ImportWorker.java:2465)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndexes(ImportWorker.java:2418)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1334)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$4(ImportWorker.java:2173)
     [java] 	at java.lang.Thread.run(Thread.java:750)
     [java] 
     [java] END room.d. 0 records imported into room
     [java] 80.07203% complete:  0 recs in 0:00:01.247 (0/sec, 0/min, 0/hr)
     [java] 
     [java] com.goldencode.p2j.persist.PersistenceException: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 66
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "include"
     [java]   Position: 66
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
     [java] 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
     [java] 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:155)
     [java] 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.executeImpl(SQLExecutor.java:354)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:272)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:226)
     [java] 	at com.goldencode.p2j.persist.orm.SQLQuery.executeUpdate(SQLQuery.java:621)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndex(ImportWorker.java:2465)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndexes(ImportWorker.java:2418)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1334)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$4(ImportWorker.java:2173)
     [java] 	at java.lang.Thread.run(Thread.java:750)
     [java] 
     [java] END room-type.d. 0 records imported into room_type
     [java] 82.18573% complete:  0 recs in 0:00:01.249 (0/sec, 0/min, 0/hr)
     [java] BEGIN _user.d (meta_user)
     [java] BEGIN service.d (service)
     [java] service.d: SQL: drop index if exists idx__service_stay_charge
     [java] service.d: Set up UTF-8 character encoding.
     [java] rate.d: Set up UTF-8 character encoding.
     [java] _user.d: SQL: drop index if exists idx__meta_user_userid
     [java] reservation.d: Set up UTF-8 character encoding.
     [java] _user.d: SQL: drop index if exists idx__meta_user_user_domain_name
     [java] _user.d: SQL: drop index if exists idx__meta_user_user_sql_only_user
     [java] _user.d: SQL: create unique index idx__meta_user_userid on meta_user (upper(rtrim(userid)), upper(rtrim(domain_name))) include (recid)
     [java] _user.d: Error processing import data; 0 of ? record(s) successfully processed;  0 record(s) uncommitted due to this error;  1 record(s) dropped. Cause: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 106
     [java] 
     [java] com.goldencode.p2j.persist.PersistenceException: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 106
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "include"
     [java]   Position: 106
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
     [java] 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
     [java] 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:155)
     [java] 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.executeImpl(SQLExecutor.java:354)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:272)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:226)
     [java] 	at com.goldencode.p2j.persist.orm.SQLQuery.executeUpdate(SQLQuery.java:621)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndex(ImportWorker.java:2465)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndexes(ImportWorker.java:2418)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1334)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$4(ImportWorker.java:2173)
     [java] 	at java.lang.Thread.run(Thread.java:750)
     [java] 
     [java] END _user.d. 0 records imported into meta_user
     [java] 83.24901% complete:  0 recs in 0:00:01.332 (0/sec, 0/min, 0/hr)
     [java] BEGIN guest-id-type.d (guest_id_type)
     [java] guest-id-type.d: SQL: drop index if exists idx__guest_id_type_id_type
     [java] guest-id-type.d: SQL: create unique index idx__guest_id_type_id_type on guest_id_type (id_type) include (recid)
     [java] guest-id-type.d: Error processing import data; 0 of ? record(s) successfully processed;  0 record(s) uncommitted due to this error;  1 record(s) dropped. Cause: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 75
     [java] 
     [java] com.goldencode.p2j.persist.PersistenceException: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 75
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "include"
     [java]   Position: 75
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
     [java] 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
     [java] 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:155)
     [java] 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.executeImpl(SQLExecutor.java:354)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:272)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:226)
     [java] 	at com.goldencode.p2j.persist.orm.SQLQuery.executeUpdate(SQLQuery.java:621)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndex(ImportWorker.java:2465)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndexes(ImportWorker.java:2418)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1334)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$4(ImportWorker.java:2173)
     [java] 	at java.lang.Thread.run(Thread.java:750)
     [java] 
     [java] END guest-id-type.d. 0 records imported into guest_id_type
     [java] 84.16224% complete:  0 recs in 0:00:01.375 (0/sec, 0/min, 0/hr)
     [java] service.d: SQL: create index idx__service_stay_charge on service (stay_id, service_type, service_date, recid)
     [java] service.d: Analyzing service...
     [java] BEGIN service-type.d (service_type)
     [java] service-type.d: SQL: drop index if exists idx__service_type_charge_type
     [java] service-type.d: SQL: create unique index idx__service_type_charge_type on service_type (service_type) include (recid)
     [java] END service.d. 5 records imported into service
     [java] 85.19979% complete:  5 recs in 0:00:01.397 (3/sec, 214/min, 12884/hr)
     [java] service-type.d: Error processing import data; 0 of ? record(s) successfully processed;  0 record(s) uncommitted due to this error;  1 record(s) dropped. Cause: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 82
     [java] 
     [java] com.goldencode.p2j.persist.PersistenceException: Error executeUpdate: ERROR: syntax error at or near "include"
     [java]   Position: 82
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "include"
     [java]   Position: 82
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
     [java] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
     [java] 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
     [java] 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
     [java] 	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:155)
     [java] 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.executeImpl(SQLExecutor.java:354)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:272)
     [java] 	at com.goldencode.p2j.persist.orm.SQLExecutor.execute(SQLExecutor.java:226)
     [java] 	at com.goldencode.p2j.persist.orm.SQLQuery.executeUpdate(SQLQuery.java:621)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndex(ImportWorker.java:2465)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.createIndexes(ImportWorker.java:2418)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.importTable(ImportWorker.java:1334)
     [java] 	at com.goldencode.p2j.schema.ImportWorker$Library.lambda$importAsync$4(ImportWorker.java:2173)
     [java] 	at java.lang.Thread.run(Thread.java:750)
     [java] 
     [java] END service-type.d. 0 records imported into service_type
     [java] 86.11302% complete:  5 recs in 0:00:01.401 (3/sec, 214/min, 12847/hr)
     [java] rate.d: SQL: create index idx__rate_room_type_date on rate (room_type, start_date, end_date, recid)
     [java] rate.d: Analyzing rate...
     [java] END rate.d. 56 records imported into rate
     [java] 92.42840% complete:  61 recs in 0:00:01.426 (42/sec, 2566/min, 153997/hr)
     [java] reservation.d: SQL: create index idx__reservation_room_num_date on reservation (room_num, start_date, end_date, recid)
     [java] reservation.d: Skipping creation of word index: guest
     [java] reservation.d: Analyzing reservation...
     [java] END reservation.d. 36 records imported into reservation
     [java] 100.00000% complete:  97 recs in 0:00:01.444 (67/sec, 4030/min, 241828/hr)
     [java] Updated identity generator sequence starting at 40001.
     [java] Total records processed:  97 in 0:00:01.445 (67.128 records/sec)
     [java] Number of failed records: 7. Summary by table:
     [java] 	stay.d: 1 (fatal)
     [java] 	guest.d: 1 (fatal)
     [java] 	room.d: 1 (fatal)
     [java] 	room-type.d: 1 (fatal)
     [java] 	_user.d: 1 (fatal)
     [java] 	guest-id-type.d: 1 (fatal)
     [java] 	service-type.d: 1 (fatal)
     [java] Total sequences initialized: 0.
     [java] Reading merge DMO definitions...
     [java] Elapsed job time:  00:00:05.611
     [exec] CREATE FUNCTION
     [exec] DROP TRIGGER
     [exec] CREATE TRIGGER
     [exec] DROP TRIGGER
     [exec] CREATE TRIGGER
     [exec] ALTER TABLE
     [exec] psql:ddl/schema_word_tables_hotel_postgresql.sql:13: NOTICE:  trigger "reservation__guest__upd" for relation "reservation" does not exist, skipping
     [exec] psql:ddl/schema_word_tables_hotel_postgresql.sql:20: NOTICE:  trigger "reservation__guest__ins" for relation "reservation" does not exist, skipping
     [exec] psql:ddl/schema_word_tables_hotel_postgresql.sql:27: NOTICE:  constraint "pk__reservation__guest" of relation "reservation__guest" does not exist, skipping
     [exec] ALTER TABLE
     [exec] DROP INDEX
     [exec] CREATE INDEX
     [exec] ALTER TABLE
     [exec] DROP INDEX
     [exec] CREATE INDEX
     [exec] ALTER TABLE
     [exec] psql:ddl/schema_word_tables_hotel_postgresql.sql:29: NOTICE:  index "idx__reservation__guest" does not exist, skipping
     [exec] psql:ddl/schema_word_tables_hotel_postgresql.sql:31: NOTICE:  constraint "fk__reservation__guest" of relation "reservation__guest" does not exist, skipping
     [exec] psql:ddl/schema_word_tables_hotel_postgresql.sql:32: NOTICE:  index "fkidx__reservation__guest" does not exist, skipping
     [exec] ANALYZE

clean.db.mariadb:

create.db.mariadb:

import.db.mariadb:

import.db:

BUILD SUCCESSFUL
Total time: 12 seconds