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.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/0576085e-3701-4dda-b49d-34985e437da7%40googlegroups.com.
