Examples of java.sql.DatabaseMetaData.supportsCorrelatedSubqueries()

java.sql.DatabaseMetaData.supportsCorrelatedSubqueries()
Determine if the database supports correlated sub-queries. @return true if the database does support correlatedsub-queries and false otherwise. @throws SQLException a database error occurred

        // is supported, though most likely in a test class
        // specific to convert.
        assertFalse(dmd.supportsConvert(Types.INTEGER, Types.SMALLINT));
        
        assertFalse(dmd.supportsCoreSQLGrammar());
        assertTrue(dmd.supportsCorrelatedSubqueries());
        
        assertTrue(dmd.supportsDataDefinitionAndDataManipulationTransactions());
        assertFalse(dmd.supportsDataManipulationTransactionsOnly());
        assertTrue(dmd.supportsDifferentTableCorrelationNames());

View Full Code Here

        // is supported, though most likely in a test class
        // specific to convert.
        assertFalse(dmd.supportsConvert(Types.INTEGER, Types.SMALLINT));
        
        assertFalse(dmd.supportsCoreSQLGrammar());
        assertTrue(dmd.supportsCorrelatedSubqueries());
        
        assertTrue(dmd.supportsDataDefinitionAndDataManipulationTransactions());
        assertFalse(dmd.supportsDataManipulationTransactionsOnly());
        assertTrue(dmd.supportsDifferentTableCorrelationNames());

View Full Code Here

      System.out.println("supportsSubqueriesInIns(): " +
                 met.supportsSubqueriesInIns());
      System.out.println("supportsSubqueriesInQuantifieds(): " +
                 met.supportsSubqueriesInQuantifieds());
      System.out.println("supportsCorrelatedSubqueries(): " +
                 met.supportsCorrelatedSubqueries());
      System.out.println("supportsUnion(): " +
                 met.supportsUnion());
      System.out.println("supportsUnionAll(): " +
                 met.supportsUnionAll());
      System.out.println("supportsOpenCursorsAcrossCommit(): " +

View Full Code Here

      System.out.println("supportsSubqueriesInIns(): " +
                 met.supportsSubqueriesInIns());
      System.out.println("supportsSubqueriesInQuantifieds(): " +
                 met.supportsSubqueriesInQuantifieds());
      System.out.println("supportsCorrelatedSubqueries(): " +
                 met.supportsCorrelatedSubqueries());
      System.out.println("supportsUnion(): " +
                 met.supportsUnion());
      System.out.println("supportsUnionAll(): " +
                 met.supportsUnionAll());
      System.out.println("supportsOpenCursorsAcrossCommit(): " +

View Full Code Here

      System.out.println("supportsSubqueriesInIns(): " +
                 met.supportsSubqueriesInIns());
      System.out.println("supportsSubqueriesInQuantifieds(): " +
                 met.supportsSubqueriesInQuantifieds());
      System.out.println("supportsCorrelatedSubqueries(): " +
                 met.supportsCorrelatedSubqueries());
      System.out.println("supportsUnion(): " +
                 met.supportsUnion());
      System.out.println("supportsUnionAll(): " +
                 met.supportsUnionAll());
      System.out.println("supportsOpenCursorsAcrossCommit(): " +

View Full Code Here

        // is supported, though most likely in a test class
        // specific to convert.
        assertFalse(dmd.supportsConvert(Types.INTEGER, Types.SMALLINT));
        
        assertFalse(dmd.supportsCoreSQLGrammar());
        assertTrue(dmd.supportsCorrelatedSubqueries());
        
        assertTrue(dmd.supportsDataDefinitionAndDataManipulationTransactions());
        assertFalse(dmd.supportsDataManipulationTransactionsOnly());
        assertTrue(dmd.supportsDifferentTableCorrelationNames());

View Full Code Here

        // is supported, though most likely in a test class
        // specific to convert.
        assertFalse(dmd.supportsConvert(Types.INTEGER, Types.SMALLINT));
        
        assertFalse(dmd.supportsCoreSQLGrammar());
        assertTrue(dmd.supportsCorrelatedSubqueries());
        
        assertTrue(dmd.supportsDataDefinitionAndDataManipulationTransactions());
        assertFalse(dmd.supportsDataManipulationTransactionsOnly());
        assertTrue(dmd.supportsDifferentTableCorrelationNames());

View Full Code Here

        // is supported, though most likely in a test class
        // specific to convert.
        assertFalse(dmd.supportsConvert(Types.INTEGER, Types.SMALLINT));
        
        assertFalse(dmd.supportsCoreSQLGrammar());
        assertTrue(dmd.supportsCorrelatedSubqueries());
        
        assertTrue(dmd.supportsDataDefinitionAndDataManipulationTransactions());
        assertFalse(dmd.supportsDataManipulationTransactionsOnly());
        assertTrue(dmd.supportsDifferentTableCorrelationNames());

View Full Code Here


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


    assertEquals(versionMeetsMinimum(4, 1),
        dbmd.supportsCorrelatedSubqueries());
  }


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

View Full Code Here

  }


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


    assertEquals(versionMeetsMinimum(4, 1), dbmd
        .supportsCorrelatedSubqueries());
  }


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

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.