Cannot find class: NUMERIC

mybatis启动报错：

org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'cn/xdf/yn/api/mapper/ExamQuestionMapper.xml'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'NUMERIC'.  Cause: java.lang.ClassNotFoundException: Cannot find class: NUMERIC

 

 

	<select id="sumSorceByTestIdAndSubjectIdAndAttrIdB" resultType="NUMERIC">
		select sum(a.score) from exam_question a,exam_test_detail b,que_attr_busi c 
		where a.pap_Id =b.pap_Id and a.que_Id=c.busi_Id and a.subject_Id=#{subjectId} and 
		b.parent_Test_Id=#{testId} and c.attr_Id=#{attrId}
	</select>

resultType改为

resultType="java.math.BigDecimal"

 

SQL数据类型和Java数据类型的对应关系

integer、int ---> int

tinyint、smallint ---> short

bigint ---> long

decimal、numeric ---> java.math.BigDecimal

float ---> float

double ---> double

char、varchar ---> String

boolean、bit ---> boolean

date ---> java.sql.Date

time ---> java.sql.Time

timestamp ---> java.sql.Timestamp

blob ---> java.sql.Blob

clob ---> java.sql.Clob

array ---> java.sql.Array