java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致: 应为 BINARY, 但却获得 CHAR

今天写代码遇到的，检查了一下发现实际上是把null值作为参数了

遇到此类问题，需要检查传入的参数中是否有空值(null).

查询代码如下:

@Repository
public interface OssDao extends JpaRepository<OssFileEntity, Long> {

    @Query(nativeQuery = true, value =
            " SELECT " +
                    " "uri" " +
                    " FROM " +
                    "         "oss_file" " +
                    " WHERE " +
                    " "namespace" = :namespace " +
                    " AND "prefix" LIKE COALESCE (:prefix, '%%') " +
                    " AND "name" LIKE COALESCE (:fileName, '%%') "
    )
    List<String> findUriByCondition(@Param("namespace") String namespace,
                                    @Param("prefix") String prefix,
                                    @Param("fileName") String fileName);
}

为了做Oracle和MySQL兼容, 也是绞尽乳汁了