List of supportsOrderByUnrelated() Examples

Examples of supportsOrderByUnrelated()

java.sql.DatabaseMetaData.supportsOrderByUnrelated()
Determine whether using a column in an ORDER BY clause that is not in the SELECT statement is supported. @return true if it is possible to ORDER using a column notin the SELECT, false otherwise. @throws SQLException a database error occurred

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

      System.out.println("supportsDifferentTableCorrelationNames(): " +
                 met.supportsDifferentTableCorrelationNames());
      System.out.println("supportsExpressionsInOrderBy(): " +
                 met.supportsExpressionsInOrderBy());
      System.out.println("supportsOrderByUnrelated(): " +
                 met.supportsOrderByUnrelated());
      System.out.println("supportsGroupBy(): " +
                 met.supportsGroupBy());
      System.out.println("supportsGroupByUnrelated(): " +
                 met.supportsGroupByUnrelated());
      System.out.println("supportsGroupByBeyondSelect(): " +

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

      System.out.println("supportsDifferentTableCorrelationNames(): " +
                 met.supportsDifferentTableCorrelationNames());
      System.out.println("supportsExpressionsInOrderBy(): " +
                 met.supportsExpressionsInOrderBy());
      System.out.println("supportsOrderByUnrelated(): " +
                 met.supportsOrderByUnrelated());
      System.out.println("supportsGroupBy(): " +
                 met.supportsGroupBy());
      System.out.println("supportsGroupByUnrelated(): " +
                 met.supportsGroupByUnrelated());
      System.out.println("supportsGroupByBeyondSelect(): " +

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

    // yes we can have expressions in ORDERBY
    assertTrue(dbmd.supportsExpressionsInOrderBy());


    // Yes, an ORDER BY clause can contain columns that are not in the
    // SELECT clause.
    assertTrue(dbmd.supportsOrderByUnrelated());


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

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

      System.out.println("supportsDifferentTableCorrelationNames(): " +
                 met.supportsDifferentTableCorrelationNames());
      System.out.println("supportsExpressionsInOrderBy(): " +
                 met.supportsExpressionsInOrderBy());
      System.out.println("supportsOrderByUnrelated(): " +
                 met.supportsOrderByUnrelated());
      System.out.println("supportsGroupBy(): " +
                 met.supportsGroupBy());
      System.out.println("supportsGroupByUnrelated(): " +
                 met.supportsGroupByUnrelated());
      System.out.println("supportsGroupByBeyondSelect(): " +

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

        assertFalse(dmd.supportsOpenCursorsAcrossRollback());
        assertTrue(dmd.supportsOpenStatementsAcrossCommit());
        
        assertFalse(dmd.supportsOpenStatementsAcrossRollback());
        
        assertFalse(dmd.supportsOrderByUnrelated());
        
        assertTrue(dmd.supportsOuterJoins());
        
        assertTrue(dmd.supportsPositionedDelete());
        assertTrue(dmd.supportsPositionedUpdate());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

        assertFalse(dmd.supportsOpenCursorsAcrossRollback());
        assertTrue(dmd.supportsOpenStatementsAcrossCommit());
        
        assertFalse(dmd.supportsOpenStatementsAcrossRollback());
        
        assertFalse(dmd.supportsOrderByUnrelated());
        
        assertTrue(dmd.supportsOuterJoins());
        
        assertTrue(dmd.supportsPositionedDelete());
        assertTrue(dmd.supportsPositionedUpdate());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

        assertFalse(dmd.supportsOpenCursorsAcrossRollback());
        assertTrue(dmd.supportsOpenStatementsAcrossCommit());
        
        assertFalse(dmd.supportsOpenStatementsAcrossRollback());
        
        assertFalse(dmd.supportsOrderByUnrelated());
        
        assertTrue(dmd.supportsOuterJoins());
        
        assertTrue(dmd.supportsPositionedDelete());
        assertTrue(dmd.supportsPositionedUpdate());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

        boolean supportsOpenCursorsAcrossCommit = dbMetaData.supportsOpenCursorsAcrossCommit();
        boolean supportsOpenCursorsAcrossRollback = dbMetaData.supportsOpenCursorsAcrossRollback();
        boolean supportsOpenStatementsAcrossCommit = dbMetaData.supportsOpenStatementsAcrossCommit();
        boolean supportsOpenStatementsAcrossRollback = dbMetaData.supportsOpenStatementsAcrossRollback();


        boolean supportsOrderByUnrelated = dbMetaData.supportsOrderByUnrelated();
        boolean supportsPositionedDelete = dbMetaData.supportsPositionedDelete();


        boolean supportsSelectForUpdate = dbMetaData.supportsSelectForUpdate();
        boolean supportsStoredProcedures = dbMetaData.supportsStoredProcedures();
        boolean supportsTransactions = dbMetaData.supportsTransactions();

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

        assertFalse(dmd.supportsOpenCursorsAcrossRollback());
        assertTrue(dmd.supportsOpenStatementsAcrossCommit());
        
        assertFalse(dmd.supportsOpenStatementsAcrossRollback());
        
        assertFalse(dmd.supportsOrderByUnrelated());
        
        assertTrue(dmd.supportsOuterJoins());
        
        assertTrue(dmd.supportsPositionedDelete());
        assertTrue(dmd.supportsPositionedUpdate());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOrderByUnrelated()

      System.out.println("supportsDifferentTableCorrelationNames(): " +
                 met.supportsDifferentTableCorrelationNames());
      System.out.println("supportsExpressionsInOrderBy(): " +
                 met.supportsExpressionsInOrderBy());
      System.out.println("supportsOrderByUnrelated(): " +
                 met.supportsOrderByUnrelated());
      System.out.println("supportsGroupBy(): " +
                 met.supportsGroupBy());
      System.out.println("supportsGroupByUnrelated(): " +
                 met.supportsGroupByUnrelated());
      System.out.println("supportsGroupByBeyondSelect(): " +

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.