Examples of java.sql.DatabaseMetaData.supportsColumnAliasing()

java.sql.DatabaseMetaData.supportsColumnAliasing()
Determine if the database supports column aliasing.
If aliasing is supported, then the SQL AS clause is used to provide names for computed columns and provide alias names for columns. @return true if column aliasing is supported,false otherwise. @throws SQLException a database error occurred

      System.out.println("supportsAlterTableWithAddColumn(): " +
                 met.supportsAlterTableWithAddColumn());
      System.out.println("supportsAlterTableWithDropColumn(): " +
                 met.supportsAlterTableWithDropColumn());
      System.out.println("supportsColumnAliasing(): " +
                 met.supportsColumnAliasing());
      System.out.println("nullPlusNonNullIsNull(): " +
                 met.nullPlusNonNullIsNull());
      System.out.println("supportsConvert(): " +
                 met.supportsConvert());
      System.out.println("supportsConvert(Types.INTEGER, Types.SMALLINT): " +

View Full Code Here

      System.out.println("supportsAlterTableWithAddColumn(): " +
                 met.supportsAlterTableWithAddColumn());
      System.out.println("supportsAlterTableWithDropColumn(): " +
                 met.supportsAlterTableWithDropColumn());
      System.out.println("supportsColumnAliasing(): " +
                 met.supportsColumnAliasing());
      System.out.println("nullPlusNonNullIsNull(): " +
                 met.nullPlusNonNullIsNull());
      System.out.println("supportsConvert(): " +
                 met.supportsConvert());
      System.out.println("supportsConvert(Types.INTEGER, Types.SMALLINT): " +

View Full Code Here

  public void testSelect() throws SQLException {
    DatabaseMetaData dbmd = con.getMetaData();
    assertNotNull(dbmd);


    // yes we can?: SELECT col a FROM a;
    assertTrue(dbmd.supportsColumnAliasing());


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


    // Yes, an ORDER BY clause can contain columns that are not in the

View Full Code Here

      System.out.println("supportsAlterTableWithAddColumn(): " +
                 met.supportsAlterTableWithAddColumn());
      System.out.println("supportsAlterTableWithDropColumn(): " +
                 met.supportsAlterTableWithDropColumn());
      System.out.println("supportsColumnAliasing(): " +
                 met.supportsColumnAliasing());
      System.out.println("nullPlusNonNullIsNull(): " +
                 met.nullPlusNonNullIsNull());
      System.out.println("supportsConvert(): " +
                 met.supportsConvert());
      System.out.println("supportsConvert(Types.INTEGER, Types.SMALLINT): " +

View Full Code Here

        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
        
        assertTrue(dmd.supportsColumnAliasing());
        
        // Bug DERBY-462 should return false.
        assertTrue(dmd.supportsConvert());
        // Simple check since convert is not supported.
        // A comprehensive test should be added when convert

View Full Code Here

        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
        
        assertTrue(dmd.supportsColumnAliasing());
        
        assertFalse(dmd.supportsConvert());
        // Simple check since convert is not supported.
        // A comprehensive test should be added when convert
        // is supported, though most likely in a test class

View Full Code Here

        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
        
        assertTrue(dmd.supportsColumnAliasing());
        
        // Bug DERBY-462 should return false.
        assertTrue(dmd.supportsConvert());
        // Simple check since convert is not supported.
        // A comprehensive test should be added when convert

View Full Code Here

        String user = RDBMServices.getJdbcUser();


        boolean supportsANSI92EntryLevelSQL = dbMetaData.supportsANSI92EntryLevelSQL();
        boolean supportsANSI92FullSQL = dbMetaData.supportsANSI92FullSQL();
        boolean supportsBatchUpdates = dbMetaData.supportsBatchUpdates();
        boolean supportsColumnAliasing = dbMetaData.supportsColumnAliasing();
        boolean supportsCoreSQLGrammar = dbMetaData.supportsCoreSQLGrammar();
        boolean supportsExtendedSQLGrammar = dbMetaData.supportsExtendedSQLGrammar();
        boolean supportsExpressionsInOrderBy = dbMetaData.supportsExpressionsInOrderBy();
        boolean supportsOuterJoins = dbMetaData.supportsOuterJoins();
        boolean supportsFullOuterJoins = dbMetaData.supportsFullOuterJoins();

View Full Code Here

        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
        
        assertTrue(dmd.supportsColumnAliasing());
        
        assertFalse(dmd.supportsConvert());
        // Simple check since convert is not supported.
        // A comprehensive test should be added when convert
        // is supported, though most likely in a test class

View Full Code Here

      System.out.println("supportsAlterTableWithAddColumn(): " +
                 met.supportsAlterTableWithAddColumn());
      System.out.println("supportsAlterTableWithDropColumn(): " +
                 met.supportsAlterTableWithDropColumn());
      System.out.println("supportsColumnAliasing(): " +
                 met.supportsColumnAliasing());
      System.out.println("nullPlusNonNullIsNull(): " +
                 met.nullPlusNonNullIsNull());
      System.out.println("supportsConvert(): " +
                 met.supportsConvert());
      System.out.println("supportsConvert(Types.INTEGER, Types.SMALLINT): " +

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.