<p>我有以下：</p> <pre class="brush:scala;toolbar:false;"> def getIds(name: String): java.sql.Array = { val ids: Array[Integer] = Array() val ps: PreparedStatement = connection.prepareStatement("SELECT id FROM table WHERE name = ?") ps.setString(1, name) val resultSet = ps.executeQuery() while(resultSet.next()) { val currentId = resultSet.getInt(1) ids : currentId } return connection.createArrayOf("INTEGER", ids.toArray) } </pre> <p>我的意圖是用這個方法的輸出放入另一個PreparedStatement中，使用<code>.setArray(1, <array>)</code></p> <p>但我得到了以下錯誤：<code>java.sql.SQLFeatureNotSupportedException</code></p> <p>我正在使用MySQL。已經嘗試了INTEGER，INT，BIGINT。但都沒有成功。 </p>

val idsStatement = connection.prepareStatement(
   "CREATE TEMPORARY TABLE to_delete_ids SELECT id FROM table WHERE name = ?")
idsStatement.setString(1, name)
idsStatement.executeUpdate()

val statementDeleteUsingIds = connection.prepareStatement(
    "DELETE to_delete_rows FROM table2 to_delete_rows INNER JOIN to_delete_ids tdi ON tdi.id = to_delete_rows.other_tables_id")
statementDeleteUsingIds.executeUpdate()