Been seeing a lot of questions lately on StackOverflow about native SQL
queries and the "No Dialect mapping for JDBC type: XYZ" error.
Is there a reason we don't do a best effort to resolve these using the
drivers database metadata? In fact we already read and parse this
information during JdbcServices init
(org.hibernate.engine.jdbc.spi.ExtractedDatabaseMetaData#getTypeInfoSet).
We could resolve the unknown type to its
org.hibernate.engine.jdbc.internal.TypeInfo and use the TypeInfo's
reported javaType to resolve the Hibernate type to use.
WDYT?
Then the dialect really just needs to become involved in the exception
case(s). This is really another case of what I want to do eventually
where we blend information from the JDBC driver's DatabaseMetaData and
Dialect.
--
steve(a)hibernate.org
http://hibernate.org