Can't get querydsl-spatial to work

[Menighin]

Important Notice

Thank you for opening an issue! Please note that, as outlined in the README, I currently only work on feature requests or bug fixes when sponsored. Balancing this project with professional and personal priorities means I have a very limited amount of effort I can divert to this project.

You must put in the work to address this issue, or it won't be addressed.

• I am willing to put in the work and submit a PR to resolve this issue.

Describe the bug
Im trying to setup QueryDSL with PostGis. I have the following dependencies added:

val queryDslVersion = "7.0"

dependencies {
	// QueryDSL
	implementation("io.github.openfeign.querydsl:querydsl-jpa-spring:$queryDslVersion")
	ksp("io.github.openfeign.querydsl:querydsl-ksp-codegen:${queryDslVersion}")
	implementation("io.github.openfeign.querydsl:querydsl-spatial:$queryDslVersion")
	ksp("io.github.openfeign.querydsl:querydsl-spatial:$queryDslVersion")

	// Database
	runtimeOnly("org.postgresql:postgresql")
	implementation("net.postgis:postgis-jdbc:2.5.1")
	implementation("org.liquibase:liquibase-core")
	implementation("org.hibernate.orm:hibernate-spatial:6.6.13.Final")
	implementation("org.locationtech.jts:jts-core:1.19.0")
}

I have my User.kt entity defined:

@Entity
@Table(name = "users")
class User (

    // ...
    @Column(columnDefinition = "geography(Point, 4326)")
    var location: Point? = null,
    // ...
}

On trying to run the project I get

[ksp] java.lang.IllegalStateException: Error processing com.testquerydsl.app.entity.User.location: Type was not recognised, This may be an entity that has not been annotated with @Entity, or maybe you are using javax instead of jakarta.

Tried a few stuff I saw in the web like annotating the entity colum with @PropertyType but that didnt work. Also apparently there's not much people on this scenario 😅

Im not sure if this is indeed an issue or just me misusing/missing something (wouldn't be the first time). If it is indeed an issue Im up to dig a little bit and try to solve it with a PR.

To Reproduce
Follow the above description

Expected behavior
QueryDSL to generate the class correctly

Desktop (please complete the following information):

• OS: MacOS

[IceBlizz6]

Hey
Thank you for submitting this.

What is the "Point" type from location field?

I'm curious on whether this is a problem with my KSP module, if you have some time please try to see if you can make this work in kapt or just plain java.
I could probably fix this without too much trouble if i get a working example in kapt or java.

I will try to find some time this week to dive into it, but if you could provide some further context then that would be great.

[Menighin]

Hey @IceBlizz6 thanks for answering!
Yes! Right after I posted I was like: "What if its a KSP issue? 🤔 "
And indeed apparently is!

The point type im using is org.locationtech.jts.geom.Point.
I just changed the project to use kapt and it compiled!

Plus: While using KSP, even annotating the column with @QueryTransient didn't do it, I still got the same error.

Do you think you can have a look on that? Thanks a lot!!

[Menighin]

Let me know if you need a reproduceable project for this and I can find some time to make it by tomorrow possibly!

[IceBlizz6]

I'll try to take a look at it later this week, hoping the details from your first post may be enough to reproduce it.

[IceBlizz6]

I'm working on this now.

Just wanted to confirm with you whether the User.location property here is valid without annotating it with org.hibernate.annotations.Type, org.hibernate.annotations.JdbcTypeCode or jakarta.persistence.Convert?
(does this actually work in hibernate?)

It seems like one of these are normally required when using custom types.

Currently i think even if these annotations are used then it would apply SimplePath instead of ComparablePath, i'm sitting on a fix for that now.

[Menighin]

Hey!
I have only the @Column(columnDefinition = "geography(Point, 4326)") and it seems to be working fine (I have updated this column on my entity just fine) 👍

[github-actions]

This issue has been automatically marked as stale due to inactivity. If no further action is taken, it will be closed in 7 days.

[github-actions]

This issue has been automatically closed due to prolonged inactivity.