Examples of java.sql.DatabaseMetaData.supportsGroupByBeyondSelect()

java.sql.DatabaseMetaData.supportsGroupByBeyondSelect()
Determine if the database supports using a column name in a GROUP BY clause not included in the SELECT statement as long as all of the columns in the SELECT statement are used in the GROUP BY clause. @return true if GROUP BY clauses can use column names inthis way, false otherwise. @throws SQLException a database error occurred

    // SELECT clause.
    assertTrue(dbmd.supportsOrderByUnrelated());


    assertTrue(dbmd.supportsGroupBy());
    assertTrue(dbmd.supportsGroupByUnrelated());
    assertTrue(dbmd.supportsGroupByBeyondSelect()); // needs checking
  }


  @Test
  public void testDBParams() throws SQLException {
    DatabaseMetaData dbmd = con.getMetaData();

View Full Code Here

      System.out.println("supportsGroupBy(): " +
                 met.supportsGroupBy());
      System.out.println("supportsGroupByUnrelated(): " +
                 met.supportsGroupByUnrelated());
      System.out.println("supportsGroupByBeyondSelect(): " +
                 met.supportsGroupByBeyondSelect());
      System.out.println("supportsLikeEscapeClause(): " +
                 met.supportsLikeEscapeClause());
      System.out.println("supportsMultipleResultSets(): " +
                 met.supportsMultipleResultSets());
      System.out.println("supportsMultipleTransactions(): " +

View Full Code Here

        assertFalse(dmd.supportsExtendedSQLGrammar());
        assertFalse(dmd.supportsFullOuterJoins());
        assertFalse(dmd.supportsGetGeneratedKeys());
        
        assertTrue(dmd.supportsGroupBy());
        assertTrue(dmd.supportsGroupByBeyondSelect());
        assertTrue(dmd.supportsGroupByUnrelated());
        
        assertFalse(dmd.supportsIntegrityEnhancementFacility());
        assertTrue(dmd.supportsLikeEscapeClause());
        assertTrue(dmd.supportsLimitedOuterJoins());

View Full Code Here

        assertFalse(dmd.supportsExtendedSQLGrammar());
        assertFalse(dmd.supportsFullOuterJoins());
        assertFalse(dmd.supportsGetGeneratedKeys());
        
        assertTrue(dmd.supportsGroupBy());
        assertTrue(dmd.supportsGroupByBeyondSelect());
        assertTrue(dmd.supportsGroupByUnrelated());
        
        assertFalse(dmd.supportsIntegrityEnhancementFacility());
        assertTrue(dmd.supportsLikeEscapeClause());
        assertTrue(dmd.supportsLimitedOuterJoins());

View Full Code Here

        assertFalse(dmd.supportsExtendedSQLGrammar());
        assertFalse(dmd.supportsFullOuterJoins());
        assertFalse(dmd.supportsGetGeneratedKeys());
        
        assertTrue(dmd.supportsGroupBy());
        assertTrue(dmd.supportsGroupByBeyondSelect());
        assertTrue(dmd.supportsGroupByUnrelated());
        
        assertFalse(dmd.supportsIntegrityEnhancementFacility());
        assertTrue(dmd.supportsLikeEscapeClause());
        assertTrue(dmd.supportsLimitedOuterJoins());

View Full Code Here

        assertFalse(dmd.supportsExtendedSQLGrammar());
        assertFalse(dmd.supportsFullOuterJoins());
        assertFalse(dmd.supportsGetGeneratedKeys());
        
        assertTrue(dmd.supportsGroupBy());
        assertTrue(dmd.supportsGroupByBeyondSelect());
        assertTrue(dmd.supportsGroupByUnrelated());
        
        assertFalse(dmd.supportsIntegrityEnhancementFacility());
        assertTrue(dmd.supportsLikeEscapeClause());
        assertTrue(dmd.supportsLimitedOuterJoins());

View Full Code Here

      System.out.println("supportsGroupBy(): " +
                 met.supportsGroupBy());
      System.out.println("supportsGroupByUnrelated(): " +
                 met.supportsGroupByUnrelated());
      System.out.println("supportsGroupByBeyondSelect(): " +
                 met.supportsGroupByBeyondSelect());
      System.out.println("supportsLikeEscapeClause(): " +
                 met.supportsLikeEscapeClause());
      System.out.println("supportsMultipleResultSets(): " +
                 met.supportsMultipleResultSets());
      System.out.println("supportsMultipleTransactions(): " +

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.