java - select 子句中参数的未知数据类型错误

Question

我想使用以下代码查询我的数据库(H2):

PreparedStatement x = connection.prepareStatement("INSERT INTO tree(ancestor, desc) (select ancestor,? from tree where desc = ? union all select ?,? )");
x.setInt(1,99219);
x.setInt(2,4);
x.setInt(3,99219);
x.setInt(4,99219);

但它不起作用，我收到以下错误:

org.h2.jdbc.JdbcSQLException: Unknown data type: "?, ?"; SQL statement:insert into tree(ancestor, desc) (select ancestor,? from tree where desc = ? union all select ?,? ) [50004-192]

在控制台中执行查询(没有 JDBC)工作正常。这段代码有什么问题？

Answer 1

"INSERT INTO tree(ancestor, desc) (select ancestor,? from tree where desc = ? union all select ?,? )"

此 SQL 语句不完整。此后缺少 FROM 部分:

union all select ?,?