代码如下：
sql.xml中的语句：
<!-- 保存被保人临时信息 参数映射 -->
<parameterMap id="callProcedureSaveTempMap" class="java.util.Map">
<parameter property="prtNo" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" />
<parameter property="user" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" />
<parameter property="sourceModule" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" />
<parameter property="masterContNo" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" />
<parameter property="mode" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" />
<parameter property="insuredTempList" javaType="java.util.List" jdbcType="ARRAY" mode="IN" typeName="TYPE_IM_INSURED_TEMP_ARRAY" typeHandler="com.sunshine.cis.common.typehandler.InsuredTempArrayHandler" />
<parameter property="dutyTempList" javaType="java.util.List" jdbcType="ARRAY" mode="IN" typeName="TYPE_IM_DUTY_TEMP_ARRAY" typeHandler="com.sunshine.cis.common.typehandler.DutyTempArrayHandler" />
<parameter property="bnfTempList" javaType="java.util.List" jdbcType="ARRAY" mode="IN" typeName="TYPE_IM_BNF_TEMP_ARRAY" typeHandler="com.sunshine.cis.common.typehandler.BnfTempArrayHandler" />
<parameter property="batchNo" javaType="java.lang.Integer" jdbcType="INTEGER" mode="OUT" />
<parameter property="resultCode" javaType="java.lang.String" jdbcType="VARCHAR" mode="OUT" />
<parameter property="message" javaType="java.lang.String" jdbcType="CLOB" mode="OUT" />
</parameterMap>
<!-- 保存被保人临时信息 -->
<procedure id="callProcedureSaveTemp" parameterMap="callProcedureSaveTempMap">
{call pkg_cis_insured_manage.p_save_insured(?,?,?,?,?,?,?,?,?,?,?)}
</procedure>
java代码数据类型转换：
public void setParameter(PreparedStatement ps, int i, Object parameter, String jdbcType) throws SQLException {
// 获取原始连接
System.out.println("开始获取数据库连接池原始链接==============");
Connection conn = ConnectionUtil.getNativeConnection(ps.getConnection());
System.out.println("获取数据库连接池原始链接==============："+conn);
@SuppressWarnings("unchecked")
List<InsuredTempVO> insuredTempList = (List<InsuredTempVO>) parameter;
System.out.println("开始转换被保人数组，讲list转换为oracle数组=======");
ARRAY insuredTempArray = getInsuredTempArray(conn, insuredTempList);
System.out.println("转换被保人数组，讲list转换为oracle数组=======："+insuredTempArray.length());
ps.setArray(i, insuredTempArray);
}
private ARRAY getInsuredTempArray(Connection con, List<InsuredTempVO> insuredTempList) throws SQLException {
ARRAY insuredTempArray = null;
System.out.println("================1=============："+insuredTempList.size());
if (insuredTempList != null && insuredTempList.size() > 0) {
System.out.println("==================2===============");
StructDescriptor structdesc = new StructDescriptor(TYPE_IM_INSURED_TEMP, con);
System.out.println("==================3===============");
STRUCT[] structs = new STRUCT[insuredTempList.size()];
System.out.println("==================4===============");
ArrayDescriptor desc = ArrayDescriptor.createDescriptor(TYPE_IM_INSURED_TEMP_ARRAY, con);
System.out.println("==================5===============");
Object[] result = new Object[4];
InsuredTempVO insuredTempVO = null;
for (int i = 0; i < insuredTempList.size(); i++) {
insuredTempVO = insuredTempList.get(i);
result[0] = insuredTempVO.getSerialNo();
result[1] = insuredTempVO.getPrtNo();
result[2] = insuredTempVO.getBatchNo();
result[3] = insuredTempVO.getProposalContNo();
STRUCT item = new STRUCT(structdesc, con, result);
structs[i] = item;
}
insuredTempArray = new ARRAY(desc, con, structs);
} else {
ArrayDescriptor desc = ArrayDescriptor.createDescriptor(TYPE_IM_INSURED_TEMP_ARRAY, con);
STRUCT[] structs = new STRUCT[0];
insuredTempArray = new ARRAY(desc, con, structs);
}
System.out.println("==================6===============："+insuredTempArray.length());
return insuredTempArray;
}
在把项目发布到jboss7上后，老是在这里就报错了：
StructDescriptor structdesc = new StructDescriptor(TYPE_IM_INSURED_TEMP, con);
错误信息：
13:53:29,879 INFO [com.sunshine.cis.insuredmanagement.service.impl.InsuredManageServiceImpl] (http--0.0.0.0-8888-5) [1484632407160] user=cis 1002201612301218调用存储过程保存被保人临时信息。
13:53:29,989 INFO [stdout] (http--0.0.0.0-8888-5) 开始获取数据库连接池原始链接============== 13:53:30,090 INFO [stdout] (http--0.0.0.0-8888-5) 获取数据库连接池原始链接==============：oracle.jdbc.driver.T4CConnection@1981115 13:53:30,173 INFO [stdout] (http--0.0.0.0-8888-5) 开始转换被保人数组，讲list转换为oracle数组======= 13:53:30,233 INFO [stdout] (http--0.0.0.0-8888-5) ================1=============：5 13:53:30,282 INFO [stdout] (http--0.0.0.0-8888-5) ==================2=============== 13:53:30,395 INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader] (http--0.0.0.0-8888-5) Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
13:53:30,552 INFO [org.springframework.jdbc.support.SQLErrorCodesFactory] (http--0.0.0.0-8888-5) SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
13:53:30,666 ERROR [com.sunshine.cis.insuredmanagement.service.impl.InsuredManageServiceImpl] (http--0.0.0.0-8888-5) [1484632407160] user=cis 1002201612301218保存被保人信息异常！org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in /com/sunshine/cis/insuredmanagement/xml/sql/sql-map-insuredmanagement.xml.
--- The error occurred while applying a parameter map.
--- Check the insuredmanagement.callProcedureSaveTempMap.
--- Check the parameter mapping for the 'insuredTempList' property.
--- Cause: java.lang.ClassCastException: oracle.jdbc.driver.T4CConnection cannot be cast to oracle.jdbc.OracleConnection; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in /com/sunshine/cis/insuredmanagement/xml/sql/sql-map-insuredmanagement.xml.
--- The error occurred while applying a parameter map.
--- Check the insuredmanagement.callProcedureSaveTempMap.
--- Check the parameter mapping for the 'insuredTempList' property.
--- Cause: java.lang.ClassCastException: oracle.jdbc.driver.T4CConnection cannot be cast to oracle.jdbc.OracleConnection
13:53:31,341 INFO [com.sunshine.cis.insuredmanagement.service.impl.InsuredManageServiceImpl] (http--0.0.0.0-8888-5) [1484632407160]execute SERVICE complatelly, quit [com.sunshine.cis.insuredmanagement.service.impl.InsuredManageServiceImpl.uploadFileTx]
13:53:31,478 ERROR [com.sunshine.cis.insuredmanagement.web.InsuredManageAction] (http--0.0.0.0-8888-5) [1484632407160] user=cis 文件上传异常，1002201612301218保存被保人信息异常！org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in /com/sunshine/cis/insuredmanagement/xml/sql/sql-map-insuredmanagement.xml.
--- The error occurred while applying a parameter map.
--- Check the insuredmanagement.callProcedureSaveTempMap.
--- Check the parameter mapping for the 'insuredTempList' property.
--- Cause: java.lang.ClassCastException: oracle.jdbc.driver.T4CConnection cannot be cast to oracle.jdbc.OracleConnection; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in /com/sunshine/cis/insuredmanagement/xml/sql/sql-map-insuredmanagement.xml.
--- The error occurred while applying a parameter map.
--- Check the insuredmanagement.callProcedureSaveTempMap.
--- Check the parameter mapping for the 'insuredTempList' property.
--- Cause: java.lang.ClassCastException: oracle.jdbc.driver.T4CConnection cannot be cast to oracle.jdbc.OracleConnection
最近在网上也找了不少资料，Oracle.sql 下的StructDescriptor 、 ArrayDescriptor 这两个类已被弃用，但是在jboss4和tomcat上还能正常使用，搞不懂为什么，用java.sql 下的Struct 代替掉上面被弃用的类，在jboss4和tomcat上也能正常使用，但是一发布到jboss7就不行了。
