Creating tables using jdbc

[Stephen Booth]

I have some code I'm porting to H2 that creates tables programmatically using a PreparedStatement with executeUpdate  the original code uses statement parameters for field default values.

However in H2, though no exception is raised these default values are ignored and the INFORMATION_SCHEMA shows default values of ?1 ?2 ?3 etc. for the created table

I can work round the problem but I would have expected either a syntax error or the parameters to be expanded.