com.ibatis.sqlmap.client.SqlMapException: There is no statement named getAll

应该是你的文件没有包含进来

<sqlMapConfig>
<settings cacheModelsEnabled="false" enhancementEnabled="true" lazyLoadingEnabled="true" maxRequests="32" maxSessions="10" maxTransactions="5"
useStatementNamespaces="false" />
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver" />
<property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@22.22.22.22:1521:pps" />
<property name="JDBC.Username" value="pps_core" />
<property name="JDBC.Password" value="pps_core" />
</dataSource>
</transactionManager>
<sqlMap resource="destsub.xml" />
<sqlMap resource="destsub2sub.xml" />

</sqlMapConfig>