Connecting to SQL Server using Hibernate

How to connect to the Sql Server database by using Hibernate in Netbeans 6.7.1? Please advice.

The dialect is disabled for me.

  • How do I extract part of a string in t-sql
  • “Model already has an element” errors (TSD04105) when using Visual Studio 2008 Database Project GDR2
  • Is there a way to return more than 1 row in select without using existing tables
  • In SQL Server Management Studio what is SQLCMD mode?
  • SQL While Loop 60 seconds?
  • Set Locale of a SQL Server 2005
  • JPA SQL Server No Dialect mapping for JDBC type: -9
  • Avoiding null pointer on failed join
  • How do I map a BigDecimal in Hibernate so I get back the same scale I put in?
  • Different representation of UUID in Java Hibernate and SQL Server
  • Case sensitive on restrictions 'equals id' in Hibernate restrictions
  • JPA GenerationType.AUTO not considering column with auto increment
  • 2 Solutions collect form web for “Connecting to SQL Server using Hibernate”

    For SQL Server 2000 and 2005, you should use SQLServerDialect (that should be preferred over SybaseDialect that will be deprecated).

    I can’t verify how NetBeans Hibernate wizard behave with SQL Server but, according to this tutorial:

    When you create a Hibernate configuration file using a wizard you specify the database connection by choosing from a list of database connection registered with the IDE. When generating the configuration file the IDE automatically adds the connection details and dialect information based on the selected database connection.

    So, my question is: did you register a database connection for your SQL Server database? If not, go to Services, add a New Driver (right click on the Drivers node) for your SQL Server JDBC driver and add a New Connection (right click on the Databases node) with the right URL for your database.

    For anyone using Hibernate with SQL Server – our customized dialect may help: http://www.componentix.com/blog/5/improved-hibernate-dialect-for-microsoft-sql-server

    public class SQLServerDialect extends org.hibernate.dialect.SQLServerDialect {
    
       /**
        * Initializes a new instance of the {@link SQLServerDialect} class.
        */
        public SQLServerDialect() {
            registerColumnType(Types.BIGINT, "bigint");
            registerColumnType(Types.BIT, "bit");
            registerColumnType(Types.CHAR, "nchar(1)");
            registerColumnType(Types.VARCHAR, 4000, "nvarchar($l)");
            registerColumnType(Types.VARCHAR, "nvarchar(max)");
            registerColumnType(Types.VARBINARY, 4000, "varbinary($1)");
            registerColumnType(Types.VARBINARY, "varbinary(max)");
            registerColumnType(Types.BLOB, "varbinary(max)");
            registerColumnType(Types.CLOB, "nvarchar(max)");
        }
    }
    
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.