oracle 写入字节数组,如何在Oracle的SQLData.writeSQL（）中将java.sql.Array写入java.sql.SQLOutput...

小编典典

这是解决此问题的方法。它不漂亮，但是可以用。

我在实现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);

希望能帮助到你。

2020-11-23