JPA SQL Server No Dialect mapping for JDBC type: -9

by

First you have to define what is your dialect class name that you want to use:
in hibernate.cfg.xml add your own class address

<property name="hibernate.dialect">com.nhl.dao.SQlServerDBDialect</property>

then create new class same below

package com.nhl.dao;
import java.sql.Types;
import org.hibernate.dialect.SQLServerDialect;
import org.hibernate.type.StandardBasicTypes;

public class SQlServerDBDialect extends SQLServerDialect {

    public SQlServerDBDialect() {
        super();
        registerHibernateType(Types.NCHAR, StandardBasicTypes.CHARACTER.getName()); 
        registerHibernateType(Types.NCHAR, 1, StandardBasicTypes.CHARACTER.getName());
        registerHibernateType(Types.NCHAR, 255, StandardBasicTypes.STRING.getName());
        registerHibernateType(Types.NVARCHAR, StandardBasicTypes.STRING.getName());
        registerHibernateType(Types.LONGNVARCHAR, StandardBasicTypes.TEXT.getName());
        registerHibernateType(Types.NCLOB, StandardBasicTypes.CLOB.getName());

    }
}

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. How to map an entity field whose name is a reserved word in JPA
  3. Getting Database connection in pure JPA setup
  4. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR
  5. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  6. What’s the difference between JPA and Hibernate? [closed]
  7. How to convert a Hibernate proxy to a real entity object
  8. What is the solution for the N+1 issue in JPA and Hibernate?
  9. JPA CascadeType.ALL does not delete orphans
  10. Wrong ordering in generated table in jpa
  11. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  12. what is @JoinColumn and how it is used in Hibernate
  13. How do I connect to a SQL Server 2008 database using JDBC?
  14. JPA eager fetch does not join
  15. In which case do you use the JPA @JoinTable annotation?
  16. How can I get the session object if I have the entity-manager?
  17. Make Hibernate ignore instance variables that are not mapped [duplicate]
  18. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  19. How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
  20. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  21. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  22. Doing an “IN” query with Hibernate
  23. Difference between save and saveAndFlush in Spring data jpa
  24. Inherited abstract class with JPA (+Hibernate)
  25. spring data jpa @query and pageable
  26. org.hibernate.MappingException: Could not determine type for: java.util.Set [duplicate]
  27. Different representation of UUID in Java Hibernate and SQL Server
  28. Why hibernate generates insert and update for OneToMany mapping
  29. HQL joined query to eager fetch a large number of relationships
  30. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB

Leave a Comment