JdbcSQLNonTransientException: Unknown data type

[Jason Pickens]

I have the following query:

connection.prepareStatement("SELECT * FROM (SELECT ?)")

This throws a "JdbcSQLNonTransientException: Unknown data type" exception as it needs to know the types of the temporary table.

This works:

"SELECT ?"

The parameter doesn't have a type in this case either.

Why does the prepared statement need to know the type of the temporary table? The lack of type information in the simple case doesn't appear to be a problem.

Is there any workaround? This is a total blocker to me using h2.

[Evgenij Ryazanov]

Hello.

H2 compiles your query immediately, so it needs to know the data types of some arguments.

The usual workaround is to wrap the parameter into CAST function. This function doesn't need to know the type of its argument.

SELECT * FROM (SELECT CAST(? AS INT))

Of course, you need to know the data types of such parameters.