Examples with SQLServer2008Dialect org.hibernate.dialect.SQLServer2008Dialect used on opensource projects

Example 1 with SQLServer2008Dialect

use of org.hibernate.dialect.SQLServer2008Dialect in project hibernate-orm by hibernate.

the class StandardDialectResolver method resolveDialect.

@Override
public Dialect resolveDialect(DialectResolutionInfo info) {
    final String databaseName = info.getDatabaseName();
    if ("CUBRID".equalsIgnoreCase(databaseName)) {
        return new CUBRIDDialect();
    }
    if ("HSQL Database Engine".equals(databaseName)) {
        return new HSQLDialect();
    }
    if ("H2".equals(databaseName)) {
        return new H2Dialect();
    }
    if ("MySQL".equals(databaseName)) {
        final int majorVersion = info.getDatabaseMajorVersion();
        if (majorVersion >= 5) {
            return new MySQL5Dialect();
        }
        return new MySQLDialect();
    }
    if ("PostgreSQL".equals(databaseName)) {
        final int majorVersion = info.getDatabaseMajorVersion();
        final int minorVersion = info.getDatabaseMinorVersion();
        if (majorVersion == 9) {
            if (minorVersion >= 4) {
                return new PostgreSQL94Dialect();
            } else if (minorVersion >= 2) {
                return new PostgreSQL92Dialect();
            }
            return new PostgreSQL9Dialect();
        }
        if (majorVersion == 8 && minorVersion >= 2) {
            return new PostgreSQL82Dialect();
        }
        return new PostgreSQL81Dialect();
    }
    if ("EnterpriseDB".equals(databaseName)) {
        return new PostgresPlusDialect();
    }
    if ("Apache Derby".equals(databaseName)) {
        final int majorVersion = info.getDatabaseMajorVersion();
        final int minorVersion = info.getDatabaseMinorVersion();
        if (majorVersion > 10 || (majorVersion == 10 && minorVersion >= 7)) {
            return new DerbyTenSevenDialect();
        } else if (majorVersion == 10 && minorVersion == 6) {
            return new DerbyTenSixDialect();
        } else if (majorVersion == 10 && minorVersion == 5) {
            return new DerbyTenFiveDialect();
        } else {
            return new DerbyDialect();
        }
    }
    if ("ingres".equalsIgnoreCase(databaseName)) {
        final int majorVersion = info.getDatabaseMajorVersion();
        final int minorVersion = info.getDatabaseMinorVersion();
        switch(majorVersion) {
            case 9:
                if (minorVersion > 2) {
                    return new Ingres9Dialect();
                }
                return new IngresDialect();
            case 10:
                return new Ingres10Dialect();
            default:
                LOG.unknownIngresVersion(majorVersion);
        }
        return new IngresDialect();
    }
    if (databaseName.startsWith("Microsoft SQL Server")) {
        final int majorVersion = info.getDatabaseMajorVersion();
        switch(majorVersion) {
            case 8:
                {
                    return new SQLServerDialect();
                }
            case 9:
                {
                    return new SQLServer2005Dialect();
                }
            case 10:
                {
                    return new SQLServer2008Dialect();
                }
            case 11:
            case 12:
            case 13:
                {
                    return new SQLServer2012Dialect();
                }
            default:
                {
                    if (majorVersion < 8) {
                        LOG.unknownSqlServerVersion(majorVersion, SQLServerDialect.class);
                        return new SQLServerDialect();
                    } else {
                        // assume `majorVersion > 13`
                        LOG.unknownSqlServerVersion(majorVersion, SQLServer2012Dialect.class);
                        return new SQLServer2012Dialect();
                    }
                }
        }
    }
    if ("Sybase SQL Server".equals(databaseName) || "Adaptive Server Enterprise".equals(databaseName)) {
        return new SybaseASE15Dialect();
    }
    if (databaseName.startsWith("Adaptive Server Anywhere")) {
        return new SybaseAnywhereDialect();
    }
    if ("Informix Dynamic Server".equals(databaseName)) {
        return new InformixDialect();
    }
    if ("DB2 UDB for AS/400".equals(databaseName)) {
        return new DB2400Dialect();
    }
    if (databaseName.startsWith("DB2/")) {
        return new DB2Dialect();
    }
    if ("Oracle".equals(databaseName)) {
        final int majorVersion = info.getDatabaseMajorVersion();
        switch(majorVersion) {
            case 12:
                return new Oracle12cDialect();
            case 11:
            // fall through
            case 10:
                return new Oracle10gDialect();
            case 9:
                return new Oracle9iDialect();
            case 8:
                return new Oracle8iDialect();
            default:
                LOG.unknownOracleVersion(majorVersion);
        }
        return new Oracle8iDialect();
    }
    if ("HDB".equals(databaseName)) {
        // SAP recommends defaulting to column store.
        return new HANAColumnStoreDialect();
    }
    if (databaseName.startsWith("Firebird")) {
        return new FirebirdDialect();
    }
    return null;
}

Example 2 with SQLServer2008Dialect

use of org.hibernate.dialect.SQLServer2008Dialect in project hibernate-orm by hibernate.

the class ASTParserLoadingTest method testAggregation.

@Test
@SkipForDialect(value = SybaseASE15Dialect.class, jiraKey = "HHH-6424")
public void testAggregation() {
    Session s = openSession();
    s.beginTransaction();
    Human h = new Human();
    h.setBodyWeight((float) 74.0);
    h.setHeightInches(120.5);
    h.setDescription("Me");
    h.setName(new Name("Gavin", 'A', "King"));
    h.setNickName("Oney");
    s.persist(h);
    Double sum = (Double) s.createQuery("select sum(h.bodyWeight) from Human h").uniqueResult();
    // uses custom read and write for column
    Double avg = (Double) s.createQuery("select avg(h.heightInches) from Human h").uniqueResult();
    assertEquals(sum.floatValue(), 74.0, 0.01);
    assertEquals(avg.doubleValue(), 120.5, 0.01);
    Long id = (Long) s.createQuery("select max(a.id) from Animal a").uniqueResult();
    assertNotNull(id);
    s.delete(h);
    s.getTransaction().commit();
    s.close();
    s = openSession();
    s.beginTransaction();
    h = new Human();
    h.setFloatValue(2.5F);
    h.setIntValue(1);
    s.persist(h);
    Human h2 = new Human();
    h2.setFloatValue(2.5F);
    h2.setIntValue(2);
    s.persist(h2);
    Object[] results = (Object[]) s.createQuery("select sum(h.floatValue), avg(h.floatValue), sum(h.intValue), avg(h.intValue) from Human h").uniqueResult();
    // spec says sum() on a float or double value should result in double
    assertTrue(Double.class.isInstance(results[0]));
    assertEquals(5D, results[0]);
    // avg() should return a double
    assertTrue(Double.class.isInstance(results[1]));
    assertEquals(2.5D, results[1]);
    // spec says sum() on short, int or long should result in long
    assertTrue(Long.class.isInstance(results[2]));
    assertEquals(3L, results[2]);
    // avg() should return a double
    assertTrue(Double.class.isInstance(results[3]));
    if (getDialect() instanceof SQLServer2008Dialect)
        assertEquals(1.0D, results[3]);
    else
        assertEquals(1.5D, results[3]);
    s.delete(h);
    s.delete(h2);
    s.getTransaction().commit();
    s.close();
}