How to use

SQLServer2008Dialect

in

org.hibernate.dialect

return new SQLServer2008Dialect();

/**
 * Constructs a SQLServer2008Dialect
 */
public SQLServer2008Dialect() {
  registerColumnType( Types.DATE, "date" );
  registerColumnType( Types.TIME, "time" );
  registerColumnType( Types.TIMESTAMP, "datetime2" );
  registerColumnType( Types.NVARCHAR, NVARCHAR_MAX_LENGTH, "nvarchar($l)" );
  registerColumnType( Types.NVARCHAR, "nvarchar(MAX)" );
  registerFunction(
      "current_timestamp", new NoArgSQLFunction( "current_timestamp", StandardBasicTypes.TIMESTAMP, false )
  );
}

@Override
public void contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry) {
  super.contributeTypes(
      typeContributions,
      serviceRegistry
  );
  typeContributions.contributeType( new GeolatteGeometryType( SqlServer2008GeometryTypeDescriptor.INSTANCE ) );
  typeContributions.contributeType( new JTSGeometryType( SqlServer2008GeometryTypeDescriptor.INSTANCE ) );
  typeContributions.contributeJavaTypeDescriptor( GeolatteGeometryJavaTypeDescriptor.INSTANCE );
  typeContributions.contributeJavaTypeDescriptor( JTSGeometryJavaTypeDescriptor.INSTANCE );
}

/**
 * Constructs a SQLServer2008Dialect
 */
public SQLServer2008Dialect() {
  registerColumnType( Types.DATE, "date" );
  registerColumnType( Types.TIME, "time" );
  registerColumnType( Types.TIMESTAMP, "datetime2" );
  registerColumnType( Types.NVARCHAR, NVARCHAR_MAX_LENGTH, "nvarchar($l)" );
  registerColumnType( Types.NVARCHAR, "nvarchar(MAX)" );
}

  public SQLServer2008Dialect() {
    registerColumnType( Types.DATE, "date" );
    registerColumnType( Types.TIME, "time" );
    registerColumnType( Types.TIMESTAMP, "datetime2" );

    registerFunction(
        "current_timestamp", new NoArgSQLFunction( "current_timestamp", StandardBasicTypes.TIMESTAMP, false )
    );
  }
}

return new SQLServer2008Dialect();

  public SQLServer2008Dialect() {
    registerColumnType( Types.DATE, "date" );
    registerColumnType( Types.TIME, "time" );
    registerColumnType( Types.TIMESTAMP, "datetime2" );

    registerFunction(
        "current_timestamp", new NoArgSQLFunction( "current_timestamp", StandardBasicTypes.TIMESTAMP, false )
    );
  }
}

  return new SQLServer2005Dialect();
case 10:
  return new SQLServer2008Dialect();
default:
  LOG.unknownSqlServerVersion(databaseMajorVersion);

  return new SQLServer2005Dialect();
case 10:
  return new SQLServer2008Dialect();
default:
  LOG.unknownSqlServerVersion(databaseMajorVersion);