Message Title

Any updates here? This stops me from using Oracle db, because my @Filter:

 
                                                                @FilterDef(name = AbstractActivatableEntityDefinition.ACTIVATABLE_FILTER)
@Filter(name = AbstractActivatableEntityDefinition.ACTIVATABLE_FILTER, condition = "(({alias}.active = TRUE) OR (CURRENT_TIMESTAMP BETWEEN {alias}.active_from AND {alias}.active_to))", deduceAliasInjectionPoints = false)

breaks under Oracle with:

 
                                                                Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)

Is there any way to make the filter database agnostic?

Add Comment

This message was sent by Atlassian JIRA