Error when using the jdbcType NVARCHAR with H2


mwhesse@...
 

When mapping a column with java type String and using jdbcType="NVARCHAR" in the @Column annotation we receive an error that the type is not supported by our H2 datastore.

We looked at the H2Adapter and it does register NVARCHAR as a supported JDBCType, but when DN queries the store metadata and retrieves the supported JDBCTypeInfos NVARCHAR is not returned by the H2 driver and subsequently DN unregisters the type from the supported types. Yet H2 claims to support NVARCHAR.

How can we use the JDBC type NVARCHAR with H2 and DN?

Using the latest DN 5.2 version and H2 1.4.200. 

Join main@datanucleus.groups.io to automatically receive all group messages.