TEXT column: Argument data type text is invalid for argument 1 of lower function

Ukončen Zveřejněno před 3 lety K zaplacení v momentě doručení
Ukončen K zaplacení v momentě doručení

I currently have a repo method which is acting as a filter with pagination:

Repo:

@Query("SELECT e FROM DeTest e " +

"WHERE [login to view URL] = '9999-12-31 00:00:00.000' " +

"AND (:name is null OR LOWER ([login to view URL]) LIKE LOWER ('%' + :name+ '%')) " +

"AND (:description is null OR LOWER ([login to view URL]) LIKE LOWER ('%' + :description + '%')) " +

"AND (:theProblem is null OR LOWER ([login to view URL] ) LIKE LOWER ('%' + :theProblem + '%')) "

)

So as shown here, I have it so when you enter a value it will change it ensuring that both uppercase values and lowercase values are displayed. However, when adding LOWER to the 'theProblem' column, it produces the error in the title:

Argument data type text is invalid for argument 1 of lower function

My datatype for that particular column is text, and therefore, I think the culprit of the issue. However, due to the db layout I need it to be a text. Therefore, is there anyway I could convert/cast it in the repo method for when it's called?

Column:

@Column(name = "the_problem", columnDefinition = "TEXT") // text rather than varchar

private String theProblem;

Thank you.

Java Vývoj softwaru Programování Kódování

Identifikační číslo projektu: #27546201

O projektu

2 nabídek Projekt na dálku Aktivní před 3 lety

2 Freelnceři na tento projekt zveřejňují nabídky v průměru £15

theatasolution1

Hello, I'm an expert Java developer with experience in object-oriented, data structure, swing, JavaFX and more advanced. I can help you to finish this project with great quality. We can negotiate on price/Budget Regard Další

£15 GBP za 1 den
(5 Recenzí)
2.4