Examples of java.sql.DatabaseMetaData.storesMixedCaseIdentifiers()

java.sql.DatabaseMetaData.storesMixedCaseIdentifiers()
Determine whether the database considers mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case. @return true if unquoted SQL identifiers as stored inmixed case, false otherwise. @throws SQLException a database error occurred

            debug.appendln("Keywords", metaData.getSQLKeywords());
            debug.appendln("Date/Time functions", metaData.getTimeDateFunctions());
            debug.appendln("Mixed case identifiers", metaData.supportsMixedCaseIdentifiers());
            debug.appendln("Lower case identifiers", metaData.storesLowerCaseIdentifiers());
            debug.appendln("Lower case quoted", metaData.storesLowerCaseQuotedIdentifiers());
            debug.appendln("Mixed case identifiers", metaData.storesMixedCaseIdentifiers());
            debug.appendln("Mixed case quoted", metaData.storesMixedCaseQuotedIdentifiers());
            debug.appendln("Upper case identifiers", metaData.storesUpperCaseIdentifiers());
            debug.appendln("Upper case quoted", metaData.storesUpperCaseQuotedIdentifiers());
            debug.appendln("Max table name length", metaData.getMaxTableNameLength());
            debug.appendln("Max column name length", metaData.getMaxColumnNameLength());

View Full Code Here

      System.out.println("storesUpperCaseIdentifiers(): " +
                 met.storesUpperCaseIdentifiers());
      System.out.println("storesLowerCaseIdentifiers(): " +
                 met.storesLowerCaseIdentifiers());
      System.out.println("storesMixedCaseIdentifiers(): " +
                 met.storesMixedCaseIdentifiers());
      System.out.println("supportsMixedCaseQuotedIdentifiers(): " +
                 met.supportsMixedCaseQuotedIdentifiers());
      System.out.println("storesUpperCaseQuotedIdentifiers(): " +
                 met.storesUpperCaseQuotedIdentifiers());
      System.out.println("storesLowerCaseQuotedIdentifiers(): " +

View Full Code Here

    {
        DatabaseMetaData dmd = getDMD();
        
        assertFalse(dmd.storesLowerCaseIdentifiers());
        assertFalse(dmd.storesLowerCaseQuotedIdentifiers());
        assertFalse(dmd.storesMixedCaseIdentifiers());
        
        assertTrue(dmd.storesMixedCaseQuotedIdentifiers());
        assertTrue(dmd.storesUpperCaseIdentifiers());
        assertFalse(dmd.storesUpperCaseQuotedIdentifiers());
    }

View Full Code Here

    }


    private void readMetaData() throws SQLException {
        DatabaseMetaData meta = conn.getConnection().getMetaData();
        storesLowerCase = meta.storesLowerCaseIdentifiers();
        storesMixedCase = meta.storesMixedCaseIdentifiers();
        storesMixedCaseQuoted = meta.storesMixedCaseQuotedIdentifiers();
        supportsMixedCaseIdentifiers = meta.supportsMixedCaseIdentifiers();
        ResultSet rs = meta.getTables(null, originalSchema, originalTable, null);
        if (rs.next() && rs.next()) {
            throw DbException.get(ErrorCode.SCHEMA_NAME_MUST_MATCH, originalTable);

View Full Code Here

    {
        DatabaseMetaData dmd = getDMD();
        
        assertFalse(dmd.storesLowerCaseIdentifiers());
        assertFalse(dmd.storesLowerCaseQuotedIdentifiers());
        assertFalse(dmd.storesMixedCaseIdentifiers());
        
        assertTrue(dmd.storesMixedCaseQuotedIdentifiers());
        assertTrue(dmd.storesUpperCaseIdentifiers());
        assertFalse(dmd.storesUpperCaseQuotedIdentifiers());
    }

View Full Code Here

    {
        DatabaseMetaData dmd = getDMD();
        
        assertFalse(dmd.storesLowerCaseIdentifiers());
        assertFalse(dmd.storesLowerCaseQuotedIdentifiers());
        assertFalse(dmd.storesMixedCaseIdentifiers());
        
        assertTrue(dmd.storesMixedCaseQuotedIdentifiers());
        assertTrue(dmd.storesUpperCaseIdentifiers());
        assertFalse(dmd.storesUpperCaseQuotedIdentifiers());
    }

View Full Code Here

    }


    private void readMetaData() throws SQLException {
        DatabaseMetaData meta = conn.getConnection().getMetaData();
        storesLowerCase = meta.storesLowerCaseIdentifiers();
        storesMixedCase = meta.storesMixedCaseIdentifiers();
        supportsMixedCaseIdentifiers = meta.supportsMixedCaseIdentifiers();
        ResultSet rs = meta.getTables(null, originalSchema, originalTable, null);
        if (rs.next() && rs.next()) {
            throw DbException.get(ErrorCode.SCHEMA_NAME_MUST_MATCH, originalTable);
        }

View Full Code Here

    DatabaseMetaData dbmd = this.conn.getMetaData();


    if (isServerRunningOnWindows()) {
      assertEquals(true, dbmd.storesLowerCaseIdentifiers());
      assertEquals(true, dbmd.storesLowerCaseQuotedIdentifiers());
      assertEquals(false, dbmd.storesMixedCaseIdentifiers());
      assertEquals(false, dbmd.storesMixedCaseQuotedIdentifiers());
      assertEquals(false, dbmd.storesUpperCaseIdentifiers());
      assertEquals(true, dbmd.storesUpperCaseQuotedIdentifiers());
    } else {
      assertEquals(false, dbmd.storesLowerCaseIdentifiers());

View Full Code Here

      assertEquals(false, dbmd.storesUpperCaseIdentifiers());
      assertEquals(true, dbmd.storesUpperCaseQuotedIdentifiers());
    } else {
      assertEquals(false, dbmd.storesLowerCaseIdentifiers());
      assertEquals(false, dbmd.storesLowerCaseQuotedIdentifiers());
      assertEquals(true, dbmd.storesMixedCaseIdentifiers());
      assertEquals(true, dbmd.storesMixedCaseQuotedIdentifiers());
      assertEquals(false, dbmd.storesUpperCaseIdentifiers());
      assertEquals(true, dbmd.storesUpperCaseQuotedIdentifiers());
    }
  }

View Full Code Here

    DatabaseMetaData dbmd = this.conn.getMetaData();


    if (isServerRunningOnWindows()) {
      assertEquals(true, dbmd.storesLowerCaseIdentifiers());
      assertEquals(true, dbmd.storesLowerCaseQuotedIdentifiers());
      assertEquals(false, dbmd.storesMixedCaseIdentifiers());
      assertEquals(false, dbmd.storesMixedCaseQuotedIdentifiers());
      assertEquals(false, dbmd.storesUpperCaseIdentifiers());
      assertEquals(true, dbmd.storesUpperCaseQuotedIdentifiers());
    } else {
      assertEquals(false, dbmd.storesLowerCaseIdentifiers());

View Full Code Here

0 1 2 3 4 5 6 7

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.