JPA : antlr error with @ElementCollection @OrderBy

[AfshinHonari]

I have an issue when running native spring boot app on Gradle with nativeRun or bootBuildImage and then run on docker;
when the application is launching after checking JPA the following exception accrue and application is failed to launch
CharScanner; panic: ClassNotFoundException: antlr.CommonToken

pluings I used:
plugins {
id 'org.springframework.boot' version '2.6.3'
id 'io.spring.dependency-management' version '1.0.11.RELEASE'
id 'java'
id 'org.springframework.experimental.aot' version '0.11.2'
id 'org.hibernate.orm'
}

build image config:
bootBuildImage {
builder = 'paketobuildpacks/builder:tiny'
environment = ['BP_NATIVE_IMAGE': 'true']
imageName='ahs441/vimage'
}

hibernate config:
hibernate {
enhance {
enableLazyInitialization = true
enableDirtyTracking = true
enableAssociationManagement = true
enableExtendedEnhancement = false
}
}

[bclozel]

We're going to need more information to understand what's going on here. A complete stacktrace would help, but I suspect a minimal, sample application would be more helpful. Could you share a minimal repro app for this?

[AfshinHonari]

The stacktrace is empty with only CharScanner; panic: ClassNotFoundException: antlr.CommonToken exception;
The dependencies are:
implementation 'org.springframework.boot:spring-boot-starter-actuator'
implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
implementation 'org.springframework.boot:spring-boot-starter-security'
implementation 'org.springframework.boot:spring-boot-starter-validation'
implementation 'org.springframework.boot:spring-boot-starter-web'
annotationProcessor "org.springframework.boot:spring-boot-configuration-processor"
compileOnly 'org.projectlombok:lombok'
runtimeOnly 'org.postgresql:postgresql'
annotationProcessor 'org.projectlombok:lombok'
testImplementation 'org.springframework.boot:spring-boot-starter-test'
testImplementation 'org.springframework.security:spring-security-test'

implementation 'io.jsonwebtoken:jjwt-api:0.11.2'
runtimeOnly 'io.jsonwebtoken:jjwt-impl:0.11.2',
        'io.jsonwebtoken:jjwt-jackson:0.11.2' 

implementation 'org.bouncycastle:bcprov-jdk15to18:1.70'

implementation 'org.mapstruct:mapstruct:1.4.2.Final'
annotationProcessor 'org.mapstruct:mapstruct-processor:1.4.2.Final'

implementation platform('com.amazonaws:aws-java-sdk-bom:1.12.131')
implementation 'com.amazonaws:aws-java-sdk-s3'


implementation "com.github.kokorin.jaffree:jaffree:2021.12.30"
implementation 'net.jthink:jaudiotagger:3.0.1'

annotationProcessor 'com.querydsl:querydsl-apt:5.0.0:jpa'
annotationProcessor 'org.springframework.boot:spring-boot-starter-data-jpa'
implementation('com.querydsl:querydsl-jpa:5.0.0')

implementation 'org.ocpsoft.prettytime:prettytime:5.0.2.Final'

implementation 'com.github.kavenegar:kavenegar-java:v2.0.1'

implementation 'org.springdoc:springdoc-openapi-ui:1.6.5'
implementation 'org.springdoc:springdoc-openapi-webmvc-core:1.6.5'
implementation 'org.springdoc:springdoc-openapi-security:1.6.5'
implementation 'org.springdoc:springdoc-openapi-native:1.6.5'

implementation 'com.fasterxml.jackson.datatype:jackson-datatype-jsr353'
implementation 'javax.json:javax.json-api'
implementation 'org.apache.johnzon:johnzon-core'
implementation 'com.google.firebase:firebase-admin:8.1.0'
implementation 'com.googlecode.libphonenumber:libphonenumber:8.12.41'

and the error is:

OS is MacOS 12.1
Docker version 20.10.8, build 3967b7d
GraalVM : openjdk 17.0.2 2022-01-18 - GraalVM CE 22.0.0.2

[bclozel]

There is no way for us to reproduce the problem with the information you've provided.

[AfshinHonari]

Finally, I found this issue occurs when I use @orderby annotation in hibernate entity

[sdeleuze]

I can reproduce by adding @ElementCollection @OrderBy private List<String> phoneNumbers; to data-jpa sample here.

[sdeleuze]

I have been able to get past this error by adding:

@TypeHint(types = {
		antlr.CommonToken.class,
		org.hibernate.persister.collection.BasicCollectionPersister.class
})

But I get the following error which lead me to think Antlr require more reflection configuration:

Caused by: org.hibernate.MappingException: Could not get constructor for org.hibernate.persister.collection.BasicCollectionPersister
	at org.hibernate.persister.internal.PersisterFactoryImpl.createCollectionPersister(PersisterFactoryImpl.java:178) ~[na:na]
	at org.hibernate.persister.internal.PersisterFactoryImpl.createCollectionPersister(PersisterFactoryImpl.java:140) ~[na:na]
	at org.hibernate.metamodel.internal.MetamodelImpl.initialize(MetamodelImpl.java:225) ~[na:na]
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:303) ~[na:na]
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:468) ~[na:na]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259) ~[na:na]
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[na:na]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[data-jpa:5.3.15]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) ~[data-jpa:5.3.15]
	... 20 common frames omitted
Caused by: org.hibernate.HibernateException: Unable to parse order-by fragment
	at org.hibernate.sql.ordering.antlr.OrderByFragmentTranslator.translate(OrderByFragmentTranslator.java:55) ~[na:na]
	at org.hibernate.sql.Template.translateOrderBy(Template.java:724) ~[na:na]
	at org.hibernate.persister.collection.AbstractCollectionPersister.<init>(AbstractCollectionPersister.java:575) ~[data-jpa:5.4.33]
	at org.hibernate.persister.collection.BasicCollectionPersister.<init>(BasicCollectionPersister.java:59) ~[data-jpa:5.4.33]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[na:na]
	at org.hibernate.persister.internal.PersisterFactoryImpl.createCollectionPersister(PersisterFactoryImpl.java:152) ~[na:na]
	... 28 common frames omitted
Caused by: java.lang.NullPointerException: null
	at org.hibernate.sql.ordering.antlr.OrderByFragmentParser.isFunctionName(OrderByFragmentParser.java:77) ~[na:na]
	at org.hibernate.sql.ordering.antlr.GeneratedOrderByFragmentParser.expression(GeneratedOrderByFragmentParser.java:685) ~[na:na]
	at org.hibernate.sql.ordering.antlr.GeneratedOrderByFragmentParser.sortKey(GeneratedOrderByFragmentParser.java:359) ~[na:na]
	at org.hibernate.sql.ordering.antlr.GeneratedOrderByFragmentParser.sortSpecification(GeneratedOrderByFragmentParser.java:249) ~[na:na]
	at org.hibernate.sql.ordering.antlr.GeneratedOrderByFragmentParser.orderByFragment(GeneratedOrderByFragmentParser.java:193) ~[na:na]
	at org.hibernate.sql.ordering.antlr.OrderByFragmentTranslator.translate(OrderByFragmentTranslator.java:49) ~[na:na]

@christophstrobl @schauder Could you please take it from there?