Vacuum Micronaut JDBC

[szigya]

Hi! I would like to do a scheduled vacuum query and add it to my repository, but the @Query annotation throws an exception.
Could you please help me how can I achieve this?

@JdbcRepository
@Requires(property = "persistence.order", value = "sqlite")
public interface OrderRepository extends CrudRepository<Order, String> {

    @Query(value = "DELETE FROM orders WHERE updated_at < :date", nativeQuery = true)
    void deleteOlderThan(long date);

    @Query(value="VACUUM", nativeQuery = true)
    void vacuum();

}

The above code snippet works fine with the delete query, but not for vacuum. The error message I get is the following:

io.micronaut.data.exceptions.DataAccessException: Error executing SQL Query: Query does not return results

[szigya]

Figured out a workaround:

• convert interface to abstract class
• inject connection
• run vacuum as native query