Java Code Examples for java.sql.DatabaseMetaData#nullsAreSortedAtEnd()

The following examples show how to use java.sql.DatabaseMetaData#nullsAreSortedAtEnd() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: SqlDialectFactoryImpl.java    From Bats with Apache License 2.0 6 votes vote down vote up 
private NullCollation getNullCollation(DatabaseMetaData databaseMetaData) {
  try {
    if (databaseMetaData.nullsAreSortedAtEnd()) {
      return NullCollation.LAST;
    } else if (databaseMetaData.nullsAreSortedAtStart()) {
      return NullCollation.FIRST;
    } else if (databaseMetaData.nullsAreSortedLow()) {
      return NullCollation.LOW;
    } else if (databaseMetaData.nullsAreSortedHigh()) {
      return NullCollation.HIGH;
    } else {
      throw new IllegalArgumentException("cannot deduce null collation");
    }
  } catch (SQLException e) {
    throw new IllegalArgumentException("cannot deduce null collation", e);
  }
}
Example 2
Source File: SqlDialectFactoryImpl.java    From Quicksql with MIT License 6 votes vote down vote up 
private NullCollation getNullCollation(DatabaseMetaData databaseMetaData) {
  try {
    if (databaseMetaData.nullsAreSortedAtEnd()) {
      return NullCollation.LAST;
    } else if (databaseMetaData.nullsAreSortedAtStart()) {
      return NullCollation.FIRST;
    } else if (databaseMetaData.nullsAreSortedLow()) {
      return NullCollation.LOW;
    } else if (databaseMetaData.nullsAreSortedHigh()) {
      return NullCollation.HIGH;
    } else if (isBigQuery(databaseMetaData)) {
      return NullCollation.LOW;
    } else {
      throw new IllegalArgumentException("cannot deduce null collation");
    }
  } catch (SQLException e) {
    throw new IllegalArgumentException("cannot deduce null collation", e);
  }
}
Example 3
Source File: SqlDialectFactoryImpl.java    From calcite with Apache License 2.0 6 votes vote down vote up 
private NullCollation getNullCollation(DatabaseMetaData databaseMetaData) {
  try {
    if (databaseMetaData.nullsAreSortedAtEnd()) {
      return NullCollation.LAST;
    } else if (databaseMetaData.nullsAreSortedAtStart()) {
      return NullCollation.FIRST;
    } else if (databaseMetaData.nullsAreSortedLow()) {
      return NullCollation.LOW;
    } else if (databaseMetaData.nullsAreSortedHigh()) {
      return NullCollation.HIGH;
    } else if (isBigQuery(databaseMetaData)) {
      return NullCollation.LOW;
    } else {
      throw new IllegalArgumentException("cannot deduce null collation");
    }
  } catch (SQLException e) {
    throw new IllegalArgumentException("cannot deduce null collation", e);
  }
}