Examples of java.sql.DatabaseMetaData.supportsGroupByUnrelated()

java.sql.DatabaseMetaData.supportsGroupByUnrelated()
Determine if the database supports using a column name in a GROUP BY clause that is not in the SELECT statement. @return true if GROUP BY clause can use a column name notin the SELECT statement, false otherwise. @throws SQLException a database error occurred

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

View Full Code Here

      System.out.println("supportsOrderByUnrelated(): " +
                 met.supportsOrderByUnrelated());
      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(): " +

View Full Code Here

  }


  public void testSupportesGroupByUnrelated() throws Exception {
    DatabaseMetaData dbmd = this.conn.getMetaData();


    assertEquals(true, dbmd.supportsGroupByUnrelated());
  }


  /**
   * Tests fix for BUG#21267, ParameterMetaData throws NullPointerException
   * when prepared SQL actually has a syntax error

View Full Code Here

  }


  public void testSupportesGroupByUnrelated() throws Exception {
    DatabaseMetaData dbmd = this.conn.getMetaData();


    assertEquals(true, dbmd.supportsGroupByUnrelated());
  }


  /**
   * Tests fix for BUG#21267, ParameterMetaData throws NullPointerException
   * when prepared SQL actually has a syntax error

View Full Code Here

0 1 2

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.