这是解决此问题的方法。它不漂亮，但是可以用。
我在实现
SQLData中的类中添加了一个方法，该方法接收a
java.sql.Connection并设置相应的
java.sql.ARRAY对象。
像这样：
public class MyObject01 implements SQLData { private String value; private MyObject02[] details; // do note that details is a java array // ... also added getters and setters for these two properties private Array detailsArray; public void setupArrays(oracle.jdbc.OracleConnection oconn) throws SQLException { detailsArrays = oconn.createARRAY(MyObject02.ORACLE_OBJECT_ARRAY_NAME, getDetails()); // MyObject02.ORACLE_OBJECT_ARRAY_NAME must be the name of the oracle "table of" type name // Also note that in Oracle you can't use JDBC's default createArray // since it's not supported. That's why you need to get a OracleConnection // instance here. } @Override public void writeSQL(Stream stream) throws SQLException { stream.writeString(getValue()); stream.writeArray(detailsArray); // that's it } @Override public void readSQL(Stream stream) throws SQLException { setValue(stream.readString()); Array array = stream.readArray(); if (array != null) {setDetails((MyObject02[])array.getArray()); } }这是第一部分。
然后，在过程调用中使用该对象之前，请对该对象调用
setupArrays方法。例：
public class DB { public static String executeProc(Connection conn, MyObject01 obj) throws SQLException { CalllableStatement cs = conn.prepareCall(" { ? = call sch.proc(?) }"); cs.registerOutParameter(1, Types.VARCHAR); obj.setupArrays((oracle.jdbc.Connection)conn); cs.setObject(2, obj, Types.STRUCT); cs.executeUpdate(); String ret = cs.getString(1); cs.close(); return ret; }}当然，连接后，您需要正确注册类型：
Connection conn = DriverManager.getConnection("jdbc:oracle://localhost:1521/XE", "scott", "tiger" );conn.getTypeMap().put(MyObject01.ORACLE_OBJECT_NAME, MyObject01.class);conn.getTypeMap().put(MyObject02.ORACLE_OBJECT_NAME, MyObject02.class);conn.getTypeMap().put(MyObject02.ORACLE_OBJECT_ARRAY_NAME, MyObject02[].class);希望能帮助到你。
