public interface OraBackupInfoMapper
{
List queryRacList();
}
二、开发*mapper.xml
三、执行测试类SELECT DISTINCT rac_name FROM `ora_backup_info`
@Test
public void testApi(){
List racList = oraBackupInfoMapper.queryRacList();
System.out.println(racList);
}
运行结果报错:
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.UnsupportedOperationException ### The error may exist in file [D:workspace_ruoyi_codebranchhipaaspaastargetclassesmapperoracleOraBackupInfoMapper.xml] ### The error may involve com.hidata.devops.selfops.mapper.OraBackupInfoMapper.queryRacList ### The error occurred while handling results ### SQL: SELECT DISTINCT rac_name FROM `ora_backup_info` ### Cause: java.lang.UnsupportedOperationException四、解决办法
将resultType=“java.util.List” 修改为 resultType=“String”
SELECT DISTINCT rac_name FROM `ora_backup_info`



