no dialect mapping for jdbc type 9 – hibernate and ms sql server

Dec 16

no dialect mapping for jdbc type 9

the issue: receiving the following error using hibernate and jdbc against an ms sql server database

ms sql server & hibernate: No Dialect mapping for JDBC type: -9

the solution: 2 possible “fixes” for this…

try changing your driver to jTDS
using the ms sql server jdbc driver provided by microsoft can cause this issue while jTDS does not give this complaint.
you may need to explicitly “addScalar” to your hibernate query.
you might have something like this:
```
sess.createSQLQuery("SELECT * FROM CATS")
```
try changing to:
```
sess.createSQLQuery("SELECT * FROM CATS")
 .addScalar("ID", Hibernate.LONG)
 .addScalar("NAME", Hibernate.STRING)
 .addScalar("BIRTHDATE", Hibernate.DATE)
```
related documented issue: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28333

ms sql server equivalent of oracle’s NVL function