Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

by 
public class SQLServerUnicodeDialect extends org.hibernate.dialect.SQLServerDialect {
    public SQLServerUnicodeDialect() {
        super();
        registerColumnType(Types.CHAR, "nchar(1)");
        registerColumnType(Types.LONGVARCHAR, "nvarchar(max)" );
        registerColumnType(Types.VARCHAR, 4000, "nvarchar($l)");
        registerColumnType(Types.VARCHAR, "nvarchar(max)");
        registerColumnType(Types.CLOB, "nvarchar(max)" );

        registerColumnType(Types.NCHAR, "nchar(1)");
        registerColumnType(Types.LONGNVARCHAR, "nvarchar(max)");
        registerColumnType(Types.NVARCHAR, 4000, "nvarchar($l)");
        registerColumnType(Types.NVARCHAR, "nvarchar(max)");
        registerColumnType(Types.NCLOB, "nvarchar(max)");

        registerHibernateType(Types.NCHAR, StandardBasicTypes.CHARACTER.getName());
        registerHibernateType(Types.LONGNVARCHAR, StandardBasicTypes.TEXT.getName());
        registerHibernateType(Types.NVARCHAR, StandardBasicTypes.STRING.getName());
        registerHibernateType(Types.NCLOB, StandardBasicTypes.CLOB.getName() );
    }
}

More Related Contents:

  1. JPA SQL Server No Dialect mapping for JDBC type: -9
  2. having an exception when saving oracle type object in some entity
  3. How to map an entity field whose name is a reserved word in JPA
  4. JDBC connection failed, error: TCP/IP connection to host failed
  5. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  6. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  7. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  8. How do I connect to a SQL Server 2008 database using JDBC?
  9. Getting Database connection in pure JPA setup
  10. SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  11. Hibernate batch size confusion
  12. how to configure hibernate config file for sql server
  13. Native Library sqljdbc_auth.dll already loaded in another classloader
  14. Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29
  15. Do you need a database transaction for reading data?
  16. Adding jdbc driver to classpath
  17. JDBC SQLServerException: “This driver is not configured for integrated authentication.”
  18. How to pass Table-Valued parameters from java to sql server stored procedure?
  19. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  20. Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
  21. How to get *everything* back from a stored procedure using JDBC
  22. Getting the Return Value from JDBC MSSQL
  23. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  24. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  25. Different representation of UUID in Java Hibernate and SQL Server
  26. Connection cannot be cast to oracle.jdbc.OracleConnection
  27. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  28. The TCP/IP connection to the host localhost, port 1433 has failed
  29. How do I map a BigDecimal in Hibernate so I get back the same scale I put in?
  30. How to get jdbc connection from hibernate session? [duplicate]

Leave a Comment