And this application.yaml
#Uncomment the "servlet" and "context-path" lines below to make the fhir endpoint available at /example/path/fhir instead of the default value of /fhir
server:
# servlet:
# context-path: /example/path
port: 8080
#Adds the option to go to eg. http://localhost:8080/actuator/health for seeing the running configuration
#see https://docs.spring.io/spring-boot/docs/current/reference/html/actuator.html#actuator.endpoints
management:
endpoints:
web:
exposure:
include: "health,prometheus"
spring:
main:
allow-circular-references: true
#allow-bean-definition-overriding: true
flyway:
enabled: false
baselineOnMigrate: true
fail-on-missing-locations: false
datasource:
url: jdbc:postgresql://172.26.0.2:5432/hapi
username: postgres
password: password
driver-class-name: org.postgresql.Driver
# database connection pool size
hikari:
maximum-pool-size: 10
jpa:
properties:
hibernate.format_sql: false
hibernate.show_sql: false
#Hibernate dialect is automatically detected except Postgres and H2.
#If using H2, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
#If using postgres, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgres94Dialect
hibernate.dialect: ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
# hibernate.hbm2ddl.auto: update
# hibernate.jdbc.batch_size: 20
# hibernate.cache.use_query_cache: false
# hibernate.cache.use_second_level_cache: false
# hibernate.cache.use_structured_entries: false
# hibernate.cache.use_minimal_puts: false
### These settings will enable fulltext search with lucene or elastic
hibernate.search.enabled: true
### lucene parameters
# hibernate.search.backend.type: lucene
# hibernate.search.backend.analysis.configurer: ca.uhn.fhir.jpa.search.HapiHSearchAnalysisConfigurers$HapiLuceneAnalysisConfigurer
# hibernate.search.backend.directory.type: local-filesystem
# hibernate.search.backend.directory.root: target/lucenefiles
# hibernate.search.backend.lucene_version: lucene_current
### elastic parameters ===> see also elasticsearch section below <===
# hibernate.search.backend.type: elasticsearch
# hibernate.search.backend.analysis.configurer: ca.uhn.fhir.jpa.search.HapiHSearchAnalysisConfigurers$HapiElasticAnalysisConfigurer
hapi:
fhir:
### This flag when enabled to true, will avail evaluate measure operations from CR Module.
### Flag is false by default, can be passed as command line argument to override.
cr:
enabled: false
cdshooks:
enabled: true
clientIdHeaderName: client_id
### This enables the swagger-ui at /fhir/swagger-ui/index.html as well as the /fhir/api-docs (see https://hapifhir.io/hapi-fhir/docs/server_plain/openapi.html)
openapi_enabled: true
### This is the FHIR version. Choose between, DSTU2, DSTU3, R4 or R5
fhir_version: R4
### Flag is false by default. This flag enables runtime installation of IG's.
ig_runtime_upload_enabled: false
### This flag when enabled to true, will avail evaluate measure operations from CR Module.
### enable to use the ApacheProxyAddressStrategy which uses X-Forwarded-* headers
### to determine the FHIR server address
# use_apache_address_strategy: false
### forces the use of the https:// protocol for the returned server address.
### alternatively, it may be set using the X-Forwarded-Proto header.
# use_apache_address_strategy_https: false
### enables the server to overwrite defaults on HTML, css, etc. under the url pattern of eg. /content/custom **
### Folder with custom content MUST be named custom. If omitted then default content applies
#custom_content_path: ./custom
### enables the server host custom content. If e.g. the value ./configs/app is supplied then the content
### will be served under /web/app
#app_content_path: ./configs/app
### enable to set the Server URL
# server_address: http://hapi.fhir.org/baseR4
# defer_indexing_for_codesystems_of_size: 101
# install_transitive_ig_dependencies: true
#implementationguides:
### example from registry (packages.fhir.org)
# swiss:
# name: swiss.mednet.fhir
# version: 0.8.0
# reloadExisting: false
# installMode: STORE_AND_INSTALL
# example not from registry
# ips_1_0_0:
# packageUrl: https://build.fhir.org/ig/HL7/fhir-ips/package.tgz
# name: hl7.fhir.uv.ips
# version: 1.0.0
# supported_resource_types:
# - Patient
# - Observation
##################################################
# Allowed Bundle Types for persistence (defaults are: COLLECTION,DOCUMENT,MESSAGE)
##################################################
# allowed_bundle_types: COLLECTION,DOCUMENT,MESSAGE,TRANSACTION,TRANSACTIONRESPONSE,BATCH,BATCHRESPONSE,HISTORY,SEARCHSET
# allow_cascading_deletes: true
# allow_contains_searches: true
# allow_external_references: true
# allow_multiple_delete: true
# allow_override_default_search_params: true
# auto_create_placeholder_reference_targets: false
### tells the server to automatically append the current version of the target resource to references at these paths
# auto_version_reference_at_paths: Device.patient, Device.location, Device.parent, DeviceMetric.parent, DeviceMetric.source, Observation.device, Observation.subject
# ips_enabled: false
# default_encoding: JSON
# default_pretty_print: true
# default_page_size: 20
# delete_expunge_enabled: true
# enable_repository_validating_interceptor: true
# enable_index_missing_fields: false
# enable_index_of_type: true
# enable_index_contained_resource: false
# resource_dbhistory_enabled: false
### !!Extended Lucene/Elasticsearch Indexing is still a experimental feature, expect some features (e.g. _total=accurate) to not work as expected!!
### more information here: https://hapifhir.io/hapi-fhir/docs/server_jpa/elastic.html
advanced_lucene_indexing: false
bulk_export_enabled: false
bulk_import_enabled: false
# language_search_parameter_enabled: true
# enforce_referential_integrity_on_delete: false
# This is an experimental feature, and does not fully support _total and other FHIR features.
# enforce_referential_integrity_on_delete: false
# enforce_referential_integrity_on_write: false
# etag_support_enabled: true
# expunge_enabled: true
# client_id_strategy: ALPHANUMERIC
# server_id_strategy: SEQUENTIAL_NUMERIC
# fhirpath_interceptor_enabled: false
# filter_search_enabled: true
# graphql_enabled: true
narrative_enabled: false
mdm_enabled: false
mdm_rules_json_location: "mdm-rules.json"
# local_base_urls:
# - https://hapi.fhir.org/baseR4
logical_urls:
- http://terminology.hl7.org/*
- https://terminology.hl7.org/*
- http://snomed.info/*
- https://snomed.info/*
- http://unitsofmeasure.org/*
- https://unitsofmeasure.org/*
- http://loinc.org/*
- https://loinc.org/*
# partitioning:
# allow_references_across_partitions: false
# partitioning_include_in_search_hashes: false
cors:
allow_Credentials: true
# These are allowed_origin patterns, see: https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/web/cors/CorsConfiguration.html#setAllowedOriginPatterns-java.util.List-
allowed_origin:
- '*'
# Search coordinator thread pool sizes
search-coord-core-pool-size: 20
search-coord-max-pool-size: 100
search-coord-queue-capacity: 200
# comma-separated package names, will be @ComponentScan'ed by Spring to allow for creating custom Spring beans
#custom-bean-packages:
# comma-separated list of fully qualified interceptor classes.
# classes listed here will be fetched from the Spring context when combined with 'custom-bean-packages',
# or will be instantiated via reflection using an no-arg contructor; then registered with the server
#custom-interceptor-classes:
# comma-separated list of fully qualified provider classes.
# classes listed here will be fetched from the Spring context when combined with 'custom-bean-packages',
# or will be instantiated via reflection using an no-arg contructor; then registered with the server
#custom-provider-classes:
# Threadpool size for BATCH'ed GETs in a bundle.
# bundle_batch_pool_size: 10
# bundle_batch_pool_max_size: 50
# logger:
# error_format: 'ERROR - ${requestVerb} ${requestUrl}'
# format: >-
# Path[${servletPath}] Source[${requestHeader.x-forwarded-for}]
# Operation[${operationType} ${operationName} ${idOrResourceName}]
# UA[${requestHeader.user-agent}] Params[${requestParameters}]
# ResponseEncoding[${responseEncodingNoDefault}]
# log_exceptions: true
# name: fhirtest.access
# max_binary_size: 104857600
# max_page_size: 200
# retain_cached_searches_mins: 60
# reuse_cached_search_results_millis: 60000
tester:
home:
name: Local Tester
server_address: 'http://localhost:8080/fhir'
refuse_to_fetch_third_party_urls: false
fhir_version: R4
global:
name: Global Tester
server_address: "http://hapi.fhir.org/baseR4"
refuse_to_fetch_third_party_urls: false
fhir_version: R4
# validation:
# requests_enabled: true
# responses_enabled: true
# binary_storage_enabled: true
inline_resource_storage_below_size: 4000
# bulk_export_enabled: true
# subscription:
# resthook_enabled: true
# websocket_enabled: false
# email:
# from: so...@test.com
# host: google.com
# port:
# username:
# password:
# auth:
# startTlsEnable:
# startTlsRequired:
# quitWait:
# lastn_enabled: true
# store_resource_in_lucene_index_enabled: true
### This is configuration for normalized quantity search level default is 0
### 0: NORMALIZED_QUANTITY_SEARCH_NOT_SUPPORTED - default
### 1: NORMALIZED_QUANTITY_STORAGE_SUPPORTED
### 2: NORMALIZED_QUANTITY_SEARCH_SUPPORTED
# normalized_quantity_search_level: 2
#elasticsearch:
# debug:
# pretty_print_json_log: false
# refresh_after_write: false
# enabled: false
# password: SomePassword
# required_index_status: YELLOW
# rest_url: 'localhost:9200'
# protocol: 'http'
# schema_management_strategy: CREATE
# username: SomeUsernameBut when I start with docker compose up, the tables were created in PostgreSQL, but I'm getting these errors in the log then
http://localhost:8090/ works, but REST API does not:
2024-06-12 15:50:57 hapi-fhir |
2024-06-12 15:50:57 hapi-fhir | . ____ _ __ _ _
2024-06-12 15:50:57 hapi-fhir | /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
2024-06-12 15:50:57 hapi-fhir | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
2024-06-12 15:50:57 hapi-fhir | \\/ ___)| |_)| | | | | || (_| | ) ) ) )
2024-06-12 15:50:57 hapi-fhir | ' |____| .__|_| |_|_| |_\__, | / / / /
2024-06-12 15:50:57 hapi-fhir | =========|_|==============|___/=/_/_/_/
2024-06-12 15:50:57 hapi-fhir | 2024-06-12 18:50:57.312 [background-preinit] INFO o.h.validator.internal.util.Version [Version.java:21] HV000001: Hibernate Validator 8.0.0.Final
2024-06-12 15:50:57 hapi-fhir | :: Spring Boot :: (v3.2.0)
2024-06-12 15:50:57 hapi-fhir |
2024-06-12 15:50:57 hapi-fhir | 2024-06-12 18:50:57.370 [main] INFO ca.uhn.fhir.jpa.starter.Application [StartupInfoLogger.java:50] Starting Application using Java 17.0.11 with PID 1 (/app/main.war started by nonroot in /app)
2024-06-12 15:50:57 hapi-fhir | 2024-06-12 18:50:57.371 [main] INFO ca.uhn.fhir.jpa.starter.Application [SpringApplication.java:653] No active profile set, falling back to 1 default profile: "default"
2024-06-12 15:50:58 hapi-fhir | 2024-06-12 18:50:58.036 [main] INFO o.s.d.r.c.RepositoryConfigurationDelegate [RepositoryConfigurationDelegate.java:139] Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-06-12 15:50:58 hapi-fhir | 2024-06-12 18:50:58.160 [main] INFO o.s.d.r.c.RepositoryConfigurationDelegate [RepositoryConfigurationDelegate.java:208] Finished Spring Data repository scanning in 119 ms. Found 52 JPA repository interfaces.
2024-06-12 15:50:58 hapi-fhir | 2024-06-12 18:50:58.966 [main] WARN o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker [PostProcessorRegistrationDelegate.java:429] Bean 'ca.uhn.fhir.jpa.config.BeanPostProcessorConfig' of type [ca.uhn.fhir.jpa.config.BeanPostProcessorConfig$$SpringCGLIB$$0] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying). The currently created BeanPostProcessor [persistenceExceptionTranslationPostProcessor] is declared through a non-static factory method on that class; consider declaring it as static instead.
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.212 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer [TomcatWebServer.java:108] Tomcat initialized with port 8080 (http)
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.219 [main] INFO o.a.coyote.http11.Http11NioProtocol [DirectJDKLog.java:173] Initializing ProtocolHandler ["http-nio-8080"]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.220 [main] INFO o.a.catalina.core.StandardService [DirectJDKLog.java:173] Starting service [Tomcat]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.220 [main] INFO o.a.catalina.core.StandardEngine [DirectJDKLog.java:173] Starting Servlet engine: [Apache Tomcat/10.1.16]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.283 [main] INFO o.a.c.c.C.[Tomcat].[localhost].[/] [DirectJDKLog.java:173] Initializing Spring embedded WebApplicationContext
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.284 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext [ServletWebServerApplicationContext.java:296] Root WebApplicationContext: initialization completed in 1877 ms
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.331 [main] INFO ca.uhn.fhir.util.VersionUtil [VersionUtil.java:84] HAPI FHIR version 7.2.0 - Rev 018a38bd45
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.333 [main] INFO ca.uhn.fhir.context.FhirContext [FhirContext.java:226] Creating new FHIR context for FHIR version [R4]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.346 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:39] Server configured to allow contains searches
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:41] Server configured to deny multiple deletes
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:43] Server configured to deny external references
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:45] Server configured to enable DAO scheduling
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:47] Server configured to disable delete expunges
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:49] Server configured to enable expunges
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:51] Server configured to allow overriding default search params
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:54] Server configured to disable auto-creating placeholder references
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:57] Server configured to auto-version references at paths []
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.370 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:122] Server configured to have a maximum fetch size of 'unlimited'
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.370 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:127] Server configured to cache search results for 60000 milliseconds
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.370 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:178] Server configured to use 'ALPHANUMERIC' Client ID Strategy
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.432 [main] INFO o.h.jpa.internal.util.LogHelper [LogHelper.java:31] HHH000204: Processing PersistenceUnitInfo [name: HAPI_PU]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.473 [main] INFO org.hibernate.Version [Version.java:44] HHH000412: Hibernate ORM core version 6.4.1.Final
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.607 [main] INFO c.u.f.j.l.FilteringSqlLoggerImplContributor [FilteringSqlLoggerImplContributor.java:33] Adding service: SqlStatementFilteringLogger
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.620 [main] INFO o.h.c.i.RegionFactoryInitiator [RegionFactoryInitiator.java:50] HHH000026: Second-level cache disabled
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.663 [main] INFO o.h.e.b.internal.EnversServiceImpl [EnversServiceImpl.java:76] Envers integration enabled? : true
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.836 [main] INFO o.s.o.j.p.SpringPersistenceUnitInfo [SpringPersistenceUnitInfo.java:87] No LoadTimeWeaver setup: ignoring JPA class transformer
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.852 [main] INFO com.zaxxer.hikari.HikariDataSource [HikariDataSource.java:110] HikariPool-1 - Starting...
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.991 [main] INFO com.zaxxer.hikari.pool.HikariPool [HikariPool.java:565] HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@65bb6275
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.994 [main] INFO com.zaxxer.hikari.HikariDataSource [HikariDataSource.java:123] HikariPool-1 - Start completed.
2024-06-12 15:51:03 hapi-fhir | 2024-06-12 18:51:03.010 [main] WARN o.h.e.j.e.i.JdbcEnvironmentInitiator [JdbcEnvironmentInitiator.java:345] HHH000342: Could not obtain connection to query metadata
2024-06-12 15:51:03 hapi-fhir | org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named strategy class [ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect]
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:244)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:189)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.constructDialect(DialectFactoryImpl.java:123)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:88)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:328)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:277)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:58)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:70)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata(JdbcEnvironmentInitiator.java:276)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:107)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:129)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:238)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.model.relational.Database.<init>(Database.java:45)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:223)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:191)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:170)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1432)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1503)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:142)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:390)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:366)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1833)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:225)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1323)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1284)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1252)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findDefaultEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:593)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:557)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.resolveEntityManager(PersistenceAnnotationBeanPostProcessor.java:724)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.getResourceToInject(PersistenceAnnotationBeanPostProcessor.java:697)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:270)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:145)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessProperties(PersistenceAnnotationBeanPostProcessor.java:385)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1419)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1335)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1165)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1335)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1165)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:205)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:210)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:201)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addServletContextInitializerBeans(ServletContextInitializerBeans.java:96)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:85)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:266)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:240)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:52)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4850)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2024-06-12 15:51:03 hapi-fhir | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:845)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2024-06-12 15:51:03 hapi-fhir | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:240)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardService.startInternal(StandardService.java:433)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:917)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.startup.Tomcat.start(Tomcat.java:488)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:123)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:104)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:501)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:218)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:188)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:162)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:618)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:753)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:455)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.run(SpringApplication.java:323)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1342)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1331)
2024-06-12 15:51:03 hapi-fhir | at ca.uhn.fhir.jpa.starter.Application.main(Application.java:46)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.reflect.Method.invoke(Method.java:568)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.Launcher.launch(Launcher.java:95)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:466)
2024-06-12 15:51:03 hapi-fhir | Caused by: org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named dialect class [ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect]
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:143)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:240)
2024-06-12 15:51:03 hapi-fhir | ... 131 common frames omitted
2024-06-12 15:51:03 hapi-fhir | Caused by: java.lang.reflect.InvocationTargetException: null
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:131)
2024-06-12 15:51:03 hapi-fhir | ... 132 common frames omitted
2024-06-12 15:51:03 hapi-fhir | Caused by: java.lang.NumberFormatException: For input string: "(Debian"
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.Integer.parseInt(Integer.java:654)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.Integer.parseInt(Integer.java:786)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.dialect.H2Dialect.parseBuildId(H2Dialect.java:160)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.dialect.H2Dialect.parseVersion(H2Dialect.java:150)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.dialect.H2Dialect.<init>(H2Dialect.java:124)
2024-06-12 15:51:03 hapi-fhir | at ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect.<init>(HapiFhirH2Dialect.java:36)
2024-06-12 15:51:03 hapi-fhir | ... 138 common frames omitted
2024-06-12 15:51:03 hapi-fhir | 2024-06-12 18:51:03.384 [main] INFO o.h.s.m.o.b.i.HibernateSearchPreIntegrationService [HibernateSearchPreIntegrationService.java:101] HSEARCH000034: Hibernate Search version 7.0.0.Final
2024-06-12 15:51:03 hapi-fhir | 2024-06-12 18:51:03.470 [main] INFO o.h.e.c.i.m.AuditMetadataGenerator [AuditMetadataGenerator.java:322] Adding properties for entity: ca.uhn.fhir.jpa.entity.MdmLink
2024-06-12 15:51:04 hapi-fhir | 2024-06-12 18:51:04.258 [main] INFO o.h.e.t.j.p.i.JtaPlatformInitiator [JtaPlatformInitiator.java:58] HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2024-06-12 15:51:04 hapi-fhir | 2024-06-12 18:51:04.310 [main] WARN o.h.t.s.i.ExceptionHandlerLoggedImpl [ExceptionHandlerLoggedImpl.java:27] GenerationTarget encountered exception accepting command : Error executing DDL "create table bt2_job_instance (id varchar(100) not null, job_cancelled boolean not null, cmb_recs_processed integer, cmb_recs_per_sec float(53), create_time timestamp(6) not null, cur_gated_step_id varchar(100), definition_id varchar(100) not null, definition_ver integer not null, end_time timestamp(6), error_count integer, error_msg varchar(500), est_remaining varchar(100), fast_tracking boolean, params_json varchar(2000), params_json_lob clob, params_json_vc clob, progress_pct float(53), report clob, report_vc clob, start_time timestamp(6), stat varchar(20) not null, tot_elapsed_millis integer, client_id varchar(200), user_name varchar(200), update_time timestamp(6), warning_msg varchar(4000), work_chunks_purged boolean not null, primary key (id))" via JDBC [ERROR: type "clob" does not exist
2024-06-12 15:51:04 hapi-fhir | Position: 445]
2024-06-12 15:51:04 hapi-fhir | org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table bt2_job_instance (id varchar(100) not null, job_cancelled boolean not null, cmb_recs_processed integer, cmb_recs_per_sec float(53), create_time timestamp(6) not null, cur_gated_step_id varchar(100), definition_id varchar(100) not null, definition_ver integer not null, end_time timestamp(6), error_count integer, error_msg varchar(500), est_remaining varchar(100), fast_tracking boolean, params_json varchar(2000), params_json_lob clob, params_json_vc clob, progress_pct float(53), report clob, report_vc clob, start_time timestamp(6), stat varchar(20) not null, tot_elapsed_millis integer, client_id varchar(200), user_name varchar(200), update_time timestamp(6), warning_msg varchar(4000), work_chunks_purged boolean not null, primary key (id))" via JDBC [ERROR: type "clob" does not exist
2024-06-12 15:51:04 hapi-fhir | Position: 445]
.... and more....Please, can anyone help me to understand what I am doing wrong?
Thanks!