Examples of java.sql.DatabaseMetaData.supportsAlterTableWithAddColumn()

java.sql.DatabaseMetaData.supportsAlterTableWithAddColumn()
Determine if the database supports ALTER TABLE operation with add column. @return true if ALTER TABLE with add column is supported,false otherwise. @throws SQLException a database error occurred

    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());


    //-1 indicates malformed version.
    assertTrue(meta.getDatabaseMajorVersion() > -1);
    assertTrue(meta.getDatabaseMinorVersion() > -1);
  }

View Full Code Here

    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
  }


  public void testResultSetMetaData() throws SQLException {
    Statement stmt = con.createStatement();

View Full Code Here

     */
    public void testDetermineFeatureSupport() throws SQLException
    {
        DatabaseMetaData dmd = getDMD();
        
        assertTrue(dmd.supportsAlterTableWithAddColumn());
        assertTrue(dmd.supportsAlterTableWithDropColumn());
        
  /* DERBY-2243 Derby does support ANSI 92 standards
  * and this behaviour is now consistant across drivers
  */

View Full Code Here

     */
    public void testDetermineFeatureSupport() throws SQLException
    {
        DatabaseMetaData dmd = getDMD();
        
        assertTrue(dmd.supportsAlterTableWithAddColumn());
        assertTrue(dmd.supportsAlterTableWithDropColumn());
        
  /* DERBY-2243 Derby does support ANSI 92 standards
  * and this behaviour is now consistant across drivers
  */

View Full Code Here

    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertTrue(meta.supportsSchemasInTableDefinitions());
    assertTrue(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());


    //-1 indicates malformed version.
    assertTrue(meta.getDatabaseMajorVersion() > -1);
    assertTrue(meta.getDatabaseMinorVersion() > -1);
  }

View Full Code Here

     */
    public void testDetermineFeatureSupport() throws SQLException
    {
        DatabaseMetaData dmd = getDMD();
        
        assertTrue(dmd.supportsAlterTableWithAddColumn());
        assertTrue(dmd.supportsAlterTableWithDropColumn());
        
  /* DERBY-2243 Derby does support ANSI 92 standards
  * and this behaviour is now consistant across drivers
  */

View Full Code Here

      System.out.println("getTimeDateFunctions(): " +
                 met.getTimeDateFunctions());
      System.out.println("getExtraNameCharacters(): " +
                 met.getExtraNameCharacters());
      System.out.println("supportsAlterTableWithAddColumn(): " +
                 met.supportsAlterTableWithAddColumn());
      System.out.println("supportsAlterTableWithDropColumn(): " +
                 met.supportsAlterTableWithDropColumn());
      System.out.println("supportsColumnAliasing(): " +
                 met.supportsColumnAliasing());
      System.out.println("nullPlusNonNullIsNull(): " +

View Full Code Here

    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
  }


  public void testResultSetMetaData() throws SQLException {
    Statement stmt = con.createStatement();

View Full Code Here

    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
  }


  public void testResultSetMetaData() throws SQLException {
    Statement stmt = con.createStatement();

View Full Code Here

    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
  }


  public void testResultSetMetaData() throws SQLException {
    Statement stmt = con.createStatement();
    ResultSet res = stmt.executeQuery(

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.